/
timezones.go
executable file
·455 lines (452 loc) · 24.5 KB
/
timezones.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
// Copyright (C) 2017, 2018, 2019 EGAAS S.A.
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or (at
// your option) any later version.
//
// This program is distributed in the hope that it will be useful, but
// WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
package migration
var timeZonesSQL = `
DROP TABLE IF EXISTS "1_time_zones";
CREATE TABLE "1_time_zones" (
"id" bigint NOT NULL DEFAULT '0',
"name" varchar(255) NOT NULL,
"offset" varchar(6) NOT NULL,
CONSTRAINT "1_time_zones_name_uniq" UNIQUE (name)
);
ALTER TABLE ONLY "1_time_zones" ADD CONSTRAINT "1_time_zones_pkey" PRIMARY KEY ("id");
INSERT INTO "1_time_zones" VALUES
(next_id('1_time_zones'), 'Africa/Abidjan', 'UTC'),
(next_id('1_time_zones'), 'Africa/Accra', 'UTC'),
(next_id('1_time_zones'), 'Africa/Addis_Ababa', '+03:00'),
(next_id('1_time_zones'), 'Africa/Algiers', '+01:00'),
(next_id('1_time_zones'), 'Africa/Asmara', '+03:00'),
(next_id('1_time_zones'), 'Africa/Bamako', 'UTC'),
(next_id('1_time_zones'), 'Africa/Bangui', '+01:00'),
(next_id('1_time_zones'), 'Africa/Banjul', 'UTC'),
(next_id('1_time_zones'), 'Africa/Bissau', 'UTC'),
(next_id('1_time_zones'), 'Africa/Blantyre', '+02:00'),
(next_id('1_time_zones'), 'Africa/Brazzaville', '+01:00'),
(next_id('1_time_zones'), 'Africa/Bujumbura', '+02:00'),
(next_id('1_time_zones'), 'Africa/Cairo', '+02:00'),
(next_id('1_time_zones'), 'Africa/Casablanca', '+01:00'),
(next_id('1_time_zones'), 'Africa/Ceuta', '+02:00'),
(next_id('1_time_zones'), 'Africa/Conakry', 'UTC'),
(next_id('1_time_zones'), 'Africa/Dakar', 'UTC'),
(next_id('1_time_zones'), 'Africa/Dar_es_Salaam', '+03:00'),
(next_id('1_time_zones'), 'Africa/Djibouti', '+03:00'),
(next_id('1_time_zones'), 'Africa/Douala', '+01:00'),
(next_id('1_time_zones'), 'Africa/El_Aaiun', '+01:00'),
(next_id('1_time_zones'), 'Africa/Freetown', 'UTC'),
(next_id('1_time_zones'), 'Africa/Gaborone', '+02:00'),
(next_id('1_time_zones'), 'Africa/Harare', '+02:00'),
(next_id('1_time_zones'), 'Africa/Johannesburg', '+02:00'),
(next_id('1_time_zones'), 'Africa/Juba', '+03:00'),
(next_id('1_time_zones'), 'Africa/Kampala', '+03:00'),
(next_id('1_time_zones'), 'Africa/Khartoum', '+02:00'),
(next_id('1_time_zones'), 'Africa/Kigali', '+02:00'),
(next_id('1_time_zones'), 'Africa/Kinshasa', '+01:00'),
(next_id('1_time_zones'), 'Africa/Lagos', '+01:00'),
(next_id('1_time_zones'), 'Africa/Libreville', '+01:00'),
(next_id('1_time_zones'), 'Africa/Lome', 'UTC'),
(next_id('1_time_zones'), 'Africa/Luanda', '+01:00'),
(next_id('1_time_zones'), 'Africa/Lubumbashi', '+02:00'),
(next_id('1_time_zones'), 'Africa/Lusaka', '+02:00'),
(next_id('1_time_zones'), 'Africa/Malabo', '+01:00'),
(next_id('1_time_zones'), 'Africa/Maputo', '+02:00'),
(next_id('1_time_zones'), 'Africa/Maseru', '+02:00'),
(next_id('1_time_zones'), 'Africa/Mbabane', '+02:00'),
(next_id('1_time_zones'), 'Africa/Mogadishu', '+03:00'),
(next_id('1_time_zones'), 'Africa/Monrovia', 'UTC'),
(next_id('1_time_zones'), 'Africa/Nairobi', '+03:00'),
(next_id('1_time_zones'), 'Africa/Ndjamena', '+01:00'),
(next_id('1_time_zones'), 'Africa/Niamey', '+01:00'),
(next_id('1_time_zones'), 'Africa/Nouakchott', 'UTC'),
(next_id('1_time_zones'), 'Africa/Ouagadougou', 'UTC'),
(next_id('1_time_zones'), 'Africa/Porto-Novo', '+01:00'),
(next_id('1_time_zones'), 'Africa/Sao_Tome', 'UTC'),
(next_id('1_time_zones'), 'Africa/Tripoli', '+02:00'),
(next_id('1_time_zones'), 'Africa/Tunis', '+01:00'),
(next_id('1_time_zones'), 'Africa/Windhoek', '+02:00'),
(next_id('1_time_zones'), 'America/Adak', '-09:00'),
(next_id('1_time_zones'), 'America/Anchorage', '-08:00'),
(next_id('1_time_zones'), 'America/Anguilla', '-04:00'),
(next_id('1_time_zones'), 'America/Antigua', '-04:00'),
(next_id('1_time_zones'), 'America/Araguaina', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Buenos_Aires', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Catamarca', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Cordoba', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Jujuy', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/La_Rioja', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Mendoza', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Rio_Gallegos', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Salta', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/San_Juan', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/San_Luis', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Tucuman', '-03:00'),
(next_id('1_time_zones'), 'America/Argentina/Ushuaia', '-03:00'),
(next_id('1_time_zones'), 'America/Aruba', '-04:00'),
(next_id('1_time_zones'), 'America/Asuncion', '-04:00'),
(next_id('1_time_zones'), 'America/Atikokan', '-05:00'),
(next_id('1_time_zones'), 'America/Bahia', '-03:00'),
(next_id('1_time_zones'), 'America/Bahia_Banderas', '-05:00'),
(next_id('1_time_zones'), 'America/Barbados', '-04:00'),
(next_id('1_time_zones'), 'America/Belem', '-03:00'),
(next_id('1_time_zones'), 'America/Belize', '-06:00'),
(next_id('1_time_zones'), 'America/Blanc-Sablon', '-04:00'),
(next_id('1_time_zones'), 'America/Boa_Vista', '-04:00'),
(next_id('1_time_zones'), 'America/Bogota', '-05:00'),
(next_id('1_time_zones'), 'America/Boise', '-06:00'),
(next_id('1_time_zones'), 'America/Cambridge_Bay', '-06:00'),
(next_id('1_time_zones'), 'America/Campo_Grande', '-04:00'),
(next_id('1_time_zones'), 'America/Cancun', '-05:00'),
(next_id('1_time_zones'), 'America/Caracas', '-04:00'),
(next_id('1_time_zones'), 'America/Cayenne', '-03:00'),
(next_id('1_time_zones'), 'America/Cayman', '-05:00'),
(next_id('1_time_zones'), 'America/Chicago', '-05:00'),
(next_id('1_time_zones'), 'America/Chihuahua', '-06:00'),
(next_id('1_time_zones'), 'America/Costa_Rica', '-06:00'),
(next_id('1_time_zones'), 'America/Creston', '-07:00'),
(next_id('1_time_zones'), 'America/Cuiaba', '-04:00'),
(next_id('1_time_zones'), 'America/Curacao', '-04:00'),
(next_id('1_time_zones'), 'America/Danmarkshavn', 'UTC'),
(next_id('1_time_zones'), 'America/Dawson', '-07:00'),
(next_id('1_time_zones'), 'America/Dawson_Creek', '-07:00'),
(next_id('1_time_zones'), 'America/Denver', '-06:00'),
(next_id('1_time_zones'), 'America/Detroit', '-04:00'),
(next_id('1_time_zones'), 'America/Dominica', '-04:00'),
(next_id('1_time_zones'), 'America/Edmonton', '-06:00'),
(next_id('1_time_zones'), 'America/Eirunepe', '-05:00'),
(next_id('1_time_zones'), 'America/El_Salvador', '-06:00'),
(next_id('1_time_zones'), 'America/Fort_Nelson', '-07:00'),
(next_id('1_time_zones'), 'America/Fortaleza', '-03:00'),
(next_id('1_time_zones'), 'America/Glace_Bay', '-03:00'),
(next_id('1_time_zones'), 'America/Godthab', '-02:00'),
(next_id('1_time_zones'), 'America/Goose_Bay', '-03:00'),
(next_id('1_time_zones'), 'America/Grand_Turk', '-04:00'),
(next_id('1_time_zones'), 'America/Grenada', '-04:00'),
(next_id('1_time_zones'), 'America/Guadeloupe', '-04:00'),
(next_id('1_time_zones'), 'America/Guatemala', '-06:00'),
(next_id('1_time_zones'), 'America/Guayaquil', '-05:00'),
(next_id('1_time_zones'), 'America/Guyana', '-04:00'),
(next_id('1_time_zones'), 'America/Halifax', '-03:00'),
(next_id('1_time_zones'), 'America/Havana', '-04:00'),
(next_id('1_time_zones'), 'America/Hermosillo', '-07:00'),
(next_id('1_time_zones'), 'America/Indiana/Indianapolis', '-04:00'),
(next_id('1_time_zones'), 'America/Indiana/Knox', '-05:00'),
(next_id('1_time_zones'), 'America/Indiana/Marengo', '-04:00'),
(next_id('1_time_zones'), 'America/Indiana/Petersburg', '-04:00'),
(next_id('1_time_zones'), 'America/Indiana/Tell_City', '-05:00'),
(next_id('1_time_zones'), 'America/Indiana/Vevay', '-04:00'),
(next_id('1_time_zones'), 'America/Indiana/Vincennes', '-04:00'),
(next_id('1_time_zones'), 'America/Indiana/Winamac', '-04:00'),
(next_id('1_time_zones'), 'America/Inuvik', '-06:00'),
(next_id('1_time_zones'), 'America/Iqaluit', '-04:00'),
(next_id('1_time_zones'), 'America/Jamaica', '-05:00'),
(next_id('1_time_zones'), 'America/Juneau', '-08:00'),
(next_id('1_time_zones'), 'America/Kentucky/Louisville', '-04:00'),
(next_id('1_time_zones'), 'America/Kentucky/Monticello', '-04:00'),
(next_id('1_time_zones'), 'America/Kralendijk', '-04:00'),
(next_id('1_time_zones'), 'America/La_Paz', '-04:00'),
(next_id('1_time_zones'), 'America/Lima', '-05:00'),
(next_id('1_time_zones'), 'America/Los_Angeles', '-07:00'),
(next_id('1_time_zones'), 'America/Lower_Princes', '-04:00'),
(next_id('1_time_zones'), 'America/Maceio', '-03:00'),
(next_id('1_time_zones'), 'America/Managua', '-06:00'),
(next_id('1_time_zones'), 'America/Manaus', '-04:00'),
(next_id('1_time_zones'), 'America/Marigot', '-04:00'),
(next_id('1_time_zones'), 'America/Martinique', '-04:00'),
(next_id('1_time_zones'), 'America/Matamoros', '-05:00'),
(next_id('1_time_zones'), 'America/Mazatlan', '-06:00'),
(next_id('1_time_zones'), 'America/Menominee', '-05:00'),
(next_id('1_time_zones'), 'America/Merida', '-05:00'),
(next_id('1_time_zones'), 'America/Metlakatla', '-08:00'),
(next_id('1_time_zones'), 'America/Mexico_City', '-05:00'),
(next_id('1_time_zones'), 'America/Miquelon', '-02:00'),
(next_id('1_time_zones'), 'America/Moncton', '-03:00'),
(next_id('1_time_zones'), 'America/Monterrey', '-05:00'),
(next_id('1_time_zones'), 'America/Montevideo', '-03:00'),
(next_id('1_time_zones'), 'America/Montserrat', '-04:00'),
(next_id('1_time_zones'), 'America/Nassau', '-04:00'),
(next_id('1_time_zones'), 'America/New_York', '-04:00'),
(next_id('1_time_zones'), 'America/Nipigon', '-04:00'),
(next_id('1_time_zones'), 'America/Nome', '-08:00'),
(next_id('1_time_zones'), 'America/Noronha', '-02:00'),
(next_id('1_time_zones'), 'America/North_Dakota/Beulah', '-05:00'),
(next_id('1_time_zones'), 'America/North_Dakota/Center', '-05:00'),
(next_id('1_time_zones'), 'America/North_Dakota/New_Salem', '-05:00'),
(next_id('1_time_zones'), 'America/Ojinaga', '-06:00'),
(next_id('1_time_zones'), 'America/Panama', '-05:00'),
(next_id('1_time_zones'), 'America/Pangnirtung', '-04:00'),
(next_id('1_time_zones'), 'America/Paramaribo', '-03:00'),
(next_id('1_time_zones'), 'America/Phoenix', '-07:00'),
(next_id('1_time_zones'), 'America/Port-au-Prince', '-04:00'),
(next_id('1_time_zones'), 'America/Port_of_Spain', '-04:00'),
(next_id('1_time_zones'), 'America/Porto_Velho', '-04:00'),
(next_id('1_time_zones'), 'America/Puerto_Rico', '-04:00'),
(next_id('1_time_zones'), 'America/Punta_Arenas', '-03:00'),
(next_id('1_time_zones'), 'America/Rainy_River', '-05:00'),
(next_id('1_time_zones'), 'America/Rankin_Inlet', '-05:00'),
(next_id('1_time_zones'), 'America/Recife', '-03:00'),
(next_id('1_time_zones'), 'America/Regina', '-06:00'),
(next_id('1_time_zones'), 'America/Resolute', '-05:00'),
(next_id('1_time_zones'), 'America/Rio_Branco', '-05:00'),
(next_id('1_time_zones'), 'America/Santarem', '-03:00'),
(next_id('1_time_zones'), 'America/Santiago', '-04:00'),
(next_id('1_time_zones'), 'America/Santo_Domingo', '-04:00'),
(next_id('1_time_zones'), 'America/Sao_Paulo', '-03:00'),
(next_id('1_time_zones'), 'America/Scoresbysund', 'UTC'),
(next_id('1_time_zones'), 'America/Sitka', '-08:00'),
(next_id('1_time_zones'), 'America/St_Barthelemy', '-04:00'),
(next_id('1_time_zones'), 'America/St_Johns', '-02:30'),
(next_id('1_time_zones'), 'America/St_Kitts', '-04:00'),
(next_id('1_time_zones'), 'America/St_Lucia', '-04:00'),
(next_id('1_time_zones'), 'America/St_Thomas', '-04:00'),
(next_id('1_time_zones'), 'America/St_Vincent', '-04:00'),
(next_id('1_time_zones'), 'America/Swift_Current', '-06:00'),
(next_id('1_time_zones'), 'America/Tegucigalpa', '-06:00'),
(next_id('1_time_zones'), 'America/Thule', '-03:00'),
(next_id('1_time_zones'), 'America/Thunder_Bay', '-04:00'),
(next_id('1_time_zones'), 'America/Tijuana', '-07:00'),
(next_id('1_time_zones'), 'America/Toronto', '-04:00'),
(next_id('1_time_zones'), 'America/Tortola', '-04:00'),
(next_id('1_time_zones'), 'America/Vancouver', '-07:00'),
(next_id('1_time_zones'), 'America/Whitehorse', '-07:00'),
(next_id('1_time_zones'), 'America/Winnipeg', '-05:00'),
(next_id('1_time_zones'), 'America/Yakutat', '-08:00'),
(next_id('1_time_zones'), 'America/Yellowknife', '-06:00'),
(next_id('1_time_zones'), 'Antarctica/Casey', '+08:00'),
(next_id('1_time_zones'), 'Antarctica/Davis', '+07:00'),
(next_id('1_time_zones'), 'Antarctica/DumontDUrville', '+10:00'),
(next_id('1_time_zones'), 'Antarctica/Macquarie', '+11:00'),
(next_id('1_time_zones'), 'Antarctica/Mawson', '+05:00'),
(next_id('1_time_zones'), 'Antarctica/McMurdo', '+12:00'),
(next_id('1_time_zones'), 'Antarctica/Palmer', '-03:00'),
(next_id('1_time_zones'), 'Antarctica/Rothera', '-03:00'),
(next_id('1_time_zones'), 'Antarctica/Syowa', '+03:00'),
(next_id('1_time_zones'), 'Antarctica/Troll', '+02:00'),
(next_id('1_time_zones'), 'Antarctica/Vostok', '+06:00'),
(next_id('1_time_zones'), 'Arctic/Longyearbyen', '+02:00'),
(next_id('1_time_zones'), 'Asia/Aden', '+03:00'),
(next_id('1_time_zones'), 'Asia/Almaty', '+06:00'),
(next_id('1_time_zones'), 'Asia/Amman', '+03:00'),
(next_id('1_time_zones'), 'Asia/Anadyr', '+12:00'),
(next_id('1_time_zones'), 'Asia/Aqtau', '+05:00'),
(next_id('1_time_zones'), 'Asia/Aqtobe', '+05:00'),
(next_id('1_time_zones'), 'Asia/Ashgabat', '+05:00'),
(next_id('1_time_zones'), 'Asia/Atyrau', '+05:00'),
(next_id('1_time_zones'), 'Asia/Baghdad', '+03:00'),
(next_id('1_time_zones'), 'Asia/Bahrain', '+03:00'),
(next_id('1_time_zones'), 'Asia/Baku', '+04:00'),
(next_id('1_time_zones'), 'Asia/Bangkok', '+07:00'),
(next_id('1_time_zones'), 'Asia/Barnaul', '+07:00'),
(next_id('1_time_zones'), 'Asia/Beirut', '+03:00'),
(next_id('1_time_zones'), 'Asia/Bishkek', '+06:00'),
(next_id('1_time_zones'), 'Asia/Brunei', '+08:00'),
(next_id('1_time_zones'), 'Asia/Chita', '+09:00'),
(next_id('1_time_zones'), 'Asia/Choibalsan', '+08:00'),
(next_id('1_time_zones'), 'Asia/Colombo', '+05:30'),
(next_id('1_time_zones'), 'Asia/Damascus', '+03:00'),
(next_id('1_time_zones'), 'Asia/Dhaka', '+06:00'),
(next_id('1_time_zones'), 'Asia/Dili', '+09:00'),
(next_id('1_time_zones'), 'Asia/Dubai', '+04:00'),
(next_id('1_time_zones'), 'Asia/Dushanbe', '+05:00'),
(next_id('1_time_zones'), 'Asia/Famagusta', '+03:00'),
(next_id('1_time_zones'), 'Asia/Gaza', '+03:00'),
(next_id('1_time_zones'), 'Asia/Hebron', '+03:00'),
(next_id('1_time_zones'), 'Asia/Ho_Chi_Minh', '+07:00'),
(next_id('1_time_zones'), 'Asia/Hong_Kong', '+08:00'),
(next_id('1_time_zones'), 'Asia/Hovd', '+07:00'),
(next_id('1_time_zones'), 'Asia/Irkutsk', '+08:00'),
(next_id('1_time_zones'), 'Asia/Jakarta', '+07:00'),
(next_id('1_time_zones'), 'Asia/Jayapura', '+09:00'),
(next_id('1_time_zones'), 'Asia/Jerusalem', '+03:00'),
(next_id('1_time_zones'), 'Asia/Kabul', '+04:30'),
(next_id('1_time_zones'), 'Asia/Kamchatka', '+12:00'),
(next_id('1_time_zones'), 'Asia/Karachi', '+05:00'),
(next_id('1_time_zones'), 'Asia/Kathmandu', '+05:45'),
(next_id('1_time_zones'), 'Asia/Khandyga', '+09:00'),
(next_id('1_time_zones'), 'Asia/Kolkata', '+05:30'),
(next_id('1_time_zones'), 'Asia/Krasnoyarsk', '+07:00'),
(next_id('1_time_zones'), 'Asia/Kuala_Lumpur', '+08:00'),
(next_id('1_time_zones'), 'Asia/Kuching', '+08:00'),
(next_id('1_time_zones'), 'Asia/Kuwait', '+03:00'),
(next_id('1_time_zones'), 'Asia/Macau', '+08:00'),
(next_id('1_time_zones'), 'Asia/Magadan', '+11:00'),
(next_id('1_time_zones'), 'Asia/Makassar', '+08:00'),
(next_id('1_time_zones'), 'Asia/Manila', '+08:00'),
(next_id('1_time_zones'), 'Asia/Muscat', '+04:00'),
(next_id('1_time_zones'), 'Asia/Nicosia', '+03:00'),
(next_id('1_time_zones'), 'Asia/Novokuznetsk', '+07:00'),
(next_id('1_time_zones'), 'Asia/Novosibirsk', '+07:00'),
(next_id('1_time_zones'), 'Asia/Omsk', '+06:00'),
(next_id('1_time_zones'), 'Asia/Oral', '+05:00'),
(next_id('1_time_zones'), 'Asia/Phnom_Penh', '+07:00'),
(next_id('1_time_zones'), 'Asia/Pontianak', '+07:00'),
(next_id('1_time_zones'), 'Asia/Pyongyang', '+09:00'),
(next_id('1_time_zones'), 'Asia/Qatar', '+03:00'),
(next_id('1_time_zones'), 'Asia/Qostanay', '+06:00'),
(next_id('1_time_zones'), 'Asia/Qyzylorda', '+05:00'),
(next_id('1_time_zones'), 'Asia/Riyadh', '+03:00'),
(next_id('1_time_zones'), 'Asia/Sakhalin', '+11:00'),
(next_id('1_time_zones'), 'Asia/Samarkand', '+05:00'),
(next_id('1_time_zones'), 'Asia/Seoul', '+09:00'),
(next_id('1_time_zones'), 'Asia/Shanghai', '+08:00'),
(next_id('1_time_zones'), 'Asia/Singapore', '+08:00'),
(next_id('1_time_zones'), 'Asia/Srednekolymsk', '+11:00'),
(next_id('1_time_zones'), 'Asia/Taipei', '+08:00'),
(next_id('1_time_zones'), 'Asia/Tashkent', '+05:00'),
(next_id('1_time_zones'), 'Asia/Tbilisi', '+04:00'),
(next_id('1_time_zones'), 'Asia/Tehran', '+04:30'),
(next_id('1_time_zones'), 'Asia/Thimphu', '+06:00'),
(next_id('1_time_zones'), 'Asia/Tokyo', '+09:00'),
(next_id('1_time_zones'), 'Asia/Tomsk', '+07:00'),
(next_id('1_time_zones'), 'Asia/Ulaanbaatar', '+08:00'),
(next_id('1_time_zones'), 'Asia/Urumqi', '+06:00'),
(next_id('1_time_zones'), 'Asia/Ust-Nera', '+10:00'),
(next_id('1_time_zones'), 'Asia/Vientiane', '+07:00'),
(next_id('1_time_zones'), 'Asia/Vladivostok', '+10:00'),
(next_id('1_time_zones'), 'Asia/Yakutsk', '+09:00'),
(next_id('1_time_zones'), 'Asia/Yangon', '+06:30'),
(next_id('1_time_zones'), 'Asia/Yekaterinburg', '+05:00'),
(next_id('1_time_zones'), 'Asia/Yerevan', '+04:00'),
(next_id('1_time_zones'), 'Atlantic/Azores', 'UTC'),
(next_id('1_time_zones'), 'Atlantic/Bermuda', '-03:00'),
(next_id('1_time_zones'), 'Atlantic/Canary', '+01:00'),
(next_id('1_time_zones'), 'Atlantic/Cape_Verde', '-01:00'),
(next_id('1_time_zones'), 'Atlantic/Faroe', '+01:00'),
(next_id('1_time_zones'), 'Atlantic/Madeira', '+01:00'),
(next_id('1_time_zones'), 'Atlantic/Reykjavik', 'UTC'),
(next_id('1_time_zones'), 'Atlantic/South_Georgia', '-02:00'),
(next_id('1_time_zones'), 'Atlantic/St_Helena', 'UTC'),
(next_id('1_time_zones'), 'Atlantic/Stanley', '-03:00'),
(next_id('1_time_zones'), 'Australia/Adelaide', '+09:30'),
(next_id('1_time_zones'), 'Australia/Brisbane', '+10:00'),
(next_id('1_time_zones'), 'Australia/Broken_Hill', '+09:30'),
(next_id('1_time_zones'), 'Australia/Currie', '+10:00'),
(next_id('1_time_zones'), 'Australia/Darwin', '+09:30'),
(next_id('1_time_zones'), 'Australia/Eucla', '+08:45'),
(next_id('1_time_zones'), 'Australia/Hobart', '+10:00'),
(next_id('1_time_zones'), 'Australia/Lindeman', '+10:00'),
(next_id('1_time_zones'), 'Australia/Lord_Howe', '+10:30'),
(next_id('1_time_zones'), 'Australia/Melbourne', '+10:00'),
(next_id('1_time_zones'), 'Australia/Perth', '+08:00'),
(next_id('1_time_zones'), 'Australia/Sydney', '+10:00'),
(next_id('1_time_zones'), 'Europe/Amsterdam', '+02:00'),
(next_id('1_time_zones'), 'Europe/Andorra', '+02:00'),
(next_id('1_time_zones'), 'Europe/Astrakhan', '+04:00'),
(next_id('1_time_zones'), 'Europe/Athens', '+03:00'),
(next_id('1_time_zones'), 'Europe/Belgrade', '+02:00'),
(next_id('1_time_zones'), 'Europe/Berlin', '+02:00'),
(next_id('1_time_zones'), 'Europe/Bratislava', '+02:00'),
(next_id('1_time_zones'), 'Europe/Brussels', '+02:00'),
(next_id('1_time_zones'), 'Europe/Bucharest', '+03:00'),
(next_id('1_time_zones'), 'Europe/Budapest', '+02:00'),
(next_id('1_time_zones'), 'Europe/Busingen', '+02:00'),
(next_id('1_time_zones'), 'Europe/Chisinau', '+03:00'),
(next_id('1_time_zones'), 'Europe/Copenhagen', '+02:00'),
(next_id('1_time_zones'), 'Europe/Dublin', '+01:00'),
(next_id('1_time_zones'), 'Europe/Gibraltar', '+02:00'),
(next_id('1_time_zones'), 'Europe/Guernsey', '+01:00'),
(next_id('1_time_zones'), 'Europe/Helsinki', '+03:00'),
(next_id('1_time_zones'), 'Europe/Isle_of_Man', '+01:00'),
(next_id('1_time_zones'), 'Europe/Istanbul', '+03:00'),
(next_id('1_time_zones'), 'Europe/Jersey', '+01:00'),
(next_id('1_time_zones'), 'Europe/Kaliningrad', '+02:00'),
(next_id('1_time_zones'), 'Europe/Kiev', '+03:00'),
(next_id('1_time_zones'), 'Europe/Kirov', '+03:00'),
(next_id('1_time_zones'), 'Europe/Lisbon', '+01:00'),
(next_id('1_time_zones'), 'Europe/Ljubljana', '+02:00'),
(next_id('1_time_zones'), 'Europe/London', '+01:00'),
(next_id('1_time_zones'), 'Europe/Luxembourg', '+02:00'),
(next_id('1_time_zones'), 'Europe/Madrid', '+02:00'),
(next_id('1_time_zones'), 'Europe/Malta', '+02:00'),
(next_id('1_time_zones'), 'Europe/Mariehamn', '+03:00'),
(next_id('1_time_zones'), 'Europe/Minsk', '+03:00'),
(next_id('1_time_zones'), 'Europe/Monaco', '+02:00'),
(next_id('1_time_zones'), 'Europe/Moscow', '+03:00'),
(next_id('1_time_zones'), 'Europe/Oslo', '+02:00'),
(next_id('1_time_zones'), 'Europe/Paris', '+02:00'),
(next_id('1_time_zones'), 'Europe/Podgorica', '+02:00'),
(next_id('1_time_zones'), 'Europe/Prague', '+02:00'),
(next_id('1_time_zones'), 'Europe/Riga', '+03:00'),
(next_id('1_time_zones'), 'Europe/Rome', '+02:00'),
(next_id('1_time_zones'), 'Europe/Samara', '+04:00'),
(next_id('1_time_zones'), 'Europe/San_Marino', '+02:00'),
(next_id('1_time_zones'), 'Europe/Sarajevo', '+02:00'),
(next_id('1_time_zones'), 'Europe/Saratov', '+04:00'),
(next_id('1_time_zones'), 'Europe/Simferopol', '+03:00'),
(next_id('1_time_zones'), 'Europe/Skopje', '+02:00'),
(next_id('1_time_zones'), 'Europe/Sofia', '+03:00'),
(next_id('1_time_zones'), 'Europe/Stockholm', '+02:00'),
(next_id('1_time_zones'), 'Europe/Tallinn', '+03:00'),
(next_id('1_time_zones'), 'Europe/Tirane', '+02:00'),
(next_id('1_time_zones'), 'Europe/Ulyanovsk', '+04:00'),
(next_id('1_time_zones'), 'Europe/Uzhgorod', '+03:00'),
(next_id('1_time_zones'), 'Europe/Vaduz', '+02:00'),
(next_id('1_time_zones'), 'Europe/Vatican', '+02:00'),
(next_id('1_time_zones'), 'Europe/Vienna', '+02:00'),
(next_id('1_time_zones'), 'Europe/Vilnius', '+03:00'),
(next_id('1_time_zones'), 'Europe/Volgograd', '+04:00'),
(next_id('1_time_zones'), 'Europe/Warsaw', '+02:00'),
(next_id('1_time_zones'), 'Europe/Zagreb', '+02:00'),
(next_id('1_time_zones'), 'Europe/Zaporozhye', '+03:00'),
(next_id('1_time_zones'), 'Europe/Zurich', '+02:00'),
(next_id('1_time_zones'), 'Indian/Antananarivo', '+03:00'),
(next_id('1_time_zones'), 'Indian/Chagos', '+06:00'),
(next_id('1_time_zones'), 'Indian/Christmas', '+07:00'),
(next_id('1_time_zones'), 'Indian/Cocos', '+06:30'),
(next_id('1_time_zones'), 'Indian/Comoro', '+03:00'),
(next_id('1_time_zones'), 'Indian/Kerguelen', '+05:00'),
(next_id('1_time_zones'), 'Indian/Mahe', '+04:00'),
(next_id('1_time_zones'), 'Indian/Maldives', '+05:00'),
(next_id('1_time_zones'), 'Indian/Mauritius', '+04:00'),
(next_id('1_time_zones'), 'Indian/Mayotte', '+03:00'),
(next_id('1_time_zones'), 'Indian/Reunion', '+04:00'),
(next_id('1_time_zones'), 'Pacific/Apia', '+13:00'),
(next_id('1_time_zones'), 'Pacific/Auckland', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Bougainville', '+11:00'),
(next_id('1_time_zones'), 'Pacific/Chatham', '+12:45'),
(next_id('1_time_zones'), 'Pacific/Chuuk', '+10:00'),
(next_id('1_time_zones'), 'Pacific/Easter', '-06:00'),
(next_id('1_time_zones'), 'Pacific/Efate', '+11:00'),
(next_id('1_time_zones'), 'Pacific/Enderbury', '+13:00'),
(next_id('1_time_zones'), 'Pacific/Fakaofo', '+13:00'),
(next_id('1_time_zones'), 'Pacific/Fiji', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Funafuti', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Galapagos', '-06:00'),
(next_id('1_time_zones'), 'Pacific/Gambier', '-09:00'),
(next_id('1_time_zones'), 'Pacific/Guadalcanal', '+11:00'),
(next_id('1_time_zones'), 'Pacific/Guam', '+10:00'),
(next_id('1_time_zones'), 'Pacific/Honolulu', '-10:00'),
(next_id('1_time_zones'), 'Pacific/Kiritimati', '+14:00'),
(next_id('1_time_zones'), 'Pacific/Kosrae', '+11:00'),
(next_id('1_time_zones'), 'Pacific/Kwajalein', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Majuro', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Marquesas', '-09:30'),
(next_id('1_time_zones'), 'Pacific/Midway', '-11:00'),
(next_id('1_time_zones'), 'Pacific/Nauru', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Niue', '-11:00'),
(next_id('1_time_zones'), 'Pacific/Norfolk', '+11:00'),
(next_id('1_time_zones'), 'Pacific/Noumea', '+11:00'),
(next_id('1_time_zones'), 'Pacific/Pago_Pago', '-11:00'),
(next_id('1_time_zones'), 'Pacific/Palau', '+09:00'),
(next_id('1_time_zones'), 'Pacific/Pitcairn', '-08:00'),
(next_id('1_time_zones'), 'Pacific/Pohnpei', '+11:00'),
(next_id('1_time_zones'), 'Pacific/Port_Moresby', '+10:00'),
(next_id('1_time_zones'), 'Pacific/Rarotonga', '-10:00'),
(next_id('1_time_zones'), 'Pacific/Saipan', '+10:00'),
(next_id('1_time_zones'), 'Pacific/Tahiti', '-10:00'),
(next_id('1_time_zones'), 'Pacific/Tarawa', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Tongatapu', '+13:00'),
(next_id('1_time_zones'), 'Pacific/Wake', '+12:00'),
(next_id('1_time_zones'), 'Pacific/Wallis', '+12:00')
`