aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/SQLiteRegionData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* * Consistently use dashed uuid format for sqlite region data, as was ↵Justin Clarke Casey2009-05-071-38/+35
| | | | | | | | | | | previously done for sqlite inventory data. * This revision contains a data migration. Please backup your sqlite region db 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
* * 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.
* * optimized usings.lbsa712009-02-121-3/+2
|
* This changeset is the step 1 of 2 in refactoringDr Scofield2009-02-061-2/+2
| | | | | | | | | | | | | | | | | | | | 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!
* * 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-191-4/+3
| | | | | | | * 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.
* Thanks Gerhard for a patch that implements part 3 of VolumeDetection / ↵Dahlia Trimble2008-12-221-0/+10
| | | | 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?
* * 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
* Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2008-11-191-0/+10
| | | | | | Attached patch implements llCollisionSound. Thanks T. Sado.
* Fixed MySQL and SQLite so they will save theSean Dague2008-11-181-0/+11
| | | | | | | 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)
* * 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
* - 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>
* Mid-work, trying to fix region part insertion and retrievalSean Dague2008-10-301-8/+34
| | | | | | | | SQLite reports System NUll Reference, but works, inside LoadItems, on SQLiteRegionData.cs From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2008-10-181-0/+7
| | | | | | | | 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.
* fix the sqlite break. There were two issue here:Sean Dague2008-10-031-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.
* Add database persistence for material settingMelanie Thielker2008-10-031-0/+6
|
* add delete prim tests. Found and fixed bugs where regionSean Dague2008-10-011-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.
* add a test for updating region settings and fix a bug in uuidSean Dague2008-09-291-1/+1
| | | | | | translation in sqlite uncovered by this test.
* * Patch from JHurlimanTeravus Ovares2008-09-261-5/+5
| | | | | | | | | * Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
* remove a bunch of out of date inline ALTER table commands that would onlySean Dague2008-09-241-84/+17
| | | | | | confuse people.
* Small formatting cleanup, before chi11ken notices. Me bad.Homer Horwitz2008-09-191-10/+19
|
* - Add Dispose method to IRegionDataStoreHomer Horwitz2008-09-181-0/+40
| | | | | | | | - Add necessary dummy Dispose-methods where they are missing - Implement the SQLite Dispose-methods (currently only used for unit tests, in the next commit)
* * Updates the SQLite region database to support the same properties that the ↵Teravus Ovares2008-09-181-0/+152
| | | | | | | MySQL version does for the table, prims. * If this causes any unit tests to fail, the tests need to be updated.
* Added some terrain tests, and found a fun race condition in the sqliteSean Dague2008-09-161-15/+15
| | | | | | terrain driver in the process, which is now fixed. yay for unit tests!
* * Adds regiondata and estatedata persistence in Sqlite. This commit is ↵Teravus Ovares2008-09-131-0/+3
| | | | actually an assist. 99% of the work was already done by Melanie.
* Formatting cleanup.Jeff Ames2008-09-131-1/+1
|
* * Fixes SQLite load crash. Teravus Ovares2008-09-131-2/+3
| | | | | | | * added primary key to regionsettings table in the cached table * initialized the data adapter. * Still untested fully, so watch out!
* Add region settings support to SQLite (untested!)Melanie Thielker2008-09-131-1/+183
|
* * Patch http://opensimulator.org/mantis/view.php?id=2163Justin Clarke Casey2008-09-121-0/+7
| | | | | | | | * Add prim ClickAction persistence to SQLite * This will require a prebuild * Thanks nlin!
* added the first couple of sqlite tests. we'll see how bambooSean Dague2008-09-101-1/+1
| | | | | | handles them.
* Update svn properties, minor formatting cleanup.Jeff Ames2008-09-101-2/+2
| | | | | Fix unreachable code due to typo in llDetectedGroup.
* * Fixes Sqlite crash bug when saving a prim.Teravus Ovares2008-09-091-1/+6
|
* possible fix for EARTH SHATTERING KABOOM! when trying to save a primSean Dague2008-09-091-1/+1
|
* fix an automatically stripped out UUID from SQLiteManagerSean Dague2008-09-091-6/+6
| | | | | | fix some spacing in SQLiteRegionData
* hopefully fix embedded inventory for sqliteSean Dague2008-09-091-3/+3
|
* Implement proper persistence of the following prim properties:Melanie Thielker2008-09-081-0/+9
| | | | | | | | | Floating text, Rotation, Texture animation, Particle System This will make "Eye Candy" scripts work without modification in XEngine. The use of the CHANGED_REGION_RESTART hack is no longer needed. Implemented in MySQL only, hovertext also in SQLite.
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-061-64/+64
| | | | | | | * This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
* we are now past change 6000, so getting rid of pre-Migration cruftSean Dague2008-08-271-222/+0
|
* Formatting cleanup.Jeff Ames2008-08-181-25/+25
|
* * Remove dumb bug I put in which meant that an archive save would never ↵Justin Clarke Casey2008-07-251-1/+1
| | | | complete if there were any missing assets
* refactor TaskInventoryItem Mask -> Permissions to be consistant with how thingsSean Dague2008-07-231-10/+10
| | | | | | are stored in the db.
* refactored LandData to use properties, and cleaned up the naming onSean Dague2008-07-231-69/+69
| | | | | | | the properties a bit to be more consistant with other objects (having things like .Name .Description, etc).
* Introduce a separate connection string for estates, which defaults to the one giMelanie Thielker2008-07-181-24/+1
| | | | | | ven for the region datastore. Removes the flag to store prim inventories, which are now always stored.
* Patch #9151Melanie Thielker2008-07-181-114/+0
| | | | | | 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.
* change SitTarget calls from functions to propertiesSean Dague2008-07-071-14/+15
|
* patch and files from mantis #1630, Thanks MelanieMW2008-06-291-0/+9
|