clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 1 | :VERSION 13 |
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 | |||
7 | BEGIN; |
||
8 | |||
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=InnoDB; |
||
14 | |||
15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( |
||
16 | `EstateID` int(10) unsigned NOT NULL, |
||
17 | `uuid` char(36) NOT NULL, |
||
18 | KEY `EstateID` (`EstateID`) |
||
19 | ) ENGINE=InnoDB; |
||
20 | |||
21 | CREATE TABLE IF NOT EXISTS `estate_users` ( |
||
22 | `EstateID` int(10) unsigned NOT NULL, |
||
23 | `uuid` char(36) NOT NULL, |
||
24 | KEY `EstateID` (`EstateID`) |
||
25 | ) ENGINE=InnoDB; |
||
26 | |||
27 | CREATE TABLE IF NOT EXISTS `estateban` ( |
||
28 | `EstateID` int(10) unsigned NOT NULL, |
||
29 | `bannedUUID` varchar(36) NOT NULL, |
||
30 | `bannedIp` varchar(16) NOT NULL, |
||
31 | `bannedIpHostMask` varchar(16) NOT NULL, |
||
32 | `bannedNameMask` varchar(64) default NULL, |
||
33 | KEY `estateban_EstateID` (`EstateID`) |
||
34 | ) ENGINE=InnoDB; |
||
35 | |||
36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( |
||
37 | `EstateID` int(10) unsigned NOT NULL auto_increment, |
||
38 | `EstateName` varchar(64) default NULL, |
||
39 | `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, |
||
40 | `DenyAnonymous` tinyint(4) NOT NULL, |
||
41 | `ResetHomeOnTeleport` tinyint(4) NOT NULL, |
||
42 | `FixedSun` tinyint(4) NOT NULL, |
||
43 | `DenyTransacted` tinyint(4) NOT NULL, |
||
44 | `BlockDwell` tinyint(4) NOT NULL, |
||
45 | `DenyIdentified` tinyint(4) NOT NULL, |
||
46 | `AllowVoice` tinyint(4) NOT NULL, |
||
47 | `UseGlobalTime` tinyint(4) NOT NULL, |
||
48 | `PricePerMeter` int(11) NOT NULL, |
||
49 | `TaxFree` tinyint(4) NOT NULL, |
||
50 | `AllowDirectTeleport` tinyint(4) NOT NULL, |
||
51 | `RedirectGridX` int(11) NOT NULL, |
||
52 | `RedirectGridY` int(11) NOT NULL, |
||
53 | `ParentEstateID` int(10) unsigned NOT NULL, |
||
54 | `SunPosition` double NOT NULL, |
||
55 | `EstateSkipScripts` tinyint(4) NOT NULL, |
||
56 | `BillableFactor` float NOT NULL, |
||
57 | `PublicAccess` tinyint(4) NOT NULL, |
||
58 | `AbuseEmail` varchar(255) not null, |
||
59 | `EstateOwner` varchar(36) not null, |
||
60 | `DenyMinors` tinyint not null, |
||
61 | |||
62 | PRIMARY KEY (`EstateID`) |
||
63 | ) ENGINE=InnoDB AUTO_INCREMENT=100; |
||
64 | |||
65 | CREATE TABLE IF NOT EXISTS `estate_map` ( |
||
66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
||
67 | `EstateID` int(11) NOT NULL, |
||
68 | PRIMARY KEY (`RegionID`), |
||
69 | KEY `EstateID` (`EstateID`) |
||
70 | ) ENGINE=InnoDB; |
||
71 | |||
72 | COMMIT; |
||
73 | |||
74 | :VERSION 32 #--------------------- (moved from RegionStore migr, just in case) |
||
75 | |||
76 | BEGIN; |
||
77 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; |
||
78 | COMMIT; |
||
79 | |||
80 | :VERSION 33 #--------------------- |
||
81 | |||
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; |
||
87 |