aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
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
2008-11-14Mantis #2618Melanie Thielker1-0/+5
Thank you, StrawberryFride, for a patch that adds group permission support to MSSQL. Contains a migration, back up your database.
2008-11-09Update svn properties. Add copyright headers. Minor formatting cleanup.Jeff Ames2-50/+50
2008-11-09Mantis#2591. Thank you kindly, Ruud Lathrop for a patch that:Charles Krinke2-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.
2008-11-05Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2008-11-05added missing file from mantis #2555Dahlia Trimble1-0/+5
2008-10-27Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2008-10-27Thank you kindly, Ruud Lathrop for a patch that solves:Charles Krinke1-0/+5
Primary Key violation when just linked a lot of prims using MSSQL.
2008-10-18Add a resource file on Strawberry's patch I missedMelanie Thielker1-0/+7
2008-09-29* Add missing mssql migration files from ↵Justin Clarke Casey3-0/+76
http://opensimulator.org/mantis/view.php?id=2295 * Sorry about that
2008-09-28Mantis#2291. Thank you kindly, StrawberryFride for a patch that solves:Charles Krinke3-53/+0
User server won't start up for a MSSQL grid migrating from a significantly older version to current version due to duplication in three of the migrations code files. Patch included takes out the duplicated code from the three files so a smooth update should happen on start up.
2008-09-14Mantis #2124Melanie Thielker11-14/+509
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-02Committing the missing resource file for MSSQL. Sorry...Melanie Thielker1-0/+161
2008-09-01Mantis #2095Melanie Thielker6-0/+327
Thank you, RuudL, for a complete adaptation of migration and estate data to MSSQL, and the updating of the RegionData handling in MSSQL.
2008-08-06Thanks, zaki, for a patch that embeds plugin manifest files into plugin ↵Mike Mazur1-0/+23
dlls. Fix issue 1876.
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-1/+0
* 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-11Mantis#1528. Thank you kindly, Boscata for:Charles Krinke1-28/+31
MSSQL Avatar appearance solved. Appearance functions and modified table.
2008-06-09*Patched CreateItemsTable.sql (MSSQL). Patch by Kyle and Chris from G2.mingchen1-1/+1
2008-06-05Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke1-1/+2
I have detected a bug of conversion data type in OpenSim.Data.MSSQL.MSSQLInventoryData.addInventoryItem(InventoryItemBase item) in the GroupOwned field. My sollution is to change the flield to bit in the table. In the readInventoryItem(IDataReader reader) change too item.Flags = (uint) reader["flags"]; to item.Flags = Convert.ToUInt32(reader["flags"]); Now Inventory runs fine.
2008-04-30* Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey1-2/+2
database adapter * I don't use mssql so this may not work, corrections (in the form of patches) are welcome. * Unlike mysql, mssql requires manual updating of existing tables here (which should mean just adding the new fields manually)
2008-04-30* Change new inventory groupID field to 36 rather than 63Justin Clarke Casey1-1/+7
* Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
2008-04-03Update svn properties.Jeff Ames1-44/+44
2008-04-02whole lot more movingSean Dague9-0/+283