-- copy everything from CREATE TABLE downward and use the sql feature with Mysql to create and insert all records listed below into the table.
-- Table structure for table `TimeZone` --
CREATE TABLE `TimeZone` ( `timezone_id` int(11) NOT NULL, `timezone_GMT_Diff` varchar(11) NOT NULL, `timezone_Zone` text NOT NULL, `timezone_Area` text NOT NULL, `timezone_default_name` text NOT NULL, `timezone_flag` text, `timezone_note` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- -- Dumping data for table `TimeZone` --
INSERT INTO `TimeZone` (`timezone_id`, `timezone_GMT_Diff`, `timezone_Zone`, `timezone_Area`, `timezone_default_name`, `timezone_flag`, `timezone_note`) VALUES (1, '-11:00', 'Pacific', 'Midway Island ', 'Pacific/Midway', NULL, NULL), (2, '-11:00', 'Pacific', 'Samoa ', 'Pacific/Samoa', NULL, NULL), (3, '-10:00', 'Pacific', 'Hawaii ', 'Pacific/Honolulu', NULL, NULL), (4, '-9:00', 'US', 'Alaska ', 'US/Alaska', NULL, NULL), (5, '-8:00', 'US', 'Pacific Time ', 'America/Los_Angeles', NULL, NULL), (6, '8:00', 'America', 'Tijuana', 'America/Tijuana', NULL, NULL), (7, '-7:00', 'US', 'Arizona', 'US/Arizona', NULL, NULL), (8, '-7:00', 'America', 'Chihuahua', 'America/Chihuahua', NULL, NULL), (9, '-7:00', 'America', 'La Paz ', 'America/Chihuahua', NULL, NULL), (10, '-7:00', 'America', 'Mazatlan', 'America/Mazatlan', NULL, NULL), (11, '-7:00', 'US & Canada', 'Mountain Time ', 'US/Mountain', NULL, NULL), (12, '-6:00', 'America', 'Central America', 'America/Managua', NULL, NULL), (13, '-6:00', 'US & Canada', 'Central Time ', 'US/Central', NULL, NULL), (14, '-6:00', 'America', 'Guadalajara', 'America/Mexico_City', NULL, NULL), (15, '-6:00', 'Amewrica', 'Mexico City ', 'America/Mexico_City', NULL, NULL), (16, '-6:00', 'America', 'Monterrey', 'America/Monterrey', NULL, NULL), (17, '-6:00', 'Canada', 'Saskatchewan', 'Canada/Saskatchewan', NULL, NULL), (18, '-5:00', 'America', 'Bogota ', 'America/Bogota', NULL, NULL), (19, '-5:00', 'US & Canada', 'Eastern Time ', 'US/Eastern', NULL, NULL), (20, '-5:00', 'US', 'Indiana (East)', 'US/East-Indiana', NULL, NULL), (21, '-5:00', 'America', 'Lima ', 'America/Lima', NULL, NULL), (22, '-5:00', 'America', 'Quito ', 'America/Bogota', NULL, NULL), (23, '-4:30', 'America', 'Caracas ', 'America/Caracas', NULL, NULL), (24, '-4:00', 'Canada', 'Atlantic Time (Canada) ', 'Canada/Atlantic', NULL, NULL), (25, '-4:00', 'America', 'La Paz ', 'America/La_Paz', NULL, NULL), (26, '-4:00', 'America', 'Santiago', 'America/Santiago', NULL, NULL), (27, '-3:30', 'Canada', 'Newfoundland', 'Canada/Newfoundland', NULL, NULL), (28, '-3:00', 'America', 'Brasilia', 'America/Sao_Paulo', NULL, NULL), (29, '-3:00', 'America', 'Buenos Aires ', 'America/Argentina/Buenos_Aires', NULL, NULL), (30, '-3:00', 'America', 'Georgetown ', 'America/Argentina/Buenos_Aires', NULL, NULL), (31, '-3:00', 'America', 'Greenland', 'America/Godthab', NULL, NULL), (32, '-2:00', 'America', 'Mid-Atlantic', 'America/Noronha', NULL, NULL), (33, '-1:00', 'Atlantic', 'Azores ', 'Atlantic/Azores', NULL, NULL), (34, '-1:00', 'Atlantic', 'Cape Verde Is.', 'Atlantic/Cape_Verde', NULL, NULL), (35, '0:00', 'Africa', 'Casablanca ', 'Africa/Casablanca', NULL, NULL), (36, '0:00', 'Europe', 'Edinburgh', 'Europe/London', NULL, NULL), (37, '0:00', 'GMT', 'Greenwich Mean Time : Dublin ', 'Etc/Greenwich', NULL, NULL), (38, '0:00', 'Europe', 'Lisbon ', 'Europe/Lisbon', NULL, NULL), (39, '0:00', 'Europe', 'London', 'Europe/London', NULL, NULL), (40, '0:00', 'Africa', 'Monrovia ', 'Africa/Monrovia', NULL, NULL), (41, '0:00', 'UTC', 'UTC ', 'UTC', NULL, NULL), (42, '+1:00', 'Europe', 'Amsterdam ', 'Europe/Amsterdam', NULL, NULL), (43, '+1:00', 'Europe', 'Belgrade', 'Europe/Belgrade', NULL, NULL), (44, '+1:00', 'Europe', 'Berlin ', 'Europe/Berlin', NULL, NULL), (45, '+1:00', 'Europe', 'Bern ', 'Europe/Berlin', NULL, NULL), (46, '+1:00', 'Europe', 'Bratislava ', 'Europe/Bratislava', NULL, NULL), (47, '+1:00', 'Europe', 'Brussels ', 'Europe/Brussels', NULL, NULL), (48, '+1:00', 'Europe', 'Budapest ', 'Europe/Budapest', NULL, NULL), (49, '+1:00', 'Europe', 'Copenhagen', 'Europe/Copenhagen', NULL, NULL), (50, '+1:00', 'Europe', 'Ljubljana ', 'Europe/Ljubljana', NULL, NULL), (51, '+1:00', 'Europe', 'Madrid ', 'Europe/Madrid', NULL, NULL), (52, '+1:00', 'Europe', 'Paris ', 'Europe/Paris', NULL, NULL), (53, '+1:00', 'Europe', 'Prague ', 'Europe/Prague', NULL, NULL), (54, '+1:00', 'Europe', 'Rome ', 'Europe/Rome', NULL, NULL), (55, '+1:00', 'Europe', 'Sarajevo', 'Europe/Sarajevo', NULL, NULL), (56, '+1:00', 'Europe', 'Skopje ', 'Europe/Skopje', NULL, NULL), (57, '+1:00', 'Europe', 'Stockholm ', 'Europe/Stockholm', NULL, NULL), (58, '+1:00', 'Europe', 'Vienna ', 'Europe/Vienna', NULL, NULL), (59, '+1:00', 'Europe', 'Warsaw ', 'Europe/Warsaw', NULL, NULL), (60, '+1:00', 'Europe', 'West Central Africa ', 'Africa/Lagos', NULL, NULL), (61, '+1:00', 'Europe', 'Zagreb', 'Europe/Zagreb', NULL, NULL), (62, '+2:00', 'Europe', 'Athens', 'Europe/Athens', NULL, NULL), (63, '+2:00', 'Europe', 'Bucharest', 'Europe/Bucharest', NULL, NULL), (64, '+2:00', 'Africa', 'Cairo ', 'Africa/Cairo', NULL, NULL), (65, '+2:00', 'Africa', 'Harare ', 'Africa/Harare', NULL, NULL), (66, '+2:00', 'Europe', 'Helsinki ', 'Europe/Helsinki', NULL, NULL), (67, '+2:00', 'Europe', 'Istanbul ', 'Europe/Istanbul', NULL, NULL), (68, '+2:00', 'Asia', 'Jerusalem ', 'Asia/Jerusalem', NULL, NULL), (69, '+2:00', 'Europe', 'Kyiv ', 'Europe/Helsinki', NULL, NULL), (70, '+2:00', 'Africa', 'Pretoria ', 'Africa/Johannesburg', NULL, NULL), (71, '+2:00', 'Europe', 'Riga ', 'Europe/Riga', NULL, NULL), (72, '+2:00', 'Europe', 'Sofia ', 'Europe/Sofia', NULL, NULL), (73, '+2:00', 'Europe', 'Tallinn', 'Europe/Tallinn', NULL, NULL), (74, '+2:00', 'Europe', 'Vilnius ', 'Europe/Vilnius', NULL, NULL), (75, '+3:00', 'Asia', 'Baghdad ', 'Asia/Baghdad', NULL, NULL), (76, '+3:00', 'Asia', 'Kuwait', 'Asia/Kuwait', NULL, NULL), (77, '+3:00', 'Europe', 'Minsk ', 'Europe/Minsk', NULL, NULL), (78, '+3:00', 'Africa', 'Nairobi', 'Africa/Nairobi', NULL, NULL), (79, '+3:00', 'Asia', 'Riyadh', 'Asia/Riyadh', NULL, NULL), (80, '+3:00', 'Europe', 'Volgograd ', 'Europe/Volgograd', NULL, NULL), (81, '+3:30', 'Asia', 'Tehran ', 'Asia/Tehran', NULL, NULL), (82, '+4:00', 'Asia', 'Abu Dhabi ', 'Asia/Muscat', NULL, NULL), (83, '+4:00', 'Asia', 'Baku ', 'Asia/Baku', NULL, NULL), (84, '+4:00', 'Europe', 'Moscow ', 'Europe/Moscow', NULL, NULL), (85, '+4:00', 'Asia', 'Muscat', 'Asia/Muscat', NULL, NULL), (86, '+4:00', 'Europe', 'St. Petersburg', 'Europe/Moscow', NULL, NULL), (87, '+4:00', 'Asia', 'Tbilisi ', 'Asia/Tbilisi', NULL, NULL), (88, '+4:00', 'Asia', 'Yerevan ', 'Asia/Yerevan', NULL, NULL), (89, '+4:30', 'Asia', 'Kabul ', 'Asia/Kabul', NULL, NULL), (90, '+5:00', 'Asia', 'Islamabad', 'Asia/Karachi', NULL, NULL), (91, '+5:00', 'Asia', 'Karachi ', 'Asia/Karachi', NULL, NULL), (92, '+5:00', 'Asia', 'Tashkent ', 'Asia/Tashkent', NULL, NULL), (93, '+5:30', 'Asia', 'Chennai ', 'Asia/Calcutta', NULL, NULL), (94, '+5:30', 'Asia', 'Kolkata ', 'Asia/Kolkata', NULL, NULL), (95, '+5:30', 'Asia', 'Mumbai ', 'Asia/Calcutta', NULL, NULL), (96, '+5:30', 'Asia', 'New Delhi ', 'Asia/Calcutta', NULL, NULL), (97, '+5:30', 'Asia', 'Sri Jayawardenepura ', 'Asia/Calcutta', NULL, NULL), (98, '+5:45', 'Asia', 'Kathmandu ', 'Asia/Katmandu', NULL, NULL), (99, '+6:00', 'Asia', 'Almaty ', 'Asia/Almaty', NULL, NULL), (100, '+6:00', 'Asia', 'Astana', 'Asia/Dhaka', NULL, NULL), (101, '+6:00', 'Asia', 'Dhaka ', 'Asia/Dhaka', NULL, NULL), (102, '+6:00', 'Asia', 'Ekaterinburg ', 'Asia/Yekaterinburg', NULL, NULL), (103, '+6:30', 'Asia', 'Rangoon ', 'Asia/Rangoon', NULL, NULL), (104, '+7:00', 'Asia', 'Bangkok ', 'Asia/Bangkok', NULL, NULL), (105, '+7:00', 'Asia', 'Hanoi', 'Asia/Bangkok', NULL, NULL), (106, '+7:00', 'Asia', 'Jakarta ', 'Asia/Jakarta', NULL, NULL), (107, '+7:00', 'Asia', 'Novosibirsk ', 'Asia/Novosibirsk', NULL, NULL), (108, '+8:00', 'Asia', 'Beijing ', 'Asia/Hong_Kong', NULL, NULL), (109, '+8:00', 'Asia', 'Chongqing ', 'Asia/Chongqing', NULL, NULL), (110, '+8:00', 'Asia', 'Hong Kong ', 'Asia/Hong_Kong', NULL, NULL), (111, '+8:00', 'Asia', 'Krasnoyarsk', 'Asia/Krasnoyarsk', NULL, NULL), (112, '+8:00', 'Asia', 'Kuala Lumpur ', 'Asia/Kuala_Lumpur', NULL, NULL), (113, '+8:00', 'Australia', 'Perth ', 'Australia/Perth', NULL, NULL), (114, '+8:00', 'Asia', 'Singapore ', 'Asia/Singapore', NULL, NULL), (115, '+8:00', 'Asia', 'Taipei ', 'Asia/Taipei', NULL, NULL), (116, '+8:00', 'Asia', 'Ulaan Bataar ', 'Asia/Ulan_Bator', NULL, NULL), (117, '+8:00', 'Asia', 'Urumqi', 'Asia/Urumqi', NULL, NULL), (118, '+9:00', 'Asia', 'Irkutsk ', 'Asia/Irkutsk', NULL, NULL), (119, '+9:00', 'Asia', ' Osaka', 'Asia/Tokyo', NULL, NULL), (120, '+9:00', 'Asia', ' Sapporo ', 'Asia/Tokyo', NULL, NULL), (121, '+9:00', 'Asia', 'Seoul ', 'Asia/Seoul', NULL, NULL), (122, '+9:00', 'Asia', 'Tokyo', 'Asia/Tokyo', NULL, NULL), (123, '+9:30', 'Australia', 'Adelaide', 'Australia/Adelaide', NULL, NULL), (124, '+9:30', 'Australia', 'Darwin ', 'Australia/Darwin', NULL, NULL), (125, '+10:00', 'Australia', 'Brisbane ', 'Australia/Brisbane', NULL, NULL), (126, '+10:00', 'Australia', 'Canberra ', 'Australia/Canberra', NULL, NULL), (127, '+10:00', 'Pacific', 'Guam ', 'Pacific/Guam', NULL, NULL), (128, '+10:00', 'Australia', 'Hobart ', 'Australia/Hobart', NULL, NULL), (129, '+10:00', 'Australia', 'Melbourne ', 'Australia/Melbourne', NULL, NULL), (130, '+10:00', 'Pacific', 'Port Moresby ', 'Pacific/Port_Moresby', NULL, NULL), (131, '+10:00', 'Australia', 'Sydney ', 'Australia/Sydney', NULL, NULL), (132, '+10:00', 'Asia', 'Yakutsk ', 'Asia/Yakutsk', NULL, NULL), (133, '+11:00', 'Asia', 'Vladivostok ', 'Asia/Vladivostok', NULL, NULL), (134, '+12:00', 'Pacific', 'Auckland ', 'Pacific/Auckland', NULL, NULL), (135, '+12:00', 'Pacific', 'Fiji ', 'Pacific/Fiji', NULL, NULL), (136, '+12:00', 'Pacific/IDL', 'International Date Line West ', 'Pacific/Kwajalein', NULL, NULL), (137, '+12:00', 'Asia', 'Kamchatka ', 'Asia/Kamchatka', NULL, NULL), (138, '+12:00', 'Asia', 'Magadan', 'Asia/Magadan', NULL, NULL), (139, '+12:00', 'Asia', 'Marshall Is. ', 'Pacific/Fiji', NULL, NULL), (140, '+12:00', 'Asia', 'New Caledonia ', 'Asia/Magadan', NULL, NULL), (141, '+12:00', 'Asia', 'Solomon Is.', 'Asia/Magadan', NULL, NULL), (142, '+12:00', 'Pacific', 'Wellington ', 'Pacific/Auckland', NULL, NULL), (143, '+13:00', 'Pacific', 'Nuku-alofa ', 'Pacific/Tongatapu', NULL, NULL);
|