aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-07-03add 3 migrations, 1 each for prims, primshapes, and primitemsSean Dague3-0/+65
to move all their UUID stores from varchar(255) -> char(36). Based on past evidence, this should help with performance.
2008-07-03migrate the myisam mysql regions to innodbSean Dague1-0/+12
2008-07-03Update svn properties.Jeff Ames1-5/+5
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-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
2008-06-29patch and files from mantis #1630, Thanks MelanieMW1-0/+40
2008-06-25add migrations to mysql and sqlite for flags on embedded inventorySean Dague1-0/+5
2008-06-24based on positive feedback on performance of making keys fixed lengthSean Dague1-0/+31
for assets, make all the indexed columns in the inventory fixed length via migration.
2008-06-23add migration to go from varchar -> char for uuid. TestedSean Dague1-0/+9
on my machine, and works, but backing up before migrations is always a good idea.
2008-06-21* Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares1-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.
2008-06-19add migrations support for mysql log store. This should completeSean Dague2-1/+11
all the mysql bits for migration.
2008-06-19fix an edge case with migrations in the region store.Sean Dague1-0/+32
Add migration support to gridstore.
2008-06-16the beginning of the great id format migration. This makesSean Dague1-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.
2008-06-12look mom, migrations in action. This adds a couple of indexesSean Dague1-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.
2008-06-12Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague4-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.
2008-06-12check in region store initial migration definition, Sean Dague1-0/+150
now on to integrating this approach into the mysql driver. Beware the next couple of checkins.
2008-06-12check in migration files for mysqlSean Dague3-0/+152
2008-05-21this removes use of the mapper for wearables, and I can confirm thingsSean Dague1-30/+33
get saved to the database. There are still issues on wearing things after a cleared cache that I'm looking at now.
2008-05-19autocreate appearance table if it isn't thereSean Dague1-0/+0
2008-05-19prep for changes need to create the appearance tablesSean Dague1-4/+1
by default
2008-05-01Update svn properties. Minor formatting cleanup.Jeff Ames2-40/+40
2008-05-01* Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey2-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
2008-05-01* Change mysql inventory items table version 3 upgrade sql to provide ↵Justin Clarke Casey1-5/+5
explicit default values
2008-04-30* Refactored the land table to be versionable in mySQL.Teravus Ovares2-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.
2008-04-30* Change new inventory groupID field to 36 rather than 63Justin Clarke Casey1-1/+1
* Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
2008-04-30* Long awaited patch from A_Biondi Mantis 923. Kept alive by Melanie. ↵Teravus Ovares2-1/+15
Thanks A_Biondi and Melanie! * This builds but might not work. JustinCC will examine.. it may work out of the box.
2008-04-02whole lot more movingSean Dague14-0/+232