diff options
author | Justin Clark-Casey (justincc) | 2010-09-01 22:06:56 +0100 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2010-09-01 22:06:56 +0100 |
commit | b9db495d91b1618c9caf0aeb81f65ad7ef86dc2a (patch) | |
tree | a6539350e5fdf6037769937db81c4738dac4fff4 /OpenSim/Data/SQLite/Resources/RegionStore.migrations | |
parent | refactor: move SOG.AttachToAgent() into AttachmentsModule (diff) | |
download | opensim-SC_OLD-b9db495d91b1618c9caf0aeb81f65ad7ef86dc2a.zip opensim-SC_OLD-b9db495d91b1618c9caf0aeb81f65ad7ef86dc2a.tar.gz opensim-SC_OLD-b9db495d91b1618c9caf0aeb81f65ad7ef86dc2a.tar.bz2 opensim-SC_OLD-b9db495d91b1618c9caf0aeb81f65ad7ef86dc2a.tar.xz |
Fix sqlite migration problems by moving migrations in 019_RegionStore.sql and 020 into RegionStore.migrations
This shows that panda is still not running the sqlite database tests since this change fixes the test failure in that area when "nant test" is executed locally
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/RegionStore.migrations | 17 |
1 files changed, 14 insertions, 3 deletions
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations index 0c421ec..5e2045b 100644 --- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations +++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations | |||
@@ -448,11 +448,22 @@ update land | |||
448 | COMMIT; | 448 | COMMIT; |
449 | 449 | ||
450 | :VERSION 19 | 450 | :VERSION 19 |
451 | BEGIN ; | 451 | BEGIN; |
452 | ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none' ; | 452 | ALTER TABLE regionsettings ADD COLUMN map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; |
453 | COMMIT; | ||
454 | |||
455 | :VERSION 20 | ||
456 | BEGIN; | ||
457 | ALTER TABLE prims ADD COLUMN MediaURL varchar(255); | ||
458 | ALTER TABLE primshapes ADD COLUMN Media TEXT; | ||
459 | COMMIT; | ||
460 | |||
461 | :VERSION 21 | ||
462 | BEGIN; | ||
463 | ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none'; | ||
453 | ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT ''; | 464 | ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT ''; |
454 | ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0'; | 465 | ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0'; |
455 | ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; | 466 | ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; |
456 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; | 467 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; |
457 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; | 468 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; |
458 | COMMIT ; \ No newline at end of file | 469 | COMMIT; \ No newline at end of file |