aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
...
* 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.
* Yay for unit tests. Increased the type width of the prims and primshapesMelanie Thielker2008-11-261-37/+41
| | | | | | | tables, and changed the database modules to actually push these doubles down into the database layer.
* A migration to make the floats in prims table be doublesMelanie Thielker2008-11-261-0/+41
|
* A migration to convert the floats int the database to doubles.Melanie Thielker2008-11-262-0/+60
| | | | | | Maybe we don't have to say "Shift happens" as often anymore....
* Committing the LCO database layer. Native MySQL, no ADO. New reconnectMelanie Thielker2008-11-261-0/+6
| | | | | | | | mechanism to prevent prim loss. Preserve link order on sim restart and drag copy. Fix drag-copied prims' inventories. Fix persistence of child prim inventories.
* Update svn properties, minor formatting cleanup.Jeff Ames2008-11-211-6/+6
|
* Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2008-11-191-0/+6
| | | | | | Attached patch implements llCollisionSound. Thanks T. Sado.
* Fixed MySQL and SQLite so they will save theSean Dague2008-11-181-0/+8
| | | | | | | variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Add SQLite and the missing migrations files for last commitMelanie Thielker2008-11-141-0/+5
|
* add create_time and access_time to asset db for mysql, as wellSean Dague2008-11-061-0/+6
| | | | | | | | | | | | as the code to update these at the appropriate time. This isn't surfaced in AssetBase yet. Change the replace into to an insert into for asset create. Assets are not supposed to be updatable, and the replace into is more expensive. From: Sean Dague <sdague@gmail.com>
* implement email field for MySQL and SQLiteSean Dague2008-11-041-0/+5
| | | | | From: Sean Dague <sdague@gmail.com>
* Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2008-10-181-0/+7
| | | | | | | | Add rezzing time to objects. Add Object return and traffic fields to land database. Add plumbing for auto return. Implement auto return. Contains a migration. May contain nuts.
* Add database persistence for material settingMelanie Thielker2008-10-031-0/+6
|
* * Add userstore sql upgrade I carelessly forgot to check in a couple of ↵Justin Clarke Casey2008-09-121-0/+5
| | | | | | | | revisions ago * Hopefully there wasn't a problem anyway, since the look at stuff isn't enabled yet
* Thanks, nlin, for a patch implementing persistence for "When Left Clicked"Mike Mazur2008-09-101-0/+6
| | | | | | object property. Fix issue 2149.
* Implement proper persistence of the following prim properties:Melanie Thielker2008-09-081-0/+9
| | | | | | | | | Floating text, Rotation, Texture animation, Particle System This will make "Eye Candy" scripts work without modification in XEngine. The use of the CHANGED_REGION_RESTART hack is no longer needed. Implemented in MySQL only, hovertext also in SQLite.
* Add the fields for the eye candy and sale featires to the prims table.Melanie Thielker2008-08-241-0/+27
| | | | | | | No user functionality yet. Run prebuild. Contains a Migration. May contain nuts.
* Avatar Attachment persistence!! Patch #9168 (Mantis #1171)Melanie Thielker2008-08-181-0/+5
| | | | | | | Plumbs in attachment persistence and adds the tables. Currently MySQL only, no user functionality yet.
* Plumb in the partner and the account title fields for profile info.Melanie Thielker2008-08-151-0/+6
|
* Adds UserFlags and GodLevel to the user data store and plumbs then in.Melanie Thielker2008-08-141-0/+6
| | | | | | | This will have no effect unless both the UGAI and the region are this revision or later
* Add the UserStore migrations to the TP fixes patchMelanie Thielker2008-08-141-0/+5
|
* Thanks, zaki, for a patch that embeds plugin manifest files into plugin ↵Mike Mazur2008-08-061-0/+23
| | | | dlls. Fix issue 1876.
* Estate series, patch 9 (#9157)Melanie Thielker2008-08-011-0/+6
| | | | | | | | | Adds the new access semantics and the new flag (allow only age verified) Plumbs in the abuse email address from sim to viewer. The other way around, libomv appears to be lacking support for the data field in the packet. Includes a migration, run prebuild!
* Add the missing migration files :/Melanie Thielker2008-08-011-0/+8
|
* Patch #9151Melanie Thielker2008-07-181-0/+103
| | | | | | Makes the estate dialog fully functional. Implements all client facing functionality. Moves estate data from estate_settings.xml, which is used to provide defaults, to the region data store. Creates one estate for each region, and places the region in it. Converts all region bans to estate bans.
* added index to ParentID on prims, as this is sorted on for prim loading.Sean Dague2008-07-161-0/+5
| | | | | | This should speed up initial load of prims, especially on primy regions.
* add migration for SceneGroupID to char(36) plus add an index. ThisSean Dague2008-07-151-0/+9
| | | | | | | should actually speed up deletes substantially, especially for large regions, as this was a table scan before.
* Patch #9148Melanie Thielker2008-07-141-0/+9
| | | | | | | | Patch 5 in the region settings series. Adds a migration to ensure corrupted data is purged and re-read from defaults. Some changes. Still no full functionality
* add 3 migrations, 1 each for prims, primshapes, and primitemsSean Dague2008-07-033-0/+65
| | | | | | | to move all their UUID stores from varchar(255) -> char(36). Based on past evidence, this should help with performance.
* migrate the myisam mysql regions to innodbSean Dague2008-07-031-0/+12
|
* Update svn properties.Jeff Ames2008-07-031-5/+5
|
* * Drop InvType from the assets table since it is no longer usedJustin Clarke Casey2008-07-021-0/+5
| | | | | | | | * 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
* patch and files from mantis #1630, Thanks MelanieMW2008-06-291-0/+40
|
* add migrations to mysql and sqlite for flags on embedded inventorySean Dague2008-06-251-0/+5
|
* based on positive feedback on performance of making keys fixed lengthSean Dague2008-06-241-0/+31
| | | | | | | for assets, make all the indexed columns in the inventory fixed length via migration.
* add migration to go from varchar -> char for uuid. TestedSean Dague2008-06-231-0/+9
| | | | | | | on my machine, and works, but backing up before migrations is always a good idea.
* * Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares2008-06-211-0/+5
| | | | | | | | World->Region/Estate. Then on the Estate tab, at the lower right hand corner, clicking the 'Add' button and picking an avatar. * It only persists across reboots for the mySQL datastore currently. * Currently have stubs in the other datastores.
* add migrations support for mysql log store. This should completeSean Dague2008-06-192-1/+11
| | | | | | all the mysql bits for migration.
* fix an edge case with migrations in the region store.Sean Dague2008-06-191-0/+32
| | | | | | Add migration support to gridstore.
* the beginning of the great id format migration. This makesSean Dague2008-06-161-0/+9
| | | | | | | | | asset uuids no longer binary. I've tested this migration a few times, and it seems working in all the scenarios I've found but it wouldn't hurt to backup your asset db before running this as it does touch a very sensitive part of our content system.
* look mom, migrations in action. This adds a couple of indexesSean Dague2008-06-121-0/+6
| | | | | | | | | to mysql regions that should help on performance of some of the selects. We should start capturing more data on performance bits to figure out where else we are missing indexes and add them via migrations as well.
* Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague2008-06-124-15/+29
| | | | | | | | | and no schema. It should also work with a non up to date schema as well. Btw, meetings in which I can get code done are the right kind of meetings.
* check in region store initial migration definition, Sean Dague2008-06-121-0/+150
| | | | | | | now on to integrating this approach into the mysql driver. Beware the next couple of checkins.