From 05d9ca1b26baaae3e9ab106665163f5beeecd11d Mon Sep 17 00:00:00 2001
From: AlexRa
Date: Sun, 23 May 2010 11:36:40 +0300
Subject: MySQL Migrations: Minor correcton to Region/Estate split

(some Estate SQL left behind in the Region migration)
---
 OpenSim/Data/MySQL/Resources/EstateStore.migrations | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'OpenSim/Data/MySQL/Resources/EstateStore.migrations')

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 @@
 :VERSION 13
 
 # The estate migrations used to be in Region store
+# here they will do nothing (bad) if the tables are already there, 
+# just update the store version.
+
+BEGIN;
 
 CREATE TABLE IF NOT EXISTS `estate_managers` (
   `EstateID` int(10) unsigned NOT NULL,
@@ -65,5 +69,13 @@ CREATE TABLE IF NOT EXISTS `estate_map` (
   KEY `EstateID` (`EstateID`)
 ) ENGINE=InnoDB;
 
+COMMIT;
+
+:VERSION 32			#--------------------- (moved from RegionStore migr, just in case)
+
+BEGIN;
+ALTER TABLE estate_settings AUTO_INCREMENT = 100;
+COMMIT;
+
 
 
-- 
cgit v1.1