aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
diff options
context:
space:
mode:
authorSean Dague2008-08-27 17:32:02 +0000
committerSean Dague2008-08-27 17:32:02 +0000
commitf87f8b3b9f3e0e56f720b32cadc3984a8251493b (patch)
tree96f9a64eb998afd72fd666cc472fa4ac4bea45f5 /OpenSim/Data/SQLite/Resources/006_RegionStore.sql
parentImplements the r6005 foes for XEngine as well (diff)
downloadopensim-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.sql6
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 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3drop table if exists estate_groups;
4CREATE TABLE estate_groups ( 3CREATE 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
9drop table if exists estate_managers;
10CREATE TABLE estate_managers ( 8CREATE 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
15drop table if exists estate_map;
16CREATE TABLE estate_map ( 13CREATE 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
21drop table if exists estate_settings;
22CREATE TABLE estate_settings ( 18CREATE 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
52drop table if exists estateban;
53CREATE TABLE estateban ( 48CREATE 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
61drop table if exists regionsettings;
62CREATE TABLE regionsettings ( 56CREATE 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,