aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-05-18Massive bugfix in MSSQLEstateData (now works!)AlexRa1-49/+41
2010-05-16MS SQL migrations converted to the new formatAlexRa77-2008/+2273
2010-05-16Migrations for SQLite converted to new formatAlexRa46-709/+828
2010-05-16Converted MySQL migration history to the new formatAlexRa79-1008/+1228
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-16Added MySqlMigrations.cs (supports stored proc/funcs)AlexRa1-0/+85
Uses MySqlScript class to correctly run proc/func definitions that need delimiter change. Requires MySql.Data.dll 6.2 or later.
2010-05-16Migration.cs supports single-file migration history formatAlexRa1-104/+233
Scans for migration resources in either old-style "scattered" (one file per version) or new-style "integrated" format (single file "Resources/{StoreName}.migrations[.nnn]") with ":VERSION nnn" sections). In the new-style migrations it also recognizes ':GO' separators for parts of the SQL script that must be sent to the server separately. The old-style migrations are loaded each in one piece and don't support the ':GO' feature. Status: TESTED and works fine in all modes!
2010-05-09OK, this really fixes it, I promise.Diva Canto1-2/+2
2010-05-09Yey for unit tests. The previous commit had a couple of bugs on SQL ↵Diva Canto2-3/+3
statements. Fixed here.
2010-05-09* Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto8-9/+36
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 ↵Melanie6-1/+34
asset deletion in robust handler.
2010-05-09Add a field asset_flags and a corresponding enum to the asset database. ThisMelanie2-3/+10
CHANGES THE ASSET SERVER PROTOCOL and means you CAN NOT MIX PRIOR VERSIONS WITH LATER ONES. It may also eat your babies, yada, yada, yada. The usual cautions for migrations to the assets table apply. Coding: Can not guarantee nut free.
2010-05-07These files are part of the GridUserService write-up.Diva Canto3-0/+94
2010-05-07GridUserService in place. Replaces the contrived concept of storing user's ↵Diva Canto10-228/+25
home and position info in the presence service. WARNING: I violated a taboo by deleting 2 migration files and simplifying the original table creation for Presence. This should not cause any problems to anyone, though. Things will work with the new simplified table, as well as with the previous contrived one. If there are any problems, solving them is as easy as dropping the presence table and deleting its row in the migrations table. The presence info only exists during a user's session anyway. BTW, the Meshing files want to be committed too -- EOFs.
2010-05-04Fixed: migration #2 for SQLite. Problem was that ATTACH cannot be done ↵Diva Canto1-3/+2
inside a transaction.
2010-05-04Allow regions to get the list of the other regions in the estateMelanie Thielker1-1/+30
2010-05-04Allow regions to get the list of the other regions in the estateMelanie Thielker1-1/+30
2010-05-03Refix the fixMelanie Thielker1-1/+1
2010-05-03Add folder version incrementing to XInventoryService. Fixes offline giveMelanie Thielker1-0/+31
for avatar->avatar
2010-05-03Refix the fixMelanie Thielker1-1/+1
2010-05-03Add folder version incrementing to XInventoryService. Fixes offline giveMelanie Thielker1-0/+31
for avatar->avatar
2010-05-03Add folder version uncrementing to XInventoryService. Fixes offline giveMelanie Thielker1-0/+31
for avatar->avatar
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-30take out some more sqlite db console debug linesJustin Clark-Casey (justincc)1-6/+0
2010-04-30fix an issue with user appearance where the new sqlite db adapter expects ↵Justin Clark-Casey (justincc)8-81/+25
directly specification of byte[] type rather than base64 strings
2010-04-30minor: eliminate more debug Console.WriteLines, convert one to logging insteadJustin Clark-Casey (justincc)3-3/+11
2010-04-30Fix a bunch of issues that crop up after the naive porting of the new sqlite ↵Justin Clark-Casey (justincc)16-774/+24
db from master to 0.6.9
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 SQLiteLegacy this seems the least ↵Justin Clark-Casey (justincc)69-366/+902
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-30get region prim saving working properly in SQLiteNGJustin Clark-Casey (justincc)1-10/+13
it wasn't working because of debug work that I'd forgotton to take out
2010-04-30dispose of the DbCommand used to execute migrations after we've finished ↵Justin Clark-Casey (justincc)1-1/+2
with it rather than within the loop disposing of it within the loop causes Mono.Data.Sqlite.dll to get upset, and it's the wrong behaviour anyway
2010-04-30put SQLiteNG classes in their own namespace to avoid confusionJustin Clark-Casey12-12/+12
2010-04-30minor: correct the assembly information for SQLiteNGJustin Clark-Casey (justincc)1-2/+2
2010-04-30Change SQLiteNG to work with mono 2.6 and above using the Mono.Data.Sqlite.dllJustin Clark-Casey (justincc)16-429/+236
Include the library so that Windows builds correctly It appears that Windows is okay with either SQLite or SQLiteNG Incorporate the latest fixes made by Diva to OpenSim.Data.SQLite
2010-04-30Duplicate OpenSim.Data.SQLite into OpenSim.Data.SQLiteNG. SQLiteNG will ↵Justin Clark-Casey (justincc)61-0/+6341
shortly be changed to work under mono 2.6 and above
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)70-422/+423
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-28Refactoring in Migration.cs: "using()" instead of explicit Dispose()AlexRa1-52/+56
This ensures that 'cmd' gets disposed on errors
2010-04-28Fixed comments in Migration.cs: wrong argument order (no change to code)AlexRa1-2/+2
2010-04-28Just a bit of spellchecking in the commentsAlexRa1-2/+2
2010-04-23get region prim saving working properly in SQLiteNGJustin Clark-Casey (justincc)1-10/+13
it wasn't working because of debug work that I'd forgotton to take out
2010-04-23dispose of the DbCommand used to execute migrations after we've finished ↵Justin Clark-Casey (justincc)2-2/+3
with it rather than within the loop disposing of it within the loop causes Mono.Data.Sqlite.dll to get upset, and it's the wrong behaviour anyway
2010-04-23put SQLiteNG classes in their own namespace to avoid confusionJustin Clark-Casey12-12/+12
2010-04-23minor: correct the assembly information for SQLiteNGJustin Clark-Casey (justincc)1-2/+2
2010-04-23Change SQLiteNG to work with mono 2.6 and above using the Mono.Data.Sqlite.dllJustin Clark-Casey (justincc)16-429/+236
Include the library so that Windows builds correctly It appears that Windows is okay with either SQLite or SQLiteNG Incorporate the latest fixes made by Diva to OpenSim.Data.SQLite
2010-04-23Duplicate OpenSim.Data.SQLite into OpenSim.Data.SQLiteNG. SQLiteNG will ↵Justin Clark-Casey (justincc)61-0/+6341
shortly be changed to work under mono 2.6 and above
2010-04-22Insert a ROLLBACK command on migration step failure. This ensures thatMelanie1-0/+2
updating the Migrations table will not occur in a partial transaction, which would be auto-rolled-back later.
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-16Expose Delete at IUserAccountData interface. It was there already. No ↵Diva Canto2-0/+22
changes in IUserAccountService, just the data layer.
generated by cgit v1.1 at 2025-03-18 05:56:30 +0000