aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-08-03get rid of PrimitiveBaseShape.MediaRaw staging postJustin Clark-Casey (justincc)1-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
2010-07-26relocate serialization code from SQLiteRegionData to MoapModule using load ↵Justin Clark-Casey (justincc)1-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.
2010-07-26Put a wrapper around the media texture region serializationJustin Clark-Casey (justincc)1-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.
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-26fix bug where prim persistence would fail if media had never been setJustin Clark-Casey (justincc)1-6/+9
2010-07-26fix problem persisting when only one face had a media textureJustin Clark-Casey (justincc)1-2/+8
2010-07-26Implement media texture persistence over server restarts for sqliteJustin Clark-Casey (justincc)1-4/+32
This is currently persisting media as an OSDArray serialized to LLSD XML.
2010-07-26relocate serialization code from SQLiteRegionData to MoapModule using load ↵Justin Clark-Casey (justincc)1-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.
2010-07-26Put a wrapper around the media texture region serializationJustin Clark-Casey (justincc)1-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.
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-07-14fix bug where prim persistence would fail if media had never been setJustin Clark-Casey (justincc)1-6/+9
2010-07-12fix problem persisting when only one face had a media textureJustin Clark-Casey (justincc)1-2/+8
2010-07-08Hopefully fixes mantis #4852Diva Canto1-2/+2
2010-07-01Implement media texture persistence over server restarts for sqliteJustin Clark-Casey (justincc)1-4/+32
This is currently persisting media as an OSDArray serialized to LLSD XML.
2010-06-27Same patch as before but for SQLite.Diva Canto1-0/+8
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-06-04Fix bug where prim items were not loaded in the new sqlite database handlerJustin Clark-Casey (justincc)1-27/+39
This addresses mantis http://opensimulator.org/mantis/view.php?id=4739
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-23Removed MySql and SQLite-specific asset test filesAlexRa1-64/+0
2010-05-23All data tests made DBMS-independentAlexRa3-195/+0
2010-05-20Revert one of the previous patches' hunks. The new code looked better, butMelanie1-3/+10
was less efficient.
2010-05-19SQLite: CreatorID added (and asset_flags moved) to the migration scriptAlexRa1-0/+24
2010-05-19Added CreatorID to SQLite asset dataAlexRa1-15/+27
2010-05-19A bit of harmless refactoring in SQLiteAssetData.csAlexRa1-10/+3
2010-05-18Migrations for SQLite converted to new formatAlexRa46-709/+828
2010-05-16Migrations for SQLite converted to new formatAlexRa46-709/+828
2010-05-09Yey for unit tests. The previous commit had a couple of bugs on SQL ↵Diva Canto1-1/+1
statements. Fixed here.
2010-05-09* Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto4-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.
2010-05-09Add Delete handler to SQLite (NG)Melanie1-15/+16
2010-05-09Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie1-0/+5
asset deletion in robust handler.
2010-05-07These files are part of the GridUserService write-up.Diva Canto2-0/+77
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 Canto3-1/+48
there for now, in case bugs pop up with XInventory.
2010-04-30minor: eliminate more debug Console.WriteLines, convert one to logging insteadJustin Clark-Casey (justincc)2-2/+6
2010-04-30take out some debug logging in the sqlite db adaptorJustin Clark-Casey (justincc)1-3/+3
2010-04-30rename SQLiteNG to SQLite and SQLite to SQLiteLegacyJustin Clark-Casey (justincc)12-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.
2010-04-16One more bug fix in sqlite sql statements.Diva Canto1-1/+1
2010-04-16Bug fix: UserAccounts in SQLite was missing the primary key constraint.Diva Canto1-1/+1
2010-04-16Bug fix in SQLite/SQLiteUserAccountData.cs: Missing'(' in one of the SQL ↵Diva Canto1-1/+1
statements.
2010-04-14minor: add some documentation around the asset udp request path and replace ↵Justin Clark-Casey (justincc)1-1/+1
some magic numbers with libomv enums
2010-03-31Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie1-2/+11
This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
2010-03-23UNTESTED SQLite code to enable estate setup in interactive confgurationMelanie1-7/+45
2010-03-23First stage of the new interactive region creation. This will allow creationMelanie1-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.
2010-03-22Remove the reading of estate_settings.xml and the associated processing ofMelanie1-18/+2
defaults. Adding code to facilitate estate creation / managemment as part of first time start up
2010-03-10Formatting cleanup. Add copyright notices.Jeff Ames1-1/+1
2010-03-01Changed the query in GetFriends in SQLite to match the one in MySql.Diva Canto1-1/+1
2010-02-28Added FriendsData to both Null storage and SQLite. Untested.Diva Canto4-1/+86
2010-02-22Changed asset CreatorID to a stringJohn Hurliman1-1/+1