aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
-rw-r--r--OpenSim/Data/SQLite/Resources/006_RegionStore.sql13
1 files changed, 12 insertions, 1 deletions
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 @@
1drop table if exists `estate_groups`;
1CREATE TABLE `estate_groups` ( 2CREATE TABLE `estate_groups` (
2 `EstateID` int(10) NOT NULL, 3 `EstateID` int(10) NOT NULL,
3 `uuid` char(36) NOT NULL 4 `uuid` char(36) NOT NULL
4); 5);
6
7drop table if exists `estate_managers`;
5CREATE TABLE `estate_managers` ( 8CREATE TABLE `estate_managers` (
6 `EstateID` int(10) NOT NULL, 9 `EstateID` int(10) NOT NULL,
7 `uuid` char(36) NOT NULL 10 `uuid` char(36) NOT NULL
8); 11);
12
13drop table if exists `estate_map`;
9CREATE TABLE `estate_map` ( 14CREATE TABLE `estate_map` (
10 `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', 15 `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
11 `EstateID` int(11) NOT NULL 16 `EstateID` int(11) NOT NULL
12); 17);
18
19drop table if exists `estate_settings`;
13CREATE TABLE `estate_settings` ( 20CREATE TABLE `estate_settings` (
14 `EstateID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 21 `EstateID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
15 `EstateName` varchar(64) default NULL, 22 `EstateName` varchar(64) default NULL,
@@ -39,6 +46,8 @@ CREATE TABLE `estate_users` (
39 `EstateID` int(10) NOT NULL, 46 `EstateID` int(10) NOT NULL,
40 `uuid` char(36) NOT NULL 47 `uuid` char(36) NOT NULL
41); 48);
49
50drop table if exists `estateban`;
42CREATE TABLE `estateban` ( 51CREATE TABLE `estateban` (
43 `EstateID` int(10) NOT NULL, 52 `EstateID` int(10) NOT NULL,
44 `bannedUUID` varchar(36) NOT NULL, 53 `bannedUUID` varchar(36) NOT NULL,
@@ -46,6 +55,7 @@ CREATE TABLE `estateban` (
46 `bannedIpHostMask` varchar(16) NOT NULL, 55 `bannedIpHostMask` varchar(16) NOT NULL,
47 `bannedNameMask` varchar(64) default NULL 56 `bannedNameMask` varchar(64) default NULL
48); 57);
58
49drop table if exists `regionsettings`; 59drop table if exists `regionsettings`;
50CREATE TABLE `regionsettings` ( 60CREATE TABLE `regionsettings` (
51 `regionUUID` char(36) NOT NULL, 61 `regionUUID` char(36) NOT NULL,
@@ -84,9 +94,10 @@ CREATE TABLE `regionsettings` (
84 `Sandbox` tinyint(4) NOT NULL, 94 `Sandbox` tinyint(4) NOT NULL,
85 PRIMARY KEY (`regionUUID`) 95 PRIMARY KEY (`regionUUID`)
86); 96);
97
87CREATE INDEX `estate_ban_estate_id` on `estateban`(`EstateID`); 98CREATE INDEX `estate_ban_estate_id` on `estateban`(`EstateID`);
88CREATE INDEX `estate_groups_estate_id` on `estate_groups`(`EstateID`); 99CREATE INDEX `estate_groups_estate_id` on `estate_groups`(`EstateID`);
89CREATE INDEX `estate_managers_estate_id` on `estate_managers`(`EstateID`); 100CREATE INDEX `estate_managers_estate_id` on `estate_managers`(`EstateID`);
90CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`); 101CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`);
91CREATE UNIQUE INDEX `estate_map_region)id` on `estate_map`(`RegionID`); 102CREATE UNIQUE INDEX `estate_map_region_id` on `estate_map`(`RegionID`);
92CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`); 103CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`);