aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Fix SQLite database plugin for UserAccountData queries with a single word.Marck2010-08-151-1/+1
|
* Hopefully fixes mantis #4852Diva Canto2010-07-081-2/+2
|
* Same patch as before but for SQLite.Diva Canto2010-06-271-0/+8
|
* * 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
* Fix bug where prim items were not loaded in the new sqlite database handlerJustin Clark-Casey (justincc)2010-06-041-27/+39
| | | | This addresses mantis http://opensimulator.org/mantis/view.php?id=4739
* 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.
* Removed MySql and SQLite-specific asset test filesAlexRa2010-05-231-64/+0
|
* All data tests made DBMS-independentAlexRa2010-05-233-195/+0
|
* Revert one of the previous patches' hunks. The new code looked better, butMelanie2010-05-201-3/+10
| | | | was less efficient.
* SQLite: CreatorID added (and asset_flags moved) to the migration scriptAlexRa2010-05-191-0/+24
|
* Added CreatorID to SQLite asset dataAlexRa2010-05-191-15/+27
|
* A bit of harmless refactoring in SQLiteAssetData.csAlexRa2010-05-191-10/+3
|
* Migrations for SQLite converted to new formatAlexRa2010-05-1646-709/+828
|
* Yey for unit tests. The previous commit had a couple of bugs on SQL ↵Diva Canto2010-05-091-1/+1
| | | | statements. Fixed here.
* * Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto2010-05-094-3/+20
| | | | | | 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.
* Add Delete handler to SQLite (NG)Melanie2010-05-091-15/+16
|
* Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie2010-05-091-0/+5
| | | | asset deletion in robust handler.
* These files are part of the GridUserService write-up.Diva Canto2010-05-072-0/+77
|
* 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-023-1/+48
| | | | there for now, in case bugs pop up with XInventory.
* minor: eliminate more debug Console.WriteLines, convert one to logging insteadJustin Clark-Casey (justincc)2010-04-302-2/+6
|
* take out some debug logging in the sqlite db adaptorJustin Clark-Casey (justincc)2010-04-301-3/+3
|
* rename SQLiteNG to SQLite and SQLite to SQLiteLegacyJustin Clark-Casey (justincc)2010-04-3012-169/+238
| | | | | | | this seems the least evil way forward since mono 2.6 and later will see increasing usage, and this only works with what was SQLiteNG MAC USERS WILL NEED TO CHANGE REFERENCES TO "OpenSim.Data.SQLite.dll" to "OpenSim.Data.SQLiteLegacy.dll" in OpenSim.ini and config-include/StandaloneCommon.ini (if using standalone) See the OpenSim.ini.example and StandaloneCommon.ini.example files for more details This commit also temporarily changes unsigned ParentEstateID values in the OpenSim.Data.Tests to signed temporarily, since the new plugin enforces creation of signed fields in the database (which is what the SQL actually specifies). And change data columns in sqlite is a pita.
* One more bug fix in sqlite sql statements.Diva Canto2010-04-161-1/+1
|
* Bug fix: UserAccounts in SQLite was missing the primary key constraint.Diva Canto2010-04-161-1/+1
|
* Bug fix in SQLite/SQLiteUserAccountData.cs: Missing'(' in one of the SQL ↵Diva Canto2010-04-161-1/+1
| | | | statements.
* minor: add some documentation around the asset udp request path and replace ↵Justin Clark-Casey (justincc)2010-04-141-1/+1
| | | | some magic numbers with libomv enums
* Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie2010-03-311-2/+11
| | | | | This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
* UNTESTED SQLite code to enable estate setup in interactive confgurationMelanie2010-03-231-7/+45
|
* First stage of the new interactive region creation. This will allow creationMelanie2010-03-231-0/+25
| | | | | | | of a region and joining it to an existing estate or creating a new estate, as well as creating an estate owner if in standalone, and assigning estate owners. In Grid mode, existing users must be used. MySQL ONLY!!!! so far, as I can't develop or test for either SQLite or MSSQL.
* Remove the reading of estate_settings.xml and the associated processing ofMelanie2010-03-221-18/+2
| | | | | defaults. Adding code to facilitate estate creation / managemment as part of first time start up
* Formatting cleanup. Add copyright notices.Jeff Ames2010-03-101-1/+1
|
* Changed the query in GetFriends in SQLite to match the one in MySql.Diva Canto2010-03-011-1/+1
|
* Added FriendsData to both Null storage and SQLite. Untested.Diva Canto2010-02-284-1/+86
|
* Changed asset CreatorID to a stringJohn Hurliman2010-02-221-1/+1
|
* Merge branch 'presence-refactor' of ssh://opensimulator.org/var/git/opensim ↵John Hurliman2010-02-2214-1825/+484
|\ | | | | | | into presence-refactor
| * Deleted obsolete files in the Data layer. Compiles.Diva Canto2010-02-214-1837/+0
| |
| * 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-212-0/+83
| | | | | | | | | | * Small bug fix in debug message * Set default standalone configs to use SQLite across the board
| * SQLite connector for UserAccounts and Auth works. Yey!Diva Canto2010-02-214-53/+69
| |
| * Restored mising m_Connection.Diva Canto2010-02-202-4/+7
| |
| * Fix SQLite locking and make it more fascist for nowMelanie2010-02-211-14/+22
| |
| * Reverted SQLite/SQLiteGenericTableHandler to what it was + singleton.Diva Canto2010-02-201-6/+6
| |
| * SQLite connector better, but access to tables still doesn't work.Diva Canto2010-02-203-28/+62
| |
| * Added UserAccountData and auth to the SQLite connector. Compiles, runs, but ↵Diva Canto2010-02-208-7/+359
| | | | | | | | access to these tables doesn't work.
* | * Adds CreatorID to asset metadata. This is just the plumbing to support ↵John Hurliman2010-02-221-1/+2
|/ | | | CreatorID, it doesn't modify database backends or OAR files to support storing/loading it
* Merge branch 'master' into presence-refactorMelanie2010-02-151-12/+101
|\
| * * SQLite match code casing with regionsettings table field casing (what's ↵Teravus Ovares (Dan Olivares)2010-02-131-1/+1
| | | | | | | | | | | | with the upper case S in Sandbox while the rest is lower case 0.o) * It's doubtful that this will have any effect on mantis http://opensimulator.org/mantis/view.php?id=4577 . Sqlite 3 is required, Sqlite 2 was reported.