diff options
author | Melanie | 2010-05-26 10:38:46 +0100 |
---|---|---|
committer | Melanie | 2010-05-26 10:56:24 +0100 |
commit | 1c7f60ab493dffe44ab0517e4a6101fe5d909e28 (patch) | |
tree | 72b6a478d32d968ad7f5f3d6d11955bee9662926 /OpenSim/Data/MySQL/Resources/EstateStore.migrations | |
parent | Change the way alpha is interpreted on prim text. Manris #4723 (diff) | |
parent | Minor correction to AssetTests.cs (diff) | |
download | opensim-SC_OLD-1c7f60ab493dffe44ab0517e4a6101fe5d909e28.zip opensim-SC_OLD-1c7f60ab493dffe44ab0517e4a6101fe5d909e28.tar.gz opensim-SC_OLD-1c7f60ab493dffe44ab0517e4a6101fe5d909e28.tar.bz2 opensim-SC_OLD-1c7f60ab493dffe44ab0517e4a6101fe5d909e28.tar.xz |
Merge branch 'unitests'
Signed-off-by: Melanie <melanie@t-data.com>
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 81 |
1 files changed, 81 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..df82a2e --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -0,0 +1,81 @@ | |||
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 | |||
81 | |||