diff options
author | AlexRa | 2010-05-17 17:37:16 +0200 |
---|---|---|
committer | AlexRa | 2010-05-23 11:48:16 +0300 |
commit | ebc2b6d4f6ebb0392ec0081bea913d24e9753786 (patch) | |
tree | 7faf0a526f0010c0b980f0c18ad6d162cbc30e64 /OpenSim/Data/SQLite/Resources/RegionStore.migrations | |
parent | Prebuild: removed DB-specific test projects, added refs to Data.Tests (diff) | |
download | opensim-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.migrations | 25 |
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 | ||
314 | CREATE INDEX estate_ban_estate_id on estateban(EstateID); | ||
315 | CREATE INDEX estate_groups_estate_id on estate_groups(EstateID); | ||
316 | CREATE INDEX estate_managers_estate_id on estate_managers(EstateID); | ||
317 | CREATE INDEX estate_map_estate_id on estate_map(EstateID); | ||
318 | CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID); | ||
319 | CREATE INDEX estate_users_estate_id on estate_users(EstateID); | ||
320 | |||
321 | COMMIT; | 314 | COMMIT; |
322 | 315 | ||
323 | :VERSION 7 | ||
324 | |||
325 | begin; | ||
326 | |||
327 | alter table estate_settings add column AbuseEmail varchar(255) not null default ''; | ||
328 | |||
329 | alter table estate_settings add column EstateOwner varchar(36) not null default ''; | ||
330 | |||
331 | commit; | ||
332 | |||
333 | :VERSION 8 | ||
334 | |||
335 | begin; | ||
336 | |||
337 | alter table estate_settings add column DenyMinors tinyint not null default 0; | ||
338 | |||
339 | commit; | ||
340 | |||
341 | :VERSION 9 | 316 | :VERSION 9 |
342 | 317 | ||
343 | BEGIN; | 318 | BEGIN; |