aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2013-02-09Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz1-0/+12
2013-01-25Remove the accidental PrimShapes column that I added back to the SQLite ↵Justin Clark-Casey (justincc)1-2/+1
region store
2013-01-25Fix tests by adding DynAttrs add column commands to RegionStore.migrations ↵Justin Clark-Casey (justincc)1-0/+6
(these were originally in 021_RegionStore.sql which I might have forgotton to add 2 years ago).
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen1-0/+11
includes database region store migrations for mssql, mysql, sqlite enable/disable this module: Cap_EnvironmentSettings = "localhost" (for enable) Cap_EnvironmentSettings = "" (for disable) at ClientStack.LindenCaps section (OpenSimDefaults.ini file) or owerwrite in OpenSim.ini mantis: http://opensimulator.org/mantis/view.php?id=5860 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2012-02-17Parcel sales support to SQLiteBlueWall1-1/+7
2012-02-17Fillin missing SQLite support for TelehubsBlueWall1-0/+16
2012-02-14Fix: Lightshare Module(Windlight)-Region settings are not applicable for ↵PixelTomsen1-0/+70
database sqlite mantis: http://opensimulator.org/mantis/view.php?id=5888
2012-02-03Fix: Covenant changed time not set ↵PixelTomsen1-1/+6
http://opensimulator.org/mantis/view.php?id=5869 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2011-09-20Remove vestigal OpenSim.Data mono addins extension points that don't look ↵Justin Clark-Casey (justincc)1-20/+0
like they've been active for at least 2 and a half years
2011-08-15Remove un-needed ATTACH command in migration script.BlueWall1-3/+1
This was causing issues when using specified paths to database files by using a hard-coded name.
2010-09-01Fix sqlite migration problems by moving migrations in 019_RegionStore.sql ↵Justin Clark-Casey (justincc)3-14/+14
and 020 into RegionStore.migrations This shows that panda is still not running the sqlite database tests since this change fixes the test failure in that area when "nant test" is executed locally
2010-08-30Implements parcel media setting persistence and packet / CAPS handlingJonathan Freedman1-0/+10
properly for the new media settings. Signed-off-by: Melanie <melanie@t-data.com>
2010-08-30local commit with parcel media bitsJonathan Freedman1-0/+10
Signed-off-by: Melanie <melanie@t-data.com>
2010-07-26add missing regionstore migration file for new fields. D'oh!Justin Clark-Casey (justincc)1-0/+6
this should enable persistence now
2010-07-15add missing regionstore migration file for new fields. D'oh!Justin Clark-Casey (justincc)1-0/+6
this should enable persistence now
2010-06-08* Changed CreatorIDs consistently to varchar(128)Diva Canto5-52/+53
* Deleted redundant migration for assets in SQLite * Rewrote XInventory migrations in SQLite in the new style
2010-06-04remove estate stuff in sqlite region migrations since this also exists in ↵Justin Clark-Casey (justincc)1-54/+1
estate migrations, change Sandbox to sandbox in sqlite region migrations re-enabling the sqlite data tests revealed these errors!
2010-06-04add sqlite database back to database testsJustin Clark-Casey (justincc)1-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
2010-05-23Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa2-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.
2010-05-19SQLite: CreatorID added (and asset_flags moved) to the migration scriptAlexRa1-0/+24
2010-05-18Migrations for SQLite converted to new formatAlexRa46-709/+828
2010-05-16Migrations for SQLite converted to new formatAlexRa46-709/+828
2010-05-09* Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto2-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.
2010-05-07These files are part of the GridUserService write-up.Diva Canto1-0/+16
2010-05-04Fixed: migration #2 for SQLite. Problem was that ATTACH cannot be done ↵Diva Canto1-3/+2
inside a transaction.
2010-05-02Switched everything to XInventory by default. The old Inventory is still ↵Diva Canto2-0/+47
there for now, in case bugs pop up with XInventory.
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.