aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-09-12* Add userstore sql upgrade I carelessly forgot to check in a couple of ↵Justin Clarke Casey1-0/+5
revisions ago * Hopefully there wasn't a problem anyway, since the look at stuff isn't enabled yet
2008-09-10Thanks, nlin, for a patch implementing persistence for "When Left Clicked"Mike Mazur1-0/+6
object property. Fix issue 2149.
2008-09-08Implement proper persistence of the following prim properties:Melanie Thielker1-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.
2008-08-24Add the fields for the eye candy and sale featires to the prims table.Melanie Thielker1-0/+27
No user functionality yet. Run prebuild. Contains a Migration. May contain nuts.
2008-08-18Avatar Attachment persistence!! Patch #9168 (Mantis #1171)Melanie Thielker1-0/+5
Plumbs in attachment persistence and adds the tables. Currently MySQL only, no user functionality yet.
2008-08-15Plumb in the partner and the account title fields for profile info.Melanie Thielker1-0/+6
2008-08-14Adds UserFlags and GodLevel to the user data store and plumbs then in.Melanie Thielker1-0/+6
This will have no effect unless both the UGAI and the region are this revision or later
2008-08-14Add the UserStore migrations to the TP fixes patchMelanie Thielker1-0/+5
2008-08-06Thanks, zaki, for a patch that embeds plugin manifest files into plugin ↵Mike Mazur1-0/+23
dlls. Fix issue 1876.
2008-08-01Estate series, patch 9 (#9157)Melanie Thielker1-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!
2008-08-01Add the missing migration files :/Melanie Thielker1-0/+8
2008-07-18Patch #9151Melanie Thielker1-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.
2008-07-16added index to ParentID on prims, as this is sorted on for prim loading.Sean Dague1-0/+5
This should speed up initial load of prims, especially on primy regions.
2008-07-15add migration for SceneGroupID to char(36) plus add an index. ThisSean Dague1-0/+9
should actually speed up deletes substantially, especially for large regions, as this was a table scan before.
2008-07-14Patch #9148Melanie Thielker1-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
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