aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * Deleted duplicated migration that was failing anyway.Diva Canto2010-06-141-2/+0
| | | | * Added an error message in initial estate owner creation that makes it clear what needs to happen.
* Add the BEGIN; I had missedMelanie2010-06-091-0/+1
|
* Re-add Migration version 32, which apparently got dropped completely.Melanie2010-06-091-0/+72
|
* * Changed CreatorIDs consistently to varchar(128)Diva Canto2010-06-082-1/+9
| | | | | * Deleted redundant migration for assets in SQLite * Rewrote XInventory migrations in SQLite in the new style
* Add a migration to adjust types in the WL table. The new connector likes thatMelanie2010-06-081-0/+6
| | | | better
* Merge branch 'unitests'Melanie2010-05-262-84/+81
|\ | | | | | | Signed-off-by: Melanie <melanie@t-data.com>
| * MySQL Migrations: Minor correcton to Region/Estate splitAlexRa2010-05-232-6/+12
| | | | | | | | (some Estate SQL left behind in the Region migration)
| * Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa2010-05-232-78/+69
| | | | | | | | | | | | | | | | | | | | | | | | ok, so the estate stores now want their own migration files, but as it happened the SQL definition were inside the Region migrations. It seems better/cleaner to keep each 'store' separately updatable. WARNING: any editing in the middle of the migration scripts (as opposite to just appending to them) has the potential of messing up updates of existing databases. As far as I can see, this one is (probably) safe, the worst that could happen is the EstateStore migration silently fail if the estate the tables are already there.
* | The 8th migration statement in AssetStore.migrations didn't look right.Diva Canto2010-05-231-1/+1
|/
* Cleaned up MySql migrations a bit more, got rid of all old-form migration ↵Diva Canto2010-05-205-32/+8
| | | | files. Restored Presence table to its taboo-breaking form.
* MySQL: added CreatorID, moved asset_flag to migration scriptAlexRa2010-05-191-0/+8
|
* Converted MySQL migration history to the new formatAlexRa2010-05-1678-1002/+1228
| | | | | Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
* * Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto2010-05-091-0/+3
| | | | | | stored in regionsettings. Upon generation of a new tile image, the old one is deleted. Tested for SQLite and MySql standalone. * Fixed small bug with map search where the local sim regions weren't found.
* Add a field asset_flags and a corresponding enum to the asset database. ThisMelanie2010-05-091-0/+5
| | | | | | | CHANGES THE ASSET SERVER PROTOCOL and means you CAN NOT MIX PRIOR VERSIONS WITH LATER ONES. It may also eat your babies, yada, yada, yada. The usual cautions for migrations to the assets table apply. Coding: Can not guarantee nut free.
* These files are part of the GridUserService write-up.Diva Canto2010-05-071-0/+17
|
* GridUserService in place. Replaces the contrived concept of storing user's ↵Diva Canto2010-05-073-19/+4
| | | | | | home and position info in the presence service. WARNING: I violated a taboo by deleting 2 migration files and simplifying the original table creation for Presence. This should not cause any problems to anyone, though. Things will work with the new simplified table, as well as with the previous contrived one. If there are any problems, solving them is as easy as dropping the presence table and deleting its row in the migrations table. The presence info only exists during a user's session anyway. BTW, the Meshing files want to be committed too -- EOFs.
* Somehow the starting estate number in MySQL was lost. This adds a migrationMelanie2010-03-221-0/+3
| | | | | | | | to start estates at 100. Existing databases having autcreated estates below 100 will see a gap in estate numbering. Other database implementors need to ensure that no estates with numbers less that 100 are autocreated, unless they are prepared to deal with the viewer's built-in notions of Linden Mainland
* Implement the friends data adaptorMelanie2010-02-052-0/+10
|
* Fixed a missing field in the last regions table migration.Diva Canto2010-01-161-0/+1
|
* Add a handful of new region flags and a small migrationMelanie2010-01-151-0/+6
|
* Add last_seen field to regions tableMelanie2010-01-101-0/+5
|
* Preliminary work on the new default region setting mechanismMelanie2010-01-091-0/+6
|
* Add migrations to add fields to user and auth tablesMelanie2010-01-082-0/+13
|
* AvatarStore. Untested, but completeMelanie2010-01-041-0/+5
|
* Auth data migration.Diva Canto2010-01-011-0/+5
|
* Fixed a couple of bugs that were bombing the data migration.Diva Canto2009-12-292-2/+2
|
* Give the new user tables the once-over. Strip the current set of methodsMelanie2009-12-293-2/+16
| | | | | from IUserAccountService, we need to define what goes in there. Change the handler to the generic handler. Adjust migrations, add index
* * Added useraccount tableDiva Canto2009-12-291-0/+13
|
* Add the indices to really make this table workMelanie2009-12-281-0/+6
|
* Add a migration to add the 3 new fieldsMelanie2009-12-281-0/+7
|
* Add the second step of the friends migration to pull data from the old table ↵Melanie2009-12-281-0/+5
| | | | into the new
* Add the migration for friends and guard the presence Report functionMelanie2009-12-281-0/+9
|
* Forgot the migration fileMelanie2009-12-281-0/+15
|
* Add the Migration for the regions tableMelanie2009-09-271-0/+6
|
* Add the migration for scoping grid dataMelanie2009-09-161-0/+7
|
* Revising the user account data interfaces. No user functionality yetMelanie2009-09-061-0/+5
|
* Add the new AuthStore to migrations. Update OpenSim.Server.iniMelanie2009-09-041-0/+21
|
* 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.
* From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield2009-06-031-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch adds oar file date and time (UTC) meta data to an oar file when it is created. It also adds a unique ID, though this id does not in anyway identify the machine that the oar file was created on. When an oar file with this meta data is loaded this extra information is saved with the region settings and available via LSL through: - osLoadedCreationDate() - osLoadedCreationTime() - osLoadedCreationID() If there is no meta data these fields will be blank. Subsequent oar file loads will erase the information for the previous oar file load. Persistence has only been implemented for MySQL, the other backends need updating. Overall this allows us to much more easily identify the specific version of software that clients are using. Its very straightforward to edit the oar file to change the ID string to be something more human friendly. Included in the patch is a new file OpenSim/Data/MySQL/Resources/030_RegionStore.sql required for the MySQL DB migration. btw I had a chat with justincc about this a few weeks ago since he wrote the oar file import/export and he sounded happy to accept something that included date/time information but didn't want anything that would silently leak private information like machine names.
* From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield2009-05-271-0/+5
| | | | | | | | | | | | The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.
* Update svn properties.Jeff Ames2009-05-171-5/+5
|
* Thank you kindly, Patnad, for a patch that:Charles Krinke2009-05-121-0/+5
| | | | | | | | | This is to handle the changes in the v1.23 viewer of LL regarding the adult rating. With this patch a region can be changed to the adult rating from LL viewer v1.23 and above.
* WARNING: contains migrationSean Dague2009-05-081-0/+7
| | | | | Since creatorID is no longer treated as a UUID type in the code from the database we need to make sure that it isn't null in the database. This updates all empty string and null values for this column to the Zero UUID, and makes the column a not null definition with a default fo the Zero UUID.
* * Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey2009-05-071-0/+79
| | | | | | | | | | all other tables * This revision contains a mysql data migration. Please backup your mysql region database as a precaution before using this code. * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
* Adding migrations for MySQL and SQLite for removing the "old" cloud image.Homer Horwitz2009-04-051-0/+1
| | | | | | The new one already in the Library will be reinserted automatically. Fixes Mantis #964
* remove all the very old create and upgrade sql files, these wereSean Dague2009-02-1717-288/+0
| | | | | outdated by migrations 6 months ago.
* AssetInventoryServer plugins can't be a dependency for the ↵Mike Mazur2009-02-161-1/+0
| | | | OpenSim.Data.MySQL addin.
* Rename NewAssetServer AssetInventoryServer and fully qualify withMike Mazur2009-02-161-1/+1
| | | | | OpenSim.Grid.AssetInventoryServer.
* - 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
* * Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey2009-01-191-0/+5
| | | | | | | * Since this is a db change, as always I strongly recommend that you backup your database before updating to this revision * Haven't touched MSSQL in case I get it wrong - looking for some kind soul to take care of this.