aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
* 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.
* check in migration files for mysqlSean Dague2008-06-123-0/+152
|
* this removes use of the mapper for wearables, and I can confirm thingsSean Dague2008-05-211-30/+33
| | | | | | | get saved to the database. There are still issues on wearing things after a cleared cache that I'm looking at now.
* autocreate appearance table if it isn't thereSean Dague2008-05-191-0/+0
|
* prep for changes need to create the appearance tablesSean Dague2008-05-191-4/+1
| | | | | | by default
* Update svn properties. Minor formatting cleanup.Jeff Ames2008-05-012-40/+40
|
* * Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey2008-05-012-7/+7
| | | | | | | | settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code
* * Change mysql inventory items table version 3 upgrade sql to provide ↵Justin Clarke Casey2008-05-011-5/+5
| | | | explicit default values
* * Refactored the land table to be versionable in mySQL.Teravus Ovares2008-04-302-0/+42
| | | | | * Added AuthbuyerID so that if someone sets a land for sale to someone and then restarts the simulator, when the simulator comes back up, the setting persists.
* * Change new inventory groupID field to 36 rather than 63Justin Clarke Casey2008-04-301-1/+1
| | | | | | * Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
* * Long awaited patch from A_Biondi Mantis 923. Kept alive by Melanie. ↵Teravus Ovares2008-04-302-1/+15
| | | | | | | Thanks A_Biondi and Melanie! * This builds but might not work. JustinCC will examine.. it may work out of the box.
* whole lot more movingSean Dague2008-04-0214-0/+232