Table: TimeZone

Static table, do not change.

A static table that contains all known time zones of Scout.

ColumnName	DataType	Key	Not Null	Comment
TimeZoneID	INTEGER	PK	NN	Unique ID of time zone
Name	NVARCHAR(255)		NN	Zone name (e.g Berlin GMT+1, London GMT)
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	TimeZoneID

how to create

CREATE TABLE TimeZone( TimeZoneID INTEGER NOT NULL, Name NVARCHAR(255) NOT NULL, ReservedString1 NVARCHAR(255), ReservedString2 NVARCHAR(255), ReservedInt1 INTEGER, ReservedInt2 INTEGER, PRIMARY KEY (TimeZoneID));

How to initialize

INSERT INTO TimeZone (TimeZoneID, Name) VALUES(1,'America/Adak'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(2,'Asia/Aden'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(3,'Asia/Almaty'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(4,'Asia/Amman'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(5,'Europe/Amsterdam'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(6,'Asia/Anadyr'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(7,'America/Anchorage'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(8,'Europe/Andorra'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(9,'America/Anguilla'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(10,'America/Antigua'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(11,'Asia/Aqtau'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(12,'Asia/Aqtobe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(13,'America/Araguaina'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(14,'America/Aruba'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(15,'Asia/Ashgabat'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(16,'America/Asuncion'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(17,'Europe/Athens'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(18,'America/Atka'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(19,'Asia/Baghdad'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(20,'Asia/Bahrain'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(21,'Asia/Baku'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(22,'Asia/Bangkok'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(23,'America/Barbados'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(24,'Asia/Beirut'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(25,'America/Belem'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(26,'Europe/Belfast'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(27,'Europe/Belgrade'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(28,'America/Belize'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(29,'Europe/Berlin'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(30,'Asia/Bishkek'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(31,'America/Boa_Vista'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(32,'America/Bogota'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(33,'America/Boise'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(34,'Europe/Bratislava'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(35,'Asia/Brunei'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(36,'Europe/Brussels'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(37,'Europe/Bucharest'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(38,'Europe/Budapest'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(39,'America/Argentina/Buenos_Aires'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(40,'Asia/Calcutta'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(41,'America/Cambridge_Bay'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(42,'America/Cancun'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(43,'America/Caracas'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(44,'America/Argentina/Catamarca'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(45,'America/Cayenne'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(46,'America/Cayman'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(47,'America/Chicago'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(48,'America/Chihuahua'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(49,'Europe/Chisinau'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(50,'Asia/Choibalsan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(51,'Asia/Chongqing'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(52,'Asia/Chungking'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(53,'Asia/Colombo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(54,'Europe/Copenhagen'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(55,'America/Argentina/Cordoba'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(56,'America/Costa_Rica'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(57,'America/Cuiaba'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(58,'America/Curacao'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(59,'Asia/Dacca'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(60,'Asia/Damascus'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(61,'America/Danmarkshavn'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(62,'America/Dawson'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(63,'America/Dawson_Creek'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(64,'America/Denver'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(65,'America/Detroit'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(66,'Asia/Dhaka'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(67,'Asia/Dili'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(68,'America/Dominica'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(69,'Asia/Dubai'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(70,'Europe/Dublin'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(71,'Asia/Dushanbe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(72,'America/Edmonton'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(73,'America/Eirunepe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(74,'America/El_Salvador'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(75,'America/Ensenada'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(76,'America/Fort_Wayne'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(77,'America/Fortaleza'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(78,'Asia/Gaza'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(79,'Europe/Gibraltar'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(80,'America/Glace_Bay'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(81,'America/Godthab'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(82,'America/Goose_Bay'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(83,'America/Grand_Turk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(84,'America/Grenada'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(85,'America/Guadeloupe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(86,'America/Guatemala'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(87,'America/Guayaquil'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(88,'America/Guyana'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(89,'America/Halifax'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(90,'Asia/Harbin'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(91,'America/Havana'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(92,'Europe/Helsinki'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(93,'America/Hermosillo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(94,'Asia/Hong_Kong'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(95,'Asia/Hovd'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(96,'America/Indiana/Indianapolis'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(97,'America/Inuvik'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(98,'America/Iqaluit'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(99,'Asia/Irkutsk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(100,'Europe/Istanbul'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(101,'Asia/Jakarta'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(102,'America/Jamaica'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(103,'Asia/Jayapura'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(104,'Asia/Jerusalem'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(105,'America/Argentina/Jujuy'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(106,'America/Juneau'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(107,'Asia/Kabul'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(108,'Europe/Kaliningrad'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(109,'Asia/Kamchatka'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(110,'Asia/Karachi'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(111,'Asia/Kashgar'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(112,'Asia/Katmandu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(113,'Europe/Kiev'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(114,'America/Indiana/Knox'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(115,'America/Knox_IN'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(116,'Asia/Krasnoyarsk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(117,'Asia/Kuala_Lumpur'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(118,'Asia/Kuching'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(119,'Asia/Kuwait'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(120,'America/La_Paz'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(121,'America/Lima'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(122,'Europe/Lisbon'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(123,'Europe/Ljubljana'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(124,'Europe/London'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(125,'America/Los_Angeles'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(126,'America/Kentucky/Louisville'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(127,'Europe/Luxembourg'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(128,'Asia/Macao'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(129,'America/Maceio'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(130,'Europe/Madrid'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(131,'Asia/Magadan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(132,'Europe/Malta'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(133,'America/Managua'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(134,'America/Manaus'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(135,'Asia/Manila'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(136,'America/Indiana/Marengo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(137,'America/Martinique'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(138,'America/Mazatlan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(139,'America/Argentina/Mendoza'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(140,'America/Menominee'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(141,'America/Merida'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(142,'America/Mexico_City'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(143,'Europe/Minsk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(144,'America/Miquelon'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(145,'Europe/Monaco'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(146,'America/Monterrey'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(147,'America/Montevideo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(148,'America/Kentucky/Monticello'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(149,'America/Montreal'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(150,'America/Montserrat'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(151,'Europe/Moscow'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(152,'Asia/Muscat'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(153,'America/Nassau'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(154,'America/New_York'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(155,'Europe/Nicosia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(156,'America/Nipigon'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(157,'America/Nome'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(158,'America/Noronha'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(159,'America/North_Dakota/Center'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(160,'Asia/Novosibirsk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(161,'Asia/Omsk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(162,'Europe/Oslo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(163,'America/Panama'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(164,'America/Pangnirtung'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(165,'America/Paramaribo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(166,'Europe/Paris'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(167,'Asia/Phnom_Penh'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(168,'America/Phoenix'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(169,'Asia/Pontianak'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(170,'America/Port-au-Prince'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(171,'America/Port_of_Spain'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(172,'America/Porto_Acre'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(173,'America/Porto_Velho'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(174,'Europe/Prague'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(175,'America/Puerto_Rico'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(176,'Asia/Pyongyang'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(177,'Asia/Qatar'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(178,'America/Rainy_River'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(179,'Asia/Rangoon'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(180,'America/Rankin_Inlet'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(181,'America/Recife'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(182,'America/Regina'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(183,'Europe/Riga'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(184,'America/Rio_Branco'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(185,'Asia/Riyadh'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(186,'Europe/Rome'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(187,'America/Rosario'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(188,'Asia/Saigon'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(189,'Asia/Sakhalin'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(190,'Europe/Samara'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(191,'Asia/Samarkand'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(192,'Europe/San_Marino'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(193,'America/Santiago'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(194,'America/Santo_Domingo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(195,'America/Sao_Paulo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(196,'Europe/Sarajevo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(197,'America/Scoresbysund'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(198,'Asia/Seoul'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(199,'Asia/Shanghai'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(200,'America/Shiprock'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(201,'Europe/Simferopol'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(202,'Asia/Singapore'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(203,'Europe/Skopje'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(204,'Europe/Sofia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(205,'America/St_Johns'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(206,'America/St_Kitts'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(207,'America/St_Lucia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(208,'America/St_Thomas'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(209,'America/St_Vincent'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(210,'Europe/Stockholm'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(211,'America/Swift_Current'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(212,'Asia/Taipei'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(213,'Europe/Tallinn'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(214,'Asia/Tashkent'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(215,'Asia/Tbilisi'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(216,'America/Tegucigalpa'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(217,'Asia/Tehran'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(218,'Asia/Tel_Aviv'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(219,'Asia/Thimbu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(220,'Asia/Thimphu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(221,'America/Thule'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(222,'America/Thunder_Bay'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(223,'America/Tijuana'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(224,'Europe/Tirane'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(225,'Europe/Tiraspol'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(226,'Asia/Tokyo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(227,'America/Tortola'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(228,'Asia/Ujung_Pandang'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(229,'Asia/Ulaanbaatar'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(230,'Asia/Ulan_Bator'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(231,'Asia/Urumqi'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(232,'Europe/Uzhgorod'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(233,'Europe/Vaduz'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(234,'America/Vancouver'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(235,'Europe/Vatican'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(236,'America/Indiana/Vevay'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(237,'Europe/Vienna'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(238,'Asia/Vientiane'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(239,'Europe/Vilnius'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(240,'America/Virgin'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(241,'Asia/Vladivostok'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(242,'Europe/Warsaw'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(243,'America/Whitehorse'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(244,'America/Winnipeg'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(245,'America/Yakutat'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(246,'Asia/Yakutsk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(247,'Asia/Yekaterinburg'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(248,'America/Yellowknife'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(249,'Asia/Yerevan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(250,'Europe/Zagreb'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(251,'Europe/Zaporozhye'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(252,'Europe/Zurich'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(253,'Europe/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(254,'Europe/Volgograd'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(255,'Europe/Jersey'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(256,'Europe/Guernsey'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(257,'Europe/Isle_of_Man'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(258,'Europe/Mariehamn'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(259,'Europe/Podgorica'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(260,'US/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(261,'US/Pacific-New'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(262,'US/Alaska'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(263,'US/Aleutian'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(264,'US/Arizona'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(265,'US/Central'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(266,'US/East-Indiana'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(267,'US/Eastern'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(268,'US/Hawaii'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(269,'US/Indiana-Starke'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(270,'US/Michigan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(271,'US/Mountain'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(272,'US/Pacific'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(273,'US/Samoa'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(274,'America/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(275,'America/North_Dakota/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(276,'America/North_Dakota/New_Salem'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(277,'America/North_Dakota/Beulah'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(278,'America/Sitka'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(279,'America/Metlakatla'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(280,'America/Indiana/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(281,'America/Indiana/Vincennes'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(282,'America/Indiana/Tell_City'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(283,'America/Indiana/Petersburg'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(284,'America/Indiana/Winamac'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(285,'America/Kentucky/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(286,'America/Moncton'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(287,'America/Blanc-Sablon'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(288,'America/Toronto'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(289,'America/Atikokan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(290,'America/Resolute'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(291,'America/Matamoros'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(292,'America/Ojinaga'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(293,'America/Bahia_Banderas'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(294,'America/Santa_Isabel'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(295,'America/Argentina/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(296,'America/Argentina/Salta'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(297,'America/Argentina/Tucuman'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(298,'America/Argentina/La_Rioja'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(299,'America/Argentina/San_Juan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(300,'America/Argentina/San_Luis'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(301,'America/Argentina/Rio_Gallegos'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(302,'America/Argentina/Ushuaia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(303,'America/Argentina/ComodRivadavia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(304,'America/Santarem'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(305,'America/Bahia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(306,'America/Campo_Grande'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(307,'America/St_Barthelemy'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(308,'America/Marigot'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(309,'America/Lower_Princes'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(310,'America/Kralendijk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(311,'America/Buenos_Aires'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(312,'America/Catamarca'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(313,'America/Coral_Harbour'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(314,'America/Cordoba'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(315,'America/Indianapolis'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(316,'America/Jujuy'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(317,'America/Louisville'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(318,'America/Mendoza'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(319,'Asia/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(320,'Asia/Macau'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(321,'Asia/Nicosia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(322,'Asia/Kolkata'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(323,'Asia/Makassar'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(324,'Asia/Qyzylorda'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(325,'Asia/Oral'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(326,'Asia/Kathmandu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(327,'Asia/Hebron'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(328,'Asia/Ho_Chi_Minh'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(329,'Asia/Novokuznetsk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(330,'Asia/Riyadh87'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(331,'Asia/Riyadh88'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(332,'Asia/Riyadh89'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(333,'Asia/Istanbul'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(334,'Asia/Ashkhabad'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(335,'Africa/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(336,'Africa/Algiers'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(337,'Africa/Luanda'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(338,'Africa/Porto-Novo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(339,'Africa/Gaborone'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(340,'Africa/Ouagadougou'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(341,'Africa/Bujumbura'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(342,'Africa/Douala'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(343,'Africa/Bangui'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(344,'Africa/Ndjamena'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(345,'Africa/Kinshasa'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(346,'Africa/Lubumbashi'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(347,'Africa/Brazzaville'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(348,'Africa/Abidjan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(349,'Africa/Djibouti'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(350,'Africa/Cairo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(351,'Africa/Malabo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(352,'Africa/Asmara'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(353,'Africa/Addis_Ababa'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(354,'Africa/Libreville'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(355,'Africa/Banjul'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(356,'Africa/Accra'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(357,'Africa/Conakry'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(358,'Africa/Bissau'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(359,'Africa/Nairobi'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(360,'Africa/Maseru'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(361,'Africa/Monrovia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(362,'Africa/Tripoli'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(363,'Africa/Blantyre'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(364,'Africa/Bamako'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(365,'Africa/Nouakchott'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(366,'Africa/Casablanca'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(367,'Africa/El_Aaiun'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(368,'Africa/Maputo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(369,'Africa/Windhoek'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(370,'Africa/Niamey'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(371,'Africa/Lagos'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(372,'Africa/Kigali'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(373,'Africa/Sao_Tome'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(374,'Africa/Dakar'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(375,'Africa/Freetown'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(376,'Africa/Mogadishu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(377,'Africa/Johannesburg'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(378,'Africa/Khartoum'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(379,'Africa/Juba'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(380,'Africa/Mbabane'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(381,'Africa/Dar_es_Salaam'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(382,'Africa/Lome'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(383,'Africa/Tunis'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(384,'Africa/Kampala'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(385,'Africa/Lusaka'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(386,'Africa/Harare'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(387,'Africa/Ceuta'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(388,'Africa/Asmera'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(389,'Africa/Timbuktu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(390,'Atlantic/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(391,'Atlantic/Cape_Verde'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(392,'Atlantic/St_Helena'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(393,'Atlantic/Faroe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(394,'Atlantic/Reykjavik'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(395,'Atlantic/Azores'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(396,'Atlantic/Madeira'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(397,'Atlantic/Canary'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(398,'Atlantic/Bermuda'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(399,'Atlantic/Stanley'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(400,'Atlantic/South_Georgia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(401,'Atlantic/Faeroe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(402,'Atlantic/Jan_Mayen'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(403,'Australia/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(404,'Australia/Darwin'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(405,'Australia/Perth'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(406,'Australia/Eucla'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(407,'Australia/Brisbane'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(408,'Australia/Lindeman'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(409,'Australia/Adelaide'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(410,'Australia/Hobart'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(411,'Australia/Currie'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(412,'Australia/Melbourne'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(413,'Australia/Sydney'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(414,'Australia/Broken_Hill'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(415,'Australia/Lord_Howe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(416,'Australia/ACT'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(417,'Australia/Canberra'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(418,'Australia/LHI'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(419,'Australia/NSW'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(420,'Australia/North'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(421,'Australia/Queensland'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(422,'Australia/South'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(423,'Australia/Tasmania'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(424,'Australia/Victoria'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(425,'Australia/West'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(426,'Australia/Yancowinna'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(427,'Indian/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(428,'Indian/Comoro'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(429,'Indian/Antananarivo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(430,'Indian/Mauritius'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(431,'Indian/Mayotte'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(432,'Indian/Reunion'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(433,'Indian/Mahe'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(434,'Indian/Kerguelen'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(435,'Indian/Chagos'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(436,'Indian/Maldives'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(437,'Indian/Christmas'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(438,'Indian/Cocos'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(439,'Pacific/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(440,'Pacific/Rarotonga'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(441,'Pacific/Fiji'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(442,'Pacific/Gambier'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(443,'Pacific/Marquesas'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(444,'Pacific/Tahiti'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(445,'Pacific/Guam'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(446,'Pacific/Tarawa'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(447,'Pacific/Enderbury'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(448,'Pacific/Kiritimati'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(449,'Pacific/Saipan'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(450,'Pacific/Majuro'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(451,'Pacific/Kwajalein'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(452,'Pacific/Chuuk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(453,'Pacific/Pohnpei'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(454,'Pacific/Kosrae'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(455,'Pacific/Nauru'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(456,'Pacific/Noumea'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(457,'Pacific/Auckland'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(458,'Pacific/Chatham'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(459,'Pacific/Niue'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(460,'Pacific/Norfolk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(461,'Pacific/Palau'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(462,'Pacific/Port_Moresby'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(463,'Pacific/Pitcairn'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(464,'Pacific/Pago_Pago'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(465,'Pacific/Apia'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(466,'Pacific/Guadalcanal'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(467,'Pacific/Fakaofo'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(468,'Pacific/Tongatapu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(469,'Pacific/Funafuti'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(470,'Pacific/Johnston'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(471,'Pacific/Midway'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(472,'Pacific/Wake'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(473,'Pacific/Efate'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(474,'Pacific/Wallis'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(475,'Pacific/Honolulu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(476,'Pacific/Easter'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(477,'Pacific/Galapagos'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(478,'Pacific/Samoa'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(479,'Pacific/Yap'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(480,'Pacific/Truk'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(481,'Pacific/Ponape'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(482,'Etc/'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(483,'Etc/GMT'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(484,'Etc/UTC'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(485,'Etc/UCT'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(486,'Etc/GMT-14'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(487,'Etc/GMT-13'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(488,'Etc/GMT-12'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(489,'Etc/GMT-11'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(490,'Etc/GMT-10'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(491,'Etc/GMT-9'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(492,'Etc/GMT-8'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(493,'Etc/GMT-7'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(494,'Etc/GMT-6'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(495,'Etc/GMT-5'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(496,'Etc/GMT-4'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(497,'Etc/GMT-3'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(498,'Etc/GMT-2'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(499,'Etc/GMT-1'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(500,'Etc/GMT+1'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(501,'Etc/GMT+2'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(502,'Etc/GMT+3'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(503,'Etc/GMT+4'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(504,'Etc/GMT+5'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(505,'Etc/GMT+6'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(506,'Etc/GMT+7'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(507,'Etc/GMT+8'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(508,'Etc/GMT+9'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(509,'Etc/GMT+10'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(510,'Etc/GMT+11'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(511,'Etc/GMT+12'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(512,'Etc/Universal'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(513,'Etc/Zulu'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(514,'Etc/Greenwich'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(515,'Etc/GMT-0'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(516,'Etc/GMT+0'); INSERT INTO TimeZone (TimeZoneID, Name) VALUES(517,'Etc/GMT0');