aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Further corrections to MS SQL stores (now passes all tests)AlexRa2010-05-232-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.
* MSSQL: added asset_flags, CreatorID to migrationsAlexRa2010-05-231-0/+6
|
* 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.
* All data tests made DBMS-independentAlexRa2010-05-231-1/+1
|
* Merge commit 'alex/mssql-estate-bugfix'Melanie2010-05-181-49/+41
|\ | | | | | | | | | | | | This fixes some type conversion bugs and also makes the estate lists work properly for MSSQL. Strawberry, please check this. Signed-off-by: Melanie <melanie@t-data.com>
| * Massive bugfix in MSSQLEstateData (now works!)AlexRa2010-05-181-49/+41
| |
* | MS SQL migrations converted to the new formatAlexRa2010-05-1677-2008/+2273
| |
* | Converted MySQL migration history to the new formatAlexRa2010-05-161-6/+0
|/ | | | | Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
* Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie2010-05-091-0/+4
| | | | asset deletion in robust handler.
* GridUserService in place. Replaces the contrived concept of storing user's ↵Diva Canto2010-05-072-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.
* Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie2010-03-311-2/+11
| | | | | This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
* First stage of the new interactive region creation. This will allow creationMelanie2010-03-231-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.
* Remove the reading of estate_settings.xml and the associated processing ofMelanie2010-03-221-21/+2
| | | | | defaults. Adding code to facilitate estate creation / managemment as part of first time start up
* Formatting cleanup. Add copyright notices.Jeff Ames2010-03-105-9/+9
|
* MSSQL tweaks for latest ROBUST - friends handling fixed, GridUserData ↵unknown2010-03-097-3/+101
| | | | | | placeholder added. Signed-off-by: Melanie <melanie@t-data.com>
* Remove some obsolete files from MSSQL. Fix a missing constructor arg thatMelanie2010-02-243-1821/+2
| | | | was introdiced by the latest jhurlipatch
* MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride2010-02-2425-842/+3262
| | | | | | 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
|
* Merge branch 'presence-refactor' of ssh://opensimulator.org/var/git/opensim ↵John Hurliman2010-02-223-1947/+0
|\ | | | | | | into presence-refactor
| * Deleted obsolete files in the Data layer. Compiles.Diva Canto2010-02-213-1947/+0
| |
* | * 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
* Preliminary work on the new default region setting mechanismMelanie2010-01-091-0/+10
|
* Implement avatar picker queriesMelanie2009-12-311-0/+5
|
* Implement saving user account dataMelanie2009-12-311-1/+1
|
* Some modifications to user service. Query by name is implemented nowMelanie2009-12-301-0/+5
|
* Polished the IUserService interface.Diva Canto2009-12-291-0/+5
|
* 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
* Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman2009-11-021-4/+4
|
* Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman2009-11-024-3/+19
| | | | the grid server after running for several hours
* Formatting cleanup.Jeff Ames2009-10-194-9/+9
|
* Adapt to renamed members in landObjectMelanie2009-10-051-10/+10
|
* MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown2009-10-055-1456/+1776
|
* * MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman2009-10-044-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)
* - cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)2009-10-021-4/+4
| | | | - adding LandDataSerializer to OAR mechanics
* Formatting cleanup.Jeff Ames2009-10-015-8/+8
|
* Add copyright header. Formatting cleanup.Jeff Ames2009-09-292-2/+2
|
* Thank you, StrawberryFride, for a hit-and-run patch to add authenticationMelanie2009-09-063-0/+413
| | | | and user services to MSSQL
* MSSQL Minor tweak to recent patch for region loading (Thanks Grumly57 for ↵Chris Hart2009-09-031-0/+1
| | | | spotting it!)
* MSSQL patch to mirror mantis 4077 for MySQL to improve region load timesChris Hart2009-09-021-24/+38
|
* Fixing a spot I missed in assets. Switching Grid to the new naming schema ↵Kunnis2009-08-191-15/+12
| | | | with Store/Get
* * Switching IAssetData to follow the new naming schema, removing the ↵Kunnis2009-08-191-5/+14
| | | | separate insert and update methods.
* * Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)2009-08-071-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
* * Updates libOMV to version 0.7.0Teravus Ovares2009-07-251-2/+2
| | | | | | | | * Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
* * minor: spacing adjustment to retrigger pandaJustin Clarke Casey2009-07-241-2/+1
|
* * Extend mssql name string size checking to create/update folderJustin Clarke Casey2009-07-241-3/+18
|
* * Extend inventory name and description length checks to UpdateItem for mssqlJustin Clarke Casey2009-07-241-2/+20
|
* * Correct minor bug where item description bounded string was not actually ↵Justin Clarke Casey2009-07-241-1/+2
| | | | being used in the previous patches.
* * 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-242-6/+36
| | | | | | | * Restrict asset and inventory name descriptions so as not to overflow MSSQL field lengths * Thanks StrawberryFride