aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-04-16Bug fix: UserAccounts in SQLite was missing the primary key constraint.Diva Canto1-1/+1
2010-02-28Added FriendsData to both Null storage and SQLite. Untested.Diva Canto2-0/+15
2010-02-21Bug fixes on field names in order to make data import work from old users ↵Diva Canto1-1/+1
table to new UserAccounts table.
2010-02-21* Added SQlite connector for AvatarData. Tested -- works.Diva Canto1-0/+9
* Small bug fix in debug message * Set default standalone configs to use SQLite across the board
2010-02-20Added UserAccountData and auth to the SQLite connector. Compiles, runs, but ↵Diva Canto4-0/+45
access to these tables doesn't work.
2009-05-07* Consistently use dashed uuid format for sqlite region data, as was ↵Justin Clarke Casey1-0/+79
previously done for sqlite inventory data. * This revision contains a data migration. Please backup your sqlite region db 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-25Thanks, Ewe Loon for a patch thatHomer Horwitz1-0/+37
provides persistent AvatarAppearance for SQLite. Fixes Mantis #3296.
2009-04-10* Apply http://opensimulator.org/mantis/view.php?id=3439Justin Clarke Casey3-11/+11
* This corrects problems seen on some SQLite systems where the migration fails because the two argument substr() isn't implemented * Thanks RemedyTomm!
2009-04-09* Change SQLite asset UUID to dashed format to be consistentJustin Clarke Casey1-0/+7
* Remaining inconsistent uuids (non dashed) are in region store for sqlite and mysql * Migration of these will happen at a later date, unless someone else wants to do it
2009-04-09* Change UUIDs in SQLite user db to dashed format to match representations ↵Justin Clarke Casey1-0/+11
elsewhere
2009-04-09* Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey1-8/+29
anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
2009-04-09* Migrate UUID representations in SQLite inventory store to dashed formatJustin Clarke Casey1-0/+15
* This makes the representation consistent with that most commonly used in the other supported database layers
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-16- remove dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur1-1/+0
OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
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/+8
* 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-12-30Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2008-12-22Thanks Gerhard for a patch that implements part 3 of VolumeDetection / ↵Dahlia Trimble1-0/+5
persistance
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-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/+6
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/+5
2008-09-18* Updates the SQLite region database to support the same properties that the ↵Teravus Ovares1-0/+28
MySQL version does for the table, prims. * If this causes any unit tests to fail, the tests need to be updated.
2008-09-17Adding currentLookAt to useragents table in SQLite. This complements theHomer Horwitz1-0/+7
MySQL change from http://opensimulator.org/mantis/view.php?id=2073
2008-09-16Mantis #904: Thanks jonc, for a patch that adds "useragents" table toHomer Horwitz1-0/+20
SQLite and stores the logout position in standalone mode. Note: This adds a migration for SQLite, so do your runprebuild
2008-09-12* Patch http://opensimulator.org/mantis/view.php?id=2163Justin Clarke Casey1-0/+5
* Add prim ClickAction persistence to SQLite * This will require a prebuild * Thanks nlin!
2008-09-08Implement proper persistence of the following prim properties:Melanie Thielker1-0/+8
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-28Fix for Bug #2065: New check out crashes on sqlite migrationSean Dague1-0/+1
I apparently missed one drop tables statement that was actually needed when I did the cleaning to make this work for old sqlite versions.
2008-08-27get rid of the "drop if exists" lines in this old migration, as thoseSean Dague1-6/+0
tables shouldn't exist yet, and the exists keyword is relatively new in sqlite. This has been breaking a lot of people on Suse Enterprise Linux, for instance.
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/+20
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-18remove all the odd quoting, on the off chance this was causing someSean Dague1-90/+90
of the issue.
2008-07-18put the entire thing inside a transaction. This probably doesn'tSean Dague1-0/+4
help much, but it might.
2008-07-18fix typo in create index that caused the entire migration to fail.Sean Dague1-1/+12
put some drop table if exist clauses in here to hopefully let this migration work for people that are in an intermediary broken state right now.
2008-07-18Patch #9151Melanie Thielker1-0/+92
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-14Patch #9148Melanie Thielker1-0/+5
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-03Update svn properties.Jeff Ames1-10/+10
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-0/+10
* 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/+38
2008-06-25add migrations to mysql and sqlite for flags on embedded inventorySean Dague1-0/+5
2008-06-21* Persists region banlists across reboots for the sqlite datastore also now.Teravus Ovares1-0/+10
2008-06-13add indexes for sqlite inventorySean Dague1-0/+8