From f87f8b3b9f3e0e56f720b32cadc3984a8251493b Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 27 Aug 2008 17:32:02 +0000
Subject: get rid of the "drop if exists" lines in this old migration, as those
 tables shouldn't exist yet, and the exists keyword is relatively new in
 sqlite.  This has been breaking a lot of people on Suse Enterprise Linux, for
 instance.

---
 OpenSim/Data/SQLite/Resources/006_RegionStore.sql | 6 ------
 1 file changed, 6 deletions(-)

(limited to 'OpenSim/Data/SQLite/Resources/006_RegionStore.sql')

diff --git a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
index 2f6ea22..15d3375 100644
--- a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
+++ b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
@@ -1,24 +1,20 @@
 BEGIN TRANSACTION;
 
-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,
@@ -49,7 +45,6 @@ CREATE TABLE estate_users (
   uuid char(36) NOT NULL
 );
 
-drop table if exists estateban;
 CREATE TABLE estateban (
   EstateID int(10) NOT NULL,
   bannedUUID varchar(36) NOT NULL,
@@ -58,7 +53,6 @@ CREATE TABLE estateban (
   bannedNameMask varchar(64) default NULL
 );
 
-drop table if exists regionsettings;
 CREATE TABLE regionsettings (
   regionUUID char(36) NOT NULL,
   block_terraform int(11) NOT NULL,
-- 
cgit v1.1

