Index: lams_common/db/sql/insert_types_data.sql =================================================================== diff -u -r51fb2a37254f24bb2a805d4ffd54482c779f43fa -r1f2071f2e0a656da1355f906820fd74ce1d04f10 --- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 51fb2a37254f24bb2a805d4ffd54482c779f43fa) +++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 1f2071f2e0a656da1355f906820fd74ce1d04f10) @@ -284,39 +284,32 @@ -- Default TimeZones +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+14'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+13'); 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+9'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+8'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+7'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+6'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+5'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT+4'); 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'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-1'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-2'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-3'); 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-8'); 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-10'); 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'); +INSERT INTO lams_timezone (timezone_id) VALUES ('Etc/GMT-12'); -- which current tool supports the old 1.0.x tools? INSERT INTO lams_tool_import_support VALUES (1, 'lafrum11', 'messageboard');