| Commit message (Collapse) | Author | Files | Lines |
|---|
|
compiles but not tested. please test and correct if necessary!
|
|
compiles but not tested. please test and correct if necessary!
|
|
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.
|
|
Again, the same thing about potentially having non-GUID CreatorID.
|
|
|
|
|
|
Replaced all NNN_StoreName.sql migration resources with a more
readable, single-file-per-store
|
|
|
|
Replaced all NNN_StoreName.sql migration resources with a more
readable, single-file-per-store
|
|
placeholder added.
Signed-off-by: Melanie <melanie@t-data.com>
|
|
works, some outstanding issues around login location and border crossings on y axis.
Signed-off-by: Melanie <melanie@t-data.com>
|
|
|
|
|
|
and user services to MSSQL
|
|
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)
|
|
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.
|
|
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
|
|
Mantis #3800
|
|
|
|
Adds maturity & access logic for MSSQL platform to
mirror that of MySQL as committed in 9502.
|
|
Fixes Mantis #3409
|
|
* 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)
|
|
OpenSim.Data.*.addin.xml, this is cruft left over from previous
testing
- fix example SQLite connection string in
AssetInventoryServer.ini.example
|
|
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
|
|
|
|
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.
|
|
|
|
Keeping up with MySQL and SQLite. Small code changes and
another resource file to add.
|
|
Added access_time and create_time, plus the new sun position
data to MSSQL code.
|
|
|
|
Thank you, StrawberryFride, for a patch that adds group permission support
to MSSQL. Contains a migration, back up your database.
|
|
|
|
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.
|
|
|
|
|
|
|
|
Primary Key violation when just linked a lot of prims using MSSQL.
|
|
|
|
http://opensimulator.org/mantis/view.php?id=2295
* Sorry about that
|
|
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.
|
|
Thank you, RuudL, for a patch that brings MSSQL up to the same
implementation level as MySQL.
|
|
|
|
Thank you, RuudL, for a complete adaptation of migration and estate
data to MSSQL, and the updating of the RegionData handling in MSSQL.
|
|
dlls. Fix issue 1876.
|
|
* 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
|
|
MSSQL Avatar appearance solved.
Appearance functions and modified table.
|
|
|
|
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.
|
|
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)
|
|
* Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
|
