Commit message (Collapse) | Author | Age | Files | Lines | ||
---|---|---|---|---|---|---|
... | ||||||
* | | Migrations for SQLite converted to new format | AlexRa | 2010-05-16 | 46 | -709/+828 | |
| | | ||||||
* | | Converted MySQL migration history to the new format | AlexRa | 2010-05-16 | 79 | -1008/+1228 | |
| | | | | | | | | | | Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store | |||||
* | | Added MySqlMigrations.cs (supports stored proc/funcs) | AlexRa | 2010-05-16 | 1 | -0/+85 | |
| | | | | | | | | | | Uses MySqlScript class to correctly run proc/func definitions that need delimiter change. Requires MySql.Data.dll 6.2 or later. | |||||
* | | Migration.cs supports single-file migration history format | AlexRa | 2010-05-16 | 1 | -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! | |||||
* | OK, this really fixes it, I promise. | Diva Canto | 2010-05-09 | 1 | -2/+2 | |
| | ||||||
* | Yey for unit tests. The previous commit had a couple of bugs on SQL ↵ | Diva Canto | 2010-05-09 | 2 | -3/+3 | |
| | | | | statements. Fixed here. | |||||
* | * Fixed spamming the assets table with map tiles. The tile image ID is now ↵ | Diva Canto | 2010-05-09 | 8 | -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. | |||||
* | Add Delete handler to SQLite (NG) | Melanie | 2010-05-09 | 1 | -15/+16 | |
| | ||||||
* | Implement the "delete" path for assets. Adds a new option to allow remote ↵ | Melanie | 2010-05-09 | 6 | -1/+34 | |
| | | | | asset deletion in robust handler. | |||||
* | Add a field asset_flags and a corresponding enum to the asset database. This | Melanie | 2010-05-09 | 2 | -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. | |||||
* | These files are part of the GridUserService write-up. | Diva Canto | 2010-05-07 | 3 | -0/+94 | |
| | ||||||
* | GridUserService in place. Replaces the contrived concept of storing user's ↵ | Diva Canto | 2010-05-07 | 10 | -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. | |||||
* | Fixed: migration #2 for SQLite. Problem was that ATTACH cannot be done ↵ | Diva Canto | 2010-05-04 | 1 | -3/+2 | |
| | | | | inside a transaction. | |||||
* | Allow regions to get the list of the other regions in the estate | Melanie Thielker | 2010-05-04 | 1 | -1/+30 | |
| | ||||||
* | Refix the fix | Melanie Thielker | 2010-05-03 | 1 | -1/+1 | |
| | ||||||
* | Add folder version incrementing to XInventoryService. Fixes offline give | Melanie Thielker | 2010-05-03 | 1 | -0/+31 | |
| | | | | for avatar->avatar | |||||
* | Switched everything to XInventory by default. The old Inventory is still ↵ | Diva Canto | 2010-05-02 | 3 | -1/+48 | |
| | | | | there for now, in case bugs pop up with XInventory. | |||||
* | minor: eliminate more debug Console.WriteLines, convert one to logging instead | Justin Clark-Casey (justincc) | 2010-04-30 | 3 | -3/+11 | |
| | ||||||
* | take out some debug logging in the sqlite db adaptor | Justin Clark-Casey (justincc) | 2010-04-30 | 1 | -3/+3 | |
| | ||||||
* | Merge branch 'master' of ssh://justincc@opensimulator.org/var/git/opensim | Justin Clark-Casey (justincc) | 2010-04-30 | 2 | -56/+60 | |
|\ | ||||||
| * | Refactoring in Migration.cs: "using()" instead of explicit Dispose() | AlexRa | 2010-04-28 | 1 | -52/+56 | |
| | | | | | | | | This ensures that 'cmd' gets disposed on errors | |||||
| * | Fixed comments in Migration.cs: wrong argument order (no change to code) | AlexRa | 2010-04-28 | 1 | -2/+2 | |
| | | ||||||
| * | Just a bit of spellchecking in the comments | AlexRa | 2010-04-28 | 1 | -2/+2 | |
| | | ||||||
* | | rename SQLiteNG to SQLite and SQLite to SQLiteLegacy | Justin Clark-Casey (justincc) | 2010-04-30 | 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. | |||||
* | get region prim saving working properly in SQLiteNG | Justin Clark-Casey (justincc) | 2010-04-23 | 1 | -10/+13 | |
| | | | | it wasn't working because of debug work that I'd forgotton to take out | |||||
* | Merge branch 'master' of ssh://justincc@opensimulator.org/var/git/opensim | Justin Clark-Casey (justincc) | 2010-04-23 | 11 | -11/+11 | |
|\ | ||||||
| * | put SQLiteNG classes in their own namespace to avoid confusion | Justin Clark-Casey | 2010-04-23 | 12 | -12/+12 | |
| | | ||||||
* | | dispose of the DbCommand used to execute migrations after we've finished ↵ | Justin Clark-Casey (justincc) | 2010-04-23 | 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 | |||||
* | minor: correct the assembly information for SQLiteNG | Justin Clark-Casey (justincc) | 2010-04-23 | 1 | -2/+2 | |
| | ||||||
* | Merge branch 'master' of ssh://justincc@opensimulator.org/var/git/opensim | Justin Clark-Casey (justincc) | 2010-04-23 | 1 | -0/+2 | |
|\ | ||||||
| * | Insert a ROLLBACK command on migration step failure. This ensures that | Melanie | 2010-04-22 | 1 | -0/+2 | |
| | | | | | | | | | | updating the Migrations table will not occur in a partial transaction, which would be auto-rolled-back later. | |||||
* | | Change SQLiteNG to work with mono 2.6 and above using the Mono.Data.Sqlite.dll | Justin Clark-Casey (justincc) | 2010-04-23 | 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 | |||||
* | | Duplicate OpenSim.Data.SQLite into OpenSim.Data.SQLiteNG. SQLiteNG will ↵ | Justin Clark-Casey (justincc) | 2010-04-23 | 61 | -0/+6341 | |
|/ | | | | shortly be changed to work under mono 2.6 and above | |||||
* | One more bug fix in sqlite sql statements. | Diva Canto | 2010-04-16 | 1 | -1/+1 | |
| | ||||||
* | Bug fix: UserAccounts in SQLite was missing the primary key constraint. | Diva Canto | 2010-04-16 | 1 | -1/+1 | |
| | ||||||
* | Expose Delete at IUserAccountData interface. It was there already. No ↵ | Diva Canto | 2010-04-16 | 2 | -0/+22 | |
| | | | | changes in IUserAccountService, just the data layer. | |||||
* | Bug fix in SQLite/SQLiteUserAccountData.cs: Missing'(' in one of the SQL ↵ | Diva Canto | 2010-04-16 | 1 | -1/+1 | |
| | | | | statements. | |||||
* | minor: add some documentation around the asset udp request path and replace ↵ | Justin Clark-Casey (justincc) | 2010-04-14 | 1 | -1/+1 | |
| | | | | some magic numbers with libomv enums | |||||
* | Added NullInventoryData for unit tests and quick try-outs of the services in ↵ | Diva Canto | 2010-04-06 | 1 | -0/+193 | |
| | | | | 64-bit machines (no SQLite). | |||||
* | Committing the LightShare code, which was developed by TomMeta of Meta7. | Melanie | 2010-03-31 | 4 | -5/+231 | |
| | | | | | This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer. | |||||
* | * Catch exceptions thrown when MySQLEstateData.LinkRegion() is called. This ↵ | John Hurliman | 2010-03-26 | 1 | -8/+14 | |
| | | | | won't fix the bug I'm seeing with regions not realizing they are already part of an estate, but it will fix the OpenSim crash if that situation ever comes up | |||||
* | replace recent IModule.GetGroup() with better GetGroupRecord(string name) | Justin Clark-Casey (justincc) | 2010-03-26 | 1 | -2/+2 | |
| | ||||||
* | UNTESTED SQLite code to enable estate setup in interactive confguration | Melanie | 2010-03-23 | 1 | -7/+45 | |
| | ||||||
* | First stage of the new interactive region creation. This will allow creation | Melanie | 2010-03-23 | 3 | -45/+180 | |
| | | | | | | | 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. | |||||
* | Somehow the starting estate number in MySQL was lost. This adds a migration | Melanie | 2010-03-22 | 1 | -0/+3 | |
| | | | | | | | | to start estates at 100. Existing databases having autcreated estates below 100 will see a gap in estate numbering. Other database implementors need to ensure that no estates with numbers less that 100 are autocreated, unless they are prepared to deal with the viewer's built-in notions of Linden Mainland | |||||
* | Remove the reading of estate_settings.xml and the associated processing of | Melanie | 2010-03-22 | 4 | -64/+21 | |
| | | | | | defaults. Adding code to facilitate estate creation / managemment as part of first time start up | |||||
* | Formatting cleanup. Add copyright notices. | Jeff Ames | 2010-03-10 | 11 | -22/+22 | |
| | ||||||
* | MSSQL tweaks for latest ROBUST - friends handling fixed, GridUserData ↵ | unknown | 2010-03-09 | 7 | -3/+101 | |
| | | | | | | placeholder added. Signed-off-by: Melanie <melanie@t-data.com> | |||||
* | Justin, I must have been dyslexic when I wrote UserGridService as the name ↵ | Diva Canto | 2010-03-05 | 2 | -9/+9 | |
| | | | | for it. GridUserService makes more sense; it's the user of the grid, "grid user". I changed it everywhere. | |||||
* | add initial UserGrid service classes as per diva's direction | Justin Clark-Casey (justincc) | 2010-03-05 | 3 | -2/+115 | |
| | | | | | this will initially store home location data instead of the presence service compiles but not enough to actually test yet |