aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-06-16I really didn't expect that one to work out of the box, but just managedSean Dague1-0/+14
to get NHibernate + MySQL + Assets working.
2008-06-16set CommandTimeout = 0 in the migration commands so that longSean Dague1-0/+2
migrations (like converting asset ids) don't run into the normal 30 second kill switch.
2008-06-16be a bit more verbose about what we are doing on the migrationSean Dague1-0/+7
side so that people don't think we're hung.
2008-06-16fix nhibernate driver so that it starts (based on the appearanceSean Dague3-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.
2008-06-16futzing around on the NHibernate side again trying to connectSean Dague3-8/+25
migrations into it.
2008-06-16change some messages on the migrations front to be Sean Dague1-5/+4
more clear
2008-06-16the beginning of the great id format migration. This makesSean Dague3-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.
2008-06-13add indexes for sqlite inventorySean Dague1-0/+8
2008-06-13Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames3-9/+18
hard-coded port numbers.
2008-06-12look mom, migrations in action. This adds a couple of indexesSean Dague1-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.
2008-06-12Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague7-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.
2008-06-12* minor: Remove and tidy duplicate 'storing object to scene' messages in logJustin Clarke Casey3-3/+3
2008-06-12this, in theory, adds migration support to mysql for all Sean Dague4-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.
2008-06-12check in region store initial migration definition, Sean Dague1-0/+150
now on to integrating this approach into the mysql driver. Beware the next couple of checkins.
2008-06-12check in migration files for mysqlSean Dague3-0/+152
2008-06-11check in working migration code fore SQLite. This Sean Dague5-214/+276
is now using migrations instead of the old model to create tables. Tested for existing old tables, and for creating new ones.
2008-06-11updated resources for current sqlite schema for migrationsSean Dague4-171/+200
2008-06-11Mantis#1528. Thank you kindly, Boscata for:Charles Krinke2-29/+168
MSSQL Avatar appearance solved. Appearance functions and modified table.
2008-06-10I'm going to need the Version property to manage Sean Dague1-0/+6
migrating from the old to the new system. Silly legacy code.
2008-06-10update of migration code to be more sane on versionSean Dague1-40/+37
tracking, and support sub types that we'll need for nhibernate.
2008-06-10Mantis#1501. Thank you kindly, Nebadon, for a patch thatCharles Krinke1-1/+7
addresses the 'terrain fill 0' error.
2008-06-10Update svn properties. Formatting cleanup.Jeff Ames1-8/+16
2008-06-09actually create and populate the migrations table correctly.Sean Dague1-8/+25
2008-06-09migrations seem to not break anything at this point. Sean Dague1-12/+24
Tomorrow I'll start trying to integrate them into sqlite to see if this works right for table migration.
2008-06-09move Migration support into OpenSim.Data, because itSean Dague1-1/+1
really turned out to be small enough to not need it's own assembly
2008-06-09fill out some more migration facilitiesSean Dague1-19/+50
2008-06-09more work in progress migration code, still a while beforeSean Dague1-4/+94
this becomes useful
2008-06-09start in on the shell for a generic database versioning module. My Sean Dague1-0/+77
intent is to create an easier way to manage database table versions like the model used for ruby on rails migrations.
2008-06-09*Patched CreateItemsTable.sql (MSSQL). Patch by Kyle and Chris from G2.mingchen1-1/+1
2008-06-06MSSQL Inventory Fix. Patch by Kyle and Chris from G2mingchen1-82/+89
2008-06-05Mantis#1450. Thank you kindly, Boscata for a patch that addresses:Charles Krinke2-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.
2008-06-04Formatting cleanup, minor refactoring, svn properties.Jeff Ames1-5/+5
2008-06-02* experimental: Make OpenSim archiver save and reload all prim textures when ↵Justin Clarke Casey1-0/+1
not all faces have the same texture
2008-05-31* Duh, actually returning from the CreateAsset method once we know the asset ↵Justin Clarke Casey1-0/+1
exists would be better than carrying on
2008-05-31* Remove the mysql logging noise I accidentally left in a few commits agoJustin Clarke Casey1-2/+2
2008-05-31* Change MySQL to check whether an asset already exists before inserting it ↵Justin Clarke Casey1-1/+40
into the database
2008-05-31* Implements UserServer logoff in a few situationsTeravus Ovares5-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.
2008-05-30Update svn properties. Formatting cleanup.Jeff Ames3-12/+16
2008-05-28update the nhibernate inventory item base definitionSean Dague1-0/+6
2008-05-28actually user the database_connect string for mysql. Sean Dague3-28/+20
This means you can run all the OpenSim grid services without needing a mysql_connection.ini
2008-05-28let Grid Servers specify a connect string in their configuration.Sean Dague9-33/+60
2008-05-28remove terrain bloat, only keep last terrain revisionSean Dague1-1/+5
for mysql. For active terraformers this should return a lot of database space.
2008-05-28remove an erroneous line to fetch the terrain table in a way that Sean Dague1-2/+0
isn't actually used.
2008-05-26* Potential fix for Mantis#167, 332 - MySQL Thread collision.Adam Frisby1-61/+76
2008-05-25Update svn properties. Formatting cleanup.Jeff Ames1-6/+8
2008-05-22add a lock on the update, this should have been there before.Sean Dague1-2/+13
still not convinced this will help, but it was wrong.
2008-05-21implement in memory appearance cache for sqlite. ThisSean Dague1-3/+12
isn't db backed, but will hang around between reboots.
2008-05-21this removes use of the mapper for wearables, and I can confirm thingsSean Dague7-122/+145
get saved to the database. There are still issues on wearing things after a cleared cache that I'm looking at now.
2008-05-21create some direct sql calls for appearanceSean Dague1-0/+109
2008-05-19autocreate appearance table if it isn't thereSean Dague2-0/+18