aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-02-17- remove the Metadata property from AssetBase and return all previousMike Mazur1-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
2009-02-16- remove dependency on OpenSim.Grid.AssetServer.Plugins.Opensim inMike Mazur1-1/+0
OpenSim.Data.*.addin.xml, this is cruft left over from previous testing - fix example SQLite connection string in AssetInventoryServer.ini.example
2009-02-16- add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur1-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
2009-02-12* optimized usings.lbsa7112-57/+15
2009-02-09Update svn properties, minor formatting cleanup.Jeff Ames1-65/+65
2009-02-09Thank you kindly, TLaukkan (Timmil) for a patch that:Charles Krinke1-0/+65
* Fixed and added athursv's BasicEstateTest * Added MySQLEstateTest * Added SQLiteEstateTest
2009-02-06This changeset is the step 1 of 2 in refactoringDr Scofield6-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!
2009-02-04- add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur1-23/+23
- trim trailing whitespace
2009-01-29* If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey1-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
2009-01-19* Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey2-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.
2008-12-30Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2008-12-23* Correct build break, no idea how that one managed to slip by meJustin Clarke Casey1-1/+1
2008-12-23* Modify SQLite implementation of UpdateUserProfile() to allow modifications ↵Justin Clarke Casey1-16/+21
where the name has not been changed
2008-12-22Thanks Gerhard for a patch that implements part 3 of VolumeDetection / ↵Dahlia Trimble2-0/+15
persistance
2008-12-14Color was set twice, first correctly, then incorrectly, in SQLiteRegionData.Homer Horwitz1-2/+0
Removed the second set. Fixes Mantis#2380.
2008-12-02* Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey1-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
2008-11-30Try to fix Mantis#2727. SQLite seems to be able to store bigger numbers inHomer Horwitz1-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?
2008-11-27* Remove unused and largely unimplemented UpdateUserCurrentRegion()Justin Clarke Casey1-12/+0
* please say if this causes you a problem
2008-11-23Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker1-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.
2008-11-21* refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey1-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
2008-11-21Update svn properties, minor formatting cleanup.Jeff Ames1-6/+6
2008-11-19Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2-0/+16
Attached patch implements llCollisionSound. Thanks T. Sado.
2008-11-18Fixed MySQL and SQLite so they will save theSean Dague2-0/+19
variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-11-15Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz1-2/+1
(added a fix for the broken build from last commit, too)
2008-11-14Add SQLite and the missing migrations files for last commitMelanie Thielker2-0/+8
2008-11-10* refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey1-4/+3
RootPart and adding the part separately * Make RootPart read only
2008-11-08Work in progress on SECS stuff. Have been holding it off until after 0.6 ↵Tedd Hansen1-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.
2008-11-04add some null protection on emailSean Dague1-1/+2
From: Sean Dague <sdague@gmail.com>
2008-11-04implement email field for MySQL and SQLiteSean Dague2-0/+8
From: Sean Dague <sdague@gmail.com>
2008-11-01Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz1-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.
2008-10-30- Includes consistency test for new and updated objects, asSean Dague1-13/+4
some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-10-30Mid-work, trying to fix region part insertion and retrievalSean Dague1-8/+34
SQLite reports System NUll Reference, but works, inside LoadItems, on SQLiteRegionData.cs From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-10-18Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2-0/+13
Add rezzing time to objects. Add Object return and traffic fields to land database. Add plumbing for auto return. Implement auto return. Contains a migration. May contain nuts.
2008-10-17Update svn properties, minor formatting cleanup.Jeff Ames1-2/+2
2008-10-16- Enforced no user or agent with UUID 0 on agent DB insertionSean Dague1-0/+4
2008-10-15- Makes MySQL reject inserting UUID 0Sean Dague1-0/+35
- Makes SQLite mimick MySQL default behavior on first and last name already on db: it does not insert the new record. - Added tests for UUID 0 and for new UUID with existing first and last name.
2008-10-14move from index based to exists strategy hereSean Dague1-10/+36
2008-10-14Merge commit 'arthur/master'Sean Dague1-4/+10
2008-10-03Add the missing bits for the new region-search:Homer Horwitz1-0/+12
- Added lookup in the data-layer - MySQL works - SQLite doesn't have a grid-db, so it won't work there - I added MSSQL-code to the best of my knowledge; but I don't know MSSQL :-) - Added the plumbing up to OGS1GridServices. This speaks with the grid-server via XMLRPC. - Modified MapSearchModule to use the new data. It's backward compatible; if used with an old grid-server, it just returns one found region instead of a list. - Refactored a bit. Note: This updates data, grid-server and region code. No new files.
2008-10-03fix the sqlite break. There were two issue here:Sean Dague1-1/+2
1. type issues on column create in ado.net 2. not setting a field in the ado.net row translates into explicitely setting it to null in sqlite land (because it can't read the defaults stanzas out of the database) Things should work again after this.
2008-10-03Add database persistence for material settingMelanie Thielker2-0/+11
2008-10-01add delete prim tests. Found and fixed bugs where regionSean Dague1-1/+1
is not respected by sqlite or mysql drivers so that deleting and object in a region actually deletes that object from any region.
2008-09-29add a test for updating region settings and fix a bug in uuidSean Dague1-1/+1
translation in sqlite uncovered by this test.
2008-09-26* Patch from JHurlimanTeravus Ovares2-11/+11
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-24Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz1-0/+19
Active gestures are sent as part of the login-response. Added fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and NHibernate. Using the empty ones won't cause errors, but doesn't provide persistence either, of course.
2008-09-24remove a bunch of out of date inline ALTER table commands that would onlySean Dague1-84/+17
confuse people.
2008-09-23couple of minor test cleanups to see if this gets us past the bamboo humpSean Dague1-8/+0
2008-09-19Small formatting cleanup, before chi11ken notices. Me bad.Homer Horwitz3-20/+39
2008-09-19convert to using proper .net tempfiles, should have done thisSean Dague4-4/+13
initially.
2008-09-18Add a db.Dispose before calling Delete on the SQLite database.Homer Horwitz4-1/+5
On Windows, you are not able to delete a file while there is still a handle to it open.