Fisheye: Tag ce763cdf18290083b22b6ad41a9c0cb386322e8d refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040001.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag ce763cdf18290083b22b6ad41a9c0cb386322e8d refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040003.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag ce763cdf18290083b22b6ad41a9c0cb386322e8d refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040005.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql =================================================================== diff -u -rcb6d628cd53fe3d51e4f67cbaff7390651a048da -rce763cdf18290083b22b6ad41a9c0cb386322e8d --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql (.../patch02040006.sql) (revision cb6d628cd53fe3d51e4f67cbaff7390651a048da) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql (.../patch02040006.sql) (revision ce763cdf18290083b22b6ad41a9c0cb386322e8d) @@ -6,86 +6,6 @@ alter table lams_lesson add column release_date DATETIME; alter table lams_lesson add index idx_release_date (release_date); --- LDEV-2564 Option in "Edit configuration settings" for not displaying the "All My Lesson" option in My Profile tab -insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('ShowAllMyLessonLink','true', 'config.show.all.my.lesson.link', 'config.header.features', 'BOOLEAN', 1); - --- LDEV-2544 Default Timezones -CREATE TABLE lams_timezone ( - id BIGINT(20) NOT NULL AUTO_INCREMENT - , timezone_id VARCHAR(255) NOT NULL - , server_timezone TINYINT DEFAULT 0 - , PRIMARY KEY (id) -)TYPE=InnoDB; - -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+12'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+11'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+10'); -INSERT INTO lams_timezone (timezone_id) VALUES ('US/Alaska'); -INSERT INTO lams_timezone (timezone_id) VALUES ('America/Vancouver'); -INSERT INTO lams_timezone (timezone_id) VALUES ('America/Denver'); -INSERT INTO lams_timezone (timezone_id) VALUES ('America/Chicago'); -INSERT INTO lams_timezone (timezone_id) VALUES ('America/Detroit'); -INSERT INTO lams_timezone (timezone_id) VALUES ('America/Halifax'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Canada/Newfoundland'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+3'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+2'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+1'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Europe/London'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Europe/Brussels'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Europe/Athens'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Europe/Moscow'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Asia/Tehran'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-4'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Asia/Kabul'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-5'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Asia/Calcutta'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Asia/Katmandu'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-6'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-7'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Australia/West'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-9'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Australia/Adelaide'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Australia/Sydney'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-11'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Pacific/Auckland'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Pacific/Tongatapu'); -INSERT INTO lams_timezone (timezone_id) VALUES ('Pacific/Kiritimati'); - -ALTER TABLE lams_user MODIFY COLUMN timezone VARCHAR(255); - -UPDATE lams_user SET timezone='Etc/GMT+12' WHERE timezone='0'; -UPDATE lams_user SET timezone='Etc/GMT+11' WHERE timezone='1'; -UPDATE lams_user SET timezone='Etc/GMT+10' WHERE timezone='2'; -UPDATE lams_user SET timezone='US/Alaska' WHERE timezone='3'; -UPDATE lams_user SET timezone='America/Vancouver' WHERE timezone='4'; -UPDATE lams_user SET timezone='America/Denver' WHERE timezone='5'; -UPDATE lams_user SET timezone='America/Chicago' WHERE timezone='6'; -UPDATE lams_user SET timezone='America/Detroit' WHERE timezone='7'; -UPDATE lams_user SET timezone='America/Halifax' WHERE timezone='8'; -UPDATE lams_user SET timezone='Canada/Newfoundland' WHERE timezone='9'; -UPDATE lams_user SET timezone='Etc/GMT+3' WHERE timezone='10'; -UPDATE lams_user SET timezone='Etc/GMT+2' WHERE timezone='11'; -UPDATE lams_user SET timezone='Etc/GMT+1' WHERE timezone='12'; -UPDATE lams_user SET timezone='Europe/London' WHERE timezone='13'; -UPDATE lams_user SET timezone='Europe/Brussels' WHERE timezone='14'; -UPDATE lams_user SET timezone='Europe/Athens' WHERE timezone='15'; -UPDATE lams_user SET timezone='Europe/Moscow' WHERE timezone='16'; -UPDATE lams_user SET timezone='Asia/Tehran' WHERE timezone='17'; -UPDATE lams_user SET timezone='Etc/GMT-4' WHERE timezone='18'; -UPDATE lams_user SET timezone='Asia/Kabul' WHERE timezone='19'; -UPDATE lams_user SET timezone='Etc/GMT-5' WHERE timezone='20'; -UPDATE lams_user SET timezone='Asia/Calcutta' WHERE timezone='21'; -UPDATE lams_user SET timezone='Asia/Katmandu' WHERE timezone='22'; -UPDATE lams_user SET timezone='Etc/GMT-6' WHERE timezone='23'; -UPDATE lams_user SET timezone='Etc/GMT-7' WHERE timezone='24'; -UPDATE lams_user SET timezone='Australia/West' WHERE timezone='25'; -UPDATE lams_user SET timezone='Etc/GMT-9' WHERE timezone='26'; -UPDATE lams_user SET timezone='Australia/Adelaide' WHERE timezone='27'; -UPDATE lams_user SET timezone='Australia/Sydney' WHERE timezone='28'; -UPDATE lams_user SET timezone='Etc/GMT-11' WHERE timezone='29'; -UPDATE lams_user SET timezone='Pacific/Auckland' WHERE timezone='30'; - -- LDEV-2550 DROP TABLE IF EXISTS lams_log_event;