timezones

CREATE TABLE `timezones` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`value` VARCHAR(155) NOT NULL COLLATE 'utf8_unicode_ci',
	`label` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci',
	PRIMARY KEY (`id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=2;


INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (1, 'Etc/GMT+12', '(GMT-12:00) International Date Line West');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (2, 'Pacific/Samoa', '(GMT-11:00) Midway Island, Samoa');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (3, 'Pacific/Honolulu', '(GMT-10:00) Hawaii');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (4, 'America/Anchorage', '(GMT-09:00) Alaska');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (5, 'America/Los_Angeles', '(GMT-08:00) Pacific Time US & Canada');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (6, 'America/Tijuana', '(GMT-08:00) Tijuana, Baja California');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (7, 'America/Denver', '(GMT-07:00) Mountain Time US & Canada');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (8, 'America/Chihuahua', '(GMT-07:00) Chihuahua, La Paz, Mazatlan');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (9, 'America/Phoenix', '(GMT-07:00) Arizona');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (10, 'America/Regina', '(GMT-06:00) Saskatchewan');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (11, 'America/Tegucigalpa', '(GMT-06:00) Central America');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (12, 'America/Chicago', '(GMT-06:00) Central Time US & Canada');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (13, 'America/Mexico_City', '(GMT-06:00) Guadalajara, Mexico City, Monterrey');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (14, 'America/New_York', '(GMT-05:00) Eastern Time US & Canada');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (15, 'America/Bogota', '(GMT-05:00) Bogota, Lima, Quito, Rio Branco');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (16, 'America/Indiana/Indianapolis', '(GMT-05:00) Indiana East');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (17, 'America/Caracas', '(GMT-04:00) Caracas');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (18, 'Canada/Atlantic', '(GMT-04:00) Atlantic Time Canada');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (19, 'America/Manaus', '(GMT-04:00) Manaus');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (20, 'America/Santiago', '(GMT-04:00) Santiago');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (21, 'America/La_Paz', '(GMT-04:00) La Paz');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (22, 'Canada/Newfoundland', '(GMT-03:30) Newfoundland');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (23, 'America/Argentina/Buenos_Aires', '(GMT-03:00) Buenos Aires');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (24, 'America/Sao_Paulo', '(GMT-03:00) Brasilia');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (25, 'America/Godthab', '(GMT-03:00) Greenland');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (26, 'America/Montevideo', '(GMT-03:00) Montevideo');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (27, 'America/Argentina/Buenos_Aires', '(GMT-03:00) Georgetown');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (28, 'Atlantic/South_Georgia', '(GMT-02:00) Mid-Atlantic');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (29, 'Atlantic/Azores', '(GMT-01:00) Azores');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (30, 'Atlantic/Cape_Verde', '(GMT-01:00) Cape Verde Is.');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (31, 'Europe/London', '(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (32, 'Atlantic/Reykjavik', '(GMT) Monrovia, Reykjavik');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (33, 'Africa/Casablanca', '(GMT) Casablanca');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (34, 'Europe/Belgrade', '(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (35, 'Europe/Sarajevo', '(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (36, 'Europe/Brussels', '(GMT+01:00) Brussels, Copenhagen, Madrid, Paris');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (37, 'Africa/Algiers', '(GMT+01:00) West Central Africa');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (38, 'Europe/Amsterdam', '(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (39, 'Africa/Cairo', '(GMT+02:00) Cairo');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (40, 'Europe/Helsinki', '(GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (41, 'Europe/Athens', '(GMT+02:00) Athens, Bucharest');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (42, 'Asia/Jerusalem', '(GMT+02:00) Jerusalem');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (43, 'Asia/Amman', '(GMT+02:00) Amman');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (44, 'Asia/Beirut', '(GMT+02:00) Beirut');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (45, 'Africa/Windhoek', '(GMT+02:00) Windhoek');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (46, 'Africa/Harare', '(GMT+02:00) Harare, Pretoria');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (47, 'Europe/Minsk', '(GMT+03:00) Minsk');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (48, 'Asia/Kuwait', '(GMT+03:00) Kuwait, Riyadh');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (49, 'Asia/Baghdad', '(GMT+03:00) Baghdad');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (50, 'Africa/Nairobi', '(GMT+03:00) Nairobi');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (51, 'Europe/Moscow', '(GMT+03:00) Moscow, St. Petersburg, Volgograd, Istanbul');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (52, 'Asia/Tehran', '(GMT+03:30) Tehran');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (53, 'Asia/Tbilisi', '(GMT+04:00) Tbilisi');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (54, 'Asia/Muscat', '(GMT+04:00) Abu Dhabi, Muscat');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (55, 'Asia/Baku', '(GMT+04:00) Baku');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (56, 'Asia/Yerevan', '(GMT+04:00) Yerevan');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (57, 'Asia/Yekaterinburg', '(GMT+05:00) Ekaterinburg');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (58, 'Asia/Karachi', '(GMT+05:00) Islamabad, Karachi');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (59, 'Asia/Tashkent', '(GMT+05:00) Tashkent');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (60, 'Asia/Kolkata', '(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (61, 'Asia/Colombo', '(GMT+05:30) Sri Jayawardenepura');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (62, 'Asia/Katmandu', '(GMT+05:45) Kathmandu');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (63, 'Asia/Dhaka', '(GMT+06:00) Astana, Dhaka');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (64, 'Asia/Rangoon', '(GMT+06:30) Yangon Rangoon');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (65, 'Asia/Novosibirsk', '(GMT+07:00) Almaty, Novosibirsk');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (66, 'Asia/Krasnoyarsk', '(GMT+07:00) Krasnoyarsk');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (67, 'Asia/Bangkok', '(GMT+07:00) Bangkok, Hanoi, Jakarta');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (68, 'Asia/Shanghai', '(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (69, 'Asia/Ulaanbaatar', '(GMT+08:00) Irkutsk, Ulaan Bataar');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (70, 'Asia/Kuala_Lumpur', '(GMT+08:00) Kuala Lumpur, Singapore');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (71, 'Asia/Taipei', '(GMT+08:00) Taipei');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (72, 'Australia/Perth', '(GMT+08:00) Perth');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (73, 'Asia/Seoul', '(GMT+09:00) Seoul');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (74, 'Asia/Tokyo', '(GMT+09:00) Osaka, Sapporo, Tokyo');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (75, 'Asia/Yakutsk', '(GMT+09:00) Yakutsk');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (76, 'Australia/Darwin', '(GMT+09:30) Darwin');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (77, 'Australia/Adelaide', '(GMT+09:30) Adelaide');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (78, 'Australia/Sydney', '(GMT+10:00) Canberra, Melbourne, Sydney');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (79, 'Australia/Brisbane', '(GMT+10:00) Brisbane');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (80, 'Australia/Hobart', '(GMT+10:00) Hobart');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (81, 'Asia/Vladivostok', '(GMT+10:00) Vladivostok');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (82, 'Pacific/Guam', '(GMT+10:00) Guam, Port Moresby');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (83, 'Asia/Magadan', '(GMT+11:00) Magadan, Solomon Is., New Caledonia');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (84, 'Pacific/Fiji', '(GMT+12:00) Fiji, Kamchatka, Marshall Is.');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (85, 'Pacific/Auckland', '(GMT+12:00) Auckland, Wellington');
INSERT INTO `timezones` (`id`, `value`, `label`) VALUES (86, 'Pacific/Tongatapu', '(GMT+13:00) Nuku\'alofa');