aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/RegionStore.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-17 17:37:16 +0200
committerAlexRa2010-05-23 11:48:16 +0300
commitebc2b6d4f6ebb0392ec0081bea913d24e9753786 (patch)
tree7faf0a526f0010c0b980f0c18ad6d162cbc30e64 /OpenSim/Data/SQLite/Resources/RegionStore.migrations
parentPrebuild: removed DB-specific test projects, added refs to Data.Tests (diff)
downloadopensim-SC-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.zip
opensim-SC-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.tar.gz
opensim-SC-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.tar.bz2
opensim-SC-ebc2b6d4f6ebb0392ec0081bea913d24e9753786.tar.xz
Split migrations for RegionStore and EstateStore (see WARNING!)
ok, so the estate stores now want their own migration files, but as it happened the SQL definition were inside the Region migrations. It seems better/cleaner to keep each 'store' separately updatable. WARNING: any editing in the middle of the migration scripts (as opposite to just appending to them) has the potential of messing up updates of existing databases. As far as I can see, this one is (probably) safe, the worst that could happen is the EstateStore migration silently fail if the estate the tables are already there.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/RegionStore.migrations')
-rw-r--r--OpenSim/Data/SQLite/Resources/RegionStore.migrations25
1 files changed, 0 insertions, 25 deletions
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
index 7b27378..c47a85d 100644
--- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
@@ -311,33 +311,8 @@ CREATE TABLE regionsettings (
311 PRIMARY KEY (regionUUID) 311 PRIMARY KEY (regionUUID)
312); 312);
313 313
314CREATE INDEX estate_ban_estate_id on estateban(EstateID);
315CREATE INDEX estate_groups_estate_id on estate_groups(EstateID);
316CREATE INDEX estate_managers_estate_id on estate_managers(EstateID);
317CREATE INDEX estate_map_estate_id on estate_map(EstateID);
318CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID);
319CREATE INDEX estate_users_estate_id on estate_users(EstateID);
320
321COMMIT; 314COMMIT;
322 315
323:VERSION 7
324
325begin;
326
327alter table estate_settings add column AbuseEmail varchar(255) not null default '';
328
329alter table estate_settings add column EstateOwner varchar(36) not null default '';
330
331commit;
332
333:VERSION 8
334
335begin;
336
337alter table estate_settings add column DenyMinors tinyint not null default 0;
338
339commit;
340
341:VERSION 9 316:VERSION 9
342 317
343BEGIN; 318BEGIN;