aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
...
* WARNING: contains migrationSean Dague2009-05-081-0/+7
| | | | | Since creatorID is no longer treated as a UUID type in the code from the database we need to make sure that it isn't null in the database. This updates all empty string and null values for this column to the Zero UUID, and makes the column a not null definition with a default fo the Zero UUID.
* now that creatorID is no longer a strict UUID, and the column can still be NULL,Sean Dague2009-05-081-1/+10
| | | | | | we lost protection from NULL strings. This puts some protection in for that case. This may address many of the inventory issues that are being seen intermitently.
* * Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey2009-05-072-29/+105
| | | | | | | | | | all other tables * This revision contains a mysql data migration. Please backup your mysql region database as a precaution before using this code. * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
* add if exists to the drop tableSean Dague2009-04-222-30/+30
|
* add cleardb to estate testsSean Dague2009-04-221-16/+24
|
* ensure we've got a clean data environment prior to running the regionSean Dague2009-04-221-17/+24
| | | | | tests
* * Some more experimental work on distributed assets. Nothing hotwired yet.lbsa712009-04-131-17/+19
| | | | | | | | | * Introduced preprocess step in FetchAsset (Might revert this later) * Some minor CCC * Added actual implementation of GetUserProfile( uri ) and the corresponding handler to OGS1. * Introduced non-functioning GetUserUri( userProfile) awaiting user server wireup (this might move elsewhere)
* * Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey2009-04-091-1/+1
| | | | | | | | anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
* * Moved the DatabaseTestAttribute to Test.Common, and thus included ref to ↵lbsa712009-04-096-0/+6
| | | | that in all db tests. *phew*
* * tagged some more database tests as suchlbsa712009-04-095-5/+5
|
* * Added custom DatabaseTestAttribute to help separating unit tests from ↵lbsa712009-04-091-1/+1
| | | | component tests.
* * Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey2009-04-081-7/+5
| | | | | | | | | as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
* Adding migrations for MySQL and SQLite for removing the "old" cloud image.Homer Horwitz2009-04-051-0/+1
| | | | | | The new one already in the Library will be reinserted automatically. Fixes Mantis #964
* * Upped trunk version number to 0.6.4 as we just tagged 0.6.4-releaselbsa712009-04-011-1/+1
|
* * This updates LibOMV to the current release 0.6.0 on March 19 2009Teravus Ovares2009-03-271-1/+1
| | | | | | * Important: HttpServer.dll was changed to HttpServer_OpenSim.dll so that the HttpServer references do not conflict if you've copied the OpenMetaverse.Http.dll and requirements to the OpenSimulator bin folder. This means that if you reference HttpServer.dll in any projects, you will need to change the reference to HttpServer_OpenSim.dll. It still uses the Same HttpServer namespace though.
* Committing partial work on passing folders across instances. This may crash.Melanie Thielker2009-03-231-0/+5
|
* MYSQL Only: Make items given while offline appear in inventory withoutMelanie Thielker2009-03-221-0/+9
| | | | | | the need to clear cache.
* Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker2009-03-211-0/+5
| | | | | | | MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
* Implemented FetchAssetMetadataSet in DB backends.Mike Mazur2009-03-091-0/+51
| | | | | | | | | | | | | This method fetches metadata for a subset of the entries in the assets database. This functionality is used in the ForEach calls in the asset storage providers in AssetInventoryServer. With this implemented, frontends such as the BrowseFrontend should now work. - MySQL: implemented, sanity tested - SQLite: implemented, sanity tested - MSSQL: implemented, not tested - NHibernate: not implemented
* * Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa712009-02-251-4/+0
| | | | | | | I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.
* Mantis#3218. Thank you kindly, TLaukkan (Tommil) for a patch that:Charles Krinke2009-02-227-12/+29
| | | | | | | | | * Added log4net dependency to physxplugin in prebuild.xml. * Added missing m_log fields to classes. * Replaced Console.WriteLine with appropriate m_log.Xxxx * Tested that nant test target runs succesfully. * Tested that local opensim sandbox starts up without errors.
* * Applied a patch that: Added estate ban table to migration scripts and ↵lbsa712009-02-211-4/+4
| | | | | | | | | | | | | | nhibernate mapping. Refactored property getters and setters for estate ban object to support NHibernate. * Added estate ban table to migration scripts of all supported databases. * Added nhibernate mapping for EstateBans property of EstateSettings * Refactored property accessors for EstateBan object. * Added comments for EstateBan properties. * Ensured that NHibernate tests pass with NUnitGUI. * Ensured that nant test target passes. This fixes mantis #3210. Thank you, tlaukkan!
* * Upped VersionInfo to 0.6.3 and in the process, changed assemblyinfo to ↵lbsa712009-02-201-3/+3
| | | | 0.6.3.* to better track down dll ref and overwrite problems.
* Fix estate ban list persistence in MySQL and reenable testsMelanie Thielker2009-02-181-1/+1
|
* remove legacy pre-migration code for mysql grid adapter, who knew thisSean Dague2009-02-181-55/+0
| | | | | was still in there.
* remove all the very old create and upgrade sql files, these wereSean Dague2009-02-1717-288/+0
| | | | | outdated by migrations 6 months ago.
* * Moved the nifty MySQLEstateData connectionstring password-stripper out ↵lbsa712009-02-171-31/+15
| | | | into the Util project
* - remove the Metadata property from AssetBase and return all previousMike Mazur2009-02-171-17/+17
| | | | | | | | | properties as before - prefix private variables with m_ in AssetBase.cs - related to Mantis #3122, as mentioned in https://lists.berlios.de/pipermail/opensim-dev/2009-February/005088.html - all services will likely need to be upgraded after this commit
* AssetInventoryServer plugins can't be a dependency for the ↵Mike Mazur2009-02-161-1/+0
| | | | OpenSim.Data.MySQL addin.
* Rename NewAssetServer AssetInventoryServer and fully qualify withMike Mazur2009-02-161-1/+1
| | | | | OpenSim.Grid.AssetInventoryServer.
* - add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur2009-02-161-0/+1
| | | | | | | | OpenSim.Data.*.addin.xml - remove OpenSim.Grid.NewAssetServer.exe from bin/OpenSim.Data.addin.xml - add prebuild.xml section for OpenSim.Grid.AssetServer.Plugins.OpenSim.dll
* * optimized usings.lbsa712009-02-1214-77/+31
|
* Update svn properties, minor formatting cleanup.Jeff Ames2009-02-091-99/+99
|
* Thank you kindly, TLaukkan (Timmil) for a patch that:Charles Krinke2009-02-091-0/+99
| | | | | | | * Fixed and added athursv's BasicEstateTest * Added MySQLEstateTest * Added SQLiteEstateTest
* This changeset is the step 1 of 2 in refactoringDr Scofield2009-02-067-9/+9
| | | | | | | | | | | | | | | | | | | | OpenSim.Region.Environment into a "framework" part and a modules only part. This first changeset refactors OpenSim.Region.Environment.Scenes, OpenSim.Region.Environment.Interfaces, and OpenSim.Region.Interfaces into OpenSim.Region.Framework.{Interfaces,Scenes} leaving only region modules in OpenSim.Region.Environment. The next step will be to move region modules up from OpenSim.Region.Environment.Modules to OpenSim.Region.CoreModules and then sort out which modules are really core modules and which should move out to forge. I've been very careful to NOT BREAK anything. i hope i've succeeded. as this is the work of a whole week i hope i managed to keep track with the applied patches of the last week --- could any of you that did check in stuff have a look at whether it survived? thx!
* - add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur2009-02-041-17/+17
| | | | | - trim trailing whitespace
* Rename IAssetProviderPlugin to IAssetDataPlugin aligning with the other data ↵Mike Mazur2009-02-031-1/+1
| | | | plugins.
* * If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey2009-01-291-1/+15
| | | | | | | | | | | | is no prim where UUID = SceneGroupID), then force one prim to have UUID = SceneGroupID. * A warning is posted about this on startup giving the location of the object * This should allow one class of persistently undeletable prims to be removed * This change should not cause any issues, but I still suggest that you backup your database beforehand * If this doesn't work for previously linked objects, then you could also try the workaround in http://opensimulator.org/mantis/view.php?id=3059 * This change has been made to mysql and mssql, but sqlite appears to work in a different way
* Slight cleanup of docs, removing trailing whitespace.Mike Mazur2009-01-281-6/+5
|
* * Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey2009-01-191-0/+5
| | | | | | | * Since this is a db change, as always I strongly recommend that you backup your database before updating to this revision * Haven't touched MSSQL in case I get it wrong - looking for some kind soul to take care of this.
* Avoid an invalid cast on legacy dataMelanie Thielker2009-01-181-1/+8
|
* * Added MySQL Grid unit testsSean Dague2009-01-141-0/+83
| | | | | From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* * Apply http://opensimulator.org/mantis/view.php?id=2948Justin Clarke Casey2009-01-073-55/+55
| | | | | | | * This fixes adding and updating user profiles in MySQL on platforms that have a commas as a decimal separator * Thanks Tommil!
* change the drop order to see if this affects unit test failsSean Dague2009-01-051-1/+1
| | | | | From: Sean Dague <sdague@gmail.com>
* * Fix http://opensimulator.org/mantis/view.php?id=2889Justin Clarke Casey2008-12-231-2/+2
| | | | | | * Primshapes uuid wasn't being converted to raw (non-dashed) format before being used in primshapes delete command
* Update the MySQL connector to 5.2.5. Fixes Mantids#2673. Thanks for the ↵Homer Horwitz2008-12-221-1/+1
| | | | hint, jhurliman.
* change a UUID cast to an actual new UUID call to be consistant withSean Dague2008-12-081-1/+1
| | | | | the rest of the assignments here.
* fix an issue I found where primshapes weren't every being removedSean Dague2008-12-081-9/+82
| | | | | | | | because of a logic error. attempt to speed up deletes a bit by batching up all the primitem deletes and primshape deletes into single delete statements. This removes the lock/release/lock/release/lock/release for loop.
* * Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey2008-12-021-5/+3
| | | | | | | | | | | | http://opensimulator.org/mantis/view.php?id=2739 by no longer bothering to store or retrieve the local parentID in the region database * The original issue is that the now randomly generated local ids do not fit into the int parentID datatype * However, as far as I know it's actually pointless to store this local parent ID anyway (we already store the groupUUID), especially as we don't bother to store the localID (as opposed to UUID itself). * Conservatively, the actual column will be removed in a later commit
* Catch all possible exceptions in the mysql module. It throws non-mysqlMelanie Thielker2008-12-021-2/+2
| | | | | | exceptions as well.