diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/EstateStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 80 |
1 files changed, 32 insertions, 48 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations index 9dfb77b..9c1ed83 100644 --- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -1,41 +1,29 @@ | |||
1 | :VERSION 13 | 1 | :VERSION 34 |
2 | |||
3 | # The estate migrations used to be in Region store | ||
4 | # here they will do nothing (bad) if the tables are already there, | ||
5 | # just update the store version. | ||
6 | 2 | ||
7 | BEGIN; | 3 | BEGIN; |
8 | 4 | ||
9 | CREATE TABLE IF NOT EXISTS `estate_managers` ( | ||
10 | `EstateID` int(10) unsigned NOT NULL, | ||
11 | `uuid` char(36) NOT NULL, | ||
12 | KEY `EstateID` (`EstateID`) | ||
13 | ) ENGINE=MyISAM; | ||
14 | |||
15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( | 5 | CREATE TABLE IF NOT EXISTS `estate_groups` ( |
16 | `EstateID` int(10) unsigned NOT NULL, | 6 | `EstateID` int(10) unsigned NOT NULL, |
17 | `uuid` char(36) NOT NULL, | 7 | `uuid` char(36) NOT NULL, |
18 | KEY `EstateID` (`EstateID`) | 8 | KEY `EstateID` (`EstateID`) |
19 | ) ENGINE=MyISAM; | 9 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
20 | 10 | ||
21 | CREATE TABLE IF NOT EXISTS `estate_users` ( | 11 | CREATE TABLE IF NOT EXISTS `estate_managers` ( |
22 | `EstateID` int(10) unsigned NOT NULL, | 12 | `EstateID` int(10) unsigned NOT NULL, |
23 | `uuid` char(36) NOT NULL, | 13 | `uuid` char(36) NOT NULL, |
24 | KEY `EstateID` (`EstateID`) | 14 | KEY `EstateID` (`EstateID`) |
25 | ) ENGINE=MyISAM; | 15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
26 | 16 | ||
27 | CREATE TABLE IF NOT EXISTS `estateban` ( | 17 | CREATE TABLE IF NOT EXISTS `estate_map` ( |
28 | `EstateID` int(10) unsigned NOT NULL, | 18 | `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
29 | `bannedUUID` varchar(36) NOT NULL, | 19 | `EstateID` int(11) NOT NULL, |
30 | `bannedIp` varchar(16) NOT NULL, | 20 | PRIMARY KEY (`RegionID`), |
31 | `bannedIpHostMask` varchar(16) NOT NULL, | 21 | KEY `EstateID` (`EstateID`) |
32 | `bannedNameMask` varchar(64) default NULL, | 22 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
33 | KEY `estateban_EstateID` (`EstateID`) | ||
34 | ) ENGINE=MyISAM; | ||
35 | 23 | ||
36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( | 24 | CREATE TABLE IF NOT EXISTS `estate_settings` ( |
37 | `EstateID` int(10) unsigned NOT NULL auto_increment, | 25 | `EstateID` int(10) unsigned NOT NULL AUTO_INCREMENT, |
38 | `EstateName` varchar(64) default NULL, | 26 | `EstateName` varchar(64) DEFAULT NULL, |
39 | `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, | 27 | `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, |
40 | `DenyAnonymous` tinyint(4) NOT NULL, | 28 | `DenyAnonymous` tinyint(4) NOT NULL, |
41 | `ResetHomeOnTeleport` tinyint(4) NOT NULL, | 29 | `ResetHomeOnTeleport` tinyint(4) NOT NULL, |
@@ -55,33 +43,29 @@ CREATE TABLE IF NOT EXISTS `estate_settings` ( | |||
55 | `EstateSkipScripts` tinyint(4) NOT NULL, | 43 | `EstateSkipScripts` tinyint(4) NOT NULL, |
56 | `BillableFactor` float NOT NULL, | 44 | `BillableFactor` float NOT NULL, |
57 | `PublicAccess` tinyint(4) NOT NULL, | 45 | `PublicAccess` tinyint(4) NOT NULL, |
58 | `AbuseEmail` varchar(255) not null, | 46 | `AbuseEmail` varchar(255) NOT NULL, |
59 | `EstateOwner` varchar(36) not null, | 47 | `EstateOwner` varchar(36) NOT NULL, |
60 | `DenyMinors` tinyint not null, | 48 | `DenyMinors` tinyint(4) NOT NULL, |
61 | 49 | `AllowLandmark` tinyint(4) NOT NULL DEFAULT '1', | |
62 | PRIMARY KEY (`EstateID`) | 50 | `AllowParcelChanges` tinyint(4) NOT NULL DEFAULT '1', |
63 | ) ENGINE=MyISAM AUTO_INCREMENT=100; | 51 | `AllowSetHome` tinyint(4) NOT NULL DEFAULT '1', |
52 | PRIMARY KEY (`EstateID`) | ||
53 | ) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8; | ||
64 | 54 | ||
65 | CREATE TABLE IF NOT EXISTS `estate_map` ( | 55 | CREATE TABLE IF NOT EXISTS `estate_users` ( |
66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 56 | `EstateID` int(10) unsigned NOT NULL, |
67 | `EstateID` int(11) NOT NULL, | 57 | `uuid` char(36) NOT NULL, |
68 | PRIMARY KEY (`RegionID`), | ||
69 | KEY `EstateID` (`EstateID`) | 58 | KEY `EstateID` (`EstateID`) |
70 | ) ENGINE=MyISAM; | 59 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
71 | 60 | ||
72 | COMMIT; | 61 | CREATE TABLE IF NOT EXISTS `estateban` ( |
73 | 62 | `EstateID` int(10) unsigned NOT NULL, | |
74 | :VERSION 32 #--------------------- (moved from RegionStore migr, just in case) | 63 | `bannedUUID` varchar(36) NOT NULL, |
75 | 64 | `bannedIp` varchar(16) NOT NULL, | |
76 | BEGIN; | 65 | `bannedIpHostMask` varchar(16) NOT NULL, |
77 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; | 66 | `bannedNameMask` varchar(64) DEFAULT NULL, |
78 | COMMIT; | 67 | KEY `estateban_EstateID` (`EstateID`) |
79 | 68 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
80 | :VERSION 33 #--------------------- | ||
81 | 69 | ||
82 | BEGIN; | ||
83 | ALTER TABLE estate_settings ADD COLUMN `AllowLandmark` tinyint(4) NOT NULL default '1'; | ||
84 | ALTER TABLE estate_settings ADD COLUMN `AllowParcelChanges` tinyint(4) NOT NULL default '1'; | ||
85 | ALTER TABLE estate_settings ADD COLUMN `AllowSetHome` tinyint(4) NOT NULL default '1'; | ||
86 | COMMIT; | 70 | COMMIT; |
87 | 71 | ||