diff options
author | Sean Dague | 2008-08-27 17:32:02 +0000 |
---|---|---|
committer | Sean Dague | 2008-08-27 17:32:02 +0000 |
commit | f87f8b3b9f3e0e56f720b32cadc3984a8251493b (patch) | |
tree | 96f9a64eb998afd72fd666cc472fa4ac4bea45f5 /OpenSim/Data/SQLite/Resources/006_RegionStore.sql | |
parent | Implements the r6005 foes for XEngine as well (diff) | |
download | opensim-SC-f87f8b3b9f3e0e56f720b32cadc3984a8251493b.zip opensim-SC-f87f8b3b9f3e0e56f720b32cadc3984a8251493b.tar.gz opensim-SC-f87f8b3b9f3e0e56f720b32cadc3984a8251493b.tar.bz2 opensim-SC-f87f8b3b9f3e0e56f720b32cadc3984a8251493b.tar.xz |
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.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/006_RegionStore.sql')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/006_RegionStore.sql | 6 |
1 files changed, 0 insertions, 6 deletions
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 @@ | |||
1 | BEGIN TRANSACTION; | 1 | BEGIN TRANSACTION; |
2 | 2 | ||
3 | drop table if exists estate_groups; | ||
4 | CREATE TABLE estate_groups ( | 3 | CREATE TABLE estate_groups ( |
5 | EstateID int(10) NOT NULL, | 4 | EstateID int(10) NOT NULL, |
6 | uuid char(36) NOT NULL | 5 | uuid char(36) NOT NULL |
7 | ); | 6 | ); |
8 | 7 | ||
9 | drop table if exists estate_managers; | ||
10 | CREATE TABLE estate_managers ( | 8 | CREATE TABLE estate_managers ( |
11 | EstateID int(10) NOT NULL, | 9 | EstateID int(10) NOT NULL, |
12 | uuid char(36) NOT NULL | 10 | uuid char(36) NOT NULL |
13 | ); | 11 | ); |
14 | 12 | ||
15 | drop table if exists estate_map; | ||
16 | CREATE TABLE estate_map ( | 13 | CREATE TABLE estate_map ( |
17 | RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 14 | RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
18 | EstateID int(11) NOT NULL | 15 | EstateID int(11) NOT NULL |
19 | ); | 16 | ); |
20 | 17 | ||
21 | drop table if exists estate_settings; | ||
22 | CREATE TABLE estate_settings ( | 18 | CREATE TABLE estate_settings ( |
23 | EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, | 19 | EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
24 | EstateName varchar(64) default NULL, | 20 | EstateName varchar(64) default NULL, |
@@ -49,7 +45,6 @@ CREATE TABLE estate_users ( | |||
49 | uuid char(36) NOT NULL | 45 | uuid char(36) NOT NULL |
50 | ); | 46 | ); |
51 | 47 | ||
52 | drop table if exists estateban; | ||
53 | CREATE TABLE estateban ( | 48 | CREATE TABLE estateban ( |
54 | EstateID int(10) NOT NULL, | 49 | EstateID int(10) NOT NULL, |
55 | bannedUUID varchar(36) NOT NULL, | 50 | bannedUUID varchar(36) NOT NULL, |
@@ -58,7 +53,6 @@ CREATE TABLE estateban ( | |||
58 | bannedNameMask varchar(64) default NULL | 53 | bannedNameMask varchar(64) default NULL |
59 | ); | 54 | ); |
60 | 55 | ||
61 | drop table if exists regionsettings; | ||
62 | CREATE TABLE regionsettings ( | 56 | CREATE TABLE regionsettings ( |
63 | regionUUID char(36) NOT NULL, | 57 | regionUUID char(36) NOT NULL, |
64 | block_terraform int(11) NOT NULL, | 58 | block_terraform int(11) NOT NULL, |