diff options
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 12 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 6 |
2 files changed, 12 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations index 2e0d658..df82a2e 100644 --- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -1,6 +1,10 @@ | |||
1 | :VERSION 13 | 1 | :VERSION 13 |
2 | 2 | ||
3 | # The estate migrations used to be in Region store | 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; | ||
4 | 8 | ||
5 | CREATE TABLE IF NOT EXISTS `estate_managers` ( | 9 | CREATE TABLE IF NOT EXISTS `estate_managers` ( |
6 | `EstateID` int(10) unsigned NOT NULL, | 10 | `EstateID` int(10) unsigned NOT NULL, |
@@ -65,5 +69,13 @@ CREATE TABLE IF NOT EXISTS `estate_map` ( | |||
65 | KEY `EstateID` (`EstateID`) | 69 | KEY `EstateID` (`EstateID`) |
66 | ) ENGINE=InnoDB; | 70 | ) ENGINE=InnoDB; |
67 | 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 | |||
68 | 80 | ||
69 | 81 | ||
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index 383c328..d8a279d 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -717,12 +717,6 @@ ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT | |||
717 | 717 | ||
718 | COMMIT; | 718 | COMMIT; |
719 | 719 | ||
720 | :VERSION 32 #--------------------- | ||
721 | |||
722 | BEGIN; | ||
723 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; | ||
724 | COMMIT; | ||
725 | |||
726 | :VERSION 33 #--------------------- | 720 | :VERSION 33 #--------------------- |
727 | 721 | ||
728 | BEGIN; | 722 | BEGIN; |