aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLAssetData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Add more information to warnings logged when asset names and descriptions ↵Justin Clark-Casey (justincc)2013-02-271-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).
* Further corrections to MS SQL stores (now passes all tests)AlexRa2010-05-231-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.
* MSSQLAssetData updated to support [CreatorID], [asset_flags]AlexRa2010-05-231-5/+11
|
* MSSQLAssetData: fixed some weirdnessAlexRa2010-05-231-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.
* Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie2010-05-091-0/+4
| | | | asset deletion in robust handler.
* Remove some obsolete files from MSSQL. Fix a missing constructor arg thatMelanie2010-02-241-1/+2
| | | | was introdiced by the latest jhurlipatch
* MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride2010-02-241-32/+22
| | | | | | works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
* Changed asset CreatorID to a stringJohn Hurliman2010-02-221-1/+1
|
* * Adds CreatorID to asset metadata. This is just the plumbing to support ↵John Hurliman2010-02-221-1/+2
| | | | CreatorID, it doesn't modify database backends or OAR files to support storing/loading it
* Changing the AssetBase constructors to avoid initializing assets with an ↵John Hurliman2009-11-051-4/+5
| | | | unknown asset type, and log an error if it ever does happen
* Formatting cleanup.Jeff Ames2009-10-011-2/+2
|
* * Switching IAssetData to follow the new naming schema, removing the ↵Kunnis2009-08-191-5/+14
| | | | separate insert and update methods.
* * Apply similar bounds checks on name and description fields on MSSQL ↵Justin Clarke Casey2009-07-241-6/+25
| | | | UpdateAsset
* * Apply http://opensimulator.org/mantis/view.php?id=3902Justin Clarke Casey2009-07-241-4/+23
| | | | | | | * Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride
* Fixes Mantis #3793 . Committing thomax/Snoopy's patch to allow deeding of ↵Melanie Thielker2009-06-141-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.
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-011-1/+1
| | | | LICENSE.txt.
* Thank you kindly, StrawberryFride, for a patch that:Charles Krinke2009-05-171-19/+20
| | | | | | | Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
* * Some more experimental work on distributed assets. Nothing hotwired yet.lbsa712009-04-131-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)
* * Apply http://opensimulator.org/mantis/view.php?id=3280Justin Clarke Casey2009-03-091-1/+1
| | | | | | | * Some small syntax and refactoring tweaks for asset and inventory MSSQL * This means the MSSQL db plugin now requires SQL Server 2005
* Implemented FetchAssetMetadataSet in DB backends.Mike Mazur2009-03-091-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
* * Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey2009-02-191-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)
* - remove the Metadata property from AssetBase and return all previousMike Mazur2009-02-171-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
* * optimized usings.lbsa712009-02-121-3/+3
|
* - add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur2009-02-041-20/+20
| | | | | - trim trailing whitespace
* - move IAssetDataPlugin from OpenSim/Framework/IAssetProvider.cs toMike Mazur2009-02-031-2/+2
| | | | | | OpenSim/Data/IAssetData.cs - remove some trailing whitespace
* Rename IAssetProviderPlugin to IAssetDataPlugin aligning with the other data ↵Mike Mazur2009-02-031-1/+1
| | | | plugins.
* * Comment out unused access time method in MSSQLJustin Clarke Casey2008-11-211-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
* Mantis#2657. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-11-191-5/+27
| | | | | | Added access_time and create_time, plus the new sun position data to MSSQL code.
* cleaning up warnings in MSSQL code.Dr Scofield2008-11-171-1/+1
|
* Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz2008-11-151-73/+2
|
* Mantis #2124Melanie Thielker2008-09-141-98/+147
| | | | | | | Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-061-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.
* Formatting cleanup.Jeff Ames2008-08-181-3/+3
|
* Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur2008-07-311-1/+1
| | | | | | PluginLoader. Fix issue 1871.
* Mantis#1736. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-07-171-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.
* * remove unused CommitAssets() hook for nowJustin Clarke Casey2008-07-071-7/+0
|
* * Drop InvType from the assets table since it is no longer usedJustin Clarke Casey2008-07-021-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
* Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke2008-06-271-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.
* Apply patch from bug #1609 -- Documentation for Data/MSSQL. Thanks ↵Jeff Ames2008-06-261-4/+46
| | | | kerunix_Flan!
* Formatting cleanup.Jeff Ames2008-05-161-1/+1
|
* * Rolled back a few changes.Adam Frisby2008-05-011-1/+1
|
* * Cleaning code still.Adam Frisby2008-05-011-1/+1
|
* * Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey2008-05-011-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
* changes to allow asset_source to be specified in the opensim.iniSean Dague2008-04-231-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.
* * Optimised using statements and namespace references across entire project ↵Adam Frisby2008-04-211-2/+3
| | | | (this took a while to run).
* fix ups to include OpenSim.Framework explicit includes (theySean Dague2008-04-021-0/+1
| | | | | | | were implicitly included before). Everything builds again. Now off to testing.
* attempt to fix up all refernces to new directory structureSean Dague2008-04-021-1/+1
|
* whole lot more movingSean Dague2008-04-021-0/+221