aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * Changed CreatorIDs consistently to varchar(128)Diva Canto2010-06-085-52/+53
| | | | | * Deleted redundant migration for assets in SQLite * Rewrote XInventory migrations in SQLite in the new style
* remove estate stuff in sqlite region migrations since this also exists in ↵Justin Clark-Casey (justincc)2010-06-041-54/+1
| | | | | | estate migrations, change Sandbox to sandbox in sqlite region migrations re-enabling the sqlite data tests revealed these errors!
* add sqlite database back to database testsJustin Clark-Casey (justincc)2010-06-041-1/+1
| | | | | this appears to be okay even though we reuse it between runs without deleting it first. size of the database appears not to be changing though that could be deceptive
* Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa2010-05-232-25/+88
| | | | | | | | | | | | ok, so the estate stores now want their own migration files, but as it happened the SQL definition were inside the Region migrations. It seems better/cleaner to keep each 'store' separately updatable. WARNING: any editing in the middle of the migration scripts (as opposite to just appending to them) has the potential of messing up updates of existing databases. As far as I can see, this one is (probably) safe, the worst that could happen is the EstateStore migration silently fail if the estate the tables are already there.
* SQLite: CreatorID added (and asset_flags moved) to the migration scriptAlexRa2010-05-191-0/+24
|
* Migrations for SQLite converted to new formatAlexRa2010-05-1646-709/+828
|
* * Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto2010-05-092-0/+10
| | | | | | stored in regionsettings. Upon generation of a new tile image, the old one is deleted. Tested for SQLite and MySql standalone. * Fixed small bug with map search where the local sim regions weren't found.
* These files are part of the GridUserService write-up.Diva Canto2010-05-071-0/+16
|
* Fixed: migration #2 for SQLite. Problem was that ATTACH cannot be done ↵Diva Canto2010-05-041-3/+2
| | | | inside a transaction.
* Switched everything to XInventory by default. The old Inventory is still ↵Diva Canto2010-05-022-0/+47
| | | | there for now, in case bugs pop up with XInventory.
* Bug fix: UserAccounts in SQLite was missing the primary key constraint.Diva Canto2010-04-161-1/+1
|
* Added FriendsData to both Null storage and SQLite. Untested.Diva Canto2010-02-282-0/+15
|
* Bug fixes on field names in order to make data import work from old users ↵Diva Canto2010-02-211-1/+1
| | | | table to new UserAccounts table.
* * Added SQlite connector for AvatarData. Tested -- works.Diva Canto2010-02-211-0/+9
| | | | | * Small bug fix in debug message * Set default standalone configs to use SQLite across the board
* Added UserAccountData and auth to the SQLite connector. Compiles, runs, but ↵Diva Canto2010-02-204-0/+45
| | | | access to these tables doesn't work.
* * Consistently use dashed uuid format for sqlite region data, as was ↵Justin Clarke Casey2009-05-071-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
* Thanks, Ewe Loon for a patch thatHomer Horwitz2009-04-251-0/+37
| | | | | | provides persistent AvatarAppearance for SQLite. Fixes Mantis #3296.
* * Apply http://opensimulator.org/mantis/view.php?id=3439Justin Clarke Casey2009-04-103-11/+11
| | | | | | | * This corrects problems seen on some SQLite systems where the migration fails because the two argument substr() isn't implemented * Thanks RemedyTomm!
* * Change SQLite asset UUID to dashed format to be consistentJustin Clarke Casey2009-04-091-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
* * Change UUIDs in SQLite user db to dashed format to match representations ↵Justin Clarke Casey2009-04-091-0/+11
| | | | elsewhere
* * Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey2009-04-091-8/+29
| | | | | | | | anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
* * Migrate UUID representations in SQLite inventory store to dashed formatJustin Clarke Casey2009-04-091-0/+15
| | | | | | * This makes the representation consistent with that most commonly used in the other supported database layers
* Adding migrations for MySQL and SQLite for removing the "old" cloud image.Homer Horwitz2009-04-051-0/+1
| | | | | | The new one already in the Library will be reinserted automatically. Fixes Mantis #964
* - remove dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur2009-02-161-1/+0
| | | | | | | | OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
* - add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur2009-02-161-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
* * Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey2009-01-191-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.
* Update svn properties, minor formatting cleanup.Jeff Ames2008-12-301-5/+5
|
* Thanks Gerhard for a patch that implements part 3 of VolumeDetection / ↵Dahlia Trimble2008-12-221-0/+5
| | | | persistance
* Update svn properties, minor formatting cleanup.Jeff Ames2008-11-211-6/+6
|
* Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2008-11-191-0/+6
| | | | | | Attached patch implements llCollisionSound. Thanks T. Sado.
* Fixed MySQL and SQLite so they will save theSean Dague2008-11-181-0/+8
| | | | | | | variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Add SQLite and the missing migrations files for last commitMelanie Thielker2008-11-141-0/+5
|
* implement email field for MySQL and SQLiteSean Dague2008-11-041-0/+5
| | | | | From: Sean Dague <sdague@gmail.com>
* Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2008-10-181-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.
* Add database persistence for material settingMelanie Thielker2008-10-031-0/+5
|
* * Updates the SQLite region database to support the same properties that the ↵Teravus Ovares2008-09-181-0/+28
| | | | | | | MySQL version does for the table, prims. * If this causes any unit tests to fail, the tests need to be updated.
* Adding currentLookAt to useragents table in SQLite. This complements theHomer Horwitz2008-09-171-0/+7
| | | | | | MySQL change from http://opensimulator.org/mantis/view.php?id=2073
* Mantis #904: Thanks jonc, for a patch that adds "useragents" table toHomer Horwitz2008-09-161-0/+20
| | | | | | | SQLite and stores the logout position in standalone mode. Note: This adds a migration for SQLite, so do your runprebuild
* * Patch http://opensimulator.org/mantis/view.php?id=2163Justin Clarke Casey2008-09-121-0/+5
| | | | | | | | * Add prim ClickAction persistence to SQLite * This will require a prebuild * Thanks nlin!
* Implement proper persistence of the following prim properties:Melanie Thielker2008-09-081-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.
* Fix for Bug #2065: New check out crashes on sqlite migrationSean Dague2008-08-281-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.
* get rid of the "drop if exists" lines in this old migration, as thoseSean Dague2008-08-271-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.
* Avatar Attachment persistence!! Patch #9168 (Mantis #1171)Melanie Thielker2008-08-181-0/+5
| | | | | | | Plumbs in attachment persistence and adds the tables. Currently MySQL only, no user functionality yet.
* Plumb in the partner and the account title fields for profile info.Melanie Thielker2008-08-151-0/+6
|
* Adds UserFlags and GodLevel to the user data store and plumbs then in.Melanie Thielker2008-08-141-0/+6
| | | | | | | This will have no effect unless both the UGAI and the region are this revision or later
* Add the UserStore migrations to the TP fixes patchMelanie Thielker2008-08-141-0/+5
|
* Thanks, zaki, for a patch that embeds plugin manifest files into plugin ↵Mike Mazur2008-08-061-0/+20
| | | | dlls. Fix issue 1876.
* Estate series, patch 9 (#9157)Melanie Thielker2008-08-011-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!
* Add the missing migration files :/Melanie Thielker2008-08-011-0/+8
|
* remove all the odd quoting, on the off chance this was causing someSean Dague2008-07-181-90/+90
| | | | | | of the issue.