aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLAssetData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2014-11-28Remove unmaintained MSSQL support.Justin Clark-Casey (justincc)1-314/+0
This has not been maintained for more than 2 years, is unimplemented for newer features (e.g. built-in groups) and has no core developers using it. If somebody fixes these issues then it could be reinstated.
2014-04-22Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz1-4/+4
pre-truncate the description of dynamic textures.
2014-04-02Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz1-7/+28
list of assets exist. This method is used to optimize sending assets with embedded assets: e.g., when a Hypergrid visitor takes an item into the inventory.
2013-02-27Add more information to warnings logged when asset names and descriptions ↵Justin Clark-Casey (justincc)1-2/+6
have to be truncated for database storage On balance, I still think this is useful because asset names and descriptions can sometimes be helpful in determining what things are. Even though they are never subsequently (inventory names/descriptions are always used instead).
2010-06-28Provide the interface for StoreAsset to report success or failureTom Grimshaw1-1/+3
2010-05-23Further corrections to MS SQL stores (now passes all tests)AlexRa1-70/+17
Besides, AssetData is slightly optimized to StoreAsset in one request ("IF EXISTS() UPDATE ... ELSE INSERT ...") The main change in the MS SQL Inventory implem. is that it now return empty list (or whatever) when called with UUID.Zero, which is consistent with how the code for other DBs work. I did no changes at all in XInventory, as there is no test set for them.
2010-05-23MSSQLAssetData updated to support [CreatorID], [asset_flags]AlexRa1-5/+11
2010-05-23MSSQLAssetData: fixed some weirdnessAlexRa1-7/+12
Fixed unfinished SQL in FetchAssetMetadataSet, fixed SQL in UpdateAsset (must not modify ID). NOT tested! But apparently shouldn't work worse than the previous version, esp. the FetchMetadata thing.
2010-05-09Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie1-0/+4
asset deletion in robust handler.
2010-02-24Remove some obsolete files from MSSQL. Fix a missing constructor arg thatMelanie1-1/+2
was introdiced by the latest jhurlipatch
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride1-32/+22
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2010-02-22Changed asset CreatorID to a stringJohn Hurliman1-1/+1
2010-02-22* Adds CreatorID to asset metadata. This is just the plumbing to support ↵John Hurliman1-1/+2
CreatorID, it doesn't modify database backends or OAR files to support storing/loading it
2009-11-05Changing the AssetBase constructors to avoid initializing assets with an ↵John Hurliman1-4/+5
unknown asset type, and log an error if it ever does happen
2009-10-01Formatting cleanup.Jeff Ames1-2/+2
2009-08-19* Switching IAssetData to follow the new naming schema, removing the ↵Kunnis1-5/+14
separate insert and update methods.
2009-07-24* Apply similar bounds checks on name and description fields on MSSQL ↵Justin Clarke Casey1-6/+25
UpdateAsset
2009-07-24* Apply http://opensimulator.org/mantis/view.php?id=3902Justin Clarke Casey1-4/+23
* Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride
2009-06-14Fixes Mantis #3793 . Committing thomax/Snoopy's patch to allow deeding of ↵Melanie Thielker1-1/+1
objects, with changes: - Set OwnerID = GroupID for deeded objects. - Close a security loophole that would have allowed a user with deed rights in a group to deed ANY object to that group, even if it's not owned by them and/or not set to that group - Set LastOwnerID correctly. Handle objects vs. prims correctly.
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-05-17Thank you kindly, StrawberryFride, for a patch that:Charles Krinke1-19/+20
Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
2009-04-13* Some more experimental work on distributed assets. Nothing hotwired yet.lbsa711-39/+39
* Introduced preprocess step in FetchAsset (Might revert this later) * Some minor CCC * Added actual implementation of GetUserProfile( uri ) and the corresponding handler to OGS1. * Introduced non-functioning GetUserUri( userProfile) awaiting user server wireup (this might move elsewhere)
2009-03-09* Apply http://opensimulator.org/mantis/view.php?id=3280Justin Clarke Casey1-1/+1
* Some small syntax and refactoring tweaks for asset and inventory MSSQL * This means the MSSQL db plugin now requires SQL Server 2005
2009-03-09Implemented FetchAssetMetadataSet in DB backends.Mike Mazur1-0/+36
This method fetches metadata for a subset of the entries in the assets database. This functionality is used in the ForEach calls in the asset storage providers in AssetInventoryServer. With this implemented, frontends such as the BrowseFrontend should now work. - MySQL: implemented, sanity tested - SQLite: implemented, sanity tested - MSSQL: implemented, not tested - NHibernate: not implemented
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey1-4/+4
* Changes varchar(36) columns to UUID type in MSSQL - this will be much more efficient * ===As always, please, please backup your database before applying this patch=== * Thanks Ruud Lathrop (for the patch) and StrawberryFride (for the review)
2009-02-17- remove the Metadata property from AssetBase and return all previousMike Mazur1-20/+20
properties as before - prefix private variables with m_ in AssetBase.cs - related to Mantis #3122, as mentioned in https://lists.berlios.de/pipermail/opensim-dev/2009-February/005088.html - all services will likely need to be upgraded after this commit
2009-02-12* optimized usings.lbsa711-3/+3
2009-02-04- add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur1-20/+20
- trim trailing whitespace
2009-02-03- move IAssetDataPlugin from OpenSim/Framework/IAssetProvider.cs toMike Mazur1-2/+2
OpenSim/Data/IAssetData.cs - remove some trailing whitespace
2009-02-03Rename IAssetProviderPlugin to IAssetDataPlugin aligning with the other data ↵Mike Mazur1-1/+1
plugins.
2008-11-21* Comment out unused access time method in MSSQLJustin Clarke Casey1-18/+18
* This should probably be being called in FetchAsset() instead as for all the other databases, but I lack the means to test MSSQL
2008-11-19Mantis#2657. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-5/+27
Added access_time and create_time, plus the new sun position data to MSSQL code.
2008-11-17cleaning up warnings in MSSQL code.Dr Scofield1-1/+1
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz1-73/+2
2008-09-14Mantis #2124Melanie Thielker1-98/+147
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-4/+4
* This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
2008-08-18Formatting cleanup.Jeff Ames1-3/+3
2008-07-31Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur1-1/+1
PluginLoader. Fix issue 1871.
2008-07-17Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-56/+43
Many issues with handling connections in MSSQL, have rearchitected to ensure that connections are always opened and closed in a timely fashion & disposed of cleanly, and removed unnecessary lock statements. SQL Server performance seems to have improved considerably as a result, and various timeout errors seem to have been fixed.
2008-07-07* remove unused CommitAssets() hook for nowJustin Clarke Casey1-7/+0
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-7/+3
* Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
2008-06-27Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke1-0/+2
Currently module loading is done ad-hoc. I propose creating a simple loader class that leverages Mono.Addins (and perhaps the new .NET addins when they become available in mono). Attached is a basic patch for review that compiles into HEAD, but doesn't yet replace any existing ad-hoc loaders.
2008-06-26Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames1-4/+46
kerunix_Flan!
2008-05-16Formatting cleanup.Jeff Ames1-1/+1
2008-05-01* Rolled back a few changes.Adam Frisby1-1/+1
2008-05-01* Cleaning code still.Adam Frisby1-1/+1
2008-05-01* Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey1-1/+1
settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code
2008-04-23changes to allow asset_source to be specified in the opensim.iniSean Dague1-0/+7
this will work for sqlite and nhibernate, but will be ignored for mysql and mssql (reverting to their ini files) until someone writes that bit.
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-2/+3
(this took a while to run).
2008-04-02fix ups to include OpenSim.Framework explicit includes (theySean Dague1-0/+1
were implicitly included before). Everything builds again. Now off to testing.