diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations new file mode 100644 index 0000000..2e0d658 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -0,0 +1,69 @@ | |||
1 | :VERSION 13 | ||
2 | |||
3 | # The estate migrations used to be in Region store | ||
4 | |||
5 | CREATE TABLE IF NOT EXISTS `estate_managers` ( | ||
6 | `EstateID` int(10) unsigned NOT NULL, | ||
7 | `uuid` char(36) NOT NULL, | ||
8 | KEY `EstateID` (`EstateID`) | ||
9 | ) ENGINE=InnoDB; | ||
10 | |||
11 | CREATE TABLE IF NOT EXISTS `estate_groups` ( | ||
12 | `EstateID` int(10) unsigned NOT NULL, | ||
13 | `uuid` char(36) NOT NULL, | ||
14 | KEY `EstateID` (`EstateID`) | ||
15 | ) ENGINE=InnoDB; | ||
16 | |||
17 | CREATE TABLE IF NOT EXISTS `estate_users` ( | ||
18 | `EstateID` int(10) unsigned NOT NULL, | ||
19 | `uuid` char(36) NOT NULL, | ||
20 | KEY `EstateID` (`EstateID`) | ||
21 | ) ENGINE=InnoDB; | ||
22 | |||
23 | CREATE TABLE IF NOT EXISTS `estateban` ( | ||
24 | `EstateID` int(10) unsigned NOT NULL, | ||
25 | `bannedUUID` varchar(36) NOT NULL, | ||
26 | `bannedIp` varchar(16) NOT NULL, | ||
27 | `bannedIpHostMask` varchar(16) NOT NULL, | ||
28 | `bannedNameMask` varchar(64) default NULL, | ||
29 | KEY `estateban_EstateID` (`EstateID`) | ||
30 | ) ENGINE=InnoDB; | ||
31 | |||
32 | CREATE TABLE IF NOT EXISTS `estate_settings` ( | ||
33 | `EstateID` int(10) unsigned NOT NULL auto_increment, | ||
34 | `EstateName` varchar(64) default NULL, | ||
35 | `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, | ||
36 | `DenyAnonymous` tinyint(4) NOT NULL, | ||
37 | `ResetHomeOnTeleport` tinyint(4) NOT NULL, | ||
38 | `FixedSun` tinyint(4) NOT NULL, | ||
39 | `DenyTransacted` tinyint(4) NOT NULL, | ||
40 | `BlockDwell` tinyint(4) NOT NULL, | ||
41 | `DenyIdentified` tinyint(4) NOT NULL, | ||
42 | `AllowVoice` tinyint(4) NOT NULL, | ||
43 | `UseGlobalTime` tinyint(4) NOT NULL, | ||
44 | `PricePerMeter` int(11) NOT NULL, | ||
45 | `TaxFree` tinyint(4) NOT NULL, | ||
46 | `AllowDirectTeleport` tinyint(4) NOT NULL, | ||
47 | `RedirectGridX` int(11) NOT NULL, | ||
48 | `RedirectGridY` int(11) NOT NULL, | ||
49 | `ParentEstateID` int(10) unsigned NOT NULL, | ||
50 | `SunPosition` double NOT NULL, | ||
51 | `EstateSkipScripts` tinyint(4) NOT NULL, | ||
52 | `BillableFactor` float NOT NULL, | ||
53 | `PublicAccess` tinyint(4) NOT NULL, | ||
54 | `AbuseEmail` varchar(255) not null, | ||
55 | `EstateOwner` varchar(36) not null, | ||
56 | `DenyMinors` tinyint not null, | ||
57 | |||
58 | PRIMARY KEY (`EstateID`) | ||
59 | ) ENGINE=InnoDB AUTO_INCREMENT=100; | ||
60 | |||
61 | CREATE TABLE IF NOT EXISTS `estate_map` ( | ||
62 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
63 | `EstateID` int(11) NOT NULL, | ||
64 | PRIMARY KEY (`RegionID`), | ||
65 | KEY `EstateID` (`EstateID`) | ||
66 | ) ENGINE=InnoDB; | ||
67 | |||
68 | |||
69 | |||