Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | based on positive feedback on performance of making keys fixed length | Sean Dague | 2008-06-24 | 1 | -0/+31 |
| | | | | | | | for assets, make all the indexed columns in the inventory fixed length via migration. | ||||
* | fix typo in Inventory nhibernate mappings. nhibernate should | Sean Dague | 2008-06-23 | 1 | -4/+4 |
| | | | | | | load now. | ||||
* | add migration to go from varchar -> char for uuid. Tested | Sean Dague | 2008-06-23 | 1 | -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 Ovares | 2008-06-21 | 2 | -3/+92 |
| | |||||
* | * Adds Region ban capability to Regions. You access this by going to ↵ | Teravus Ovares | 2008-06-21 | 5 | -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. I | Sean Dague | 2008-06-20 | 4 | -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. DBNull | Teravus Ovares | 2008-06-20 | 2 | -8/+18 |
| | | | | | * mySQL this time. | ||||
* | * Handle parcel telehub location corruption gracefully. DBNull | Teravus Ovares | 2008-06-20 | 1 | -6/+15 |
| | |||||
* | fixed to inventory for nhibernate that actually make it so I can | Sean Dague | 2008-06-19 | 2 | -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 Dague | 2008-06-19 | 4 | -7/+9 |
| | | | | | | but moving in the right direction. | ||||
* | oops, build break. needed to include another reference. | Sean Dague | 2008-06-19 | 1 | -0/+1 |
| | |||||
* | add migrations support for mysql log store. This should complete | Sean Dague | 2008-06-19 | 3 | -1/+41 |
| | | | | | | all the mysql bits for migration. | ||||
* | fix an edge case with migrations in the region store. | Sean Dague | 2008-06-19 | 3 | -2/+54 |
| | | | | | | Add migration support to gridstore. | ||||
* | oops, it helps to reference the *right* migration | Sean Dague | 2008-06-19 | 2 | -2/+2 |
| | |||||
* | clean up the nhibernate definitions to work with mysql | Sean Dague | 2008-06-18 | 8 | -117/+30 |
| | | | | | | integrate migration support into nhibernate | ||||
* | add mysql migrations for nhibernate driver | Sean Dague | 2008-06-18 | 3 | -10/+136 |
| | |||||
* | add inventory store migration | Sean Dague | 2008-06-18 | 1 | -0/+40 |
| | |||||
* | I really didn't expect that one to work out of the box, but just managed | Sean Dague | 2008-06-16 | 1 | -0/+14 |
| | | | | | | to get NHibernate + MySQL + Assets working. | ||||
* | set CommandTimeout = 0 in the migration commands so that long | Sean Dague | 2008-06-16 | 1 | -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 migration | Sean Dague | 2008-06-16 | 1 | -0/+7 |
| | | | | | | side so that people don't think we're hung. | ||||
* | fix nhibernate driver so that it starts (based on the appearance | Sean Dague | 2008-06-16 | 3 | -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 connect | Sean Dague | 2008-06-16 | 3 | -8/+25 |
| | | | | | | migrations into it. | ||||
* | change some messages on the migrations front to be | Sean Dague | 2008-06-16 | 1 | -5/+4 |
| | | | | | | more clear | ||||
* | the beginning of the great id format migration. This makes | Sean Dague | 2008-06-16 | 3 | -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 inventory | Sean Dague | 2008-06-13 | 1 | -0/+8 |
| | |||||
* | Update svn properties, clean up formatting, refactor out duplicate ↵ | Jeff Ames | 2008-06-13 | 3 | -9/+18 |
| | | | | hard-coded port numbers. | ||||
* | look mom, migrations in action. This adds a couple of indexes | Sean Dague | 2008-06-12 | 1 | -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 Dague | 2008-06-12 | 7 | -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 log | Justin Clarke Casey | 2008-06-12 | 3 | -3/+3 |
| | |||||
* | this, in theory, adds migration support to mysql for all | Sean Dague | 2008-06-12 | 4 | -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 Dague | 2008-06-12 | 1 | -0/+150 |
| | | | | | | | now on to integrating this approach into the mysql driver. Beware the next couple of checkins. | ||||
* | check in migration files for mysql | Sean Dague | 2008-06-12 | 3 | -0/+152 |
| | |||||
* | check in working migration code fore SQLite. This | Sean Dague | 2008-06-11 | 5 | -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 migrations | Sean Dague | 2008-06-11 | 4 | -171/+200 |
| | |||||
* | Mantis#1528. Thank you kindly, Boscata for: | Charles Krinke | 2008-06-11 | 2 | -29/+168 |
| | | | | | | MSSQL Avatar appearance solved. Appearance functions and modified table. | ||||
* | I'm going to need the Version property to manage | Sean Dague | 2008-06-10 | 1 | -0/+6 |
| | | | | | | | migrating from the old to the new system. Silly legacy code. | ||||
* | update of migration code to be more sane on version | Sean Dague | 2008-06-10 | 1 | -40/+37 |
| | | | | | | | tracking, and support sub types that we'll need for nhibernate. | ||||
* | Mantis#1501. Thank you kindly, Nebadon, for a patch that | Charles Krinke | 2008-06-10 | 1 | -1/+7 |
| | | | | | addresses the 'terrain fill 0' error. | ||||
* | Update svn properties. Formatting cleanup. | Jeff Ames | 2008-06-10 | 1 | -8/+16 |
| | |||||
* | actually create and populate the migrations table correctly. | Sean Dague | 2008-06-09 | 1 | -8/+25 |
| | |||||
* | migrations seem to not break anything at this point. | Sean Dague | 2008-06-09 | 1 | -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 it | Sean Dague | 2008-06-09 | 1 | -1/+1 |
| | | | | | | | really turned out to be small enough to not need it's own assembly | ||||
* | fill out some more migration facilities | Sean Dague | 2008-06-09 | 1 | -19/+50 |
| | |||||
* | more work in progress migration code, still a while before | Sean Dague | 2008-06-09 | 1 | -4/+94 |
| | | | | | | this becomes useful | ||||
* | start in on the shell for a generic database versioning module. My | Sean Dague | 2008-06-09 | 1 | -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. | mingchen | 2008-06-09 | 1 | -1/+1 |
| | |||||
* | MSSQL Inventory Fix. Patch by Kyle and Chris from G2 | mingchen | 2008-06-06 | 1 | -82/+89 |
| | |||||
* | Mantis#1450. Thank you kindly, Boscata for a patch that addresses: | Charles Krinke | 2008-06-05 | 2 | -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 Ames | 2008-06-04 | 1 | -5/+5 |
| | |||||
* | * experimental: Make OpenSim archiver save and reload all prim textures when ↵ | Justin Clarke Casey | 2008-06-02 | 1 | -0/+1 |
| | | | | not all faces have the same texture |