aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz2014-04-211-3/+11
|
* Add MSSQL EstateStore.migrations VERSION 10 transaction to add ↵Justin Clark-Casey (justincc)2014-03-261-0/+8
| | | | | | AllowLandMark, AllowParcelChanges and AllowSetHome columns to estate_settings table. Taken from http://opensimulator.org/mantis/view.php?id=7074 by LuciusSirnah. Thanks!
* Fix extra physics params MSSQL migration (version 39).Justin Clark-Casey (justincc)2014-03-261-5/+5
| | | | | | This was failing because it used MySQL syntax This is taken from Lucius Sirnah's entry in http://opensimulator.org/mantis/view.php?id=6593 But with the column existence checking removed, as this should not be necessary in a migration and is inconsistent with all other migrations, though I can see a case for doing it.
* Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood2013-09-221-0/+12
| | | | | | | | | | Patch taken from http://opensimulator.org/mantis/view.php?id=4905 originally by Greg C. Fixed to apply to r/23314 commit ba9daf849e7c8db48e7c03e7cdedb77776b2052f (cherry picked from commit 4ff9fbca441110cc2b93edc7286e0e9339e61cbe)
* Change recent MSSQL migrations to drop COLUMN from ALTER TABLE which is ↵Justin Clark-Casey (justincc)2013-04-021-6/+6
| | | | | | either not syntactical or unnecessary. May fix http://opensimulator.org/mantis/view.php?id=6593
* Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz2013-02-091-0/+12
|
* Stopped storing dynamic attributes in the PrimShapeOren Hurvitz2013-01-251-1/+0
|
* Implement dynamic attribute persistence on mysql and mssqlJustin Clark-Casey (justincc)2013-01-251-0/+9
| | | | mssql is untested
* Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen2012-05-231-0/+14
| | | | | | | | | | | | | includes database region store migrations for mssql, mysql, sqlite enable/disable this module: Cap_EnvironmentSettings = "localhost" (for enable) Cap_EnvironmentSettings = "" (for disable) at ClientStack.LindenCaps section (OpenSimDefaults.ini file) or owerwrite in OpenSim.ini mantis: http://opensimulator.org/mantis/view.php?id=5860 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Updates to MSSQL store for 0.7.3 to include:Chris Hart2012-03-061-1/+84
| | | | | | * Telehub support * Bugfix to Friends lookups * Updates to Creator fields to store up to 255 characters for HG item creator storage
* Fix: MSSQLDB Grid - unable to register region ↵PixelTomsen2012-02-141-1/+8
| | | | http://opensimulator.org/mantis/view.php?id=5886
* Revert "Add GridStore migration for MSSQL."Justin Clark-Casey (justincc)2012-02-141-8/+0
| | | | This reverts commit 0b17a66e683f7ffca3877c1601c4179684b62144.
* Add GridStore migration for MSSQL.Justin Clark-Casey (justincc)2012-02-141-0/+8
| | | | This is done blind since I don't use MSSQL. If this doesn't work, then one will have to wait for it to be updated for the 0.7.3 opensim release.
* Fix: Covenant changed time not set ↵PixelTomsen2012-02-031-0/+8
| | | | | | http://opensimulator.org/mantis/view.php?id=5869 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Remove vestigal OpenSim.Data mono addins extension points that don't look ↵Justin Clark-Casey (justincc)2011-09-201-23/+0
| | | | like they've been active for at least 2 and a half years
* MSSQL Bug fix in user account retrieval, plus migrations for FriendsStore ↵Chris Hart2011-09-162-0/+60
| | | | and InventoryStore
* Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart2011-06-013-1/+71
| | | | support. Needs plenty of testing but clean install and migration from 0.6.9 have been tested and work, a few indexes still need to be added for performance.
* Mantis #5470 -- add forgotten MSSQL's GridUserStore. Thank you MrMonkEDiva Canto2011-05-071-0/+19
|
* Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to ↵Diva Canto2011-04-288-21/+176
| | | | speed with 0.7.x.
* add mssql support for media on a primJustin Clark-Casey (justincc)2010-07-261-1/+8
| | | | compiles but not tested. please test and correct if necessary!
* Removed (unused?) empty SQL files from MSSQL resource dirAlexRa2010-05-239-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.
* MSSQL Migration: CreatorID in InventoryItems changed to VARCHAR(36)AlexRa2010-05-231-0/+70
| | | | Again, the same thing about potentially having non-GUID CreatorID.
* MSSQL: added asset_flags, CreatorID to migrationsAlexRa2010-05-231-0/+6
|
* 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
* MSSQL tweaks for latest ROBUST - friends handling fixed, GridUserData ↵unknown2010-03-095-2/+32
| | | | | | placeholder added. Signed-off-by: Melanie <melanie@t-data.com>
* MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride2010-02-249-0/+101
| | | | | | works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
* MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown2009-10-051-0/+8
|
* Thank you, StrawberryFride, for a hit-and-run patch to add authenticationMelanie2009-09-061-0/+5
| | | | and user services to MSSQL
* Thanks StrawberryFride, for a patch that fixes MSSQL migration:Arthur Valadares2009-06-291-3/+3
| | | | | Minor tweak to a region migration SQL script for the OAR DateTime field - SQL Server syntax slightly different from MySQL (and there is no unsigned in MSSQL, sadly)
* From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague2009-06-291-0/+7
| | | | | | | | Attached is a patch that changes the oar file saving of creation date/time to an integer instead of a string. I did this after justincc emailed me saying there is a problem with internationalisation doing it the old way and I said I'd fix it. Its been tested with MySQL and I've made the changes for MSSQL but that hasn't been well tested.
* Applied patch from Mantis #3817, which fixes a error when using MSSQL. I ↵MW2009-06-182-12/+0
| | | | don't use MSSQL so couldn't test this myself. But there was certainly duplicated instructions in these files...which this patch fixes. Thanks Grumly57
* Add the missing resource files for MSSQLMelanie Thielker2009-06-172-0/+24
| | | | | | Mantis #3800
* Update svn properties.Jeff Ames2009-05-201-5/+5
|
* Thank you kindly, StrawberryFride, for a patch that:Charles Krinke2009-05-171-0/+5
| | | | | | | Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
* Thanks StrawberryFride for a MSSQL patch to mirror r9011.Homer Horwitz2009-04-051-0/+1
| | | | | Fixes Mantis #3409
* * Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey2009-02-1923-0/+934
| | | | | | | | | * 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 dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur2009-02-161-1/+0
| | | | | | | | OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
* - add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur2009-02-161-0/+1
| | | | | | | | OpenSim.Data.*.addin.xml - remove OpenSim.Grid.NewAssetServer.exe from bin/OpenSim.Data.addin.xml - add prebuild.xml section for OpenSim.Grid.AssetServer.Plugins.OpenSim.dll
* Update svn properties, minor formatting cleanup.Jeff Ames2009-01-081-5/+5
|
* Thank you kindly, StrawberryFride for a patch that:Charles Krinke2009-01-071-0/+5
| | | | | | | Solves the problem of unable to load prim items on region start in MSSQL. The error was in the MSSQLRegionData code that loads objects from the database, due to reliance on the ParentID field that is not used.
* Update svn properties, minor formatting cleanup.Jeff Ames2008-11-213-19/+19
|
* Mantis#2658. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-11-191-0/+6
| | | | | | Keeping up with MySQL and SQLite. Small code changes and another resource file to add.
* Mantis#2657. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2008-11-192-0/+13
| | | | | | Added access_time and create_time, plus the new sun position data to MSSQL code.
* Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz2008-11-1510-404/+0
|
* Mantis #2618Melanie Thielker2008-11-141-0/+5
| | | | | | | Thank you, StrawberryFride, for a patch that adds group permission support to MSSQL. Contains a migration, back up your database.
* Update svn properties. Add copyright headers. Minor formatting cleanup.Jeff Ames2008-11-092-50/+50
|
* Mantis#2591. Thank you kindly, Ruud Lathrop for a patch that:Charles Krinke2008-11-092-0/+50
| | | | | | | This patch is two script that fixes a issue when adding more then 1 avatar to estateban/estatemanager list. It removes a key and adds a index to the tables.
* Update svn properties, minor formatting cleanup.Jeff Ames2008-11-051-5/+5
|
* added missing file from mantis #2555Dahlia Trimble2008-11-051-0/+5
|