aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Fix joining land parcels not being stored correctly in SQLite. Thank you to ↵Marck2010-11-231-0/+3
| | | | goetz for the initial patch in Mantis #5230.
* Added creator info across the board -- TaskInventoryItems and InventoryItems ↵Diva Canto2010-11-212-4/+4
| | | | | | themselves. Tested. Seems to be working, main tests pass. Nothing done for IARs or HG transfers yet -- this only works for OARs for the time being. New migration in inventory table in order to make CreatorID varchar(255).
* Updated SQLite/SQLiteSimulationData to use SOP.CreatorInformation instead of ↵Diva Canto2010-11-211-2/+2
| | | | SOP.CreatorID. Untested, but should work.
* Add lsClearWindlightScene() to the lightshare module to remove WL settingsMelanie2010-11-031-0/+3
| | | | from a region and allow normal day cycles to be reestablished
* * One more item for CSharpSqliteTeravus Ovares (Dan Olivares)2010-09-231-3/+10
| | | | | | | * Hopefully this will enable mac people to use SQLite again * Someone cooler then me will need to figure out how to define CSharpSqlite with Mono so the conditional will pick up. * There's also an error that occurs when you first load OpenSimulator under CSharpSQLite that goes away after. * The databases are not byte for byte compatible. Mono.Data.Sqlite is able to read CSharpSqlite made databases but not the reverse way.
* * Add CSharpSqlite to prebuildTeravus Ovares (Dan Olivares)2010-09-2312-12/+62
| | | | | | | | | | * Use a conditional define to determine whether we're using CSharpSqlite or Mono.Data.Sqlite #if CSharpSqlite using Community.CsharpSqlite.Sqlite; #else using Mono.Data.Sqlite; #endif * Hopefully, this will restore sqlite functionality on a Mac. In visual studio, you can edit the OpenSim.Data.SQLite project, go to the Build tab and enter CSharpSqlite in the box. I'm not sure how to define CSharpSqlite in Mono, someone better at it then me will have to take the job of figuring out the best way to define it in Mono.
* Changed SceneObjectGroup to store parts with the fast and thread-safe ↵John Hurliman2010-09-161-1/+1
| | | | MapAndArray collection
* MergedJohn Hurliman2010-09-122-33/+30
|\
| * Formatting cleanup.Jeff Ames2010-09-122-33/+30
| |
* | * Added ISimulationDataService and IEstateDataServiceJohn Hurliman2010-09-122-0/+18
|/ | | | | * Removed StorageManager * CONFIG CHANGE: There are no more database settings in OpenSim.ini. Check the config-include configuration files for region store and estate store database settings
* Changed all string references of "IRegionDataStore" to "ISimulationDataStore"John Hurliman2010-09-111-2/+0
|
* Fixed the naming mess around data connectors for simulation dataJohn Hurliman2010-09-111-1/+1
|
* Remove "Dwell" support from core and replace it with calls to methodsMelanie Thielker2010-09-051-3/+0
| | | | on IDwellModule
* Fix sqlite migration problems by moving migrations in 019_RegionStore.sql ↵Justin Clark-Casey (justincc)2010-09-013-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
* Fix a casting operation to use ToString()Melanie2010-08-301-1/+1
|
* Implements parcel media setting persistence and packet / CAPS handlingJonathan Freedman2010-08-302-0/+16
| | | | | | properly for the new media settings. Signed-off-by: Melanie <melanie@t-data.com>
* Remove parts locking from data classes since these are using a copy of the ↵Justin Clark-Casey (justincc)2010-08-261-6/+3
| | | | scene object
* Improve consistency of locking for SOG.m_parts in order to avoid race ↵Justin Clark-Casey (justincc)2010-08-261-3/+6
| | | | conditions in linking and unlinking
* Fix SQLite database plugin for UserAccountData queries with a single word.Marck2010-08-151-1/+1
|
* get rid of PrimitiveBaseShape.MediaRaw staging postJustin Clark-Casey (justincc)2010-08-031-3/+5
| | | | | using an OSD serialization rather than auto forces serialization code to be placed in OpenSim.Framework this makes the media texture raw data staging post in PrimitiveBaseShape redundant, now we just directly call the code in PrimitiveBaseShape.MediaList itself
* relocate serialization code from SQLiteRegionData to MoapModule using load ↵Justin Clark-Casey (justincc)2010-07-261-53/+2
| | | | | | | | | | and save events. This is better modularity. It also allows MoapModule to be replaced with some other media module that may behave completely differently in the future. Remaining non-modularity: PrimitiveBaseShape needs explicit Media and MediaRaw fields. MediaRaw is required in order to shuttle the pre-serialization data back and forth from the database layer. The database also needs to know about MediaRaw though not about Media. IMO, it would be extremely nice to remove these hard codings but this is a bridge too far at the present time.
* Put a wrapper around the media texture region serializationJustin Clark-Casey (justincc)2010-07-261-15/+43
| | | | | | THIS WILL BREAK EXISTING MEDIA TEXTURE PERSISTENCE. Please delete your existing sqlite databases if you are experimenting with this branch. This wrapper will make it easier to maintain compatibility if the media texture data evolves. This will also make it easier to store non-sl media texture data.
* add missing regionstore migration file for new fields. D'oh!Justin Clark-Casey (justincc)2010-07-261-0/+6
| | | | this should enable persistence now
* fix bug where prim persistence would fail if media had never been setJustin Clark-Casey (justincc)2010-07-261-6/+9
|
* fix problem persisting when only one face had a media textureJustin Clark-Casey (justincc)2010-07-261-2/+8
|
* Implement media texture persistence over server restarts for sqliteJustin Clark-Casey (justincc)2010-07-261-4/+32
| | | | This is currently persisting media as an OSDArray serialized to LLSD XML.
* 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.