diff options
author | onefang | 2021-08-17 21:19:52 +1000 |
---|---|---|
committer | onefang | 2021-08-17 21:19:52 +1000 |
commit | 804312a2308484cb8eb779a9aa08c0ea8ef8bd52 (patch) | |
tree | ad4becf32ada15bab31cbd6d9e1f0e801b38edcc /OpenSim/Data/MySQL/Resources/InventoryStore.migrations | |
parent | Next bit of the inventory backup, actually do the backup. (diff) | |
download | opensim-SC-804312a2308484cb8eb779a9aa08c0ea8ef8bd52.zip opensim-SC-804312a2308484cb8eb779a9aa08c0ea8ef8bd52.tar.gz opensim-SC-804312a2308484cb8eb779a9aa08c0ea8ef8bd52.tar.bz2 opensim-SC-804312a2308484cb8eb779a9aa08c0ea8ef8bd52.tar.xz |
MySQL default character set to utfmb4.
Coz on one box they defaulted to utfmb3, which .NET doesn't support.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/InventoryStore.migrations | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations index 7283e41..808cdc9 100644 --- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations +++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations | |||
@@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `inventoryitems` ( | |||
25 | PRIMARY KEY (`inventoryID`), | 25 | PRIMARY KEY (`inventoryID`), |
26 | KEY `inventoryitems_avatarid` (`avatarID`), | 26 | KEY `inventoryitems_avatarid` (`avatarID`), |
27 | KEY `inventoryitems_parentFolderid` (`parentFolderID`) | 27 | KEY `inventoryitems_parentFolderid` (`parentFolderID`) |
28 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 28 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
29 | 29 | ||
30 | CREATE TABLE IF NOT EXISTS `inventoryfolders` ( | 30 | CREATE TABLE IF NOT EXISTS `inventoryfolders` ( |
31 | `folderName` varchar(64) DEFAULT NULL, | 31 | `folderName` varchar(64) DEFAULT NULL, |
@@ -37,6 +37,6 @@ CREATE TABLE IF NOT EXISTS `inventoryfolders` ( | |||
37 | PRIMARY KEY (`folderID`), | 37 | PRIMARY KEY (`folderID`), |
38 | KEY `inventoryfolders_agentid` (`agentID`), | 38 | KEY `inventoryfolders_agentid` (`agentID`), |
39 | KEY `inventoryfolders_parentFolderid` (`parentFolderID`) | 39 | KEY `inventoryfolders_parentFolderid` (`parentFolderID`) |
40 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 40 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
41 | 41 | ||
42 | COMMIT; | 42 | COMMIT; |