aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources
diff options
context:
space:
mode:
authorSean Dague2008-07-18 15:10:20 +0000
committerSean Dague2008-07-18 15:10:20 +0000
commite2a3be254f0407bd6ef19a0875248b2b8b86baac (patch)
tree4644d8aaaa5b9ff0bc799d1af6205efc765091dd /OpenSim/Data/SQLite/Resources
parentfound a better pattern for SaveOrUpdate with nhibernate (diff)
downloadopensim-SC_OLD-e2a3be254f0407bd6ef19a0875248b2b8b86baac.zip
opensim-SC_OLD-e2a3be254f0407bd6ef19a0875248b2b8b86baac.tar.gz
opensim-SC_OLD-e2a3be254f0407bd6ef19a0875248b2b8b86baac.tar.bz2
opensim-SC_OLD-e2a3be254f0407bd6ef19a0875248b2b8b86baac.tar.xz
fix typo in create index that caused the entire migration to fail.
put some drop table if exist clauses in here to hopefully let this migration work for people that are in an intermediary broken state right now.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-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`);