aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2014-11-28Remove unmaintained MSSQL support.Justin Clark-Casey (justincc)13-2899/+0
This has not been maintained for more than 2 years, is unimplemented for newer features (e.g. built-in groups) and has no core developers using it. If somebody fixes these issues then it could be reinstated.
2014-04-21Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz1-3/+11
2014-03-26Add MSSQL EstateStore.migrations VERSION 10 transaction to add ↵Justin Clark-Casey (justincc)1-0/+8
AllowLandMark, AllowParcelChanges and AllowSetHome columns to estate_settings table. Taken from http://opensimulator.org/mantis/view.php?id=7074 by LuciusSirnah. Thanks!
2014-03-26Fix extra physics params MSSQL migration (version 39).Justin Clark-Casey (justincc)1-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.
2013-09-22Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood1-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)
2013-04-02Change recent MSSQL migrations to drop COLUMN from ALTER TABLE which is ↵Justin Clark-Casey (justincc)1-6/+6
either not syntactical or unnecessary. May fix http://opensimulator.org/mantis/view.php?id=6593
2013-02-09Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz1-0/+12
2013-01-25Stopped storing dynamic attributes in the PrimShapeOren Hurvitz1-1/+0
2013-01-25Implement dynamic attribute persistence on mysql and mssqlJustin Clark-Casey (justincc)1-0/+9
mssql is untested
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen1-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>
2012-03-06Updates to MSSQL store for 0.7.3 to include:Chris Hart1-1/+84
* Telehub support * Bugfix to Friends lookups * Updates to Creator fields to store up to 255 characters for HG item creator storage
2012-02-14Fix: MSSQLDB Grid - unable to register region ↵PixelTomsen1-1/+8
http://opensimulator.org/mantis/view.php?id=5886
2012-02-14Revert "Add GridStore migration for MSSQL."Justin Clark-Casey (justincc)1-8/+0
This reverts commit 0b17a66e683f7ffca3877c1601c4179684b62144.
2012-02-14Add GridStore migration for MSSQL.Justin Clark-Casey (justincc)1-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.
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen1-0/+8
http://opensimulator.org/mantis/view.php?id=5869 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2011-09-20Remove vestigal OpenSim.Data mono addins extension points that don't look ↵Justin Clark-Casey (justincc)1-23/+0
like they've been active for at least 2 and a half years
2011-09-16MSSQL Bug fix in user account retrieval, plus migrations for FriendsStore ↵Chris Hart2-0/+60
and InventoryStore
2011-06-01Updates to MSSQL to most recent compatibility, also included Windlight ↵Chris Hart3-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.
2011-05-07Mantis #5470 -- add forgotten MSSQL's GridUserStore. Thank you MrMonkEDiva Canto1-0/+19
2011-04-28Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to ↵Diva Canto8-21/+176
speed with 0.7.x.
2010-07-26add mssql support for media on a primJustin Clark-Casey (justincc)1-1/+8
compiles but not tested. please test and correct if necessary!
2010-07-26add mssql support for media on a primJustin Clark-Casey (justincc)1-1/+8
compiles but not tested. please test and correct if necessary!
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-23MSSQL: added asset_flags, CreatorID to migrationsAlexRa1-0/+6
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-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-03-09MSSQL tweaks for latest ROBUST - friends handling fixed, GridUserData ↵unknown5-2/+32
placeholder added. Signed-off-by: Melanie <melanie@t-data.com>
2010-02-24MSSQL Additions for Presence Refactor branch. Most functionality tested and ↵StrawberryFride9-0/+101
works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie <melanie@t-data.com>
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown1-0/+8
2009-10-05MSSQL changes for Grid server in ROBUST plus some code tweaks 'n tidy upunknown1-0/+8
2009-09-06Thank you, StrawberryFride, for a hit-and-run patch to add authenticationMelanie1-0/+5
and user services to MSSQL
2009-06-29Thanks StrawberryFride, for a patch that fixes MSSQL migration:Arthur Valadares1-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)
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-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.
2009-06-18Applied patch from Mantis #3817, which fixes a error when using MSSQL. I ↵MW2-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
2009-06-17Add the missing resource files for MSSQLMelanie Thielker2-0/+24
Mantis #3800
2009-05-20Update svn properties.Jeff Ames1-5/+5
2009-05-17Thank you kindly, StrawberryFride, for a patch that:Charles Krinke1-0/+5
Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
2009-04-05Thanks StrawberryFride for a MSSQL patch to mirror r9011.Homer Horwitz1-0/+1
Fixes Mantis #3409
2009-02-19* Apply http://opensimulator.org/mantis/view.php?id=3142Justin Clarke Casey23-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)
2009-02-16- remove dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur1-1/+0
OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
2009-02-16- add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur1-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
2009-01-08Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2009-01-07Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-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.
2008-11-21Update svn properties, minor formatting cleanup.Jeff Ames3-19/+19
2008-11-19Mantis#2658. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-0/+6
Keeping up with MySQL and SQLite. Small code changes and another resource file to add.
2008-11-19Mantis#2657. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2-0/+13
Added access_time and create_time, plus the new sun position data to MSSQL code.
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz10-404/+0