aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLAssetData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
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.
2008-04-02attempt to fix up all refernces to new directory structureSean Dague1-1/+1
2008-04-02whole lot more movingSean Dague1-0/+0
2008-03-28* Introduced common abstract AssetDataBase implementing IAssetProviderlbsa711-9/+9
* changed the semantics of SQLiteBase to SQLiteUtils * Added abstract placeholder files for the other db providers
2008-03-18Formatting cleanup.Jeff Ames1-27/+26
2008-02-20Minor cleanup.Jeff Ames1-1/+1
2008-02-05Converted logging to use log4net.Jeff Ames1-2/+4
Changed LogBase to ConsoleBase, which handles console I/O. This is mostly an in-place conversion, so lots of refactoring can still be done.
2007-12-27* Optimized usingslbsa711-33/+26
* shortened references * Removed redundant 'this' * Normalized EOF
2007-12-20Added patch from Johan. First attempt to solve the LibSL.Packet GC problem. ↵Jeff Ames1-6/+6
Works with LibSL rev>1532
2007-12-05* Applied MSSQL Patch from akokko, Thanks! akokkoTeravus Ovares1-0/+227
* This hasn't been tested in MSSQL mode, however it's been checked to make sure it doesn't cause any issues with mySQL/SQLlite