diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/EstateStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations index 99816ca..87adcca 100644 --- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -6,20 +6,20 @@ CREATE TABLE IF NOT EXISTS `estate_groups` ( | |||
6 | `EstateID` int(10) unsigned NOT NULL, | 6 | `EstateID` int(10) unsigned NOT NULL, |
7 | `uuid` char(36) NOT NULL, | 7 | `uuid` char(36) NOT NULL, |
8 | KEY `EstateID` (`EstateID`) | 8 | KEY `EstateID` (`EstateID`) |
9 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 9 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
10 | 10 | ||
11 | CREATE TABLE IF NOT EXISTS `estate_managers` ( | 11 | CREATE TABLE IF NOT EXISTS `estate_managers` ( |
12 | `EstateID` int(10) unsigned NOT NULL, | 12 | `EstateID` int(10) unsigned NOT NULL, |
13 | `uuid` char(36) NOT NULL, | 13 | `uuid` char(36) NOT NULL, |
14 | KEY `EstateID` (`EstateID`) | 14 | KEY `EstateID` (`EstateID`) |
15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
16 | 16 | ||
17 | CREATE TABLE IF NOT EXISTS `estate_map` ( | 17 | CREATE TABLE IF NOT EXISTS `estate_map` ( |
18 | `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 18 | `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
19 | `EstateID` int(11) NOT NULL, | 19 | `EstateID` int(11) NOT NULL, |
20 | PRIMARY KEY (`RegionID`), | 20 | PRIMARY KEY (`RegionID`), |
21 | KEY `EstateID` (`EstateID`) | 21 | KEY `EstateID` (`EstateID`) |
22 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 22 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
23 | 23 | ||
24 | CREATE TABLE IF NOT EXISTS `estate_settings` ( | 24 | CREATE TABLE IF NOT EXISTS `estate_settings` ( |
25 | `EstateID` int(10) unsigned NOT NULL AUTO_INCREMENT, | 25 | `EstateID` int(10) unsigned NOT NULL AUTO_INCREMENT, |
@@ -50,13 +50,13 @@ CREATE TABLE IF NOT EXISTS `estate_settings` ( | |||
50 | `AllowParcelChanges` tinyint(4) NOT NULL DEFAULT '1', | 50 | `AllowParcelChanges` tinyint(4) NOT NULL DEFAULT '1', |
51 | `AllowSetHome` tinyint(4) NOT NULL DEFAULT '1', | 51 | `AllowSetHome` tinyint(4) NOT NULL DEFAULT '1', |
52 | PRIMARY KEY (`EstateID`) | 52 | PRIMARY KEY (`EstateID`) |
53 | ) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8; | 53 | ) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4; |
54 | 54 | ||
55 | CREATE TABLE IF NOT EXISTS `estate_users` ( | 55 | CREATE TABLE IF NOT EXISTS `estate_users` ( |
56 | `EstateID` int(10) unsigned NOT NULL, | 56 | `EstateID` int(10) unsigned NOT NULL, |
57 | `uuid` char(36) NOT NULL, | 57 | `uuid` char(36) NOT NULL, |
58 | KEY `EstateID` (`EstateID`) | 58 | KEY `EstateID` (`EstateID`) |
59 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 59 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
60 | 60 | ||
61 | CREATE TABLE IF NOT EXISTS `estateban` ( | 61 | CREATE TABLE IF NOT EXISTS `estateban` ( |
62 | `EstateID` int(10) unsigned NOT NULL, | 62 | `EstateID` int(10) unsigned NOT NULL, |
@@ -65,7 +65,7 @@ CREATE TABLE IF NOT EXISTS `estateban` ( | |||
65 | `bannedIpHostMask` varchar(16) NOT NULL, | 65 | `bannedIpHostMask` varchar(16) NOT NULL, |
66 | `bannedNameMask` varchar(64) DEFAULT NULL, | 66 | `bannedNameMask` varchar(64) DEFAULT NULL, |
67 | KEY `estateban_EstateID` (`EstateID`) | 67 | KEY `estateban_EstateID` (`EstateID`) |
68 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 68 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
69 | 69 | ||
70 | COMMIT; | 70 | COMMIT; |
71 | 71 | ||