aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/InventoryStore.migrations
diff options
context:
space:
mode:
authoronefang2021-08-17 21:19:52 +1000
committeronefang2021-08-17 21:19:52 +1000
commit804312a2308484cb8eb779a9aa08c0ea8ef8bd52 (patch)
treead4becf32ada15bab31cbd6d9e1f0e801b38edcc /OpenSim/Data/MySQL/Resources/InventoryStore.migrations
parentNext bit of the inventory backup, actually do the backup. (diff)
downloadopensim-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.migrations4
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
30CREATE TABLE IF NOT EXISTS `inventoryfolders` ( 30CREATE 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
42COMMIT; 42COMMIT;