aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/EstateStore.migrations
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MySQL/Resources/EstateStore.migrations12
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations
index df82a2e..6ef92ee 100644
--- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations
@@ -10,19 +10,19 @@ CREATE TABLE IF NOT EXISTS `estate_managers` (
10 `EstateID` int(10) unsigned NOT NULL, 10 `EstateID` int(10) unsigned NOT NULL,
11 `uuid` char(36) NOT NULL, 11 `uuid` char(36) NOT NULL,
12 KEY `EstateID` (`EstateID`) 12 KEY `EstateID` (`EstateID`)
13) ENGINE=InnoDB; 13) ENGINE=MyISAM;
14 14
15CREATE TABLE IF NOT EXISTS `estate_groups` ( 15CREATE TABLE IF NOT EXISTS `estate_groups` (
16 `EstateID` int(10) unsigned NOT NULL, 16 `EstateID` int(10) unsigned NOT NULL,
17 `uuid` char(36) NOT NULL, 17 `uuid` char(36) NOT NULL,
18 KEY `EstateID` (`EstateID`) 18 KEY `EstateID` (`EstateID`)
19) ENGINE=InnoDB; 19) ENGINE=MyISAM;
20 20
21CREATE TABLE IF NOT EXISTS `estate_users` ( 21CREATE TABLE IF NOT EXISTS `estate_users` (
22 `EstateID` int(10) unsigned NOT NULL, 22 `EstateID` int(10) unsigned NOT NULL,
23 `uuid` char(36) NOT NULL, 23 `uuid` char(36) NOT NULL,
24 KEY `EstateID` (`EstateID`) 24 KEY `EstateID` (`EstateID`)
25) ENGINE=InnoDB; 25) ENGINE=MyISAM;
26 26
27CREATE TABLE IF NOT EXISTS `estateban` ( 27CREATE TABLE IF NOT EXISTS `estateban` (
28 `EstateID` int(10) unsigned NOT NULL, 28 `EstateID` int(10) unsigned NOT NULL,
@@ -31,7 +31,7 @@ CREATE TABLE IF NOT EXISTS `estateban` (
31 `bannedIpHostMask` varchar(16) NOT NULL, 31 `bannedIpHostMask` varchar(16) NOT NULL,
32 `bannedNameMask` varchar(64) default NULL, 32 `bannedNameMask` varchar(64) default NULL,
33 KEY `estateban_EstateID` (`EstateID`) 33 KEY `estateban_EstateID` (`EstateID`)
34) ENGINE=InnoDB; 34) ENGINE=MyISAM;
35 35
36CREATE TABLE IF NOT EXISTS `estate_settings` ( 36CREATE TABLE IF NOT EXISTS `estate_settings` (
37 `EstateID` int(10) unsigned NOT NULL auto_increment, 37 `EstateID` int(10) unsigned NOT NULL auto_increment,
@@ -60,14 +60,14 @@ CREATE TABLE IF NOT EXISTS `estate_settings` (
60 `DenyMinors` tinyint not null, 60 `DenyMinors` tinyint not null,
61 61
62 PRIMARY KEY (`EstateID`) 62 PRIMARY KEY (`EstateID`)
63) ENGINE=InnoDB AUTO_INCREMENT=100; 63) ENGINE=MyISAM AUTO_INCREMENT=100;
64 64
65CREATE TABLE IF NOT EXISTS `estate_map` ( 65CREATE TABLE IF NOT EXISTS `estate_map` (
66 `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', 66 `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
67 `EstateID` int(11) NOT NULL, 67 `EstateID` int(11) NOT NULL,
68 PRIMARY KEY (`RegionID`), 68 PRIMARY KEY (`RegionID`),
69 KEY `EstateID` (`EstateID`) 69 KEY `EstateID` (`EstateID`)
70) ENGINE=InnoDB; 70) ENGINE=MyISAM;
71 71
72COMMIT; 72COMMIT;
73 73