aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
* 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
|
* Update svn properties, minor formatting cleanup.Jeff Ames2008-10-271-5/+5
|
* Thank you kindly, Ruud Lathrop for a patch that solves:Charles Krinke2008-10-271-0/+5
| | | | | Primary Key violation when just linked a lot of prims using MSSQL.
* Add a resource file on Strawberry's patch I missedMelanie Thielker2008-10-181-0/+7
|
* * Add missing mssql migration files from ↵Justin Clarke Casey2008-09-293-0/+76
| | | | | | | | http://opensimulator.org/mantis/view.php?id=2295 * Sorry about that
* Mantis#2291. Thank you kindly, StrawberryFride for a patch that solves:Charles Krinke2008-09-283-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.
* Mantis #2124Melanie Thielker2008-09-1411-14/+509
| | | | | | | Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
* Committing the missing resource file for MSSQL. Sorry...Melanie Thielker2008-09-021-0/+161
|
* Mantis #2095Melanie Thielker2008-09-016-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.
* Thanks, zaki, for a patch that embeds plugin manifest files into plugin ↵Mike Mazur2008-08-061-0/+23
| | | | dlls. Fix issue 1876.
* * Drop InvType from the assets table since it is no longer usedJustin Clarke Casey2008-07-021-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
* Mantis#1528. Thank you kindly, Boscata for:Charles Krinke2008-06-111-28/+31
| | | | | | MSSQL Avatar appearance solved. Appearance functions and modified table.
* *Patched CreateItemsTable.sql (MSSQL). Patch by Kyle and Chris from G2.mingchen2008-06-091-1/+1
|
* Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke2008-06-051-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.
* * Add a scratch implementation of the new inventory fields to the mssql ↵Justin Clarke Casey2008-04-301-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)
* * Change new inventory groupID field to 36 rather than 63Justin Clarke Casey2008-04-301-1/+7
| | | | | | * Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
* Update svn properties.Jeff Ames2008-04-031-44/+44
|
* whole lot more movingSean Dague2008-04-029-0/+283