From e2a3be254f0407bd6ef19a0875248b2b8b86baac Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Fri, 18 Jul 2008 15:10:20 +0000
Subject: fix typo in create index that caused the entire migration to fail.
 put some drop table if exist clauses in here to hopefully let this migration
 work for people that are in an intermediary broken state right now.

---
 OpenSim/Data/SQLite/Resources/006_RegionStore.sql | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'OpenSim')

diff --git a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
index 025f1a9..8449fbb 100644
--- a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
+++ b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
@@ -1,15 +1,22 @@
+drop table if exists `estate_groups`;
 CREATE TABLE `estate_groups` (
   `EstateID` int(10) NOT NULL,
   `uuid` char(36) NOT NULL
 );
+
+drop table if exists `estate_managers`;
 CREATE TABLE `estate_managers` (
   `EstateID` int(10) NOT NULL,
   `uuid` char(36) NOT NULL
 );
+
+drop table if exists `estate_map`;
 CREATE TABLE `estate_map` (
   `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
   `EstateID` int(11) NOT NULL
 );
+
+drop table if exists `estate_settings`;
 CREATE TABLE `estate_settings` (
   `EstateID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   `EstateName` varchar(64) default NULL,
@@ -39,6 +46,8 @@ CREATE TABLE `estate_users` (
   `EstateID` int(10) NOT NULL,
   `uuid` char(36) NOT NULL
 );
+
+drop table if exists `estateban`;
 CREATE TABLE `estateban` (
   `EstateID` int(10) NOT NULL,
   `bannedUUID` varchar(36) NOT NULL,
@@ -46,6 +55,7 @@ CREATE TABLE `estateban` (
   `bannedIpHostMask` varchar(16) NOT NULL,
   `bannedNameMask` varchar(64) default NULL
 );
+
 drop table if exists `regionsettings`;
 CREATE TABLE `regionsettings` (
   `regionUUID` char(36) NOT NULL,
@@ -84,9 +94,10 @@ CREATE TABLE `regionsettings` (
   `Sandbox` tinyint(4) NOT NULL,
   PRIMARY KEY  (`regionUUID`)
 );
+
 CREATE INDEX `estate_ban_estate_id` on `estateban`(`EstateID`);
 CREATE INDEX `estate_groups_estate_id` on `estate_groups`(`EstateID`);
 CREATE INDEX `estate_managers_estate_id` on `estate_managers`(`EstateID`);
 CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`);
-CREATE UNIQUE INDEX `estate_map_region)id` on `estate_map`(`RegionID`);
+CREATE UNIQUE INDEX `estate_map_region_id` on `estate_map`(`RegionID`);
 CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`);
-- 
cgit v1.1