aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2013-07-28This makes group search work (Groups V2).Diva Canto1-1/+1
2013-07-14Cleanup old hg sessions (older than 2 days)Diva Canto2-0/+11
2013-07-14HG UAS: Moved hg-session data from memory to DB storage. This makes it so ↵Diva Canto2-0/+87
that traveling info survives Robust resets. It should also eliminate the cause of empty IP addresses in agent circuit data that we saw in CC grid. MySQL only.
2013-07-04HG Friends: migration #3 is failing on some installations of MySql. Setting ↵Diva Canto1-1/+1
the table to InnoDB seems to fix the problem.
2013-07-02Fix SQL statementDiva Canto1-1/+1
2013-07-02Really make it call the method with the query interfaceDiva Canto1-1/+1
2013-07-02This should have a strong effect on the Unknown User issue mantis #6625Diva Canto1-2/+5
2013-06-28In XAssetService, on a delete asset request also delete the asset in any ↵Justin Clark-Casey (justincc)1-0/+2
chained service. This eliminates the async migration since it causes a race condition with the "delete asset" console command
2013-06-27Make the concept of namespaces explicit in dynamic attributesJustin Clark-Casey (justincc)1-1/+1
This is in order to reduce the likelihood of naming clashes, make it easier to filter in/out attributes, ensure uniformity, etc. All dynattrs in the opensim distro itself or likely future ones should be in the "OpenSim" namespace. This does alter the underlying dynattrs data structure. All data in previous structures may not be available, though old structures should not cause errors. This is done without notice since this feature has been explicitly labelled as experimental, subject to change and has not been in a release. However, existing materials data is being preserved by moving it to the "Materials" store in the "OpenSim" namespace.
2013-06-12* This fixes having to select and deselect prim to get keyframemotion to ↵teravus1-2/+0
start running when pulled from data storage.
2013-06-06Database persistence for keyframes. Contains a Migration.Melanie2-4/+32
2013-05-31Adding standard OpenSim header to source filesBlueWall1-0/+27
2013-05-31Fill in fields with default values on profile creationBlueWall1-2/+48
2013-05-30UserProfilesBlueWall2-0/+1106
UserProfiles for Robust and Standalone. Includes service and connectors for Robust and standalone opensim plus matching region module.
2013-05-11Send up the part missing from the Avination Estate commit.Melanie1-0/+6
Warning - contains a small migration.
2013-04-28Fix wrong sql statement in offline im.Diva Canto1-5/+2
2013-04-25Recover a lost "virtual". Downstream projects need this.Diva Canto1-1/+1
2013-04-10minor: Make exceptions thrown by MySQLAssetData more consistent.Justin Clark-Casey (justincc)1-10/+19
2013-03-15Change the table and field names of XAssetService mysql db tables to be ↵Justin Clark-Casey (justincc)2-62/+60
capitalized like Avatars, Friends, etc. Also fixes access time being set on assets rather than XAssetsMeta This is to try and be somewhat consistent with other service tables that are mainly in this style. No migration is supplied, since nobody should be using this service yet except on a test basis.
2013-03-15Implement access time updates on assets for XAssetService.Justin Clark-Casey (justincc)1-38/+57
This only happens if access time is older than 30 days currently, in order to reduce database updates. The idea is to give some idea of assets which haven't been accessed for a very, very long time. These might conceivably be deleteable, though this will be a risk due to caching at other points in the chain. This is actually currently much less useable on the xasset service since access time is on metadata rather than the data itself. And many metadata entries may point to the same data. Probably need to address this.
2013-02-27Add more information to warnings logged when asset names and descriptions ↵Justin Clark-Casey (justincc)2-4/+12
have to be truncated for database storage On balance, I still think this is useful because asset names and descriptions can sometimes be helpful in determining what things are. Even though they are never subsequently (inventory names/descriptions are always used instead).
2013-02-19Deleted all AssemblyFileVersion directivesDiva Canto1-1/+1
2013-02-19First commit of Diva Groups. The Data bits went to OpenSim.Data core, the ↵Diva Canto2-0/+599
rest to Addons.Groups.dll.
2013-02-19Offline IM: moved the Data and MySQL bits to the corresponding places in ↵Diva Canto2-0/+86
core, so that it will be easier to plugin a SQLite backend, if anyone is interested in doing that.
2013-02-18I need these for OfflineIM and Groups.Diva Canto1-0/+60
2013-02-09Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz2-10/+11
2013-02-07Rename "Bounciness" to "Restitution"Melanie1-2/+2
2013-02-06Fix a bug I brought in by manually editing a diff file. Terrain is if cource ↵Melanie1-1/+1
not always at 20m.
2013-02-06Partial port of Avination's support for the new physics parameters.Melanie2-18/+51
Implements the parameters as properties, the serialization and database storage (MySQL only). Implements llSetPrimitiveParams for prim physics shape and the other 4 extra params. Only the prim shape type "None" is currently functional. No support for the Viewer UI (yet), that will be ported in due course. Lots more to port, this is a large-ish changeset.
2013-02-05Bump version and assembly version numbers from 0.7.5 to 0.7.6Justin Clark-Casey (justincc)1-1/+1
This is mostly Bluewall's work but I am also bumping the general version number OpenSimulator 0.7.5 remains in the release candidate stage. I'm doing this because master is significantly adding things that will not be in 0.7.5 This update should not cause issues with existing external binary DLLs because our DLLs do not have strong names and so the exact version match requirement is not in force.
2013-02-01Revert "Update assembly version numbers"BlueWall1-1/+1
This reverts commit 141ad829f448b9138b12be7cf99c834c1f3977ec.
2013-02-01Update assembly version numbersBlueWall1-1/+1
2013-01-25Store NULL in the 'DynAttrs' column if the prim doesn't have any dynamic ↵Oren Hurvitz1-1/+5
attributes
2013-01-25Stopped storing dynamic attributes in the PrimShapeOren Hurvitz2-9/+2
2013-01-25Added missing DynAttrs references in MySQLOren Hurvitz1-3/+6
2013-01-25Encapsulate an OSDMap in DAMap (was DynAttrsOSDMap) rather than inheriting ↵Justin Clark-Casey (justincc)1-4/+4
from it This is the easier way to give us control over locking, rather than asking that OSDMap IDictionary methods be virtual
2013-01-25Implement dynamic attribute persistence on mysql and mssqlJustin Clark-Casey (justincc)2-2/+23
mssql is untested
2012-12-09Restrict IPresenceData.VerifyAgentBlueWall1-3/+6
Restrict IPresenceData.VerifyAgent to only return bool result
2012-12-08Add agent verification to PresenceBlueWall1-0/+11
2012-11-15refactor: move common inventory folder version update code to parent class ↵Justin Clark-Casey (justincc)1-42/+9
in mysql, mssql and sqlite database plugins
2012-11-13Updated all existing AssemblyVersions's to 0.7.5.*. Many DLLs still don't ↵Diva Canto1-1/+1
have an AssemblyInfo file.
2012-11-09Update parent inventory folder version numbers when folders are ↵Justin Clark-Casey (justincc)1-2/+92
moved/created/deleted to match version numbers cached by viewers. This is done in the way that one would expect (e.g. moving a folder increments version number on both source and destination parent folders). This should hopefully improve viewer reuse of its cached inventory information. Currently MySQL only but will be implement for SQLite/MSSQL if there are no issues.
2012-11-06Update folder version numbers when moving items and making the ↵Justin Clark-Casey (justincc)2-4/+53
Delete(string[], string[]) call (not just string, string). This is to stop viewer inventory cache version numbers becoming out of sync with grid stored numbers when viewer performs these actions. If there are no problems with these changes, they will be propogated to SQLite (and MSSQL if that's simple enough). May also need to do the same on folder store/create/delete and maybe propogate version increments up the folder hierarchy, but that requires investigation.
2012-11-06Increment version number of a folder when an object it contains is deleted.Justin Clark-Casey (justincc)1-3/+25
Not doing this was allowing the viewer inventory cache to become out of sync if an item was directly deleted.
2012-10-09Move OpenSim.Data.RegionFlags -> OpenSim.Framework.RegionFlags to make it ↵Justin Clark-Casey (justincc)1-2/+2
easier for other code to use (e.g. LSL_Api) without having to reference OpenSim.Data just for this.
2012-09-27Removed the bits about the TOSModule. That module doesn't go into core. ↵Diva Canto1-3/+0
WARNING: migration on GridUser withdrawn too, but left the migration number there.
2012-09-25TOS module. WARNING: migration in GridUser table.Diva Canto1-0/+8
2012-08-31Also do other MySQL region settings related calls under m_dbLock, in common ↵Justin Clark-Casey (justincc)1-117/+130
with other calls.
2012-08-31Do Windlight storage and removal calls in MySQL under m_dbLock, as is done ↵Justin Clark-Casey (justincc)1-102/+108
with all the other database calls.
2012-08-15Fix and finish the extra parameters storage system for MySQLMelanie1-1/+57