aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
diff options
context:
space:
mode:
authorSean Dague2008-07-18 15:13:19 +0000
committerSean Dague2008-07-18 15:13:19 +0000
commitd9ba7c8339955eccabf20d19e7b28e57491c2c28 (patch)
treea12d2f18b1237c76f6d9e67129a3f9151ee3e3a9 /OpenSim/Data/SQLite/Resources/006_RegionStore.sql
parentfix typo in create index that caused the entire migration to fail. (diff)
downloadopensim-SC-d9ba7c8339955eccabf20d19e7b28e57491c2c28.zip
opensim-SC-d9ba7c8339955eccabf20d19e7b28e57491c2c28.tar.gz
opensim-SC-d9ba7c8339955eccabf20d19e7b28e57491c2c28.tar.bz2
opensim-SC-d9ba7c8339955eccabf20d19e7b28e57491c2c28.tar.xz
put the entire thing inside a transaction. This probably doesn't
help much, but it might.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/006_RegionStore.sql')
-rw-r--r--OpenSim/Data/SQLite/Resources/006_RegionStore.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
index 8449fbb..60b348a 100644
--- a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
+++ b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
@@ -1,3 +1,5 @@
1BEGIN TRANSACTION;
2
1drop table if exists `estate_groups`; 3drop table if exists `estate_groups`;
2CREATE TABLE `estate_groups` ( 4CREATE TABLE `estate_groups` (
3 `EstateID` int(10) NOT NULL, 5 `EstateID` int(10) NOT NULL,
@@ -101,3 +103,5 @@ CREATE INDEX `estate_managers_estate_id` on `estate_managers`(`EstateID`);
101CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`); 103CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`);
102CREATE UNIQUE INDEX `estate_map_region_id` on `estate_map`(`RegionID`); 104CREATE UNIQUE INDEX `estate_map_region_id` on `estate_map`(`RegionID`);
103CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`); 105CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`);
106
107COMMIT; \ No newline at end of file