aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * Apply http://opensimulator.org/mantis/view.php?id=3439Justin Clarke Casey2009-04-103-11/+11
| | | | | | | * This corrects problems seen on some SQLite systems where the migration fails because the two argument substr() isn't implemented * Thanks RemedyTomm!
* * minor: correct some documentation in SQLiteAssetData.csJustin Clarke Casey2009-04-091-8/+2
|
* * Change SQLite asset UUID to dashed format to be consistentJustin Clarke Casey2009-04-092-6/+13
| | | | | | | * Remaining inconsistent uuids (non dashed) are in region store for sqlite and mysql * Migration of these will happen at a later date, unless someone else wants to do it
* * Change UUIDs in SQLite user db to dashed format to match representations ↵Justin Clarke Casey2009-04-093-11/+22
| | | | elsewhere
* * Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey2009-04-091-8/+29
| | | | | | | | anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
* * Migrate UUID representations in SQLite inventory store to dashed formatJustin Clarke Casey2009-04-092-28/+42
| | | | | | * This makes the representation consistent with that most commonly used in the other supported database layers
* * Moved the DatabaseTestAttribute to Test.Common, and thus included ref to ↵lbsa712009-04-095-0/+5
| | | | that in all db tests. *phew*
* * Added custom DatabaseTestAttribute to help separating unit tests from ↵lbsa712009-04-095-5/+5
| | | | component tests.
* SQLite doesn't work on ppc64, so ignore these tests if we areSean Dague2009-04-085-0/+30
| | | | | on this platform
* * Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey2009-04-081-4/+4
| | | | | | | | | 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
|
* Committing partial work on passing folders across instances. This may crash.Melanie Thielker2009-03-231-0/+5
|
* Make offline gives work in SQLite standalonesMelanie Thielker2009-03-221-0/+8
|
* 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/+50
| | | | | | | | | | | | | 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-7/+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.
* * 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.
* - remove the Metadata property from AssetBase and return all previousMike Mazur2009-02-171-23/+23
| | | | | | | | | 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
* - remove dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur2009-02-161-1/+0
| | | | | | | | OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
* - 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-1212-57/+15
|
* Update svn properties, minor formatting cleanup.Jeff Ames2009-02-091-65/+65
|
* Thank you kindly, TLaukkan (Timmil) for a patch that:Charles Krinke2009-02-091-0/+65
| | | | | | | * Fixed and added athursv's BasicEstateTest * Added MySQLEstateTest * Added SQLiteEstateTest
* This changeset is the step 1 of 2 in refactoringDr Scofield2009-02-066-8/+8
| | | | | | | | | | | | | | | | | | | | 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-23/+23
| | | | | - trim trailing whitespace
* * If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey2009-01-291-1/+4
| | | | | | | | | | | | 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
* * Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey2009-01-192-4/+11
| | | | | | | * 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.
* Update svn properties, minor formatting cleanup.Jeff Ames2008-12-301-5/+5
|
* * Correct build break, no idea how that one managed to slip by meJustin Clarke Casey2008-12-231-1/+1
|
* * Modify SQLite implementation of UpdateUserProfile() to allow modifications ↵Justin Clarke Casey2008-12-231-16/+21
| | | | where the name has not been changed
* Thanks Gerhard for a patch that implements part 3 of VolumeDetection / ↵Dahlia Trimble2008-12-222-0/+15
| | | | persistance
* Color was set twice, first correctly, then incorrectly, in SQLiteRegionData.Homer Horwitz2008-12-141-2/+0
| | | | | Removed the second set. Fixes Mantis#2380.
* * Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey2008-12-021-3/+0
| | | | | | | | | | | | 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
* Try to fix Mantis#2727. SQLite seems to be able to store bigger numbers inHomer Horwitz2008-11-301-1/+1
| | | | | | an INTEGER column (using 6 bytes), but the mapping was wrong. Question: Should we move localIDs to int instead of uint to save some bytes?
* * Remove unused and largely unimplemented UpdateUserCurrentRegion()Justin Clarke Casey2008-11-271-12/+0
| | | | | | * please say if this causes you a problem
* Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker2008-11-231-0/+4
| | | | | | | | | from the presence module to the message server, through the user server and on into the database. This should fix the "Already logged in" issue that grids see after a sim crashes, or a user crashes out of a sim. Not yet a 100% solution for friends, but getting there.
* * refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey2008-11-211-1/+1
| | | | | | | | * SceneObjectPartInventory.cs isn't a particularly good name but it's probably not got a long life * A proper inventory interface to follow * Parallel changes for other inventory partial classes to follow at a later date
* Update svn properties, minor formatting cleanup.Jeff Ames2008-11-211-6/+6
|
* Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2008-11-192-0/+16
| | | | | | Attached patch implements llCollisionSound. Thanks T. Sado.
* Fixed MySQL and SQLite so they will save theSean Dague2008-11-182-0/+19
| | | | | | | variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz2008-11-151-2/+1
| | | | | | (added a fix for the broken build from last commit, too)
* Add SQLite and the missing migrations files for last commitMelanie Thielker2008-11-142-0/+8
|
* * refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey2008-11-101-4/+3
| | | | | | | | RootPart and adding the part separately * Make RootPart read only
* Work in progress on SECS stuff. Have been holding it off until after 0.6 ↵Tedd Hansen2008-11-081-2/+2
| | | | release. Still messy as hell and doesn't really work yet. Will undergo dramatic changes. AND MOST IMPORTANTLY: Will be conformed to work in coop with todays DNE and XEngine, hopefully one day providing a common interface for all components.
* add some null protection on emailSean Dague2008-11-041-1/+2
| | | | | From: Sean Dague <sdague@gmail.com>
* implement email field for MySQL and SQLiteSean Dague2008-11-042-0/+8
| | | | | From: Sean Dague <sdague@gmail.com>
* Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz2008-11-011-1/+21
| | | | | | | | | | | | | | on-/offline updates, calling cards for friends. This adds methods in the DB layer and changes the MessagingServer, so a full update (incl. UGAIM) is necessary to get it working. Older regions shouldn't break, nor should older UGAIM break newer regions, but friends/presence will only work with all concerned parts (UGAIM, source region and destination region) at this revision (or later). I added the DB code for MSSQL, too, but couldn't test that. BEWARE: May contain bugs.
* - Includes consistency test for new and updated objects, asSean Dague2008-10-301-13/+4
| | | | | | | some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>