aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2017-04-01 store the physics inertia override in Mysql and add it to serializer. run ↵UbitUmarov1-0/+6
prebuild is required
2017-01-05Create all tables ad InnoDB by defaultMelanie Thielker4-22/+22
MyISAM isn't properly replicated using row based replication. With the advances in clustering, these systems are becoming more prevalent and MyISAM isn't up to the task anymore.
2016-12-04The new Constant: integer OBJECT_REZZER_KEY = 32;Mandarinka Tasty1-0/+8
Signed-off-by: Mandarinka Tasty <mandarinka.tasty@gmail.com> Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-11-26Increase float precision for windlight needed by scripts. mySQL Migration on ↵AliciaRaven1-0/+63
regionwindlight table. mySQL was setup to store smaller values because the viewers editor capped input, scripts can set higher precision so settings could change on region restart. This change brings mySQL more inline with PGSQL which uses doubles for all windlight floats.
2016-09-17 add to databases a table to store baked terrain.UbitUmarov1-0/+11
2016-03-24Correct case in the names of the Avatar and Friends tablesKevin Cozens2-2/+2
2016-03-22Correct the case of the Presence tableMelanie Thielker1-1/+1
2016-03-22Change casing on UserAccountsMelanie Thielker1-1/+1
2016-02-21MySQL migrations: fix one last migration that had been left behindDiva Canto1-0/+7
2016-02-20Flatten migrations for MySQL.Diva Canto13-1514/+432
Conflicts: OpenSim/Data/MySQL/Resources/RegionStore.migrations OpenSim/Data/MySQL/Resources/UserAccount.migrations
2015-11-21row format fixed removed to allow creation of regions tableShy Robbiani1-1/+5
row_format=fixed is not supported by innodb and has broken the creation of the regions table during the first startup of ROBUST. It must be a relict from MyISAM. Also removed the probably inappropriate table comment. Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
2015-10-20 store rotation axis locks in MySql and SQlite dbs ( others need to be ↵UbitUmarov1-0/+8
updated also
2015-09-15Added migration for UserAccounts table.Kevin Cozens1-0/+7
2015-09-14 try to add a mysql migration to avnUbitUmarov1-0/+15
2015-09-03 at last we can login and see objects ( friends is dead and disable inUbitUmarov2-7/+0
scenepresence)
2015-07-14Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker1-1/+1
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker1-0/+8
2015-07-12Bringing FSAssets more inline with current OpenSim standards. * If no ↵AliciaRaven1-0/+18
connection string found in assets config, fallback to using default database config * Create database storage interface to allow other db connectors to be written at some point * Add MySQL migrations file to create the initial db table * Added new config option named DaysBetweenAccessTimeUpdates to reduce db load by only updating access times when fetching assets if the last access time was over the threshold. This idea was taken from XAssets service. * Change log message headers to indicate FS assets is the source not just assets Signed-off-by: Melanie Thielker <melanie@t-data.com>
2015-06-13Support for Linden AgentPreferences capability and friends ↵Cinder1-0/+18
(UpdateAgentLanguage and UpdateAgentInformation) and Mantis #7157 Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-03-04Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2-4/+2
operation is very expensive
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Revert "Chase latest change to asset description length with an update to ↵BlueWall1-9/+1
XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-03Follow up to last commit, fix field lengthCinder1-0/+3
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2014-10-27Add hypergrid teleporting support to user profiles picksBlueWall1-1/+6
2014-04-23Changed table 'im_offline' to use UTF8 characters. This fixes a problem with ↵Oren Hurvitz1-1/+9
Offline IM V2 (only relevant to MySQL). This fixes http://opensimulator.org/mantis/view.php?id=7123 Users that use MySQL should change their MySQL configuration to support UTF8. In the config file /etc/my.cnf (Linux) or my.ini (Windows), add these settings: [mysqld] character-set-server=utf8 [client] default-character-set=utf8 And then restart MySQL (on Linux: "sudo service mysqld restart").
2014-04-21Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz1-1/+9
2014-01-16In the offline message table, store the sender.Oren Hurvitz1-1/+11
This data is useful for preventing abuse (e.g., someone who sends too many messages), or for deleting message if their sender has been deleted.
2013-12-07Revert "Add support for user preferences (im via email)"Melanie1-10/+0
This reverts commit 1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.
2013-12-06Add support for user preferences (im via email)BlueWall1-0/+10
2013-09-22Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood1-0/+10
Patch taken from http://opensimulator.org/mantis/view.php?id=4905 originally by Greg C. Fixed to apply to r/23314 commit ba9daf849e7c8db48e7c03e7cdedb77776b2052f (cherry picked from commit 4ff9fbca441110cc2b93edc7286e0e9339e61cbe)
2013-07-14Cleanup old hg sessions (older than 2 days)Diva Canto1-0/+1
2013-07-14HG UAS: Moved hg-session data from memory to DB storage. This makes it so ↵Diva Canto1-0/+17
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-06-06Database persistence for keyframes. Contains a Migration.Melanie1-0/+7
2013-05-30UserProfilesBlueWall1-0/+83
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-03-15Change the table and field names of XAssetService mysql db tables to be ↵Justin Clark-Casey (justincc)1-15/+15
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-02-19First commit of Diva Groups. The Data bits went to OpenSim.Data core, the ↵Diva Canto1-0/+115
rest to Addons.Groups.dll.
2013-02-19Offline IM: moved the Data and MySQL bits to the corresponding places in ↵Diva Canto1-0/+24
core, so that it will be easier to plugin a SQLite backend, if anyone is interested in doing that.
2013-02-09Added physics parameters support to MSSQL and SQLite (not tested)Oren Hurvitz1-1/+1
2013-02-06Partial port of Avination's support for the new physics parameters.Melanie1-0/+13
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-01-25Stopped storing dynamic attributes in the PrimShapeOren Hurvitz1-1/+0
2013-01-25Implement dynamic attribute persistence on mysql and mssqlJustin Clark-Casey (justincc)1-0/+9
mssql is untested
2012-11-15Revert "Merge master into teravuswork", it should have been avination, not ↵teravus1-5/+0
master. This reverts commit dfac269032300872c4d0dc507f4f9062d102b0f4, reversing changes made to 619c39e5144f15aca129d6d999bcc5c34133ee64.
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-15Add a skeleton for a name value storage associated with regionsMelanie1-0/+7
2012-08-15Add a skeleton for a name value storage associated with regionsMelanie1-0/+7
2012-05-23Environment Module - allows Environment settings for Viewer3 warning: ↵PixelTomsen1-0/+11
includes database region store migrations for mssql, mysql, sqlite enable/disable this module: Cap_EnvironmentSettings = "localhost" (for enable) Cap_EnvironmentSettings = "" (for disable) at ClientStack.LindenCaps section (OpenSimDefaults.ini file) or owerwrite in OpenSim.ini mantis: http://opensimulator.org/mantis/view.php?id=5860 Signed-off-by: BlueWall <jamesh@bluewallgroup.com>