aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (follow)
Commit message (Collapse)AuthorAgeFilesLines
* based on positive feedback on performance of making keys fixed lengthSean Dague2008-06-241-0/+31
| | | | | | | for assets, make all the indexed columns in the inventory fixed length via migration.
* fix typo in Inventory nhibernate mappings. nhibernate shouldSean Dague2008-06-231-4/+4
| | | | | | load now.
* add migration to go from varchar -> char for uuid. TestedSean Dague2008-06-231-0/+9
| | | | | | | on my machine, and works, but backing up before migrations is always a good idea.
* * Persists region banlists across reboots for the sqlite datastore also now.Teravus Ovares2008-06-212-3/+92
|
* * Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares2008-06-215-0/+171
| | | | | | | | World->Region/Estate. Then on the Estate tab, at the lower right hand corner, clicking the 'Add' button and picking an avatar. * It only persists across reboots for the mySQL datastore currently. * Currently have stubs in the other datastores.
* lots of futzing with nhibernate to make it more efficient. ISean Dague2008-06-204-212/+136
| | | | | | | don't think this works, but I don't want to loose the work before the weekend, and it doesn't break the build.
* * Handle parcel telehub location corruption gracefully. DBNullTeravus Ovares2008-06-202-8/+18
| | | | | * mySQL this time.
* * Handle parcel telehub location corruption gracefully. DBNullTeravus Ovares2008-06-201-6/+15
|
* fixed to inventory for nhibernate that actually make it so I canSean Dague2008-06-192-8/+8
| | | | | | | log in using it as the driver for users, assets, inventory. User driver is still missing a lot of function.
* more work towards nhibernate working with mysql, not there yet,Sean Dague2008-06-194-7/+9
| | | | | | but moving in the right direction.
* oops, build break. needed to include another reference.Sean Dague2008-06-191-0/+1
|
* add migrations support for mysql log store. This should completeSean Dague2008-06-193-1/+41
| | | | | | all the mysql bits for migration.
* fix an edge case with migrations in the region store.Sean Dague2008-06-193-2/+54
| | | | | | Add migration support to gridstore.
* oops, it helps to reference the *right* migrationSean Dague2008-06-192-2/+2
|
* clean up the nhibernate definitions to work with mysqlSean Dague2008-06-188-117/+30
| | | | | | integrate migration support into nhibernate
* add mysql migrations for nhibernate driverSean Dague2008-06-183-10/+136
|
* add inventory store migration Sean Dague2008-06-181-0/+40
|
* I really didn't expect that one to work out of the box, but just managedSean Dague2008-06-161-0/+14
| | | | | | to get NHibernate + MySQL + Assets working.
* set CommandTimeout = 0 in the migration commands so that longSean Dague2008-06-161-0/+2
| | | | | | | migrations (like converting asset ids) don't run into the normal 30 second kill switch.
* be a bit more verbose about what we are doing on the migrationSean Dague2008-06-161-0/+7
| | | | | | side so that people don't think we're hung.
* fix nhibernate driver so that it starts (based on the appearanceSean Dague2008-06-163-4/+5
| | | | | | | | | | changes it wouldn't come up). include embedded dialect specific sql files for nhibernate migrations figure out how to get the raw db connection so that migrations can work with nhibernate. create initial migration for NHibernate + SQLite + Assets.
* futzing around on the NHibernate side again trying to connectSean Dague2008-06-163-8/+25
| | | | | | migrations into it.
* change some messages on the migrations front to be Sean Dague2008-06-161-5/+4
| | | | | | more clear
* the beginning of the great id format migration. This makesSean Dague2008-06-163-6/+15
| | | | | | | | | asset uuids no longer binary. I've tested this migration a few times, and it seems working in all the scenarios I've found but it wouldn't hurt to backup your asset db before running this as it does touch a very sensitive part of our content system.
* add indexes for sqlite inventorySean Dague2008-06-131-0/+8
|
* Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames2008-06-133-9/+18
| | | | hard-coded port numbers.
* look mom, migrations in action. This adds a couple of indexesSean Dague2008-06-121-0/+6
| | | | | | | | | to mysql regions that should help on performance of some of the selects. We should start capturing more data on performance bits to figure out where else we are missing indexes and add them via migrations as well.
* Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague2008-06-127-17/+32
| | | | | | | | | and no schema. It should also work with a non up to date schema as well. Btw, meetings in which I can get code done are the right kind of meetings.
* * minor: Remove and tidy duplicate 'storing object to scene' messages in logJustin Clarke Casey2008-06-123-3/+3
|
* this, in theory, adds migration support to mysql for all Sean Dague2008-06-124-112/+194
| | | | | | | | data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
* check in region store initial migration definition, Sean Dague2008-06-121-0/+150
| | | | | | | now on to integrating this approach into the mysql driver. Beware the next couple of checkins.
* check in migration files for mysqlSean Dague2008-06-123-0/+152
|
* check in working migration code fore SQLite. This Sean Dague2008-06-115-214/+276
| | | | | | | | is now using migrations instead of the old model to create tables. Tested for existing old tables, and for creating new ones.
* updated resources for current sqlite schema for migrationsSean Dague2008-06-114-171/+200
|
* Mantis#1528. Thank you kindly, Boscata for:Charles Krinke2008-06-112-29/+168
| | | | | | MSSQL Avatar appearance solved. Appearance functions and modified table.
* I'm going to need the Version property to manage Sean Dague2008-06-101-0/+6
| | | | | | | migrating from the old to the new system. Silly legacy code.
* update of migration code to be more sane on versionSean Dague2008-06-101-40/+37
| | | | | | | tracking, and support sub types that we'll need for nhibernate.
* Mantis#1501. Thank you kindly, Nebadon, for a patch thatCharles Krinke2008-06-101-1/+7
| | | | | addresses the 'terrain fill 0' error.
* Update svn properties. Formatting cleanup.Jeff Ames2008-06-101-8/+16
|
* actually create and populate the migrations table correctly.Sean Dague2008-06-091-8/+25
|
* migrations seem to not break anything at this point. Sean Dague2008-06-091-12/+24
| | | | | | | Tomorrow I'll start trying to integrate them into sqlite to see if this works right for table migration.
* move Migration support into OpenSim.Data, because itSean Dague2008-06-091-1/+1
| | | | | | | really turned out to be small enough to not need it's own assembly
* fill out some more migration facilitiesSean Dague2008-06-091-19/+50
|
* more work in progress migration code, still a while beforeSean Dague2008-06-091-4/+94
| | | | | | this becomes useful
* start in on the shell for a generic database versioning module. My Sean Dague2008-06-091-0/+77
| | | | | | | intent is to create an easier way to manage database table versions like the model used for ruby on rails migrations.
* *Patched CreateItemsTable.sql (MSSQL). Patch by Kyle and Chris from G2.mingchen2008-06-091-1/+1
|
* MSSQL Inventory Fix. Patch by Kyle and Chris from G2mingchen2008-06-061-82/+89
|
* Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke2008-06-052-2/+3
| | | | | | | | | | I have detected a bug of conversion data type in OpenSim.Data.MSSQL.MSSQLInventoryData.addInventoryItem(InventoryItemBase item) in the GroupOwned field. My sollution is to change the flield to bit in the table. In the readInventoryItem(IDataReader reader) change too item.Flags = (uint) reader["flags"]; to item.Flags = Convert.ToUInt32(reader["flags"]); Now Inventory runs fine.
* Formatting cleanup, minor refactoring, svn properties.Jeff Ames2008-06-041-5/+5
|
* * experimental: Make OpenSim archiver save and reload all prim textures when ↵Justin Clarke Casey2008-06-021-0/+1
| | | | not all faces have the same texture