aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2021-09-09Another database schema fix for crazy.onefang1-1/+1
2021-09-09What numbnuts thought UUIDs should be varchar(255)?onefang1-4/+4
2021-09-03Shorten the name field of os_groups_groups.onefang1-1/+1
2021-09-03os_groups UUIDs are 36 charcters, not 255 varchars.onefang1-4/+4
2021-09-03Change the database schemas for a few, might be able to create them now.onefang3-9/+9
Would have saved a lot of time if OpenSim didn't quietly fail these.
2021-09-03Make it GridUsers VERSION 1, coz there never was a VERSION 2.onefang1-1/+1
2021-09-03Fixup GridUser migrations to be like the others.onefang1-6/+1
2021-08-17MySQL default character set to utfmb4.onefang19-41/+41
Coz on one box they defaulted to utfmb3, which .NET doesn't support.
2020-07-31Various database fixups.onefang20-76/+76
InnoDB -> MyISAM utf8 if not exists white space
2019-10-29fix some mysql timestamps default valueUbitUmarov2-1/+7
2019-08-17missing fileUbitUmarov1-0/+7
2019-08-10set default value for timestand on groups v2 invites tableUbitUmarov1-0/+8
2019-05-19Various database fixups.onefang21-84/+78
InnoDB -> MyISAM utf8 if not exists white space
2019-05-19Dump OpenSim 0.9.0.1 into it's own branch.onefang22-1520/+594
2018-12-30add some persistence (mysql only)UbitUmarov1-0/+7
2018-01-13clean some modules apiUbitUmarov1-16/+0
2017-12-11 commit what i did so far for core mutes module, befere i lose itUbitUmarov1-0/+16
2017-11-14Donating the Avination Mute ModuleMelanie Thielker1-0/+16
This lived out-of-tree and therefore wasn't part of the big code drop. It's classic Avination, tied to MySQL and a direct database connection and I don't have the bandwidth to fix it to core methods. However, it has all the strange mute logic that OpenSim was missing and maybe someone can step up to make it work in an open grid context.
2017-05-04Change the engine of the groups table back to MyISAM, because MySQL 5.5 and ↵Diva Canto1-1/+1
older don't support full test search on InnoDB
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-11-03MyISAM is still much better performing for OpenSim.David Walter Seikel17-40/+40
This time we got the file system asset server, even better still. B-)
2016-11-03Initial update to OpenSim 0.8.2.1 source code.David Walter Seikel19-53/+435
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.
generated by cgit v1.1 at 2025-04-01 20:52:55 +0000