aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (follow)
Commit message (Collapse)AuthorAgeFilesLines
* 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
* * Duh, actually returning from the CreateAsset method once we know the asset ↵Justin Clarke Casey2008-05-311-0/+1
| | | | exists would be better than carrying on
* * Remove the mysql logging noise I accidentally left in a few commits agoJustin Clarke Casey2008-05-311-2/+2
|
* * Change MySQL to check whether an asset already exists before inserting it ↵Justin Clarke Casey2008-05-311-1/+40
| | | | into the database
* * Implements UserServer logoff in a few situationsTeravus Ovares2008-05-315-8/+8
| | | | | | | * User tries to log-in but is already logged in. Userserver will send message to simulator user was in to log the user out there. * From the UserServer, admin types 'logoff-user firstname lastname message'. * Some regions may not get the message because they're not updated yet.
* Update svn properties. Formatting cleanup.Jeff Ames2008-05-303-12/+16
|
* update the nhibernate inventory item base definitionSean Dague2008-05-281-0/+6
|
* actually user the database_connect string for mysql. Sean Dague2008-05-283-28/+20
| | | | | | | This means you can run all the OpenSim grid services without needing a mysql_connection.ini
* let Grid Servers specify a connect string in their configuration.Sean Dague2008-05-289-33/+60
|
* remove terrain bloat, only keep last terrain revisionSean Dague2008-05-281-1/+5
| | | | | | | for mysql. For active terraformers this should return a lot of database space.
* remove an erroneous line to fetch the terrain table in a way that Sean Dague2008-05-281-2/+0
| | | | | | isn't actually used.
* * Potential fix for Mantis#167, 332 - MySQL Thread collision.Adam Frisby2008-05-261-61/+76
|
* Update svn properties. Formatting cleanup.Jeff Ames2008-05-251-6/+8
|
* add a lock on the update, this should have been there before.Sean Dague2008-05-221-2/+13
| | | | | | still not convinced this will help, but it was wrong.
* implement in memory appearance cache for sqlite. ThisSean Dague2008-05-211-3/+12
| | | | | | isn't db backed, but will hang around between reboots.