aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/EstateStore.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-17 17:37:16 +0200
committerAlexRa2010-05-23 11:48:16 +0300
commitebc2b6d4f6ebb0392ec0081bea913d24e9753786 (patch)
tree7faf0a526f0010c0b980f0c18ad6d162cbc30e64 /OpenSim/Data/MySQL/Resources/EstateStore.migrations
parentPrebuild: removed DB-specific test projects, added refs to Data.Tests (diff)
downloadopensim-SC_OLD-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.zip
opensim-SC_OLD-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.tar.gz
opensim-SC_OLD-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.tar.bz2
opensim-SC_OLD-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.tar.xz
Split migrations for RegionStore and EstateStore (see WARNING!)
ok, so the estate stores now want their own migration files, but as it happened the SQL definition were inside the Region migrations. It seems better/cleaner to keep each 'store' separately updatable. WARNING: any editing in the middle of the migration scripts (as opposite to just appending to them) has the potential of messing up updates of existing databases. As far as I can see, this one is (probably) safe, the worst that could happen is the EstateStore migration silently fail if the estate the tables are already there.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/EstateStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/EstateStore.migrations69
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
5CREATE 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
11CREATE 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
17CREATE 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
23CREATE 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
32CREATE 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
61CREATE 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