diff options
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-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, |