diff options
author | David Walter Seikel | 2016-11-03 21:44:39 +1000 |
---|---|---|
committer | David Walter Seikel | 2016-11-03 21:44:39 +1000 |
commit | 134f86e8d5c414409631b25b8c6f0ee45fbd8631 (patch) | |
tree | 216b89d3fb89acfb81be1e440c25c41ab09fa96d /OpenSim/Data/MySQL/Resources/EstateStore.migrations | |
parent | More changing to production grid. Double oops. (diff) | |
download | opensim-SC_OLD-134f86e8d5c414409631b25b8c6f0ee45fbd8631.zip opensim-SC_OLD-134f86e8d5c414409631b25b8c6f0ee45fbd8631.tar.gz opensim-SC_OLD-134f86e8d5c414409631b25b8c6f0ee45fbd8631.tar.bz2 opensim-SC_OLD-134f86e8d5c414409631b25b8c6f0ee45fbd8631.tar.xz |
Initial update to OpenSim 0.8.2.1 source code.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/EstateStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 18 |
1 files changed, 12 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations index 6ef92ee..2d1c2b5 100644 --- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -10,19 +10,19 @@ CREATE TABLE IF NOT EXISTS `estate_managers` ( | |||
10 | `EstateID` int(10) unsigned NOT NULL, | 10 | `EstateID` int(10) unsigned NOT NULL, |
11 | `uuid` char(36) NOT NULL, | 11 | `uuid` char(36) NOT NULL, |
12 | KEY `EstateID` (`EstateID`) | 12 | KEY `EstateID` (`EstateID`) |
13 | ) ENGINE=MyISAM; | 13 | ) ENGINE=InnoDB; |
14 | 14 | ||
15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( | 15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( |
16 | `EstateID` int(10) unsigned NOT NULL, | 16 | `EstateID` int(10) unsigned NOT NULL, |
17 | `uuid` char(36) NOT NULL, | 17 | `uuid` char(36) NOT NULL, |
18 | KEY `EstateID` (`EstateID`) | 18 | KEY `EstateID` (`EstateID`) |
19 | ) ENGINE=MyISAM; | 19 | ) ENGINE=InnoDB; |
20 | 20 | ||
21 | CREATE TABLE IF NOT EXISTS `estate_users` ( | 21 | CREATE TABLE IF NOT EXISTS `estate_users` ( |
22 | `EstateID` int(10) unsigned NOT NULL, | 22 | `EstateID` int(10) unsigned NOT NULL, |
23 | `uuid` char(36) NOT NULL, | 23 | `uuid` char(36) NOT NULL, |
24 | KEY `EstateID` (`EstateID`) | 24 | KEY `EstateID` (`EstateID`) |
25 | ) ENGINE=MyISAM; | 25 | ) ENGINE=InnoDB; |
26 | 26 | ||
27 | CREATE TABLE IF NOT EXISTS `estateban` ( | 27 | CREATE TABLE IF NOT EXISTS `estateban` ( |
28 | `EstateID` int(10) unsigned NOT NULL, | 28 | `EstateID` int(10) unsigned NOT NULL, |
@@ -31,7 +31,7 @@ CREATE TABLE IF NOT EXISTS `estateban` ( | |||
31 | `bannedIpHostMask` varchar(16) NOT NULL, | 31 | `bannedIpHostMask` varchar(16) NOT NULL, |
32 | `bannedNameMask` varchar(64) default NULL, | 32 | `bannedNameMask` varchar(64) default NULL, |
33 | KEY `estateban_EstateID` (`EstateID`) | 33 | KEY `estateban_EstateID` (`EstateID`) |
34 | ) ENGINE=MyISAM; | 34 | ) ENGINE=InnoDB; |
35 | 35 | ||
36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( | 36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( |
37 | `EstateID` int(10) unsigned NOT NULL auto_increment, | 37 | `EstateID` int(10) unsigned NOT NULL auto_increment, |
@@ -60,14 +60,14 @@ CREATE TABLE IF NOT EXISTS `estate_settings` ( | |||
60 | `DenyMinors` tinyint not null, | 60 | `DenyMinors` tinyint not null, |
61 | 61 | ||
62 | PRIMARY KEY (`EstateID`) | 62 | PRIMARY KEY (`EstateID`) |
63 | ) ENGINE=MyISAM AUTO_INCREMENT=100; | 63 | ) ENGINE=InnoDB AUTO_INCREMENT=100; |
64 | 64 | ||
65 | CREATE TABLE IF NOT EXISTS `estate_map` ( | 65 | CREATE TABLE IF NOT EXISTS `estate_map` ( |
66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
67 | `EstateID` int(11) NOT NULL, | 67 | `EstateID` int(11) NOT NULL, |
68 | PRIMARY KEY (`RegionID`), | 68 | PRIMARY KEY (`RegionID`), |
69 | KEY `EstateID` (`EstateID`) | 69 | KEY `EstateID` (`EstateID`) |
70 | ) ENGINE=MyISAM; | 70 | ) ENGINE=InnoDB; |
71 | 71 | ||
72 | COMMIT; | 72 | COMMIT; |
73 | 73 | ||
@@ -77,5 +77,11 @@ BEGIN; | |||
77 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; | 77 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; |
78 | COMMIT; | 78 | COMMIT; |
79 | 79 | ||
80 | :VERSION 33 #--------------------- | ||
80 | 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; | ||
81 | 87 | ||