diff options
author | Diva Canto | 2010-09-02 16:36:43 -0700 |
---|---|---|
committer | Diva Canto | 2010-09-02 16:36:43 -0700 |
commit | 21c5377af998bdd2c6a442588195a7af4d21fa48 (patch) | |
tree | 149e6d3dbeb5b3061bd5625763dfb388a50ed47b /OpenSim/Data/SQLite/Resources | |
parent | Quick fix for making global references for gatekeepers that are not domain:po... (diff) | |
parent | Remove commented code and the comment, as the change has proven out (diff) | |
download | opensim-SC-21c5377af998bdd2c6a442588195a7af4d21fa48.zip opensim-SC-21c5377af998bdd2c6a442588195a7af4d21fa48.tar.gz opensim-SC-21c5377af998bdd2c6a442588195a7af4d21fa48.tar.bz2 opensim-SC-21c5377af998bdd2c6a442588195a7af4d21fa48.tar.xz |
Merge branch 'master' of ssh://diva@opensimulator.org/var/git/opensim
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/019_RegionStore.sql | 5 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/Resources/020_RegionStore.sql | 6 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/Resources/RegionStore.migrations | 21 |
3 files changed, 21 insertions, 11 deletions
diff --git a/OpenSim/Data/SQLite/Resources/019_RegionStore.sql b/OpenSim/Data/SQLite/Resources/019_RegionStore.sql deleted file mode 100644 index d62f848..0000000 --- a/OpenSim/Data/SQLite/Resources/019_RegionStore.sql +++ /dev/null | |||
@@ -1,5 +0,0 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE regionsettings ADD COLUMN map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; | ||
4 | |||
5 | COMMIT; \ No newline at end of file | ||
diff --git a/OpenSim/Data/SQLite/Resources/020_RegionStore.sql b/OpenSim/Data/SQLite/Resources/020_RegionStore.sql deleted file mode 100644 index 39cb752..0000000 --- a/OpenSim/Data/SQLite/Resources/020_RegionStore.sql +++ /dev/null | |||
@@ -1,6 +0,0 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE prims ADD COLUMN MediaURL varchar(255); | ||
4 | ALTER TABLE primshapes ADD COLUMN Media TEXT; | ||
5 | |||
6 | COMMIT; \ No newline at end of file | ||
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations index c461bf0..5e2045b 100644 --- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations +++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations | |||
@@ -446,3 +446,24 @@ update land | |||
446 | where AuthbuyerID not like '%-%'; | 446 | where AuthbuyerID not like '%-%'; |
447 | 447 | ||
448 | COMMIT; | 448 | COMMIT; |
449 | |||
450 | :VERSION 19 | ||
451 | BEGIN; | ||
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'; | ||
464 | ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT ''; | ||
465 | ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0'; | ||
466 | ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; | ||
467 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; | ||
468 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; | ||
469 | COMMIT; \ No newline at end of file | ||