aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-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.
2009-06-03From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield1-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.
2009-05-27From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield1-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.
2009-05-17Update svn properties.Jeff Ames1-5/+5
2009-05-12Thank you kindly, Patnad, for a patch that:Charles Krinke1-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.
2009-05-08WARNING: contains migrationSean Dague1-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.
2009-05-07* Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey1-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
2009-04-05Adding migrations for MySQL and SQLite for removing the "old" cloud image.Homer Horwitz1-0/+1
The new one already in the Library will be reinserted automatically. Fixes Mantis #964
2009-02-17remove all the very old create and upgrade sql files, these wereSean Dague17-288/+0
outdated by migrations 6 months ago.
2009-02-16AssetInventoryServer plugins can't be a dependency for the ↵Mike Mazur1-1/+0
OpenSim.Data.MySQL addin.
2009-02-16Rename NewAssetServer AssetInventoryServer and fully qualify withMike Mazur1-1/+1
OpenSim.Grid.AssetInventoryServer.
2009-02-16- add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur1-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
2009-01-19* Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey1-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.
2008-11-26Yay for unit tests. Increased the type width of the prims and primshapesMelanie Thielker1-37/+41
tables, and changed the database modules to actually push these doubles down into the database layer.
2008-11-26A migration to make the floats in prims table be doublesMelanie Thielker1-0/+41
2008-11-26A migration to convert the floats int the database to doubles.Melanie Thielker2-0/+60
Maybe we don't have to say "Shift happens" as often anymore....
2008-11-26Committing the LCO database layer. Native MySQL, no ADO. New reconnectMelanie Thielker1-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.
2008-11-21Update svn properties, minor formatting cleanup.Jeff Ames1-6/+6
2008-11-19Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke1-0/+6
Attached patch implements llCollisionSound. Thanks T. Sado.
2008-11-18Fixed MySQL and SQLite so they will save theSean Dague1-0/+8
variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-11-14Add SQLite and the missing migrations files for last commitMelanie Thielker1-0/+5
2008-11-06add create_time and access_time to asset db for mysql, as wellSean Dague1-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>
2008-11-04implement email field for MySQL and SQLiteSean Dague1-0/+5
From: Sean Dague <sdague@gmail.com>
2008-10-18Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker1-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.
2008-10-03Add database persistence for material settingMelanie Thielker1-0/+6
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.