3 sqlite3 /opt/dbspace/.worldclock.db 'PRAGMA journal_mode = PERSIST;
4 CREATE TABLE city_table (idex int primary key, city varchar(128), country varchar(128), timezone varchar(20), dst_type int, dst_enabled int, selected int, sequence int, tz_path varchar(128));
5 INSERT INTO "city_table" VALUES(0,"IDS_WCL_BODY_CITYNAME_ABIDJAN","IDS_WCL_BODY_COTE_DIVOIRE","GMT+0",0,1,0,0,"Africa/Abidjan");
6 INSERT INTO "city_table" VALUES(1,"IDS_WCL_BODY_CITYNAME_ABUDHABI","IDS_WCL_BODY_UNITED_ARAB_EMIRATES","GMT+4",0,1,0,0,"Asia/Dubai");
7 INSERT INTO "city_table" VALUES(2,"IDS_WCL_BODY_CITYNAME_ACCRA","IDS_WCL_BODY_GHANA","GMT-10",0,1,0,0,"Africa/Accra");
8 INSERT INTO "city_table" VALUES(3,"IDS_WCL_BODY_CITYNAME_ADDIS_ABABA","IDS_WCL_BODY_ETHIOPIA","GMT+3",0,1,0,0,"Africa/Addis_Ababa");
9 INSERT INTO "city_table" VALUES(4,"IDS_WCL_BODY_CITYNAME_ADELAIDE","IDS_WCL_BODY_AUSTRALIA","GMT+9:30",0,1,0,0,"Australia/Adelaide");
10 INSERT INTO "city_table" VALUES(5,"IDS_WCL_BODY_CITYNAME_ALASKA","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-9",0,1,0,0,"America/Nome");
11 INSERT INTO "city_table" VALUES(6,"IDS_WCL_BODY_CITYNAME_ALGIERS","IDS_WCL_BODY_ALGERIA","GMT+1",0,1,0,0,"Africa/Algiers");
12 INSERT INTO "city_table" VALUES(7,"IDS_WCL_BODY_CITYNAME_ALMATY","IDS_WCL_BODY_KAZAKHSTAN","GMT+6",0,1,0,0,"Asia/Almaty");
13 INSERT INTO "city_table" VALUES(8,"IDS_WCL_BODY_CITYNAME_AMBON","IDS_WCL_BODY_INDONESIA","GMT+1",0,1,0,0,"Asia/Jayapura");
14 INSERT INTO "city_table" VALUES(9,"IDS_WCL_BODY_CITYNAME_AMMAN","IDS_WCL_BODY_JORDAN","GMT+2",0,1,0,0,"Asia/Amman");
15 INSERT INTO "city_table" VALUES(10,"IDS_WCL_BODY_CITYNAME_AMSTERDAME","IDS_WCL_BODY_NETHERLANDS","GMT+1",0,1,0,0,"Europe/Amsterdam");
16 INSERT INTO "city_table" VALUES(11,"IDS_WCL_BODY_CITYNAME_ANADYR","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Anadyr");
17 INSERT INTO "city_table" VALUES(12,"IDS_WCL_BODY_CITYNAME_ANCHORAGE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-9",0,1,0,0,"America/Anchorage");
18 INSERT INTO "city_table" VALUES(13,"IDS_WCL_BODY_CITYNAME_ANKARA","IDS_WCL_BODY_TURKEY","GMT+2",0,1,0,0,"Asia/Istanbul");
19 INSERT INTO "city_table" VALUES(14,"IDS_WCL_BODY_CITYNAME_ANTANANARIVO","IDS_WCL_BODY_MADAGASCAR","GMT+3",0,1,0,0,"Indian/Antananarivo");
20 INSERT INTO "city_table" VALUES(15,"IDS_WCL_BODY_CITYNAME_ASHGABAT","IDS_WCL_BODY_TURKMENISTAN","GMT+5",0,1,0,0,"Asia/Ashgabat");
21 INSERT INTO "city_table" VALUES(16,"IDS_WCL_BODY_CITYNAME_ASMARA","IDS_WCL_BODY_ERITREA","GMT+3",0,1,0,0,"Africa/Asmara");
22 INSERT INTO "city_table" VALUES(17,"IDS_WCL_BODY_CITYNAME_ASTANA","IDS_WCL_BODY_KAZAKHSTAN","GMT+6",0,1,0,0,"Asia/Almaty");
23 INSERT INTO "city_table" VALUES(18,"IDS_WCL_BODY_CITYNAME_ASUNCION","IDS_WCL_BODY_PARAGUAY","GMT-4",0,1,0,0,"America/Asuncion");
24 INSERT INTO "city_table" VALUES(19,"IDS_WCL_BODY_CITYNAME_ATHENS","IDS_WCL_BODY_GREECE","GMT+2",0,1,0,0,"Europe/Athens");
25 INSERT INTO "city_table" VALUES(20,"IDS_WCL_BODY_CITYNAME_AUCKLAND","IDS_WCL_BODY_NEW_ZEALAND","GMT+12",0,1,0,0,"Pacific/Auckland");
26 INSERT INTO "city_table" VALUES(21,"IDS_WCL_BODY_CITYNAME_AUSTIN","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
27 INSERT INTO "city_table" VALUES(22,"IDS_WCL_BODY_CITYNAME_AZORES","IDS_WCL_BODY_PORTUGAL","GMT-1",0,1,0,0,"Atlantic/Azores");
28 INSERT INTO "city_table" VALUES(23,"IDS_WCL_BODY_CITYNAME_BAGHDAD","IDS_WCL_BODY_IRAQ","GMT+3",0,1,0,0,"Asia/Baghdad");
29 INSERT INTO "city_table" VALUES(24,"IDS_WCL_BODY_CITYNAME_BAKU","IDS_WCL_BODY_AZERBAIJAN","GMT+4",0,1,0,0,"Asia/Baku");
30 INSERT INTO "city_table" VALUES(25,"IDS_WCL_BODY_CITYNAME_BALTIMORE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
31 INSERT INTO "city_table" VALUES(26,"IDS_WCL_BODY_CITYNAME_BAMAKO","IDS_WCL_BODY_MALI","GMT+0",0,1,0,0,"Africa/Bamako");
32 INSERT INTO "city_table" VALUES(27,"IDS_WCL_BODY_CITYNAME_BANGKOK","IDS_WCL_BODY_THAILAND","GMT+7",0,1,0,0,"Asia/Bangkok");
33 INSERT INTO "city_table" VALUES(28,"IDS_WCL_BODY_CITYNAME_BANGUI","IDS_WCL_BODY_CENTRAL_AFRICAN_REPUBLIC","GMT+1",0,1,0,0,"Africa/Bangui");
34 INSERT INTO "city_table" VALUES(29,"IDS_WCL_BODY_CITYNAME_BARCELONA","IDS_WCL_BODY_SPAIN","GMT+2",0,1,0,0,"Europe/Madrid");
35 INSERT INTO "city_table" VALUES(30,"IDS_WCL_BODY_CITYNAME_BARI","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
36 INSERT INTO "city_table" VALUES(31,"IDS_WCL_BODY_CITYNAME_BASSE_TERRE","IDS_WCL_BODY_GUADELOUPE","GMT-4",0,1,0,0,"America/Guadeloupe");
37 INSERT INTO "city_table" VALUES(32,"IDS_WCL_BODY_CITYNAME_BEIJING","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
38 INSERT INTO "city_table" VALUES(33,"IDS_WCL_BODY_CITYNAME_BEIRUT","IDS_WCL_BODY_LEBANON","GMT+2",0,1,0,0,"Asia/Beirut");
39 INSERT INTO "city_table" VALUES(34,"IDS_WCL_BODY_CITYNAME_BELGRADE","IDS_WCL_BODY_SERBIA","GMT+1",0,1,0,0,"Europe/Belgrade");
40 INSERT INTO "city_table" VALUES(35,"IDS_WCL_BODY_CITYNAME_BELIZE_CITY","IDS_WCL_BODY_BELIZE","GMT-6",0,1,0,0,"America/Belize");
41 INSERT INTO "city_table" VALUES(36,"IDS_WCL_BODY_CITYNAME_BERLIN","IDS_WCL_BODY_GERMANY","GMT+1",0,1,0,0,"Europe/Berlin");
42 INSERT INTO "city_table" VALUES(37,"IDS_WCL_BODY_CITYNAME_BERN","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Zurich");
43 INSERT INTO "city_table" VALUES(38,"IDS_WCL_BODY_CITYNAME_BISHKEK","IDS_WCL_BODY_KYRGYZSTAN","GMT+6",0,1,0,0,"Asia/Bishkek");
44 INSERT INTO "city_table" VALUES(39,"IDS_WCL_BODY_CITYNAME_GUINEA_BISSAU","IDS_WCL_BODY_CITYNAME_GUINEA_BISSAU","GMT+0",0,1,0,0,"Africa/Bissau");
45 INSERT INTO "city_table" VALUES(40,"IDS_WCL_BODY_CITYNAME_BOGOTA","IDS_WCL_BODY_COLOMBIA","GMT-5",0,1,0,0,"America/Bogota");
46 INSERT INTO "city_table" VALUES(41,"IDS_WCL_BODY_CITYNAME_BOLOGNA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
47 INSERT INTO "city_table" VALUES(42,"IDS_WCL_BODY_BOSTON","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
48 INSERT INTO "city_table" VALUES(43,"IDS_WCL_BODY_CITYNAME_BRASILIA","IDS_WCL_BODY_BRAZIL","GMT-3",0,1,0,0,"America/Sao_Paulo");
49 INSERT INTO "city_table" VALUES(44,"IDS_WCL_BODY_CITYNAME_BRATISLAVA","IDS_WCL_BODY_SLOVAKIA","GMT+2",0,1,0,0,"Europe/Bratislava");
50 INSERT INTO "city_table" VALUES(45,"IDS_WCL_BODY_CITYNAME_BRIDGETOWN","IDS_WCL_BODY_BARBADOS","GMT-4",0,1,0,0,"America/Barbados");
51 INSERT INTO "city_table" VALUES(46,"IDS_WCL_BODY_CITYNAME_BRISBANE","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Brisbane");
52 INSERT INTO "city_table" VALUES(47,"IDS_WCL_BODY_CITYNAME_BRUSSELS","IDS_WCL_BODY_BELGIUM","GMT+1",0,1,0,0,"Europe/Brussels");
53 INSERT INTO "city_table" VALUES(48,"IDS_WCL_BODY_CITYNAME_BUCHAREST","IDS_WCL_BODY_ROMANIA","GMT+3",0,1,0,0,"Europe/Bucharest");
54 INSERT INTO "city_table" VALUES(49,"IDS_WCL_BODY_CITYNAME_BUDAPEST","IDS_WCL_BODY_HUNGARY_M_COUNTRY","GMT+1",0,1,0,0,"Europe/Budapest");
55 INSERT INTO "city_table" VALUES(50,"IDS_WCL_BODY_CITYNAME_BUENOSAIRES","IDS_WCL_BODY_ARGENTINA","GMT-3",0,1,0,0,"America/Argentina/Buenos_Aires");
56 INSERT INTO "city_table" VALUES(51,"IDS_WCL_BODY_CITYNAME_CAIRO","IDS_WCL_BODY_EGYPT","GMT+2",0,1,0,0,"Africa/Cairo");
57 INSERT INTO "city_table" VALUES(52,"IDS_WCL_BODY_CITYNAME_CALGARY","IDS_WCL_BODY_CANADA","GMT-7",0,1,0,0,"MST7MDT");
58 INSERT INTO "city_table" VALUES(53,"IDS_WCL_BODY_CITYNAME_CANARY_ISLANDS","IDS_WCL_BODY_SPAIN","GMT+0",0,1,0,0,"Atlantic/Canary");
59 INSERT INTO "city_table" VALUES(54,"IDS_WCL_BODY_CITYNAME_CANBERRA","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Canberra");
60 INSERT INTO "city_table" VALUES(55,"IDS_WCL_BODY_CITYNAME_CANTON","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
61 INSERT INTO "city_table" VALUES(56,"IDS_WCL_BODY_CITYNAME_CAPE_TOWN","IDS_WCL_BODY_REPUBLIC_OF_SOUTH_AFRICA","GMT+2",0,1,0,0,"Africa/Johannesburg");
62 INSERT INTO "city_table" VALUES(57,"IDS_WCL_BODY_CITYNAME_CARACAS","IDS_WCL_BODY_VENEZUELA","GMT-4:30",0,1,0,0,"America/Caracas");
63 INSERT INTO "city_table" VALUES(58,"IDS_WCL_BODY_CITYNAME_CARDIFF","IDS_WCL_BODY_WALES_M_COUNTRYNAME","GMT+0",0,1,0,0,"Europe/London");
64 INSERT INTO "city_table" VALUES(59,"IDS_WCL_BODY_CITYNAME_CASABLANCA","IDS_WCL_BODY_MOROCCO","GMT+0",0,1,0,0,"Africa/Casablanca");
65 INSERT INTO "city_table" VALUES(60,"IDS_WCL_BODY_CITYNAME_CATANZARO","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
66 INSERT INTO "city_table" VALUES(61,"IDS_WCL_BODY_CITYNAME_CAYENNE","IDS_WCL_BODY_FRENCH_GUIANA","GMT-3",0,1,0,0,"America/Cayenne");
67 INSERT INTO "city_table" VALUES(62,"IDS_WCL_BODY_CITYNAME_CHARLOTTE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
68 INSERT INTO "city_table" VALUES(63,"IDS_WCL_BODY_CITYNAME_CHARLOTTE_AMALIE","IDS_WCL_BODY_UNITED_STATES_VIRGIN_ISLANDS_M_COUNTRYNAME","GMT-5:30",0,1,0,0,"America/St_Thomas");
69 INSERT INTO "city_table" VALUES(64,"IDS_WCL_BODY_CITYNAME_CHELYABINSK","IDS_WCL_BODY_RUSSIA","GMT+6",0,1,0,0,"Asia/Yekaterinburg");
70 INSERT INTO "city_table" VALUES(65,"IDS_WCL_BODY_CITYNAME_CHENNAI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
71 INSERT INTO "city_table" VALUES(66,"IDS_WCL_BODY_CITYNAME_CHICAGO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"America/Chicago");
72 INSERT INTO "city_table" VALUES(67,"IDS_WCL_BODY_CITYNAME_CHISINAU","IDS_WCL_BODY_MOLDOVA","GMT+2",0,1,0,0,"Europe/Chisinau");
73 INSERT INTO "city_table" VALUES(68,"IDS_WCL_BODY_CITYNAME_CHITA","IDS_WCL_BODY_RUSSIA","GMT+10",0,1,0,0,"Asia/Yakutsk");
74 INSERT INTO "city_table" VALUES(69,"IDS_WCL_BODY_CITYNAME_CLEVELAND","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
75 INSERT INTO "city_table" VALUES(70,"IDS_WCL_BODY_CITYNAME_COLOMBO","IDS_WCL_BODY_SRI_LANKA","GMT+5:30",0,1,0,0,"Asia/Colombo");
76 INSERT INTO "city_table" VALUES(71,"IDS_WCL_BODY_CITYNAME_COLUMBUS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
77 INSERT INTO "city_table" VALUES(72,"IDS_WCL_BODY_CITYNAME_CONAKRY","IDS_WCL_BODY_GUINEA","GMT+1",0,1,0,0,"Africa/Conakry");
78 INSERT INTO "city_table" VALUES(73,"IDS_WCL_BODY_CITYNAME_COPENHAGEN","IDS_WCL_BODY_DENMARK","GMT+1",0,1,0,0,"Europe/Copenhagen");
79 INSERT INTO "city_table" VALUES(74,"IDS_WCL_BODY_CITYNAME_CORK","IDS_WCL_BODY_IRELAND","GMT+0",0,1,0,0,"Europe/Dublin");
80 INSERT INTO "city_table" VALUES(75,"IDS_WCL_BODY_CITYNAME_CROTONE","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
81 INSERT INTO "city_table" VALUES(76,"IDS_WCL_BODY_CITYNAME_DAKAR","IDS_WCL_BODY_SENEGAL","GMT+0",0,1,0,0,"Africa/Dakar");
82 INSERT INTO "city_table" VALUES(77,"IDS_WCL_BODY_CITYNAME_DALLAS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
83 INSERT INTO "city_table" VALUES(78,"IDS_WCL_BODY_CITYNAME_DAMASCUS","IDS_WCL_BODY_SYRIA","GMT+2",0,1,0,0,"Asia/Damascus");
84 INSERT INTO "city_table" VALUES(79,"IDS_WCL_BODY_CITYNAME_DAR_ES_SALAAM","IDS_WCL_BODY_TANZANIA","GMT+3",0,1,0,0,"Africa/Dar_es_Salaam");
85 INSERT INTO "city_table" VALUES(80,"IDS_WCL_BODY_CITYNAME_DARWIN","IDS_WCL_BODY_AUSTRALIA","GMT+9:30",0,1,0,0,"Australia/Darwin");
86 INSERT INTO "city_table" VALUES(81,"IDS_WCL_BODY_CITYNAME_DELHI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
87 INSERT INTO "city_table" VALUES(82,"IDS_WCL_BODY_CITYNAME_DENPASAR","IDS_WCL_BODY_INDONESIA","GMT+8",0,1,0,0,"Asia/Makassar");
88 INSERT INTO "city_table" VALUES(83,"IDS_WCL_BODY_CITYNAME_DENVER","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"America/Denver");
89 INSERT INTO "city_table" VALUES(84,"IDS_WCL_BODY_CITYNAME_DETROIT","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"America/Detroit");
90 INSERT INTO "city_table" VALUES(85,"IDS_WCL_BODY_CITYNAME_DHAKA","IDS_WCL_BODY_BANGLADESH","GMT+6",0,1,0,0,"Asia/Dhaka");
91 INSERT INTO "city_table" VALUES(86,"IDS_WCL_BODY_CITYNAME_DIEGO_GARCIA","IDS_WCL_BODY_UNITED_KINGDOM","GMT+5",0,1,0,0,"Indian/Chagos");
92 INSERT INTO "city_table" VALUES(87,"IDS_WCL_BODY_CITYNAME_DJIBOUTI","IDS_WCL_BODY_DJIBOUTI","GMT+3",0,1,0,0,"Africa/Djibouti");
93 INSERT INTO "city_table" VALUES(88,"IDS_WCL_BODY_CITYNAME_DOHA","IDS_WCL_BODY_QATAR","GMT+3",0,1,0,0,"Asia/Qatar");
94 INSERT INTO "city_table" VALUES(89,"IDS_WCL_BODY_CITYNAME_DOUALA","IDS_WCL_BODY_CAMEROON","GMT+1",0,1,0,0,"Africa/Douala");
95 INSERT INTO "city_table" VALUES(90,"IDS_WCL_BODY_CITYNAME_DUBAI","IDS_WCL_BODY_UNITED_ARAB_EMIRATES","GMT+4",0,1,0,0,"Asia/Dubai");
96 INSERT INTO "city_table" VALUES(91,"IDS_WCL_BODY_CITYNAME_DUBLIN","IDS_WCL_BODY_IRELAND","GMT+0",0,1,0,0,"Europe/Dublin");
97 INSERT INTO "city_table" VALUES(92,"IDS_WCL_BODY_CITYNAME_DUSHANBE","IDS_WCL_BODY_TAJIKISTAN","GMT+5",0,1,0,0,"Asia/Dushanbe");
98 INSERT INTO "city_table" VALUES(93,"IDS_WCL_BODY_CITYNAME_EASTER_ISLAND","IDS_WCL_BODY_CHILE","GMT-6",0,1,0,0,"Pacific/Easter");
99 INSERT INTO "city_table" VALUES(94,"IDS_WCL_BODY_CITYNAME_EDINBURGH","IDS_WCL_BODY_SCOTLAND_M_COUNTRYNAME","GMT+0",0,1,0,0,"Europe/London");
100 INSERT INTO "city_table" VALUES(95,"IDS_WCL_BODY_CITYNAME_EL_PASO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"MST7MDT");
101 INSERT INTO "city_table" VALUES(96,"IDS_WCL_BODY_CITYNAME_FLORENCE","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
102 INSERT INTO "city_table" VALUES(97,"IDS_WCL_BODY_CITYNAME_FORT_DE_FRANCE","IDS_WCL_BODY_MARTINIQUE","GMT-4",0,1,0,0,"America/Martinique");
103 INSERT INTO "city_table" VALUES(98,"IDS_WCL_BODY_CITYNAME_FREETOWN","IDS_WCL_BODY_SIERRA_LEONE","GMT+0",0,1,0,0,"Africa/Freetown");
104 INSERT INTO "city_table" VALUES(99,"IDS_WCL_BODY_CITYNAME_GABORONE","IDS_WCL_BODY_BOTSWANA","GMT+2",0,1,0,0,"Africa/Gaborone");
105 INSERT INTO "city_table" VALUES(100,"IDS_WCL_BODY_CITYNAME_GALAPAGOS_ISLANDS","IDS_WCL_BODY_ECUADOR","GMT-7",0,1,0,0,"Pacific/Galapagos");
106 INSERT INTO "city_table" VALUES(101,"IDS_WCL_BODY_CITYNAME_GENEVA","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Paris");
107 INSERT INTO "city_table" VALUES(102,"IDS_WCL_BODY_CITYNAME_GENOA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
108 INSERT INTO "city_table" VALUES(103,"IDS_WCL_BODY_CITYNAME_GEORGETOWN","IDS_WCL_BODY_GUYANA","GMT-4",0,1,0,0,"America/Guyana");
109 INSERT INTO "city_table" VALUES(104,"IDS_WCL_BODY_CITYNAME_GRYTVIKEN","IDS_WCL_BODY_CITYNAME_SOUTH_GEORGIA","GMT-2",0,1,0,0,"Atlantic/South_Georgia");
110 INSERT INTO "city_table" VALUES(105,"IDS_WCL_BODY_CITYNAME_GUAM","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT+10",0,1,0,0,"Pacific/Guam");
111 INSERT INTO "city_table" VALUES(106,"IDS_WCL_BODY_GUATEMALA_CITY","IDS_WCL_BODY_GUATEMALA","GMT-6",0,1,0,0,"America/Guatemala");
112 INSERT INTO "city_table" VALUES(107,"IDS_WCL_BODY_CITYNAME_GUSTAVIA","IDS_WCL_BODY_CITYNAME_SAINT_BARTHELEMY","GMT-4",0,1,0,0,"America/Antigua");
113 INSERT INTO "city_table" VALUES(108,"IDS_WCL_BODY_CITYNAME_HALIFAX","IDS_WCL_BODY_CANADA","GMT-4",0,1,0,0,"America/Halifax");
114 INSERT INTO "city_table" VALUES(109,"IDS_WCL_BODY_CITYNAME_HAMBURG","IDS_WCL_BODY_GERMANY","GMT+1",0,1,0,0,"Europe/Berlin");
115 INSERT INTO "city_table" VALUES(110,"IDS_WCL_BODY_CITYNAME_HANOI","IDS_WCL_BODY_VIETNAM","GMT+7",0,1,0,0,"Asia/Ho_Chi_Minh");
116 INSERT INTO "city_table" VALUES(111,"IDS_WCL_BODY_CITYNAME_HARARE","IDS_WCL_BODY_ZIMBABWE","GMT+2",0,1,0,0,"Africa/Harare");
117 INSERT INTO "city_table" VALUES(112,"IDS_WCL_BODY_CITYNAME_HAVANA","IDS_WCL_BODY_CUBA","GMT-5",0,1,0,0,"America/Havana");
118 INSERT INTO "city_table" VALUES(113,"IDS_WCL_BODY_CITYNAME_HAWAII","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-10",0,1,0,0,"Pacific/Honolulu");
119 INSERT INTO "city_table" VALUES(114,"IDS_WCL_BODY_CITYNAME_HELSINKI","IDS_WCL_BODY_FINLAND","GMT+2",0,1,0,0,"Europe/Helsinki");
120 INSERT INTO "city_table" VALUES(115,"IDS_WCL_BODY_CITYNAME_HOBART","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Hobart");
121 INSERT INTO "city_table" VALUES(116,"IDS_WCL_BODY_CITYNAME_HONGKONG","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Hong_Kong");
122 INSERT INTO "city_table" VALUES(117,"IDS_WCL_BODY_CITYNAME_HONOLULU","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-10",0,1,0,0,"Pacific/Honolulu");
123 INSERT INTO "city_table" VALUES(118,"IDS_WCL_BODY_CITYNAME_HOUSTON","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
124 INSERT INTO "city_table" VALUES(119,"IDS_WCL_BODY_CITYNAME_HOVD","IDS_WCL_BODY_MONGOLIA","GMT+8",0,1,0,0,"Asia/Hovd");
125 INSERT INTO "city_table" VALUES(120,"IDS_WCL_BODY_CITYNAME_INDIANAPOLIS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"America/Indiana/Indianapolis");
126 INSERT INTO "city_table" VALUES(121,"IDS_WCL_BODY_CITYNAME_IRKUTSK","IDS_WCL_BODY_RUSSIA","GMT+9",0,1,0,0,"Asia/Irkutsk");
127 INSERT INTO "city_table" VALUES(122,"IDS_WCL_BODY_CITYNAME_ISLAMABAD","IDS_WCL_BODY_PAKISTAN","GMT+5",0,1,0,0,"Asia/Karachi");
128 INSERT INTO "city_table" VALUES(123,"IDS_WCL_BODY_CITYNAME_ISTANBUL","IDS_WCL_BODY_TURKEY","GMT+2",0,1,0,0,"Europe/Istanbul");
129 INSERT INTO "city_table" VALUES(124,"IDS_WCL_BODY_CITYNAME_IZHEVSK","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Moscow");
130 INSERT INTO "city_table" VALUES(125,"IDS_WCL_BODY_CITYNAME_JAKARTA","IDS_WCL_BODY_INDONESIA","GMT+7",0,1,0,0,"Asia/Jakarta");
131 INSERT INTO "city_table" VALUES(126,"IDS_WCL_BODY_CITYNAME_JEDDAH","IDS_WCL_BODY_SAUDI_ARABIA","GMT+3",0,1,0,0,"Asia/Riyadh");
132 INSERT INTO "city_table" VALUES(127,"IDS_WCL_BODY_CITYNAME_JERUSALEM","IDS_WCL_BODY_ISRAEL","GMT+2",0,1,0,0,"Asia/Jerusalem");
133 INSERT INTO "city_table" VALUES(128,"IDS_WCL_BODY_CITYNAME_JOHANNESBURG","IDS_WCL_BODY_REPUBLIC_OF_SOUTH_AFRICA","GMT+2",0,1,0,0,"Africa/Johannesburg");
134 INSERT INTO "city_table" VALUES(129,"IDS_WCL_BODY_CITYNAME_KABUL","IDS_WCL_BODY_AFGHANISTAN","GMT+4:30",0,1,0,0,"Asia/Kabul");
135 INSERT INTO "city_table" VALUES(130,"IDS_WCL_BODY_CITYNAME_KALININGRAD","IDS_WCL_BODY_RUSSIA","GMT+3",0,1,0,0,"Europe/Kaliningrad");
136 INSERT INTO "city_table" VALUES(131,"IDS_WCL_BODY_CITYNAME_KAMCHATKA","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Kamchatka");
137 INSERT INTO "city_table" VALUES(132,"IDS_WCL_BODY_CITYNAME_KAMPALA","IDS_WCL_BODY_UGANDA","GMT+3",0,1,0,0,"Africa/Kampala");
138 INSERT INTO "city_table" VALUES(133,"IDS_WCL_BODY_CITYNAME_KARACHI","IDS_WCL_BODY_PAKISTAN","GMT+5",0,1,0,0,"Asia/Karachi");
139 INSERT INTO "city_table" VALUES(134,"IDS_WCL_BODY_CITYNAME_KATHMANDU","IDS_WCL_BODY_NEPAL","GMT+5:45",0,1,0,0,"Asia/Kathmandu");
140 INSERT INTO "city_table" VALUES(135,"IDS_WCL_BODY_CITYNAME_KHABAROVSK","IDS_WCL_BODY_RUSSIA","GMT+11",0,1,0,0,"Asia/Vladivostok");
141 INSERT INTO "city_table" VALUES(136,"IDS_WCL_BODY_CITYNAME_KHARKIV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
142 INSERT INTO "city_table" VALUES(137,"IDS_WCL_BODY_CITYNAME_KHARTOUM","IDS_WCL_BODY_SUDAN","GMT+3",0,1,0,0,"Africa/Khartoum");
143 INSERT INTO "city_table" VALUES(138,"IDS_WCL_BODY_CITYNAME_KIEV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
144 INSERT INTO "city_table" VALUES(139,"IDS_WCL_BODY_CITYNAME_KINGSTON","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"America/Toronto");
145 INSERT INTO "city_table" VALUES(140,"IDS_WCL_BODY_CITYNAME_KINGSTON","IDS_WCL_BODY_JAMAICA","GMT-5",0,1,0,0,"America/Jamaica");
146 INSERT INTO "city_table" VALUES(141,"IDS_WCL_BODY_CITYNAME_KINSHASA","IDS_WCL_BODY_DEMOCRATIC_REPUBLIC_OF_THE_CONGO","GMT+1",0,1,0,0,"Africa/Kinshasa");
147 INSERT INTO "city_table" VALUES(142,"IDS_WCL_BODY_CITYNAME_KOLKATA","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
148 INSERT INTO "city_table" VALUES(143,"IDS_WCL_BODY_CITYNAME_KRASNOYARSK","IDS_WCL_BODY_RUSSIA","GMT+8",0,1,0,0,"Asia/Krasnoyarsk");
149 INSERT INTO "city_table" VALUES(144,"IDS_WCL_BODY_CITYNAME_KUALA_LUMPUR","IDS_WCL_BODY_MALAYSIA","GMT+8",0,1,0,0,"Asia/Kuala_Lumpur");
150 INSERT INTO "city_table" VALUES(145,"IDS_WCL_BODY_KUWAIT","IDS_WCL_BODY_KUWAIT","GMT+3",0,1,0,0,"Asia/Kuwait");
151 INSERT INTO "city_table" VALUES(146,"IDS_WCL_BODY_CITYNAME_KIEV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
152 INSERT INTO "city_table" VALUES(147,"IDS_WCL_BODY_CITYNAME_LOS_ANGELES","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"America/Los_Angeles");
153 INSERT INTO "city_table" VALUES(148,"IDS_WCL_BODY_CITYNAME_LA_PAZ","IDS_WCL_BODY_BOLIVIA","GMT-4",0,1,0,0,"America/La_Paz");
154 INSERT INTO "city_table" VALUES(149,"IDS_WCL_BODY_CITYNAME_LAGOS","IDS_WCL_BODY_NIGERIA","GMT+1",0,1,0,0,"Africa/Lagos");
155 INSERT INTO "city_table" VALUES(150,"IDS_WCL_BODY_CITYNAME_LAS_VEGAS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
156 INSERT INTO "city_table" VALUES(151,"IDS_WCL_BODY_CITYNAME_LIMA","IDS_WCL_BODY_PERU","GMT-5",0,1,0,0,"America/Lima");
157 INSERT INTO "city_table" VALUES(152,"IDS_WCL_BODY_CITYNAME_LISBON","IDS_WCL_BODY_PORTUGAL","GMT+0",0,1,0,0,"Europe/Lisbon");
158 INSERT INTO "city_table" VALUES(153,"IDS_WCL_BODY_CITYNAME_LJUBLJANA","IDS_WCL_BODY_SLOVAKIA","GMT+1",0,1,0,0,"Europe/Ljubljana");
159 INSERT INTO "city_table" VALUES(154,"IDS_WCL_BODY_CITYNAME_LONDON","IDS_WCL_BODY_UNITED_KINGDOM","GMT+0",0,1,0,0,"Europe/London");
160 INSERT INTO "city_table" VALUES(155,"IDS_WCL_BODY_CITYNAME_LONGHUA","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
161 INSERT INTO "city_table" VALUES(156,"IDS_WCL_BODY_CITYNAME_LOUISVILLE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"America/Kentucky/Louisville");
162 INSERT INTO "city_table" VALUES(157,"IDS_WCL_BODY_CITYNAME_LUANDA","IDS_WCL_BODY_ANGOLA","GMT+1",0,1,0,0,"Africa/Luanda");
163 INSERT INTO "city_table" VALUES(158,"IDS_WCL_BODY_CITYNAME_LUBUMBASHI","IDS_WCL_BODY_DEMOCRATIC_REPUBLIC_OF_THE_CONGO","GMT+2",0,1,0,0,"Africa/Lubumbashi");
164 INSERT INTO "city_table" VALUES(159,"IDS_WCL_BODY_CITYNAME_LUSAKA","IDS_WCL_BODY_ZAMBIA","GMT+2",0,1,0,0,"Africa/Lusaka");
165 INSERT INTO "city_table" VALUES(160,"IDS_WCL_BODY_LUXEMBOURG","IDS_WCL_BODY_LUXEMBOURG","GMT+1",0,1,0,0,"Europe/Luxembourg");
166 INSERT INTO "city_table" VALUES(161,"IDS_WCL_BODY_CITYNAME_LVIV","IDS_WCL_BODY_UKRAINE","GMT+2",0,1,0,0,"Europe/Kiev");
167 INSERT INTO "city_table" VALUES(162,"IDS_WCL_BODY_CITYNAME_MACAU","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Macau");
168 INSERT INTO "city_table" VALUES(163,"IDS_WCL_BODY_CITYNAME_MADRID","IDS_WCL_BODY_SPAIN","GMT+2",0,1,0,0,"Europe/Madrid");
169 INSERT INTO "city_table" VALUES(164,"IDS_WCL_BODY_CITYNAME_MAGADAN","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Magadan");
170 INSERT INTO "city_table" VALUES(165,"IDS_WCL_BODY_CITYNAME_MALABO","IDS_WCL_BODY_CITYNAME_EQUAORIAL_GUINEA","GMT+1",0,1,0,0,"Africa/Malabo");
171 INSERT INTO "city_table" VALUES(166,"IDS_WCL_BODY_CITYNAME_MALE","IDS_WCL_BODY_MALDIVES","GMT+5",0,1,0,0,"Indian/Maldives");
172 INSERT INTO "city_table" VALUES(167,"IDS_WCL_BODY_CITYNAME_MANAGUA","IDS_WCL_BODY_NICARAGUA","GMT-6",0,1,0,0,"America/Managua");
173 INSERT INTO "city_table" VALUES(168,"IDS_WCL_BODY_CITYNAME_MANAMA","IDS_WCL_BODY_BAHRAIN","GMT+3",0,1,0,0,"Asia/Bahrain");
174 INSERT INTO "city_table" VALUES(169,"IDS_WCL_BODY_CITYNAME_MANILA","IDS_WCL_BODY_PHILIPPINES","GMT+8",0,1,0,0,"Asia/Manila");
175 INSERT INTO "city_table" VALUES(170,"IDS_WCL_BODY_CITYNAME_MAPUTO","IDS_WCL_BODY_MOZAMBIQUE","GMT+2",0,1,0,0,"Africa/Maputo");
176 INSERT INTO "city_table" VALUES(171,"IDS_WCL_BODY_CITYNAME_MARIGOT","IDS_WCL_BODY_CITYNAME_SAINT_MARTIN","GMT-4",0,1,0,0,"America/Marigot");
177 INSERT INTO "city_table" VALUES(172,"IDS_WCL_BODY_CITYNAME_MAZATLAN","IDS_WCL_BODY_MEXICO","GMT-7",0,1,0,0,"America/Mazatlan");
178 INSERT INTO "city_table" VALUES(173,"IDS_WCL_BODY_MECCA","IDS_WCL_BODY_SAUDI_ARABIA","GMT+3",0,1,0,0,"Asia/Riyadh");
179 INSERT INTO "city_table" VALUES(174,"IDS_WCL_BODY_CITYNAME_MELBOURNE","IDS_WCL_BODY_AUSTRALIA","GMT+10",0,1,0,0,"Australia/Melbourne");
180 INSERT INTO "city_table" VALUES(175,"IDS_WCL_BODY_CITYNAME_MEMPHIS","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
181 INSERT INTO "city_table" VALUES(176,"IDS_WCL_BODY_CITYNAME_MESSINA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
182 INSERT INTO "city_table" VALUES(177,"IDS_WCL_BODY_CITYNAME_MEXICO_CITY","IDS_WCL_BODY_MEXICO","GMT-6",0,1,0,0,"America/Mexico_City");
183 INSERT INTO "city_table" VALUES(178,"IDS_WCL_BODY_CITYNAME_MIAMI","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
184 INSERT INTO "city_table" VALUES(179,"IDS_WCL_BODY_CITYNAME_MID_ATLANTIC","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-2",0,1,0,0,"America/New_York");
185 INSERT INTO "city_table" VALUES(180,"IDS_WCL_BODY_CITYNAME_MIDWAY_ATOLL","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-11",0,1,0,0,"Pacific/Midway");
186 INSERT INTO "city_table" VALUES(181,"IDS_WCL_BODY_CITYNAME_MILAN","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
187 INSERT INTO "city_table" VALUES(182,"IDS_WCL_BODY_CITYNAME_MILWAUKEE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
188 INSERT INTO "city_table" VALUES(183,"IDS_WCL_BODY_CITYNAME_MINSK","IDS_WCL_BODY_BELARUS","GMT+2",0,1,0,0,"Europe/Minsk");
189 INSERT INTO "city_table" VALUES(184,"IDS_WCL_BODY_CITYNAME_MOGADISHU","IDS_WCL_BODY_SOMALIA","GMT+2",0,1,0,0,"Africa/Mogadishu");
190 INSERT INTO "city_table" VALUES(185,"IDS_WCL_BODY_CITYNAME_MONROVIA","IDS_WCL_BODY_LIBERIA","GMT+0",0,1,0,0,"Africa/Monrovia");
191 INSERT INTO "city_table" VALUES(186,"IDS_WCL_BODY_CITYNAME_MONTEVIDEO","IDS_WCL_BODY_URUGUAY","GMT-3",0,1,0,0,"America/Montevideo");
192 INSERT INTO "city_table" VALUES(187,"IDS_WCL_BODY_CITYNAME_MONTREAL","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"America/Montreal");
193 INSERT INTO "city_table" VALUES(188,"IDS_WCL_BODY_CITYNAME_MOSCOW","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Moscow");
194 INSERT INTO "city_table" VALUES(189,"IDS_WCL_BODY_CITYNAME_MUMBAI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
195 INSERT INTO "city_table" VALUES(190,"IDS_WCL_BODY_CITYNAME_MUNICH","IDS_WCL_BODY_GERMANY","GMT+1",0,1,0,0,"Europe/Berlin");
196 INSERT INTO "city_table" VALUES(191,"IDS_WCL_BODY_CITYNAME_MUSCAT","IDS_WCL_BODY_OMAN","GMT+4",0,1,0,0,"Asia/Muscat");
197 INSERT INTO "city_table" VALUES(192,"IDS_WCL_BODY_CITYNAME_NAIROBI","IDS_WCL_BODY_KENYA","GMT+3",0,1,0,0,"Africa/Nairobi");
198 INSERT INTO "city_table" VALUES(193,"IDS_WCL_BODY_CITYNAME_NAPLES","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
199 INSERT INTO "city_table" VALUES(194,"IDS_WCL_BODY_CITYNAME_NATERS","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Zurich");
200 INSERT INTO "city_table" VALUES(195,"IDS_WCL_BODY_CITYNAME_NDJAMENA","IDS_WCL_BODY_CHAD","GMT+1",0,1,0,0,"Africa/Ndjamena");
201 INSERT INTO "city_table" VALUES(196,"IDS_WCL_BODY_CITYNAME_NEWDELHI","IDS_WCL_BODY_INDIA","GMT+5:30",0,1,0,0,"Asia/Kolkata");
202 INSERT INTO "city_table" VALUES(197,"IDS_WCL_BODY_CITYNAME_NEWYORK","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-4",0,1,0,0,"America/New_York");
203 INSERT INTO "city_table" VALUES(198,"IDS_WCL_BODY_CITYNAME_NEWFOUNDLAND","IDS_WCL_BODY_CANADA","GMT-3:30",0,1,0,0,"America/St_Johns");
204 INSERT INTO "city_table" VALUES(199,"IDS_WCL_BODY_CITYNAME_NIAMEY","IDS_WCL_BODY_NIGER","GMT+1",0,1,0,0,"Africa/Niamey");
205 INSERT INTO "city_table" VALUES(200,"IDS_WCL_BODY_CITYNAME_NOUAKCHOTT","IDS_WCL_BODY_MAURITANIA","GMT+1",0,1,0,0,"Africa/Nouakchott");
206 INSERT INTO "city_table" VALUES(201,"IDS_WCL_BODY_CITYNAME_NOUMEA","IDS_WCL_BODY_NEW_CALEDONIA","GMT+11",0,1,0,0,"Pacific/Noumea");
207 INSERT INTO "city_table" VALUES(202,"IDS_WCL_BODY_CITYNAME_NOVOKUZNETSK","IDS_WCL_BODY_RUSSIA","GMT+7",0,1,0,0,"Asia/Novokuznetsk");
208 INSERT INTO "city_table" VALUES(203,"IDS_WCL_BODY_CITYNAME_NOVOSIBIRSK","IDS_WCL_BODY_RUSSIA","GMT+7",0,1,0,0,"Asia/Novosibirsk");
209 INSERT INTO "city_table" VALUES(204,"IDS_WCL_BODY_CITYNAME_NUKUALOFA","IDS_WCL_BODY_TONGA","GMT+13",0,1,0,0,"Pacific/Tongatapu");
210 INSERT INTO "city_table" VALUES(205,"IDS_WCL_BODY_CITYNAME_NUUK","IDS_WCL_BODY_GREENLAND_M_COUNTRYNAME","GMT-3",0,1,0,0,"America/Godthab");
211 INSERT INTO "city_table" VALUES(206,"IDS_WCL_BODY_CITYNAME_OMSK","IDS_WCL_BODY_RUSSIA","GMT+7",0,1,0,0,"Asia/Omsk");
212 INSERT INTO "city_table" VALUES(207,"IDS_WCL_BODY_CITYNAME_OSAKA","IDS_WCL_BODY_JAPAN","GMT+9",0,1,0,0,"Asia/Tokyo");
213 INSERT INTO "city_table" VALUES(208,"IDS_WCL_BODY_CITYNAME_OTTAWA","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"EST5EDT");
214 INSERT INTO "city_table" VALUES(209,"IDS_WCL_BODY_CITYNAME_OUAGADOUGOU","IDS_WCL_BODY_BURKINA_FASO","GMT+0",0,1,0,0,"Africa/Ouagadougou");
215 INSERT INTO "city_table" VALUES(210,"IDS_WCL_BODY_CITYNAME_PAGO_PAGO","IDS_WCL_BODY_INDEPENDENT_STATE_OF_SAMOA","GMT-11",0,1,0,0,"Pacific/Pago_Pago");
216 INSERT INTO "city_table" VALUES(211,"IDS_WCL_BODY_CITYNAME_PALERMO","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
217 INSERT INTO "city_table" VALUES(212,"IDS_WCL_BODY_PANAMA_CITY","IDS_WCL_BODY_PANAMA","GMT-6",0,1,0,0,"America/Panama");
218 INSERT INTO "city_table" VALUES(213,"IDS_WCL_BODY_CITYNAME_PARAMARIBO","IDS_WCL_BODY_SURINAME","GMT-3",0,1,0,0,"America/Paramaribo");
219 INSERT INTO "city_table" VALUES(214,"IDS_WCL_BODY_CITYNAME_PARIS","IDS_WCL_BODY_FRANCE","GMT+1",0,1,0,0,"Europe/Paris");
220 INSERT INTO "city_table" VALUES(215,"IDS_WCL_BODY_CITYNAME_PERM","IDS_WCL_BODY_RUSSIA","GMT+6",0,1,0,0,"Asia/Yekaterinburg");
221 INSERT INTO "city_table" VALUES(216,"IDS_WCL_BODY_CITYNAME_PERTH","IDS_WCL_BODY_AUSTRALIA","GMT+8",0,1,0,0,"Australia/Perth");
222 INSERT INTO "city_table" VALUES(217,"IDS_WCL_BODY_CITYNAME_PETROPAVLOVSK_KAMCHATSKIY","IDS_WCL_BODY_RUSSIA","GMT+12",0,1,0,0,"Asia/Kamchatka");
223 INSERT INTO "city_table" VALUES(218,"IDS_WCL_BODY_CITYNAME_PHILADELPHIA","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
224 INSERT INTO "city_table" VALUES(219,"IDS_WCL_BODY_CITYNAME_PHNOM_PENH","IDS_WCL_BODY_CAMBODIA","GMT-5",0,1,0,0,"Asia/Phnom_Penh");
225 INSERT INTO "city_table" VALUES(220,"IDS_WCL_BODY_CITYNAME_PHOENIX","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-7",0,1,0,0,"America/Phoenix");
226 INSERT INTO "city_table" VALUES(221,"IDS_WCL_BODY_CITYNAME_PODGORICA","IDS_WCL_BODY_MONTENEGRO","GMT+1",0,1,0,0,"Europe/Podgorica");
227 INSERT INTO "city_table" VALUES(222,"IDS_WCL_BODY_CITYNAME_PONTA_DELGADA","IDS_WCL_BODY_PORTUGAL","GMT-1",0,1,0,0,"Atlantic/Azores");
228 INSERT INTO "city_table" VALUES(223,"IDS_WCL_BODY_CITYNAME_PORT_LOUIS","IDS_WCL_BODY_MAURITIUS","GMT+4",0,1,0,0,"Indian/Mauritius");
229 INSERT INTO "city_table" VALUES(224,"IDS_WCL_BODY_CITYNAME_PORT_AU_PRINCE","IDS_WCL_BODY_HAITI","GMT-5",0,1,0,0,"America/Port-au-Prince");
230 INSERT INTO "city_table" VALUES(225,"IDS_WCL_BODY_CITYNAME_PORTLAND","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
231 INSERT INTO "city_table" VALUES(226,"IDS_WCL_BODY_CITYNAME_PRAGUE","IDS_WCL_BODY_CZECH_REPUBLIC","GMT+1",0,1,0,0,"Europe/Prague");
232 INSERT INTO "city_table" VALUES(227,"IDS_WCL_BODY_CITYNAME_PYONGYANG","IDS_WCL_BODY_NORTH_KOREA","GMT+9",0,1,0,0,"Asia/Pyongyang");
233 INSERT INTO "city_table" VALUES(228,"IDS_WCL_BODY_CITYNAME_QUITO","IDS_WCL_BODY_ECUADOR","GMT-5",0,1,0,0,"America/Guayaquil");
234 INSERT INTO "city_table" VALUES(229,"IDS_WCL_BODY_CITYNAME_RABAT","IDS_WCL_BODY_MOROCCO","GMT+0",0,1,0,0,"Africa/Casablanca");
235 INSERT INTO "city_table" VALUES(230,"IDS_WCL_BODY_CITYNAME_YANGON","IDS_WCL_BODY_BURMA","GMT+6:30",0,1,0,0,"Asia/Rangoon");
236 INSERT INTO "city_table" VALUES(231,"IDS_WCL_BODY_CITYNAME_RECIFE","IDS_WCL_BODY_BRAZIL","GMT-3",0,1,0,0,"America/Recife");
237 INSERT INTO "city_table" VALUES(232,"IDS_WCL_BODY_CITYNAME_REGINA","IDS_WCL_BODY_CANADA","GMT-6",0,1,0,0,"America/Regina");
238 INSERT INTO "city_table" VALUES(233,"IDS_WCL_BODY_CITYNAME_REYKJAVIK","IDS_WCL_BODY_ICELAND","GMT+0",0,1,0,0,"Atlantic/Reykjavik");
239 INSERT INTO "city_table" VALUES(234,"IDS_WCL_BODY_CITYNAME_RIGA","IDS_WCL_BODY_LATVIA","GMT+2",0,1,0,0,"Europe/Riga");
240 INSERT INTO "city_table" VALUES(235,"IDS_WCL_BODY_CITYNAME_RIO_DE_JANEIRO","IDS_WCL_BODY_BRAZIL","GMT-2",0,1,0,0,"America/Sao_Paulo");
241 INSERT INTO "city_table" VALUES(236,"IDS_WCL_BODY_CITYNAME_RIYADH","IDS_WCL_BODY_SAUDI_ARABIA","GMT+3",0,1,0,0,"Asia/Riyadh");
242 INSERT INTO "city_table" VALUES(237,"IDS_WCL_BODY_CITYNAME_ROME","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
243 INSERT INTO "city_table" VALUES(238,"IDS_WCL_BODY_CITYNAME_SAINT_DENIS","IDS_WCL_BODY_REUNION_ISLAND_M_COUNTRYNAME","GMT+4",0,1,0,0,"Indian/Reunion");
244 INSERT INTO "city_table" VALUES(239,"IDS_WCL_BODY_CITYNAME_SAMARA","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Samara");
245 INSERT INTO "city_table" VALUES(240,"IDS_WCL_BODY_CITYNAME_SAN_ANTONIO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-6",0,1,0,0,"CST6CDT");
246 INSERT INTO "city_table" VALUES(241,"IDS_WCL_BODY_CITYNAME_SAN_DIEGO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
247 INSERT INTO "city_table" VALUES(242,"IDS_WCL_BODY_CITYNAME_SAN_FRANCISCO","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"America/Los_Angeles");
248 INSERT INTO "city_table" VALUES(243,"IDS_WCL_BODY_SAN_JOSE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
249 INSERT INTO "city_table" VALUES(244,"IDS_WCL_BODY_SAN_JOSE","IDS_WCL_BODY_COSTA_RICA","GMT-6",0,1,0,0,"America/Costa_Rica");
250 INSERT INTO "city_table" VALUES(245,"IDS_WCL_BODY_CITYNAME_SAN_JUAN","IDS_WCL_BODY_PUERTO_RICO","GMT-4",0,1,0,0,"America/Puerto_Rico");
251 INSERT INTO "city_table" VALUES(246,"IDS_WCL_BODY_CITYNAME_SAN_MARINO","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/San_Marino");
252 INSERT INTO "city_table" VALUES(247,"IDS_WCL_BODY_CITYNAME_SAN_SALVADOR","IDS_WCL_BODY_EL_SALVADOR","GMT-6",0,1,0,0,"America/El_Salvador");
253 INSERT INTO "city_table" VALUES(248,"IDS_WCL_BODY_CITYNAME_SANAA","IDS_WCL_BODY_YEMEN","GMT+3",0,1,0,0,"Asia/Aden");
254 INSERT INTO "city_table" VALUES(249,"IDS_WCL_BODY_CITYNAME_SANTIAGO","IDS_WCL_BODY_CHILE","GMT-4",0,1,0,0,"America/Santiago");
255 INSERT INTO "city_table" VALUES(250,"IDS_WCL_BODY_CITYNAME_SANTO_DOMINGO","IDS_WCL_BODY_DOMINICAN_REPUBLIC","GMT-4",0,1,0,0,"America/Santo_Domingo");
256 INSERT INTO "city_table" VALUES(251,"IDS_WCL_BODY_CITYNAME_SAO_PAULO","IDS_WCL_BODY_BRAZIL","GMT-2",0,1,0,0,"America/Sao_Paulo");
257 INSERT INTO "city_table" VALUES(252,"IDS_WCL_BODY_CITYNAME_SEATTLE","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-8",0,1,0,0,"PST8PDT");
258 INSERT INTO "city_table" VALUES(253,"IDS_WCL_BODY_CITYNAME_SEOUL","IDS_WCL_BODY_REPUBLIC_OF_KOREA","GMT+9",0,1,1,0,"Asia/Seoul");
259 INSERT INTO "city_table" VALUES(254,"IDS_WCL_BODY_CITYNAME_SHANGHAI","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
260 INSERT INTO "city_table" VALUES(255,"IDS_WCL_BODY_SHENZHEN","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
261 INSERT INTO "city_table" VALUES(256,"IDS_WCL_BODY_CITYNAME_SINGAPORE","IDS_WCL_BODY_REPUBLIC_OF_SINGAPORE_M_COUNTRY","GMT+8",0,1,0,0,"Asia/Singapore");
262 INSERT INTO "city_table" VALUES(257,"IDS_WCL_BODY_CITYNAME_SKOPJE","IDS_WCL_BODY_MACEDONIA","GMT+1",0,1,0,0,"Europe/Skopje");
263 INSERT INTO "city_table" VALUES(258,"IDS_WCL_BODY_CITYNAME_SOFIA","IDS_WCL_BODY_BULGARIA","GMT+3",0,1,0,0,"Europe/Sofia");
264 INSERT INTO "city_table" VALUES(259,"IDS_WCL_BODY_CITYNAME_ST_JOHNS","IDS_WCL_BODY_ANTIGUA_AND_BARBUDA","GMT-4",0,1,0,0,"America/Antigua");
265 INSERT INTO "city_table" VALUES(260,"IDS_WCL_BODY_CITYNAME_ST_JOHNS","IDS_WCL_BODY_CANADA","GMT-3:30",0,1,0,0,"America/St_Johns");
266 INSERT INTO "city_table" VALUES(261,"IDS_WCL_BODY_CITYNAME_ST_PETERSBURG","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Moscow");
267 INSERT INTO "city_table" VALUES(262,"IDS_WCL_BODY_CITYNAME_STOCKHOLM","IDS_WCL_BODY_SWEDEN","GMT+2",0,1,0,0,"Europe/Stockholm");
268 INSERT INTO "city_table" VALUES(263,"IDS_WCL_BODY_CITYNAME_SUVA","IDS_WCL_BODY_FIJI_M_COUNTRYNAME","GMT+12",0,1,0,0,"Pacific/Fiji");
269 INSERT INTO "city_table" VALUES(264,"IDS_WCL_BODY_CITYNAME_SYDNEY","IDS_WCL_BODY_AUSTRALIA","GMT+11",0,1,0,0,"Australia/Sydney");
270 INSERT INTO "city_table" VALUES(265,"IDS_WCL_BODY_CITYNAME_TAHITI","IDS_WCL_BODY_FRENCH_POLYNESIA","GMT-10",0,1,0,0,"Pacific/Tahiti");
271 INSERT INTO "city_table" VALUES(266,"IDS_WCL_BODY_CITYNAME_TAIPEI","IDS_WCL_BODY_TAIWAN","GMT+8",0,1,0,0,"Asia/Taipei");
272 INSERT INTO "city_table" VALUES(267,"IDS_WCL_BODY_CITYNAME_TALLINN","IDS_WCL_BODY_ESTONIA","GMT+2",0,1,0,0,"Europe/Tallinn");
273 INSERT INTO "city_table" VALUES(268,"IDS_WCL_BODY_CITYNAME_TARAWA","IDS_WCL_BODY_KIRIBATI","GMT+12",0,1,0,0,"Pacific/Tarawa");
274 INSERT INTO "city_table" VALUES(269,"IDS_WCL_BODY_CITYNAME_TASHKENT","IDS_WCL_BODY_UZBEKISTAN","GMT+5",0,1,0,0,"Asia/Tashkent");
275 INSERT INTO "city_table" VALUES(270,"IDS_WCL_BODY_CITYNAME_TBILISI","IDS_WCL_BODY_GEORGIA","GMT+4",0,1,0,0,"Asia/Tbilisi");
276 INSERT INTO "city_table" VALUES(271,"IDS_WCL_BODY_CITYNAME_TEGUCIGALPA","IDS_WCL_BODY_HONDURAS","GMT-6",0,1,0,0,"America/Tegucigalpa");
277 INSERT INTO "city_table" VALUES(272,"IDS_WCL_BODY_CITYNAME_TEHRAN","IDS_WCL_BODY_IRAN_M_COUNTRYNAME","GMT+3:30",0,1,0,0,"Asia/Tehran");
278 INSERT INTO "city_table" VALUES(273,"IDS_WCL_BODY_CITYNAME_HO_CHI_MINH_CITY","IDS_WCL_BODY_VIETNAM","GMT+7",0,1,0,0,"Asia/Ho_Chi_Minh");
279 INSERT INTO "city_table" VALUES(274,"IDS_WCL_BODY_CITYNAME_THE_SETTLEMENT","IDS_WCL_BODY_BRITISH_VIRGIN_ISLANDS","GMT-4",0,1,0,0,"America/Tortola");
280 INSERT INTO "city_table" VALUES(275,"IDS_WCL_BODY_CITYNAME_TIANJIN","IDS_WCL_BODY_CHINA","GMT+8",0,1,0,0,"Asia/Shanghai");
281 INSERT INTO "city_table" VALUES(276,"IDS_WCL_BODY_CITYNAME_TIJUANA","IDS_WCL_BODY_MEXICO","GMT-5",0,1,0,0,"America/Tijuana");
282 INSERT INTO "city_table" VALUES(277,"IDS_WCL_BODY_CITYNAME_TOKYO","IDS_WCL_BODY_JAPAN","GMT+9",0,1,0,0,"Asia/Tokyo");
283 INSERT INTO "city_table" VALUES(278,"IDS_WCL_BODY_CITYNAME_TORONTO","IDS_WCL_BODY_CANADA","GMT-4",0,1,0,0,"America/Toronto");
284 INSERT INTO "city_table" VALUES(279,"IDS_WCL_BODY_CITYNAME_TREHET","IDS_WCL_BODY_FRANCE","GMT+1",0,1,0,0,"Europe/Paris");
285 INSERT INTO "city_table" VALUES(280,"IDS_WCL_BODY_CITYNAME_TRIPOLI","IDS_WCL_BODY_LIBYA","GMT+2",0,1,0,0,"Africa/Tripoli");
286 INSERT INTO "city_table" VALUES(281,"IDS_WCL_BODY_CITYNAME_TUNIS","IDS_WCL_BODY_TUNISIA","GMT+2",0,1,0,0,"Africa/Tunis");
287 INSERT INTO "city_table" VALUES(282,"IDS_WCL_BODY_CITYNAME_TURIN","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
288 INSERT INTO "city_table" VALUES(283,"IDS_WCL_BODY_CITYNAME_UFA","IDS_WCL_BODY_BASHKIRIYA_M_COUNTRYNAME","GMT+5",0,1,0,0,"Asia/Yekaterinburg");
289 INSERT INTO "city_table" VALUES(284,"IDS_WCL_BODY_CITYNAME_ULAN_BATOR","IDS_WCL_BODY_MONGOLIA","GMT+8",0,1,0,0,"Asia/Ulan_Bator");
290 INSERT INTO "city_table" VALUES(285,"IDS_WCL_BODY_CITYNAME_VADUZ","IDS_WCL_BODY_LIECHTENSTEIN","GMT+1",0,1,0,0,"Europe/Vaduz");
291 INSERT INTO "city_table" VALUES(286,"IDS_WCL_BODY_CITYNAME_VALLETTA","IDS_WCL_BODY_MALTA","GMT+1",0,1,0,0,"Europe/Malta");
292 INSERT INTO "city_table" VALUES(287,"IDS_WCL_BODY_CITYNAME_VANCOUVER","IDS_WCL_BODY_CANADA","GMT-8",0,1,0,0,"America/Vancouver");
293 INSERT INTO "city_table" VALUES(288,"IDS_WCL_BODY_CITYNAME_VERONA","IDS_WCL_BODY_ITALY","GMT+1",0,1,0,0,"Europe/Rome");
294 INSERT INTO "city_table" VALUES(289,"IDS_WCL_BODY_CITYNAME_VICTORIA","IDS_WCL_BODY_SEYCHELLES","GMT+4",0,1,0,0,"Australia/Melbourne");
295 INSERT INTO "city_table" VALUES(290,"IDS_WCL_BODY_CITYNAME_VIENNA","IDS_WCL_BODY_AUSTRIA","GMT+1",0,1,0,0,"Europe/Vienna");
296 INSERT INTO "city_table" VALUES(291,"IDS_WCL_BODY_CITYNAME_VILNIUS","IDS_WCL_BODY_LITHUANIA","GMT+3",0,1,0,0,"Europe/Vilnius");
297 INSERT INTO "city_table" VALUES(292,"IDS_WCL_BODY_CITYNAME_VLADIVOSTOK","IDS_WCL_BODY_RUSSIA","GMT+11",0,1,0,0,"Asia/Vladivostok");
298 INSERT INTO "city_table" VALUES(293,"IDS_WCL_BODY_CITYNAME_VOLGOGRAD","IDS_WCL_BODY_RUSSIA","GMT+4",0,1,0,0,"Europe/Volgograd");
299 INSERT INTO "city_table" VALUES(294,"IDS_WCL_BODY_CITYNAME_WARSAW","IDS_WCL_BODY_POLAND","GMT+2",0,1,0,0,"Europe/Warsaw");
300 INSERT INTO "city_table" VALUES(295,"IDS_WCL_BODY_CITYNAME_WASHINGTON_DC","IDS_WCL_BODY_USA_M_COUNTRYNAME","GMT-5",0,1,0,0,"EST5EDT");
301 INSERT INTO "city_table" VALUES(296,"IDS_WCL_BODY_CITYNAME_WELLINGTON","IDS_WCL_BODY_NEW_ZEALAND","GMT+12",0,1,0,0,"Pacific/Auckland");
302 INSERT INTO "city_table" VALUES(297,"IDS_WCL_BODY_CITYNAME_WINNIPEG","IDS_WCL_BODY_CANADA","GMT-5",0,1,0,0,"America/Winnipeg");
303 INSERT INTO "city_table" VALUES(298,"IDS_WCL_BODY_CITYNAME_YAKUTSK","IDS_WCL_BODY_RUSSIA","GMT+10",0,1,0,0,"Asia/Yakutsk");
304 INSERT INTO "city_table" VALUES(299,"IDS_WCL_BODY_CITYNAME_YAMOUSSOUKRO","IDS_WCL_BODY_COTE_DIVOIRE","GMT+0",0,1,0,0,"Africa/Abidjan");
305 INSERT INTO "city_table" VALUES(300,"IDS_WCL_BODY_YAOUNDE","IDS_WCL_BODY_CAMEROON","GMT+1",0,1,0,0,"Africa/Douala");
306 INSERT INTO "city_table" VALUES(301,"IDS_WCL_BODY_CITYNAME_YEKATERINBURG","IDS_WCL_BODY_RUSSIA","GMT+6",0,1,0,0,"Asia/Yekaterinburg");
307 INSERT INTO "city_table" VALUES(302,"IDS_WCL_BODY_CITYNAME_YEREVAN","IDS_WCL_BODY_ARMENIA","GMT+5",0,1,0,0,"Asia/Yerevan");
308 INSERT INTO "city_table" VALUES(303,"IDS_WCL_BODY_CITYNAME_YUZHNO_SAKHALINSK","IDS_WCL_BODY_RUSSIA","GMT+11",0,1,0,0,"Asia/Sakhalin");
309 INSERT INTO "city_table" VALUES(304,"IDS_WCL_BODY_CITYNAME_ZAGREB","IDS_WCL_BODY_CROATIA","GMT+1",0,1,0,0,"Europe/Zagreb");
310 INSERT INTO "city_table" VALUES(305,"IDS_WCL_BODY_CITYNAME_ZURICH","IDS_WCL_BODY_SWITZERLAND","GMT+1",0,1,0,0,"Europe/Zurich");'
312 if [ ${USER} == "root" ]
315 #chown 5000:5000 /usr/share/doc/worldclock/copyright
316 #chown 5000:5000 /usr/share/doc/worldclock/changelog.Debian.gz
317 #chown 5000:5000 /usr/share/doc/worldclock/CMakeLists.txt
318 chown :6015 /opt/dbspace/.worldclock.db
319 chown :6015 /opt/dbspace/.worldclock.db-journal
321 # Change file permissions
322 #chmod 600 /usr/share/doc/worldclock/copyright
323 #chmod 600 /usr/share/doc/worldclock/changelog.Debian.gz
324 #chmod 600 /usr/share/doc/worldclock/CMakeLists.txt
325 chmod 660 /opt/dbspace/.worldclock.db
326 chmod 660 /opt/dbspace/.worldclock.db-journal