aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-05-23Removed (unused?) empty SQL files from MSSQL resource dirAlexRa9-0/+0
There was a whole bunch of these SQL files, all empty and apparently unused. Removing them is just a clean-up, if anybody has a reason for these files to be there, feel free to revert.
2010-05-23MSSQL Migration: CreatorID in InventoryItems changed to VARCHAR(36)AlexRa1-0/+70
Again, the same thing about potentially having non-GUID CreatorID.
2010-05-23Further corrections to MS SQL stores (now passes all tests)AlexRa2-89/+49
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-23MSSQL: added asset_flags, CreatorID to migrationsAlexRa1-0/+6
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-23All data tests made DBMS-independentAlexRa1-1/+1
2010-05-18MS SQL migrations converted to the new formatAlexRa77-2008/+2273
2010-05-18Converted MySQL migration history to the new formatAlexRa1-6/+0
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-18Massive bugfix in MSSQLEstateData (now works!)AlexRa1-49/+41
2010-05-16MS SQL migrations converted to the new formatAlexRa77-2008/+2273
2010-05-16Converted MySQL migration history to the new formatAlexRa1-6/+0
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-09Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie1-0/+4
asset deletion in robust handler.
2010-05-07GridUserService in place. Replaces the contrived concept of storing user's ↵Diva Canto2-75/+5
home and position info in the presence service. WARNING: I violated a taboo by deleting 2 migration files and simplifying the original table creation for Presence. This should not cause any problems to anyone, though. Things will work with the new simplified table, as well as with the previous contrived one. If there are any problems, solving them is as easy as dropping the presence table and deleting its row in the migrations table. The presence info only exists during a user's session anyway. BTW, the Meshing files want to be committed too -- EOFs.
2010-03-31Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie1-2/+11
This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
2010-03-30Rename Meta7Windlight to LightShareMelanie1-3/+3
2010-03-23First stage of the new interactive region creation. This will allow creationMelanie1-0/+25
of a region and joining it to an existing estate or creating a new estate, as well as creating an estate owner if in standalone, and assigning estate owners. In Grid mode, existing users must be used. MySQL ONLY!!!! so far, as I can't develop or test for either SQLite or MSSQL.
2010-03-22Remove the reading of estate_settings.xml and the associated processing ofMelanie1-21/+2
defaults. Adding code to facilitate estate creation / managemment as part of first time start up
2010-03-10Formatting cleanup. Add copyright notices.Jeff Ames5-9/+9
2010-03-09MSSQL tweaks for latest ROBUST - friends handling fixed, GridUserData ↵unknown7-3/+101
placeholder added. Signed-off-by: Melanie <melanie@t-data.com>
2010-02-24Remove some obsolete files from MSSQL. Fix a missing constructor arg thatMelanie3-1821/+2
was introdiced by the latest jhurlipatch
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride25-842/+3262
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
2010-02-21Deleted obsolete files in the Data layer. Compiles.Diva Canto3-1947/+0
2010-01-09Preliminary work on the new default region setting mechanismMelanie1-0/+10
2009-12-31Implement avatar picker queriesMelanie1-0/+5
2009-12-31Implement saving user account dataMelanie1-1/+1
2009-12-30Some modifications to user service. Query by name is implemented nowMelanie1-0/+5
2009-12-29Polished the IUserService interface.Diva Canto1-0/+5
2009-12-09Enable scripting interface for windlightunknown1-0/+4
2009-12-07Initial windlight codebase commitunknown1-2/+7
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-11-02Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman1-4/+4
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman4-3/+19
the grid server after running for several hours
2009-10-19Formatting cleanup.Jeff Ames4-9/+9
2009-10-05Adapt to renamed members in landObjectMelanie1-10/+10
2009-10-05Adapt to renamed members in landObjectMelanie1-10/+10
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown5-1456/+1776
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown5-1456/+1776
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman4-19/+3
Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
2009-10-02- cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)1-4/+4
- adding LandDataSerializer to OAR mechanics
2009-10-01Formatting cleanup.Jeff Ames5-8/+8
2009-09-29Add copyright header. Formatting cleanup.Jeff Ames2-2/+2
2009-09-06Thank you, StrawberryFride, for a hit-and-run patch to add authenticationMelanie3-0/+413
and user services to MSSQL
2009-09-03MSSQL Minor tweak to recent patch for region loading (Thanks Grumly57 for ↵Chris Hart1-0/+1
spotting it!)
2009-09-02MSSQL patch to mirror mantis 4077 for MySQL to improve region load timesChris Hart1-24/+38
2009-08-19Fixing a spot I missed in assets. Switching Grid to the new naming schema ↵Kunnis1-15/+12
with Store/Get
2009-08-19* Switching IAssetData to follow the new naming schema, removing the ↵Kunnis1-5/+14
separate insert and update methods.
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-6/+6
256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol