aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-07-26The hazards if unclean sourc trees. Yours truly got bitten this time.Melanie Thielker1-2/+4
Re-fix the re-fix from a clean build. This makes the region based settings work as advertised
2008-07-26Re-Fix the fixMelanie Thielker1-1/+1
2008-07-26Fix Mantis #1830Melanie Thielker1-0/+1
Makes region settings save on second and subsequent sim restarts after upgrading.
2008-07-25Patch #9155 (Mantis #1793)Melanie Thielker1-0/+1
Fix a regression that caused the region settings not to save. Still no SQLite support for region settings. MySQL now functional.
2008-07-23refactor TaskInventoryItem Mask -> Permissions to be consistant with how thingsSean Dague1-10/+10
are stored in the db.
2008-07-23refactored LandData to use properties, and cleaned up the naming onSean Dague1-70/+70
the properties a bit to be more consistant with other objects (having things like .Name .Description, etc).
2008-07-23Update svn properties. Formatting cleanup. Remove a compiler warning.Jeff Ames1-12/+14
2008-07-23Thanks, sempuki, for a patch that moves control of Mono.Addins from source ↵Mike Mazur2-11/+0
attributes to external XML files. Fix issues 1682 and 1786.
2008-07-19Update svn properties. Fix some inconsistent newlines.Jeff Ames1-23/+23
2008-07-18Introduce a separate connection string for estates, which defaults to the one giMelanie Thielker1-22/+1
ven for the region datastore. Removes the flag to store prim inventories, which are now always stored.
2008-07-18Patch to fix saving of estate managers list loaded during migration.Melanie Thielker1-0/+3
No longer teleports an agent home unless their root agent is being banned. Visual blocking is still in effect.
2008-07-18squashing further warnings.Dr Scofield1-19/+19
2008-07-18Thanks, sempuki, for a patch that moves all grid plugins to new PluginLoader ↵Mike Mazur4-12/+39
(issue 1763).
2008-07-18masks MySQL password from console startup messagesDahlia Trimble2-3/+47
2008-07-18Patch #9151Melanie Thielker3-140/+492
Makes the estate dialog fully functional. Implements all client facing functionality. Moves estate data from estate_settings.xml, which is used to provide defaults, to the region data store. Creates one estate for each region, and places the region in it. Converts all region bans to estate bans.
2008-07-16added index to ParentID on prims, as this is sorted on for prim loading.Sean Dague1-0/+5
This should speed up initial load of prims, especially on primy regions.
2008-07-15add migration for SceneGroupID to char(36) plus add an index. ThisSean Dague1-0/+9
should actually speed up deletes substantially, especially for large regions, as this was a table scan before.
2008-07-14Patch #9148Melanie Thielker1-0/+9
Patch 5 in the region settings series. Adds a migration to ensure corrupted data is purged and re-read from defaults. Some changes. Still no full functionality
2008-07-07change SitTarget calls from functions to propertiesSean Dague1-14/+15
2008-07-07* remove unused CommitAssets() hook for nowJustin Clarke Casey1-7/+0
2008-07-06Copyright notices and formatting cleanup.Jeff Ames1-2/+2
2008-07-03Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke3-36/+107
patch attached to check for timeouts on mysql connections *before* operations occur that are likely to timeout. if timeout occurs or the connections is down, it is reconnected before the operation fails.
2008-07-03add 3 migrations, 1 each for prims, primshapes, and primitemsSean Dague3-0/+65
to move all their UUID stores from varchar(255) -> char(36). Based on past evidence, this should help with performance.
2008-07-03migrate the myisam mysql regions to innodbSean Dague1-0/+12
2008-07-03Update svn properties.Jeff Ames1-5/+5
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey2-5/+8
* Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
2008-07-01Mantis#1639. Thank you, Melanie for a patch that:Charles Krinke1-1/+8
Reads estate_settings.xml and populates the database from it. If there is no record, just passes the defaults to the application.
2008-06-30Mantis#1637. Thank you kindly, Melanie for a patch that:Charles Krinke1-0/+6
Make each region load it's settings from the database on startup. No user functionality yet.
2008-06-29* Fix for http://opensimulator.org/mantis/view.php?id=1512Justin Clarke Casey2-19/+95
* Introduce experimental wait timeout checking to mysql region datastore code * This should mean that if the mysql connection has timed out, we should automatically reconnect and not fail or drop queries on region database manipulations
2008-06-29patch and files from mantis #1630, Thanks MelanieMW2-0/+223
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield4-173/+185
2008-06-27Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke1-1/+3
Currently module loading is done ad-hoc. I propose creating a simple loader class that leverages Mono.Addins (and perhaps the new .NET addins when they become available in mono). Attached is a basic patch for review that compiles into HEAD, but doesn't yet replace any existing ad-hoc loaders.
2008-06-26Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames4-78/+315
kerunix_Flan!
2008-06-26Mantis#1595. Thank you, Melanie for a patch that:Charles Krinke1-0/+3
Adds pipes for the prim item flags field
2008-06-26Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames7-17/+224
files. Thanks kerunix_Flan!
2008-06-25add migrations to mysql and sqlite for flags on embedded inventorySean Dague1-0/+5
2008-06-24based on positive feedback on performance of making keys fixed lengthSean Dague1-0/+31
for assets, make all the indexed columns in the inventory fixed length via migration.
2008-06-23add migration to go from varchar -> char for uuid. TestedSean Dague1-0/+9
on my machine, and works, but backing up before migrations is always a good idea.
2008-06-21* Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares2-0/+122
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.
2008-06-20* Handle parcel telehub location corruption gracefully. DBNullTeravus Ovares1-7/+16
* mySQL this time.
2008-06-19oops, build break. needed to include another reference.Sean Dague1-0/+1
2008-06-19add migrations support for mysql log store. This should completeSean Dague3-1/+41
all the mysql bits for migration.
2008-06-19fix an edge case with migrations in the region store.Sean Dague3-2/+54
Add migration support to gridstore.
2008-06-16the beginning of the great id format migration. This makesSean Dague2-6/+13
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-13Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames2-2/+2
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 Casey1-1/+1
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.