INSERT INTO `tz_timezone` (`zone_id`, `abbreviation`, `time_start`, `gmt_offset`, `dst`, `is_valid_zone`) VALUES
(87, 'AST', 1793509200, -14400, '0', 1),
(87, 'AST', 1825563600, -14400, '0', 1),
(87, 'AST', 183531600, -14400, '0', 1),
(87, 'AST', 1857013200, -14400, '0', 1),
(87, 'AST', 1888462800, -14400, '0', 1),
(87, 'AST', 1919912400, -14400, '0', 1),
(87, 'AST', 1951362000, -14400, '0', 1),
(87, 'AST', 1983416400, -14400, '0', 1),
(87, 'AST', 2014866000, -14400, '0', 1),
(87, 'AST', 2046315600, -14400, '0', 1),
(87, 'AST', 2077765200, -14400, '0', 1),
(87, 'AST', 2109214800, -14400, '0', 1),
(87, 'AST', 2140664400, -14400, '0', 1),
(87, 'AST', 2147397247, -14400, '0', 1),
(87, 'AST', 2147483647, -14400, '0', 1),
(87, 'AST', 215586000, -14400, '0', 1),
(87, 'AST', 247035600, -14400, '0', 1),
(87, 'AST', 25678800, -14400, '0', 1),
(87, 'AST', 278485200, -14400, '0', 1),
(87, 'AST', 309934800, -14400, '0', 1),
(87, 'AST', 341384400, -14400, '0', 1),
(87, 'AST', 372834000, -14400, '0', 1),
(87, 'AST', 404888400, -14400, '0', 1),
(87, 'AST', 436338000, -14400, '0', 1),
(87, 'AST', 467787600, -14400, '0', 1),
(87, 'AST', 499237200, -14400, '0', 1),
(87, 'AST', 530686800, -14400, '0', 1),
(87, 'AST', 562136400, -14400, '0', 1),
(87, 'AST', 57733200, -14400, '0', 1),
(87, 'AST', 594190800, -14400, '0', 1),
(87, 'AST', 625640400, -14400, '0', 1),
(87, 'AST', 657090000, -14400, '0', 1),
(87, 'AST', 688539600, -14400, '0', 1),
(87, 'AST', 719989200, -14400, '0', 1),
(87, 'AST', 752036460, -14400, '0', 1),
(87, 'AST', 783486060, -14400, '0', 1),
(87, 'AST', 814935660, -14400, '0', 1),
(87, 'AST', 846385260, -14400, '0', 1),
(87, 'AST', 877834860, -14400, '0', 1),
(87, 'AST', 89182800, -14400, '0', 1),
(87, 'AST', 909284460, -14400, '0', 1),
(87, 'AST', 941338860, -14400, '0', 1),
(87, 'AST', 972788460, -14400, '0', 1),
(87, 'AWT', -880221600, -10800, '1', 0),
(87, 'EST', -2147397248, -18000, '0', 0),
(87, 'EST', -2147483648, -18000, '0', 0),
(88, 'ADDT', 576043260, -7200, '1', 0),
(88, 'ADT', -116445600, -10800, '1', 1),
(88, 'ADT', -21492000, -10800, '1', 1),
(88, 'ADT', -52941600, -10800, '1', 1),
(88, 'ADT', -84391200, -10800, '1', 1),
(88, 'ADT', 1018152060, -10800, '1', 1),
(88, 'ADT', 104911200, -10800, '1', 1),
(88, 'ADT', 1049601660, -10800, '1', 1),
(88, 'ADT', 1081051260, -10800, '1', 1),
(88, 'ADT', 1112500860, -10800, '1', 1),
(88, 'ADT', 1143950460, -10800, '1', 1),
(88, 'ADT', 1173585660, -10800, '1', 1),
(88, 'ADT', 1205035260, -10800, '1', 1),
(88, 'ADT', 1236484860, -10800, '1', 1),
(88, 'ADT', 1268539260, -10800, '1', 1),
(88, 'ADT', 1299988860, -10800, '1', 1),
(88, 'ADT', 1331445600, -10800, '1', 1),
(88, 'ADT', 1362895200, -10800, '1', 1),
(88, 'ADT', 136360800, -10800, '1', 1),
(88, 'ADT', 1394344800, -10800, '1', 1),
(88, 'ADT', 1425794400, -10800, '1', 1),
(88, 'ADT', 1457848800, -10800, '1', 1),
(88, 'ADT', 1489298400, -10800, '1', 1),
(88, 'ADT', 1520748000, -10800, '1', 1),
(88, 'ADT', 1552197600, -10800, '1', 1),
(88, 'ADT', 1583647200, -10800, '1', 1),
(88, 'ADT', 1615701600, -10800, '1', 1),
(88, 'ADT', 1647151200, -10800, '1', 1),
(88, 'ADT', 167810400, -10800, '1', 1),
(88, 'ADT', 1678600800, -10800, '1', 1),
(88, 'ADT', 1710050400, -10800, '1', 1),
(88, 'ADT', 1741500000, -10800, '1', 1),
(88, 'ADT', 1772949600, -10800, '1', 1),
(88, 'ADT', 1805004000, -10800, '1', 1),
(88, 'ADT', 1836453600, -10800, '1', 1),
(88, 'ADT', 1867903200, -10800, '1', 1),
(88, 'ADT', 1899352800, -10800, '1', 1),
(88, 'ADT', 1930802400, -10800, '1', 1),
(88, 'ADT', 1962856800, -10800, '1', 1),
(88, 'ADT', 199260000, -10800, '1', 1),
(88, 'ADT', 1994306400, -10800, '1', 1),
(88, 'ADT', 2025756000, -10800, '1', 1),
(88, 'ADT', 2057205600, -10800, '1', 1),
(88, 'ADT', 2088655200, -10800, '1', 1),
(88, 'ADT', 2120104800, -10800, '1', 1),
(88, 'ADT', 230709600, -10800, '1', 1),
(88, 'ADT', 262764000, -10800, '1', 1),
(88, 'ADT', 294213600, -10800, '1', 1),
(88, 'ADT', 325663200, -10800, '1', 1),
(88, 'ADT', 357112800, -10800, '1', 1),
(88, 'ADT', 388562400, -10800, '1', 1),
(88, 'ADT', 41407200, -10800, '1', 1),
(88, 'ADT', 420012000, -10800, '1', 1),
(88, 'ADT', 452066400, -10800, '1', 1),
(88, 'ADT', 483516000, -10800, '1', 1),
(88, 'ADT', 514965600, -10800, '1', 1),
(88, 'ADT', 544593660, -10800, '1', 1),
(88, 'ADT', 607492860, -10800, '1', 1),
(88, 'ADT', 638942460, -10800, '1', 1),
(88, 'ADT', 670996860, -10800, '1', 1),
(88, 'ADT', 702446460, -10800, '1', 1),
(88, 'ADT', 733896060, -10800, '1', 1),
(88, 'ADT', 73461600, -10800, '1', 1),
(88, 'ADT', 765345660, -10800, '1', 1),
(88, 'ADT', 796795260, -10800, '1', 1),
(88, 'ADT', 828849660, -10800, '1', 1),
(88, 'ADT', 860299260, -10800, '1', 1),
(88, 'ADT', 891748860, -10800, '1', 1),
(88, 'ADT', 923198460, -10800, '1', 1),
(88, 'ADT', 954648060, -10800, '1', 1),
(88, 'ADT', 986097660, -10800, '1', 1),
(88, 'ADT', 9957600, -10800, '1', 1),
(88, 'AST', -100119600, -14400, '0', 1),
(88, 'AST', -119903400, -14400, '0', 1),
(88, 'AST', -37220400, -14400, '0', 1),
(88, 'AST', -5770800, -14400, '0', 1),
(88, 'AST', -68670000, -14400, '0', 1),
(88, 'AST', 1004238060, -14400, '0', 1),
(88, 'AST', 1035687660, -14400, '0', 1),
(88, 'AST', 1067137260, -14400, '0', 1),
(88, 'AST', 1099191660, -14400, '0', 1),
(88, 'AST', 1130641260, -14400, '0', 1),
(88, 'AST', 1162090860, -14400, '0', 1),
(88, 'AST', 1194145260, -14400, '0', 1),
(88, 'AST', 120632400, -14400, '0', 1),
(88, 'AST', 1225594860, -14400, '0', 1),
(88, 'AST', 1257044460, -14400, '0', 1),
(88, 'AST', 1289098860, -14400, '0', 1),
(88, 'AST', 1320555600, -14400, '0', 1),
(88, 'AST', 1352005200, -14400, '0', 1),
(88, 'AST', 1383454800, -14400, '0', 1),
(88, 'AST', 1414904400, -14400, '0', 1),
(88, 'AST', 1446354000, -14400, '0', 1),
(88, 'AST', 1478408400, -14400, '0', 1),
(88, 'AST', 1509858000, -14400, '0', 1),
(88, 'AST', 152082000, -14400, '0', 1),
(88, 'AST', 1541307600, -14400, '0', 1),
(88, 'AST', 1572757200, -14400, '0', 1),
(88, 'AST', 1604206800, -14400, '0', 1),
(88, 'AST', 1636261200, -14400, '0', 1),
(88, 'AST', 1667710800, -14400, '0', 1),
(88, 'AST', 1699160400, -14400, '0', 1),
(88, 'AST', 1730610000, -14400, '0', 1),
(88, 'AST', 1762059600, -14400, '0', 1),
(88, 'AST', 1793509200, -14400, '0', 1),
(88, 'AST', 1825563600, -14400, '0', 1),
(88, 'AST', 183531600, -14400, '0', 1),
(88, 'AST', 1857013200, -14400, '0', 1),
(88, 'AST', 1888462800, -14400, '0', 1),
(88, 'AST', 1919912400, -14400, '0', 1),
(88, 'AST', 1951362000, -14400, '0', 1),
(88, 'AST', 1983416400, -14400, '0', 1),
(88, 'AST', 2014866000, -14400, '0', 1),
(88, 'AST', 2046315600, -14400, '0', 1),
(88, 'AST', 2077765200, -14400, '0', 1),
(88, 'AST', 2109214800, -14400, '0', 1),
(88, 'AST', 2140664400, -14400, '0', 1),
(88, 'AST', 2147397247, -14400, '0', 1),
(88, 'AST', 2147483647, -14400, '0', 1),
(88, 'AST', 215586000, -14400, '0', 1),
(88, 'AST', 247035600, -14400, '0', 1),
(88, 'AST', 25678800, -14400, '0', 1),
(88, 'AST', 278485200, -14400, '0', 1),
(88, 'AST', 309934800, -14400, '0', 1),
(88, 'AST', 341384400, -14400, '0', 1),
(88, 'AST', 372834000, -14400, '0', 1),
(88, 'AST', 404888400, -14400, '0', 1),
(88, 'AST', 436338000, -14400, '0', 1),
(88, 'AST', 467787600, -14400, '0', 1),
(88, 'AST', 499237200, -14400, '0', 1),
(88, 'AST', 530686800, -14400, '0', 1),
(88, 'AST', 562129260, -14400, '0', 1),
(88, 'AST', 57733200, -14400, '0', 1),
(88, 'AST', 594180060, -14400, '0', 1),
(88, 'AST', 625633260, -14400, '0', 1),
(88, 'AST', 657082860, -14400, '0', 1),
(88, 'AST', 688532460, -14400, '0', 1),
(88, 'AST', 719982060, -14400, '0', 1),
(88, 'AST', 752036460, -14400, '0', 1),
(88, 'AST', 783486060, -14400, '0', 1),
(88, 'AST', 814935660, -14400, '0', 1),
(88, 'AST', 846385260, -14400, '0', 1),
(88, 'AST', 877834860, -14400, '0', 1),
(88, 'AST', 89182800, -14400, '0', 1),
(88, 'AST', 909284460, -14400, '0', 1),
(88, 'AST', 941338860, -14400, '0', 1),
(88, 'AST', 972788460, -14400, '0', 1),
(88, 'NDT', -1030221000, -9000, '1', 0),
(88, 'NDT', -1061670600, -9000, '1', 0),
(88, 'NDT', -147897000, -9000, '1', 0),
(88, 'NDT', -1632076148, -9052, '1', 1),
(88, 'NDT', -179346600, -9000, '1', 0),
(88, 'NDT', -210796200, -9000, '1', 0),
(88, 'NDT', -242245800, -9000, '1', 0),
(88, 'NDT', -273695400, -9000, '1', 0),
(88, 'NDT', -305749800, -9000, '1', 0),
(88, 'NDT', -337199400, -9000, '1', 0),
(88, 'NDT', -368649000, -9000, '1', 0),
(88, 'NDT', -400098600, -9000, '1', 0),
(88, 'NDT', -431548200, -9000, '1', 0),
(88, 'NDT', -463602600, -9000, '1', 0),
(88, 'NDT', -495052200, -9000, '1', 0),
(88, 'NDT', -526501800, -9000, '1', 0),
(88, 'NDT', -557951400, -9000, '1', 0),
(88, 'NDT', -589401000, -9000, '1', 0),
(88, 'NDT', -619641000, -9000, '1', 0),
(88, 'NDT', -651695400, -9000, '1', 0),
(88, 'NDT', -683145000, -9000, '1', 0),
(88, 'NDT', -714594600, -9000, '1', 0),
(88, 'NDT', -746044200, -9000, '1', 0),
(88, 'NDT', -903817800, -9000, '1', 0),
(88, 'NDT', -935267400, -9000, '1', 0),
(88, 'NDT', -966717000, -9000, '1', 0),
(88, 'NDT', -998771400, -9000, '1', 0),
(88, 'NPT', -769395600, -9000, '1', 0),
(88, 'NST', -1017523800, -12600, '0', 0),
(88, 'NST', -1048973400, -12600, '0', 0),
(88, 'NST', -1096921748, -12600, '0', 0),
(88, 'NST', -131571000, -12600, '0', 0),
(88, 'NST', -1615145348, -12652, '0', 1),
(88, 'NST', -163625400, -12600, '0', 0),
(88, 'NST', -195075000, -12600, '0', 0),
(88, 'NST', -2147397248, -12652, '0', 1),
(88, 'NST', -2147483648, -12652, '0', 1),
(88, 'NST', -226524600, -12600, '0', 0),
(88, 'NST', -257974200, -12600, '0', 0),
(88, 'NST', -289423800, -12600, '0', 0),
(88, 'NST', -323897400, -12600, '0', 0),
(88, 'NST', -355347000, -12600, '0', 0),
(88, 'NST', -386796600, -12600, '0', 0),
(88, 'NST', -418246200, -12600, '0', 0),
(88, 'NST', -450300600, -12600, '0', 0),
(88, 'NST', -481750200, -12600, '0', 0),
(88, 'NST', -513199800, -12600, '0', 0),
(88, 'NST', -544649400, -12600, '0', 0),
(88, 'NST', -576099000, -12600, '0', 0),
(88, 'NST', -606943800, -12600, '0', 0),
(88, 'NST', -638998200, -12600, '0', 0),
(88, 'NST', -670447800, -12600, '0', 0),
(88, 'NST', -701897400, -12600, '0', 0),
(88, 'NST', -733347000, -12600, '0', 0),
(88, 'NST', -765401400, -12600, '0', 0),
(88, 'NST', -891120600, -12600, '0', 0),
(88, 'NST', -922570200, -12600, '0', 0),
(88, 'NST', -954624600, -12600, '0', 0),
(88, 'NST', -986074200, -12600, '0', 0),
(88, 'NWT', -872368200, -9000, '1', 0),
(89, 'ADT', -1632074400, -10800, '1', 0),
(89, 'APT', -769395600, -10800, '1', 0),
(89, 'AST', -1615143600, -14400, '0', 1),
(89, 'AST', -2147397248, -14400, '0', 1),
(89, 'AST', -2147483648, -14400, '0', 1),
(89, 'AST', -765399600, -14400, '0', 1),
(89, 'AST', 2147397247, -14400, '0', 1),
(89, 'AST', 2147483647, -14400, '0', 1),
(89, 'AWT', -880221600, -10800, '1', 0),
(9, 'NZDT', 1002376800, 46800, '1', 1),
(9, 'NZDT', 1033826400, 46800, '1', 1),
(9, 'NZDT', 1065276000, 46800, '1', 1),
(9, 'NZDT', 1096725600, 46800, '1', 1),
(9, 'NZDT', 1128175200, 46800, '1', 1),
(9, 'NZDT', 1159624800, 46800, '1', 1),
(9, 'NZDT', 1191074400, 46800, '1', 1),
(9, 'NZDT', 1222524000, 46800, '1', 1),
(9, 'NZDT', 1253973600, 46800, '1', 1),
(9, 'NZDT', 1285423200, 46800, '1', 1),
(9, 'NZDT', 1316872800, 46800, '1', 1),
(9, 'NZDT', 1348927200, 46800, '1', 1),
(9, 'NZDT', 1380376800, 46800, '1', 1),
(9, 'NZDT', 1411826400, 46800, '1', 1),
(9, 'NZDT', 1443276000, 46800, '1', 1),
(9, 'NZDT', 1474725600, 46800, '1', 1),
(9, 'NZDT', 1506175200, 46800, '1', 1),
(9, 'NZDT', 152632800, 46800, '1', 1),
(9, 'NZDT', 1538229600, 46800, '1', 1),
(9, 'NZDT', 1569679200, 46800, '1', 1),
(9, 'NZDT', 1601128800, 46800, '1', 1),
(9, 'NZDT', 1632578400, 46800, '1', 1),
(9, 'NZDT', 1664028000, 46800, '1', 1),
(9, 'NZDT', 1695477600, 46800, '1', 1),
(9, 'NZDT', 1727532000, 46800, '1', 1),
(9, 'NZDT', 1758981600, 46800, '1', 1),
(9, 'NZDT', 1790431200, 46800, '1', 1),
(9, 'NZDT', 1821880800, 46800, '1', 1),
(9, 'NZDT', 183477600, 46800, '1', 1),
(9, 'NZDT', 1853330400, 46800, '1', 1),
(9, 'NZDT', 1885384800, 46800, '1', 1),
(9, 'NZDT', 1916834400, 46800, '1', 1),
(9, 'NZDT', 1948284000, 46800, '1', 1),
(9, 'NZDT', 1979733600, 46800, '1', 1),
(9, 'NZDT', 2011183200, 46800, '1', 1),
(9, 'NZDT', 2042632800, 46800, '1', 1),
(9, 'NZDT', 2074687200, 46800, '1', 1),
(9, 'NZDT', 2106136800, 46800, '1', 1),
(9, 'NZDT', 2137586400, 46800, '1', 1),
(9, 'NZDT', 2147397247, 46800, '1', 1),
(9, 'NZDT', 2147483647, 46800, '1', 1),
(9, 'NZDT', 215532000, 46800, '1', 1),
(9, 'NZDT', 246981600, 46800, '1', 1),
(9, 'NZDT', 278431200, 46800, '1', 1),
(9, 'NZDT', 309880800, 46800, '1', 1),
(9, 'NZDT', 341330400, 46800, '1', 1),
(9, 'NZDT', 372780000, 46800, '1', 1),
(9, 'NZDT', 404834400, 46800, '1', 1),
(9, 'NZDT', 436284000, 46800, '1', 1),
(9, 'NZDT', 467733600, 46800, '1', 1),
(9, 'NZDT', 499183200, 46800, '1', 1),
(9, 'NZDT', 530632800, 46800, '1', 1),
(9, 'NZDT', 562082400, 46800, '1', 1),
(9, 'NZDT', 594136800, 46800, '1', 1),
(9, 'NZDT', 623772000, 46800, '1', 1),
(9, 'NZDT', 655221600, 46800, '1', 1),
(9, 'NZDT', 686671200, 46800, '1', 1),
(9, 'NZDT', 718120800, 46800, '1', 1),
(9, 'NZDT', 749570400, 46800, '1', 1),
(9, 'NZDT', 781020000, 46800, '1', 1),
(9, 'NZDT', 812469600, 46800, '1', 1),
(9, 'NZDT', 844524000, 46800, '1', 1),
(9, 'NZDT', 875973600, 46800, '1', 1),
(9, 'NZDT', 907423200, 46800, '1', 1),
(9, 'NZDT', 938872800, 46800, '1', 1),
(9, 'NZDT', 970322400, 46800, '1', 1),
(9, 'NZMT', -1000116000, 41400, '0', 1),
(9, 'NZMT', -1031565600, 41400, '0', 1),
(9, 'NZMT', -1063015200, 41400, '0', 1),
(9, 'NZMT', -1094464800, 41400, '0', 1),
(9, 'NZMT', -1125914400, 41400, '0', 1),
(9, 'NZMT', -1160992800, 41400, '0', 1),
(9, 'NZMT', -1192442400, 41400, '0', 1),
(9, 'NZMT', -1224496800, 41400, '0', 1),
(9, 'NZMT', -1255946400, 41400, '0', 1),
(9, 'NZMT', -1287396000, 41400, '0', 1),
(9, 'NZMT', -1320057000, 41400, '0', 1),
(9, 'NZMT', -2147397248, 41400, '0', 1),
(9, 'NZMT', -2147483648, 41400, '0', 1),
(9, 'NZMT', -936612000, 41400, '0', 1),
(9, 'NZMT', -968061600, 41400, '0', 1),
(9, 'NZST', -1018258200, 43200, '1', 1),
(9, 'NZST', -1049707800, 43200, '1', 1),
(9, 'NZST', -1081157400, 43200, '1', 1),
(9, 'NZST', -1112607000, 43200, '1', 1),
(9, 'NZST', -1143451800, 43200, '1', 1),
(9, 'NZST', -1174901400, 43200, '1', 1),
(9, 'NZST', -1206351000, 43200, '1', 1),
(9, 'NZST', -1237800600, 43200, '1', 1),
(9, 'NZST', -1269250200, 43200, '1', 1),
(9, 'NZST', -1300699800, 43200, '1', 1),
(9, 'NZST', -1330335000, 45000, '1', 1),
(9, 'NZST', -757425600, 43200, '0', 1),
(9, 'NZST', -923304600, 43200, '1', 1),
(9, 'NZST', -955359000, 43200, '1', 1),
(9, 'NZST', -986808600, 43200, '1', 1),
(9, 'NZST', 1016287200, 43200, '0', 1),
(9, 'NZST', 1047736800, 43200, '0', 1),
(9, 'NZST', 1079791200, 43200, '0', 1),
(9, 'NZST', 1111240800, 43200, '0', 1),
(9, 'NZST', 1142690400, 43200, '0', 1),
(9, 'NZST', 1174140000, 43200, '0', 1),
(9, 'NZST', 1207404000, 43200, '0', 1),
(9, 'NZST', 1238853600, 43200, '0', 1),
(9, 'NZST', 1270303200, 43200, '0', 1),
(9, 'NZST', 1301752800, 43200, '0', 1),
(9, 'NZST', 1333202400, 43200, '0', 1),
(9, 'NZST', 1365256800, 43200, '0', 1),
(9, 'NZST', 1396706400, 43200, '0', 1),
(9, 'NZST', 1428156000, 43200, '0', 1),
(9, 'NZST', 1459605600, 43200, '0', 1),
(9, 'NZST', 1491055200, 43200, '0', 1),
(9, 'NZST', 1522504800, 43200, '0', 1),
(9, 'NZST', 1554559200, 43200, '0', 1),
(9, 'NZST', 1586008800, 43200, '0', 1),
(9, 'NZST', 1617458400, 43200, '0', 1),
(9, 'NZST', 162309600, 43200, '0', 1),
(9, 'NZST', 1648908000, 43200, '0', 1),
(9, 'NZST', 1680357600, 43200, '0', 1),
(9, 'NZST', 1712412000, 43200, '0', 1),
(9, 'NZST', 1743861600, 43200, '0', 1),
(9, 'NZST', 1775311200, 43200, '0', 1),
(9, 'NZST', 1806760800, 43200, '0', 1),
(9, 'NZST', 1838210400, 43200, '0', 1),
(9, 'NZST', 1869660000, 43200, '0', 1),
(9, 'NZST', 1901714400, 43200, '0', 1),
(9, 'NZST', 1933164000, 43200, '0', 1),
(9, 'NZST', 194968800, 43200, '0', 1),
(9, 'NZST', 1964613600, 43200, '0', 1),
(9, 'NZST', 1996063200, 43200, '0', 1),
(9, 'NZST', 2027512800, 43200, '0', 1),
(9, 'NZST', 2058962400, 43200, '0', 1),
(9, 'NZST', 2091016800, 43200, '0', 1),
(9, 'NZST', 2122466400, 43200, '0', 1),
(9, 'NZST', 226418400, 43200, '0', 1),
(9, 'NZST', 257868000, 43200, '0', 1),
(9, 'NZST', 289317600, 43200, '0', 1),
(9, 'NZST', 320767200, 43200, '0', 1),
(9, 'NZST', 352216800, 43200, '0', 1),
(9, 'NZST', 384271200, 43200, '0', 1),
(9, 'NZST', 415720800, 43200, '0', 1),
(9, 'NZST', 447170400, 43200, '0', 1),
(9, 'NZST', 478620000, 43200, '0', 1),
(9, 'NZST', 510069600, 43200, '0', 1),
(9, 'NZST', 541519200, 43200, '0', 1),
(9, 'NZST', 573573600, 43200, '0', 1),
(9, 'NZST', 605023200, 43200, '0', 1),
(9, 'NZST', 637682400, 43200, '0', 1),
(9, 'NZST', 669132000, 43200, '0', 1),
(9, 'NZST', 700581600, 43200, '0', 1),
(9, 'NZST', 732636000, 43200, '0', 1),
(9, 'NZST', 764085600, 43200, '0', 1),
(9, 'NZST', 795535200, 43200, '0', 1),
(9, 'NZST', 826984800, 43200, '0', 1),
(9, 'NZST', 858434400, 43200, '0', 1),
(9, 'NZST', 889884000, 43200, '0', 1),
(9, 'NZST', 921938400, 43200, '0', 1),
(9, 'NZST', 953388000, 43200, '0', 1),
(9, 'NZST', 984837600, 43200, '0', 1),
(90, 'EDT', -1000054800, -14400, '1', 1),
(90, 'EDT', -1031504400, -14400, '1', 1),
(90, 'EDT', -1062954000, -14400, '1', 1),
(90, 'EDT', -1094403600, -14400, '1', 1),
(90, 'EDT', -1125853200, -14400, '1', 1),
(90, 'EDT', -1157302800, -14400, '1', 1),
(90, 'EDT', -116442000, -14400, '1', 1),
(90, 'EDT', -1188752400, -14400, '1', 1),
(90, 'EDT', -1220806800, -14400, '1', 1),
(90, 'EDT', -1252256400, -14400, '1', 1),
(90, 'EDT', -1283706000, -14400, '1', 1),
(90, 'EDT', -1315155600, -14400, '1', 1),
(90, 'EDT', -1346605200, -14400, '1', 1),
(90, 'EDT', -1378054800, -14400, '1', 1),
(90, 'EDT', -1409504400, -14400, '1', 1),
(90, 'EDT', -1440954000, -14400, '1', 1),
(90, 'EDT', -1471798800, -14400, '1', 1),
(90, 'EDT', -147891600, -14400, '1', 1),
(90, 'EDT', -1503248400, -14400, '1', 1),
(90, 'EDT', -1534698000, -14400, '1', 1),
(90, 'EDT', -1567357200, -14400, '1', 1),
(90, 'EDT', -1601753400, -14400, '1', 1),
(90, 'EDT', -1632070800, -14400, '1', 1),
(90, 'EDT', -179341200, -14400, '1', 1),
(90, 'EDT', -210790800, -14400, '1', 1),
(90, 'EDT', -21488400, -14400, '1', 1),
(90, 'EDT', -242240400, -14400, '1', 1),
(90, 'EDT', -273690000, -14400, '1', 1),
(90, 'EDT', -305744400, -14400, '1', 1),
(90, 'EDT', -337194000, -14400, '1', 1),
(90, 'EDT', -368643600, -14400, '1', 1),
(90, 'EDT', -400093200, -14400, '1', 1),
(90, 'EDT', -431542800, -14400, '1', 1),
(90, 'EDT', -463597200, -14400, '1', 1),
(90, 'EDT', -495046800, -14400, '1', 1),
(90, 'EDT', -526496400, -14400, '1', 1),
(90, 'EDT', -52938000, -14400, '1', 1),
(90, 'EDT', -557946000, -14400, '1', 1),
(90, 'EDT', -589395600, -14400, '1', 1),
(90, 'EDT', -620845200, -14400, '1', 1),
(90, 'EDT', -652906800, -14400, '1', 1),
(90, 'EDT', -684356400, -14400, '1', 1),
(90, 'EDT', -715806000, -14400, '1', 1),
(90, 'EDT', -747248400, -14400, '1', 1),
(90, 'EDT', -84387600, -14400, '1', 1),
(90, 'EDT', -936550800, -14400, '1', 1),
(90, 'EDT', -968000400, -14400, '1', 1),
(90, 'EDT', 1018162800, -14400, '1', 1),
(90, 'EDT', 104914800, -14400, '1', 1),
(90, 'EDT', 1049612400, -14400, '1', 1),
(90, 'EDT', 1081062000, -14400, '1', 1),
(90, 'EDT', 1112511600, -14400, '1', 1),
(90, 'EDT', 1143961200, -14400, '1', 1),
(90, 'EDT', 1173596400, -14400, '1', 1),
(90, 'EDT', 1205046000, -14400, '1', 1),
(90, 'EDT', 1236495600, -14400, '1', 1),
(90, 'EDT', 1268550000, -14400, '1', 1),
(90, 'EDT', 1299999600, -14400, '1', 1),
(90, 'EDT', 1331449200, -14400, '1', 1),
(90, 'EDT', 1362898800, -14400, '1', 1),
(90, 'EDT', 136364400, -14400, '1', 1),
(90, 'EDT', 1394348400, -14400, '1', 1),
(90, 'EDT', 1425798000, -14400, '1', 1),
(90, 'EDT', 1457852400, -14400, '1', 1),
(90, 'EDT', 1489302000, -14400, '1', 1),
(90, 'EDT', 1520751600, -14400, '1', 1),
(90, 'EDT', 1552201200, -14400, '1', 1),
(90, 'EDT', 1583650800, -14400, '1', 1),
(90, 'EDT', 1615705200, -14400, '1', 1),
(90, 'EDT', 1647154800, -14400, '1', 1),
(90, 'EDT', 167814000, -14400, '1', 1),
(90, 'EDT', 1678604400, -14400, '1', 1),
(90, 'EDT', 1710054000, -14400, '1', 1),
(90, 'EDT', 1741503600, -14400, '1', 1),
(90, 'EDT', 1772953200, -14400, '1', 1),
(90, 'EDT', 1805007600, -14400, '1', 1),
(90, 'EDT', 1836457200, -14400, '1', 1),
(90, 'EDT', 1867906800, -14400, '1', 1),
(90, 'EDT', 1899356400, -14400, '1', 1),
(90, 'EDT', 1930806000, -14400, '1', 1),
(90, 'EDT', 1962860400, -14400, '1', 1),
(90, 'EDT', 199263600, -14400, '1', 1),
(90, 'EDT', 1994310000, -14400, '1', 1),
(90, 'EDT', 2025759600, -14400, '1', 1),
(90, 'EDT', 2057209200, -14400, '1', 1),
(90, 'EDT', 2088658800, -14400, '1', 1),
(90, 'EDT', 2120108400, -14400, '1', 1),
(90, 'EDT', 230713200, -14400, '1', 1),
(90, 'EDT', 262767600, -14400, '1', 1),
(90, 'EDT', 294217200, -14400, '1', 1),
(90, 'EDT', 325666800, -14400, '1', 1),
(90, 'EDT', 357116400, -14400, '1', 1),
(90, 'EDT', 388566000, -14400, '1', 1),
(90, 'EDT', 41410800, -14400, '1', 1),
(90, 'EDT', 420015600, -14400, '1', 1),
(90, 'EDT', 452070000, -14400, '1', 1),
(90, 'EDT', 483519600, -14400, '1', 1),
(90, 'EDT', 514969200, -14400, '1', 1),
(90, 'EDT', 544604400, -14400, '1', 1),
(90, 'EDT', 576054000, -14400, '1', 1),
(90, 'EDT', 607503600, -14400, '1', 1),
(90, 'EDT', 638953200, -14400, '1', 1),
(90, 'EDT', 671007600, -14400, '1', 1),
(90, 'EDT', 702457200, -14400, '1', 1),
(90, 'EDT', 733906800, -14400, '1', 1),
(90, 'EDT', 73465200, -14400, '1', 1),
(90, 'EDT', 765356400, -14400, '1', 1),
(90, 'EDT', 796806000, -14400, '1', 1),
(90, 'EDT', 828860400, -14400, '1', 1),
(90, 'EDT', 860310000, -14400, '1', 1),
(90, 'EDT', 891759600, -14400, '1', 1),
(90, 'EDT', 923209200, -14400, '1', 1),
(90, 'EDT', 954658800, -14400, '1', 1),
(90, 'EDT', 986108400, -14400, '1', 1),
(90, 'EDT', 9961200, -14400, '1', 1),
(90, 'EPT', -769395600, -14400, '1', 1),
(90, 'EST', -100116000, -18000, '0', 1),
(90, 'EST', -1018202400, -18000, '0', 1),
(90, 'EST', -1049652000, -18000, '0', 1),
(90, 'EST', -1081101600, -18000, '0', 1),
(90, 'EST', -1112551200, -18000, '0', 1),
(90, 'EST', -1144000800, -18000, '0', 1),
(90, 'EST', -1176055200, -18000, '0', 1),
(90, 'EST', -1207504800, -18000, '0', 1),
(90, 'EST', -1238954400, -18000, '0', 1),
(90, 'EST', -1270404000, -18000, '0', 1),
(90, 'EST', -1301853600, -18000, '0', 1),
(90, 'EST', -131565600, -18000, '0', 1),
(90, 'EST', -1333908000, -18000, '0', 1),
(90, 'EST', -1365962400, -18000, '0', 1),
(90, 'EST', -1397412000, -18000, '0', 1),
(90, 'EST', -1428861600, -18000, '0', 1),
(90, 'EST', -1460916000, -18000, '0', 1),
(90, 'EST', -1492365600, -18000, '0', 1),
(90, 'EST', -1524074400, -18000, '0', 1),
(90, 'EST', -1554667200, -18000, '0', 1),
(90, 'EST', -1583697600, -18000, '0', 1),
(90, 'EST', -1615140000, -18000, '0', 1),
(90, 'EST', -163620000, -18000, '0', 1),
(90, 'EST', -195069600, -18000, '0', 1),
(90, 'EST', -2147397248, -18000, '0', 1),
(90, 'EST', -2147483648, -18000, '0', 1),
(90, 'EST', -226519200, -18000, '0', 1),
(90, 'EST', -257968800, -18000, '0', 1),
(90, 'EST', -289418400, -18000, '0', 1),
(90, 'EST', -321472800, -18000, '0', 1),
(90, 'EST', -352922400, -18000, '0', 1),
(90, 'EST', -37216800, -18000, '0', 1),
(90, 'EST', -384372000, -18000, '0', 1),
(90, 'EST', -418240800, -18000, '0', 1),
(90, 'EST', -450295200, -18000, '0', 1),
(90, 'EST', -481744800, -18000, '0', 1),
(90, 'EST', -513194400, -18000, '0', 1),
(90, 'EST', -544644000, -18000, '0', 1),
(90, 'EST', -576093600, -18000, '0', 1),
(90, 'EST', -5767200, -18000, '0', 1),
(90, 'EST', -602704800, -18000, '0', 1),
(90, 'EST', -634161600, -18000, '0', 1),
(90, 'EST', -671054400, -18000, '0', 1),
(90, 'EST', -68666400, -18000, '0', 1),
(90, 'EST', -702504000, -18000, '0', 1),
(90, 'EST', -733946400, -18000, '0', 1),
(90, 'EST', -765396000, -18000, '0', 1),
(90, 'EST', -955303200, -18000, '0', 1),
(90, 'EST', -986752800, -18000, '0', 1),
(90, 'EST', 1004248800, -18000, '0', 1),
(90, 'EST', 1035698400, -18000, '0', 1),
(90, 'EST', 1067148000, -18000, '0', 1),
(90, 'EST', 1099202400, -18000, '0', 1),
(90, 'EST', 1130652000, -18000, '0', 1),
(90, 'EST', 1162101600, -18000, '0', 1),
(90, 'EST', 1194156000, -18000, '0', 1),
(90, 'EST', 120636000, -18000, '0', 1),
(90, 'EST', 1225605600, -18000, '0', 1),
(90, 'EST', 1257055200, -18000, '0', 1),
(90, 'EST', 1289109600, -18000, '0', 1),
(90, 'EST', 1320559200, -18000, '0', 1),
(90, 'EST', 1352008800, -18000, '0', 1),
(90, 'EST', 1383458400, -18000, '0', 1),
(90, 'EST', 1414908000, -18000, '0', 1),
(90, 'EST', 1446357600, -18000, '0', 1),
(90, 'EST', 1478412000, -18000, '0', 1),
(90, 'EST', 1509861600, -18000, '0', 1),
(90, 'EST', 152085600, -18000, '0', 1),
(90, 'EST', 1541311200, -18000, '0', 1),
(90, 'EST', 1572760800, -18000, '0', 1),
(90, 'EST', 1604210400, -18000, '0', 1),
(90, 'EST', 1636264800, -18000, '0', 1),
(90, 'EST', 1667714400, -18000, '0', 1),
(90, 'EST', 1699164000, -18000, '0', 1),
(90, 'EST', 1730613600, -18000, '0', 1),
(90, 'EST', 1762063200, -18000, '0', 1),
(90, 'EST', 1793512800, -18000, '0', 1),
(90, 'EST', 1825567200, -18000, '0', 1),
(90, 'EST', 183535200, -18000, '0', 1),
(90, 'EST', 1857016800, -18000, '0', 1),
(90, 'EST', 1888466400, -18000, '0', 1),
(90, 'EST', 1919916000, -18000, '0', 1),
(90, 'EST', 1951365600, -18000, '0', 1),
(90, 'EST', 1983420000, -18000, '0', 1),
(90, 'EST', 2014869600, -18000, '0', 1),
(90, 'EST', 2046319200, -18000, '0', 1),
(90, 'EST', 2077768800, -18000, '0', 1),
(90, 'EST', 2109218400, -18000, '0', 1),
(90, 'EST', 2140668000, -18000, '0', 1),
(90, 'EST', 2147397247, -18000, '0', 1),
(90, 'EST', 2147483647, -18000, '0', 1),
(90, 'EST', 215589600, -18000, '0', 1),
(90, 'EST', 247039200, -18000, '0', 1),
(90, 'EST', 25682400, -18000, '0', 1),
(90, 'EST', 278488800, -18000, '0', 1),
(90, 'EST', 309938400, -18000, '0', 1),
(90, 'EST', 341388000, -18000, '0', 1),
(90, 'EST', 372837600, -18000, '0', 1),
(90, 'EST', 404892000, -18000, '0', 1),
(90, 'EST', 436341600, -18000, '0', 1),
(90, 'EST', 467791200, -18000, '0', 1),
(90, 'EST', 499240800, -18000, '0', 1),
(90, 'EST', 530690400, -18000, '0', 1),
(90, 'EST', 562140000, -18000, '0', 1),
(90, 'EST', 57736800, -18000, '0', 1),
(90, 'EST', 594194400, -18000, '0', 1),
(90, 'EST', 625644000, -18000, '0', 1),
(90, 'EST', 657093600, -18000, '0', 1),
(90, 'EST', 688543200, -18000, '0', 1),
(90, 'EST', 719992800, -18000, '0', 1),
(90, 'EST', 752047200, -18000, '0', 1),
(90, 'EST', 783496800, -18000, '0', 1),
(90, 'EST', 814946400, -18000, '0', 1),
(90, 'EST', 846396000, -18000, '0', 1),
(90, 'EST', 877845600, -18000, '0', 1),
(90, 'EST', 89186400, -18000, '0', 1),
(90, 'EST', 909295200, -18000, '0', 1),
(90, 'EST', 941349600, -18000, '0', 1),
(90, 'EST', 972799200, -18000, '0', 1),
(90, 'EWT', -880218000, -14400, '1', 1),
(91, 'EDT', -1632070800, -14400, '1', 1),
(91, 'EDT', -923252400, -14400, '1', 1),
(91, 'EDT', 1018162800, -14400, '1', 1),
(91, 'EDT', 1049612400, -14400, '1', 1),
(91, 'EDT', 1081062000, -14400, '1', 1),
(91, 'EDT', 1112511600, -14400, '1', 1),
(91, 'EDT', 1143961200, -14400, '1', 1),
(91, 'EDT', 1173596400, -14400, '1', 1),
(91, 'EDT', 1205046000, -14400, '1', 1),
(91, 'EDT', 1236495600, -14400, '1', 1),
(91, 'EDT', 1268550000, -14400, '1', 1),
(91, 'EDT', 1299999600, -14400, '1', 1),
(91, 'EDT', 1331449200, -14400, '1', 1),
(91, 'EDT', 1362898800, -14400, '1', 1),
(91, 'EDT', 136364400, -14400, '1', 1),
(91, 'EDT', 1394348400, -14400, '1', 1),
(91, 'EDT', 1425798000, -14400, '1', 1),
(91, 'EDT', 1457852400, -14400, '1', 1),
(91, 'EDT', 1489302000, -14400, '1', 1),
(91, 'EDT', 1520751600, -14400, '1', 1),
(91, 'EDT', 1552201200, -14400, '1', 1),
(91, 'EDT', 1583650800, -14400, '1', 1),
(91, 'EDT', 1615705200, -14400, '1', 1),
(91, 'EDT', 1647154800, -14400, '1', 1),
(91, 'EDT', 167814000, -14400, '1', 1),
(91, 'EDT', 1678604400, -14400, '1', 1),
(91, 'EDT', 1710054000, -14400, '1', 1),
(91, 'EDT', 1741503600, -14400, '1', 1),
(91, 'EDT', 1772953200, -14400, '1', 1),
(91, 'EDT', 1805007600, -14400, '1', 1),
(91, 'EDT', 1836457200, -14400, '1', 1),
(91, 'EDT', 1867906800, -14400, '1', 1),
(91, 'EDT', 1899356400, -14400, '1', 1),
(91, 'EDT', 1930806000, -14400, '1', 1),
(91, 'EDT', 1962860400, -14400, '1', 1),
(91, 'EDT', 199263600, -14400, '1', 1),
(91, 'EDT', 1994310000, -14400, '1', 1),
(91, 'EDT', 2025759600, -14400, '1', 1),
(91, 'EDT', 2057209200, -14400, '1', 1),
(91, 'EDT', 2088658800, -14400, '1', 1),
(91, 'EDT', 2120108400, -14400, '1', 1),
(91, 'EDT', 230713200, -14400, '1', 1),
(91, 'EDT', 262767600, -14400, '1', 1),
(91, 'EDT', 294217200, -14400, '1', 1),
(91, 'EDT', 325666800, -14400, '1', 1),
(91, 'EDT', 357116400, -14400, '1', 1),
(91, 'EDT', 388566000, -14400, '1', 1),
(91, 'EDT', 420015600, -14400, '1', 1),
(91, 'EDT', 452070000, -14400, '1', 1),
(91, 'EDT', 483519600, -14400, '1', 1),
(91, 'EDT', 514969200, -14400, '1', 1),
(91, 'EDT', 544604400, -14400, '1', 1),
(91, 'EDT', 576054000, -14400, '1', 1),
(91, 'EDT', 607503600, -14400, '1', 1),
(91, 'EDT', 638953200, -14400, '1', 1),
(91, 'EDT', 671007600, -14400, '1', 1),
(91, 'EDT', 702457200, -14400, '1', 1),
(91, 'EDT', 733906800, -14400, '1', 1),
(91, 'EDT', 765356400, -14400, '1', 1),
(91, 'EDT', 796806000, -14400, '1', 1),
(91, 'EDT', 828860400, -14400, '1', 1),
(91, 'EDT', 860310000, -14400, '1', 1),
(91, 'EDT', 891759600, -14400, '1', 1),
(91, 'EDT', 923209200, -14400, '1', 1),
(91, 'EDT', 954658800, -14400, '1', 1),
(91, 'EDT', 986108400, -14400, '1', 1),
(91, 'EPT', -769395600, -14400, '1', 1),
(91, 'EST', -1615140000, -18000, '0', 1),
(91, 'EST', -2147397248, -18000, '0', 1),
(91, 'EST', -2147483648, -18000, '0', 1),
(91, 'EST', -765396000, -18000, '0', 1),
(91, 'EST', 1004248800, -18000, '0', 1),
(91, 'EST', 1035698400, -18000, '0', 1),
(91, 'EST', 1067148000, -18000, '0', 1),
(91, 'EST', 1099202400, -18000, '0', 1),
(91, 'EST', 1130652000, -18000, '0', 1),
(91, 'EST', 1162101600, -18000, '0', 1),
(91, 'EST', 1194156000, -18000, '0', 1),
(91, 'EST', 1225605600, -18000, '0', 1),
(91, 'EST', 1257055200, -18000, '0', 1),
(91, 'EST', 1289109600, -18000, '0', 1),
(91, 'EST', 1320559200, -18000, '0', 1),
(91, 'EST', 1352008800, -18000, '0', 1),
(91, 'EST', 1383458400, -18000, '0', 1),
(91, 'EST', 1414908000, -18000, '0', 1),
(91, 'EST', 1446357600, -18000, '0', 1),
(91, 'EST', 1478412000, -18000, '0', 1),
(91, 'EST', 1509861600, -18000, '0', 1),
(91, 'EST', 152085600, -18000, '0', 1),
(91, 'EST', 1541311200, -18000, '0', 1),
(91, 'EST', 1572760800, -18000, '0', 1),
(91, 'EST', 1604210400, -18000, '0', 1),
(91, 'EST', 1636264800, -18000, '0', 1),
(91, 'EST', 1667714400, -18000, '0', 1),
(91, 'EST', 1699164000, -18000, '0', 1),
(91, 'EST', 1730613600, -18000, '0', 1),
(91, 'EST', 1762063200, -18000, '0', 1),
(91, 'EST', 1793512800, -18000, '0', 1),
(91, 'EST', 1825567200, -18000, '0', 1),
(91, 'EST', 183535200, -18000, '0', 1),
(91, 'EST', 1857016800, -18000, '0', 1),
(91, 'EST', 1888466400, -18000, '0', 1),
(91, 'EST', 1919916000, -18000, '0', 1),
(91, 'EST', 1951365600, -18000, '0', 1),
(91, 'EST', 1983420000, -18000, '0', 1),
(91, 'EST', 2014869600, -18000, '0', 1),
(91, 'EST', 2046319200, -18000, '0', 1),
(91, 'EST', 2077768800, -18000, '0', 1),
(91, 'EST', 2109218400, -18000, '0', 1),
(91, 'EST', 2140668000, -18000, '0', 1),
(91, 'EST', 2147397247, -18000, '0', 1),
(91, 'EST', 2147483647, -18000, '0', 1),
(91, 'EST', 215589600, -18000, '0', 1),
(91, 'EST', 247039200, -18000, '0', 1),
(91, 'EST', 278488800, -18000, '0', 1),
(91, 'EST', 309938400, -18000, '0', 1),
(91, 'EST', 341388000, -18000, '0', 1),
(91, 'EST', 372837600, -18000, '0', 1),
(91, 'EST', 404892000, -18000, '0', 1),
(91, 'EST', 436341600, -18000, '0', 1),
(91, 'EST', 467791200, -18000, '0', 1),
(91, 'EST', 499240800, -18000, '0', 1),
(91, 'EST', 530690400, -18000, '0', 1),
(91, 'EST', 562140000, -18000, '0', 1),
(91, 'EST', 594194400, -18000, '0', 1),
(91, 'EST', 625644000, -18000, '0', 1),
(91, 'EST', 657093600, -18000, '0', 1),
(91, 'EST', 688543200, -18000, '0', 1),
(91, 'EST', 719992800, -18000, '0', 1),
(91, 'EST', 752047200, -18000, '0', 1),
(91, 'EST', 783496800, -18000, '0', 1),
(91, 'EST', 814946400, -18000, '0', 1),
(91, 'EST', 846396000, -18000, '0', 1),
(91, 'EST', 877845600, -18000, '0', 1),
(91, 'EST', 909295200, -18000, '0', 1),
(91, 'EST', 941349600, -18000, '0', 1),
(91, 'EST', 972799200, -18000, '0', 1),
(91, 'EWT', -880218000, -14400, '1', 1),
(92, 'CST', -2147397248, -21600, '0', 0),
(92, 'CST', -2147483648, -21600, '0', 0),
(92, 'EDT', 1018162800, -14400, '1', 1),
(92, 'EDT', 1049612400, -14400, '1', 1),
(92, 'EDT', 1081062000, -14400, '1', 1),
(92, 'EDT', 1112511600, -14400, '1', 1),
(92, 'EDT', 1143961200, -14400, '1', 1),
(92, 'EDT', 1173596400, -14400, '1', 1),
(92, 'EDT', 1205046000, -14400, '1', 1),
(92, 'EDT', 1236495600, -14400, '1', 1),
(92, 'EDT', 1268550000, -14400, '1', 1),
(92, 'EDT', 1299999600, -14400, '1', 1),
(92, 'EDT', 1331449200, -14400, '1', 1),
(92, 'EDT', 1362898800, -14400, '1', 1),
(92, 'EDT', 136364400, -14400, '1', 1),
(92, 'EDT', 1394348400, -14400, '1', 1),
(92, 'EDT', 1425798000, -14400, '1', 1),
(92, 'EDT', 1457852400, -14400, '1', 1),
(92, 'EDT', 1489302000, -14400, '1', 1),
(92, 'EDT', 1520751600, -14400, '1', 1),
(92, 'EDT', 1552201200, -14400, '1', 1),
(92, 'EDT', 1583650800, -14400, '1', 1),
(92, 'EDT', 1615705200, -14400, '1', 1),
(92, 'EDT', 1647154800, -14400, '1', 1),
(92, 'EDT', 167814000, -14400, '1', 1),
(92, 'EDT', 1678604400, -14400, '1', 1),
(92, 'EDT', 1710054000, -14400, '1', 1),
(92, 'EDT', 1741503600, -14400, '1', 1),
(92, 'EDT', 1772953200, -14400, '1', 1),
(92, 'EDT', 1805007600, -14400, '1', 1),
(92, 'EDT', 1836457200, -14400, '1', 1),
(92, 'EDT', 1867906800, -14400, '1', 1),
(92, 'EDT', 1899356400, -14400, '1', 1),
(92, 'EDT', 1930806000, -14400, '1', 1),
(92, 'EDT', 1962860400, -14400, '1', 1),
(92, 'EDT', 199263600, -14400, '1', 1),
(92, 'EDT', 1994310000, -14400, '1', 1),
(92, 'EDT', 2025759600, -14400, '1', 1),
(92, 'EDT', 2057209200, -14400, '1', 1),
(92, 'EDT', 2088658800, -14400, '1', 1),
(92, 'EDT', 2120108400, -14400, '1', 1),
(92, 'EDT', 230713200, -14400, '1', 1),
(92, 'EDT', 262767600, -14400, '1', 1),
(92, 'EDT', 294217200, -14400, '1', 1),
(92, 'EDT', 325666800, -14400, '1', 1),
(92, 'EDT', 357116400, -14400, '1', 1),
(92, 'EDT', 388566000, -14400, '1', 1),
(92, 'EDT', 41410800, -14400, '1', 1),
(92, 'EDT', 420015600, -14400, '1', 1),
(92, 'EDT', 452070000, -14400, '1', 1),
(92, 'EDT', 483519600, -14400, '1', 1),
(92, 'EDT', 514969200, -14400, '1', 1),
(92, 'EDT', 544604400, -14400, '1', 1),
(92, 'EDT', 576054000, -14400, '1', 1),
(92, 'EDT', 607503600, -14400, '1', 1),
(92, 'EDT', 638953200, -14400, '1', 1),
(92, 'EDT', 671007600, -14400, '1', 1),
(92, 'EDT', 702457200, -14400, '1', 1),
(92, 'EDT', 733906800, -14400, '1', 1),
(92, 'EDT', 73465200, -14400, '1', 1),
(92, 'EDT', 765356400, -14400, '1', 1),
(92, 'EDT', 796806000, -14400, '1', 1),
(92, 'EDT', 828860400, -14400, '1', 1),
(92, 'EDT', 860310000, -14400, '1', 1),
(92, 'EDT', 891759600, -14400, '1', 1),
(92, 'EDT', 923209200, -14400, '1', 1),
(92, 'EDT', 954658800, -14400, '1', 1),
(92, 'EDT', 986108400, -14400, '1', 1),
(92, 'EDT', 9961200, -14400, '1', 1),
(92, 'EPT', -769395600, -14400, '1', 0),
(92, 'EST', -1893434400, -18000, '0', 1),
(92, 'EST', -765396000, -18000, '0', 1),
(92, 'EST', 1004248800, -18000, '0', 1),
(92, 'EST', 1035698400, -18000, '0', 1),
(92, 'EST', 1067148000, -18000, '0', 1),
(92, 'EST', 1099202400, -18000, '0', 1),
(92, 'EST', 1130652000, -18000, '0', 1),
(92, 'EST', 1162101600, -18000, '0', 1),
(92, 'EST', 1194156000, -18000, '0', 1),
(92, 'EST', 1225605600, -18000, '0', 1),
(92, 'EST', 1257055200, -18000, '0', 1),
(92, 'EST', 1289109600, -18000, '0', 1),
(92, 'EST', 1320559200, -18000, '0', 1),
(92, 'EST', 1352008800, -18000, '0', 1),
(92, 'EST', 1383458400, -18000, '0', 1),
(92, 'EST', 1414908000, -18000, '0', 1),
(92, 'EST', 1446357600, -18000, '0', 1),
(92, 'EST', 1478412000, -18000, '0', 1),
(92, 'EST', 1509861600, -18000, '0', 1),
(92, 'EST', 152085600, -18000, '0', 1),
(92, 'EST', 1541311200, -18000, '0', 1),
(92, 'EST', 1572760800, -18000, '0', 1),
(92, 'EST', 1604210400, -18000, '0', 1),
(92, 'EST', 1636264800, -18000, '0', 1),
(92, 'EST', 1667714400, -18000, '0', 1),
(92, 'EST', 1699164000, -18000, '0', 1),
(92, 'EST', 1730613600, -18000, '0', 1),
(92, 'EST', 1762063200, -18000, '0', 1),
(92, 'EST', 1793512800, -18000, '0', 1),
(92, 'EST', 1825567200, -18000, '0', 1),
(92, 'EST', 183535200, -18000, '0', 1),
(92, 'EST', 1857016800, -18000, '0', 1),
(92, 'EST', 1888466400, -18000, '0', 1),
(92, 'EST', 1919916000, -18000, '0', 1),
(92, 'EST', 1951365600, -18000, '0', 1),
(92, 'EST', 1983420000, -18000, '0', 1),
(92, 'EST', 2014869600, -18000, '0', 1),
(92, 'EST', 2046319200, -18000, '0', 1),
(92, 'EST', 2077768800, -18000, '0', 1),
(92, 'EST', 2109218400, -18000, '0', 1),
(92, 'EST', 2140668000, -18000, '0', 1),
(92, 'EST', 2147397247, -18000, '0', 1),
(92, 'EST', 2147483647, -18000, '0', 1),
(92, 'EST', 215589600, -18000, '0', 1),
(92, 'EST', 247039200, -18000, '0', 1),
(92, 'EST', 25682400, -18000, '0', 1),
(92, 'EST', 278488800, -18000, '0', 1),
(92, 'EST', 309938400, -18000, '0', 1),
(92, 'EST', 341388000, -18000, '0', 1),
(92, 'EST', 372837600, -18000, '0', 1),
(92, 'EST', 404892000, -18000, '0', 1),
(92, 'EST', 436341600, -18000, '0', 1),
(92, 'EST', 467791200, -18000, '0', 1),
(92, 'EST', 499240800, -18000, '0', 1),
(92, 'EST', 530690400, -18000, '0', 1),
(92, 'EST', 562140000, -18000, '0', 1),
(92, 'EST', 57736800, -18000, '0', 1),
(92, 'EST', 594194400, -18000, '0', 1),
(92, 'EST', 625644000, -18000, '0', 1),
(92, 'EST', 657093600, -18000, '0', 1),
(92, 'EST', 688543200, -18000, '0', 1),
(92, 'EST', 719992800, -18000, '0', 1),
(92, 'EST', 752047200, -18000, '0', 1),
(92, 'EST', 783496800, -18000, '0', 1),
(92, 'EST', 814946400, -18000, '0', 1),
(92, 'EST', 846396000, -18000, '0', 1),
(92, 'EST', 877845600, -18000, '0', 1),
(92, 'EST', 89186400, -18000, '0', 1),
(92, 'EST', 909295200, -18000, '0', 1),
(92, 'EST', 941349600, -18000, '0', 1),
(92, 'EST', 972799200, -18000, '0', 1),
(92, 'EWT', -880218000, -14400, '1', 0),
(93, 'CDT', 954662400, -18000, '1', 0),
(93, 'CST', 941349600, -21600, '0', 0),
(93, 'EDDT', -147898800, -10800, '1', 0),
(93, 'EDT', 1018162800, -14400, '1', 1),
(93, 'EDT', 1049612400, -14400, '1', 1),
(93, 'EDT', 1081062000, -14400, '1', 1),
(93, 'EDT', 1112511600, -14400, '1', 1),
(93, 'EDT', 1143961200, -14400, '1', 1),
(93, 'EDT', 1173596400, -14400, '1', 1),
(93, 'EDT', 1205046000, -14400, '1', 1),
(93, 'EDT', 1236495600, -14400, '1', 1),
(93, 'EDT', 1268550000, -14400, '1', 1),
(93, 'EDT', 1299999600, -14400, '1', 1),
(93, 'EDT', 1331449200, -14400, '1', 1),
(93, 'EDT', 1362898800, -14400, '1', 1),
(93, 'EDT', 1394348400, -14400, '1', 1),
(93, 'EDT', 1425798000, -14400, '1', 1),
(93, 'EDT', 1457852400, -14400, '1', 1),
(93, 'EDT', 1489302000, -14400, '1', 1),
(93, 'EDT', 1520751600, -14400, '1', 1),
(93, 'EDT', 1552201200, -14400, '1', 1),
(93, 'EDT', 1583650800, -14400, '1', 1),
(93, 'EDT', 1615705200, -14400, '1', 1),
(93, 'EDT', 1647154800, -14400, '1', 1),
(93, 'EDT', 1678604400, -14400, '1', 1),
(93, 'EDT', 1710054000, -14400, '1', 1),
(93, 'EDT', 1741503600, -14400, '1', 1),
(93, 'EDT', 1772953200, -14400, '1', 1),
(93, 'EDT', 1805007600, -14400, '1', 1),
(93, 'EDT', 1836457200, -14400, '1', 1),
(93, 'EDT', 1867906800, -14400, '1', 1),
(93, 'EDT', 1899356400, -14400, '1', 1),
(93, 'EDT', 1930806000, -14400, '1', 1),
(93, 'EDT', 1962860400, -14400, '1', 1),
(93, 'EDT', 1994310000, -14400, '1', 1),
(93, 'EDT', 2025759600, -14400, '1', 1),
(93, 'EDT', 2057209200, -14400, '1', 1),
(93, 'EDT', 2088658800, -14400, '1', 1),
(93, 'EDT', 2120108400, -14400, '1', 1),
(93, 'EDT', 325666800, -14400, '1', 1),
(93, 'EDT', 357116400, -14400, '1', 1),
(93, 'EDT', 388566000, -14400, '1', 1),
(93, 'EDT', 420015600, -14400, '1', 1),
(93, 'EDT', 452070000, -14400, '1', 1),
(93, 'EDT', 483519600, -14400, '1', 1),
(93, 'EDT', 514969200, -14400, '1', 1),
(93, 'EDT', 544604400, -14400, '1', 1),
(93, 'EDT', 576054000, -14400, '1', 1),
(93, 'EDT', 607503600, -14400, '1', 1),
(93, 'EDT', 638953200, -14400, '1', 1),
(93, 'EDT', 671007600, -14400, '1', 1),
(93, 'EDT', 702457200, -14400, '1', 1),
(93, 'EDT', 733906800, -14400, '1', 1),
(93, 'EDT', 765356400, -14400, '1', 1),
(93, 'EDT', 796806000, -14400, '1', 1),
(93, 'EDT', 828860400, -14400, '1', 1),
(93, 'EDT', 860310000, -14400, '1', 1),
(93, 'EDT', 891759600, -14400, '1', 1),
(93, 'EDT', 923209200, -14400, '1', 1),
(93, 'EDT', 986108400, -14400, '1', 1),
(93, 'EPT', -769395600, -14400, '1', 0),
(93, 'EST', -131569200, -18000, '0', 1),
(93, 'EST', -765396000, -18000, '0', 1),
(93, 'EST', 1004248800, -18000, '0', 1),
(93, 'EST', 1035698400, -18000, '0', 1),
(93, 'EST', 1067148000, -18000, '0', 1),
(93, 'EST', 1099202400, -18000, '0', 1),
(93, 'EST', 1130652000, -18000, '0', 1),
(93, 'EST', 1162101600, -18000, '0', 1),
(93, 'EST', 1194156000, -18000, '0', 1),
(93, 'EST', 1225605600, -18000, '0', 1),
(93, 'EST', 1257055200, -18000, '0', 1),
(93, 'EST', 1289109600, -18000, '0', 1),
(93, 'EST', 1320559200, -18000, '0', 1),
(93, 'EST', 1352008800, -18000, '0', 1),
(93, 'EST', 1383458400, -18000, '0', 1),
(93, 'EST', 1414908000, -18000, '0', 1),
(93, 'EST', 1446357600, -18000, '0', 1),
(93, 'EST', 1478412000, -18000, '0', 1),
(93, 'EST', 1509861600, -18000, '0', 1),
(93, 'EST', 1541311200, -18000, '0', 1),
(93, 'EST', 1572760800, -18000, '0', 1),
(93, 'EST', 1604210400, -18000, '0', 1),
(93, 'EST', 1636264800, -18000, '0', 1),
(93, 'EST', 1667714400, -18000, '0', 1),
(93, 'EST', 1699164000, -18000, '0', 1),
(93, 'EST', 1730613600, -18000, '0', 1),
(93, 'EST', 1762063200, -18000, '0', 1),
(93, 'EST', 1793512800, -18000, '0', 1),
(93, 'EST', 1825567200, -18000, '0', 1),
(93, 'EST', 1857016800, -18000, '0', 1),
(93, 'EST', 1888466400, -18000, '0', 1),
(93, 'EST', 1919916000, -18000, '0', 1),
(93, 'EST', 1951365600, -18000, '0', 1),
(93, 'EST', 1983420000, -18000, '0', 1),
(93, 'EST', 2014869600, -18000, '0', 1),
(93, 'EST', 2046319200, -18000, '0', 1),
(93, 'EST', 2077768800, -18000, '0', 1),
(93, 'EST', 2109218400, -18000, '0', 1),
(93, 'EST', 2140668000, -18000, '0', 1),
(93, 'EST', 2147397247, -18000, '0', 1),
(93, 'EST', 2147483647, -18000, '0', 1),
(93, 'EST', 341388000, -18000, '0', 1),
(93, 'EST', 372837600, -18000, '0', 1),
(93, 'EST', 404892000, -18000, '0', 1),
(93, 'EST', 436341600, -18000, '0', 1),
(93, 'EST', 467791200, -18000, '0', 1),
(93, 'EST', 499240800, -18000, '0', 1),
(93, 'EST', 530690400, -18000, '0', 1),
(93, 'EST', 562140000, -18000, '0', 1),
(93, 'EST', 594194400, -18000, '0', 1),
(93, 'EST', 625644000, -18000, '0', 1),
(93, 'EST', 657093600, -18000, '0', 1),
(93, 'EST', 688543200, -18000, '0', 1),
(93, 'EST', 719992800, -18000, '0', 1),
(93, 'EST', 752047200, -18000, '0', 1),
(93, 'EST', 783496800, -18000, '0', 1),
(93, 'EST', 814946400, -18000, '0', 1),
(93, 'EST', 846396000, -18000, '0', 1),
(93, 'EST', 877845600, -18000, '0', 1),
(93, 'EST', 909295200, -18000, '0', 1),
(93, 'EST', 972802800, -18000, '0', 1),
(93, 'EWT', -865296000, -14400, '1', 0),
(94, 'ADDT', -147902400, -7200, '1', 0),
(94, 'ADT', 325663200, -10800, '1', 0),
(94, 'ADT', 357112800, -10800, '1', 0),
(94, 'ADT', 388562400, -10800, '1', 0),
(94, 'ADT', 420012000, -10800, '1', 0),
(94, 'ADT', 452066400, -10800, '1', 0),
(94, 'ADT', 483516000, -10800, '1', 0),
(94, 'ADT', 514965600, -10800, '1', 0),
(94, 'ADT', 544600800, -10800, '1', 0),
(94, 'ADT', 576050400, -10800, '1', 0),
(94, 'ADT', 607500000, -10800, '1', 0),
(94, 'ADT', 638949600, -10800, '1', 0),
(94, 'ADT', 671004000, -10800, '1', 0),
(94, 'ADT', 702453600, -10800, '1', 0),
(94, 'ADT', 733903200, -10800, '1', 0),
(94, 'ADT', 765352800, -10800, '1', 0),
(94, 'APT', -769395600, -10800, '1', 0),
(94, 'AST', -131572800, -14400, '0', 0),
(94, 'AST', -1546300800, -14400, '0', 0),
(94, 'AST', -765399600, -14400, '0', 0),
(94, 'AST', 341384400, -14400, '0', 0),
(94, 'AST', 372834000, -14400, '0', 0),
(94, 'AST', 404888400, -14400, '0', 0),
(94, 'AST', 436338000, -14400, '0', 0),
(94, 'AST', 467787600, -14400, '0', 0),
(94, 'AST', 499237200, -14400, '0', 0),
(94, 'AST', 530686800, -14400, '0', 0),
(94, 'AST', 562136400, -14400, '0', 0),
(94, 'AST', 594190800, -14400, '0', 0),
(94, 'AST', 625640400, -14400, '0', 0),
(94, 'AST', 657090000, -14400, '0', 0),
(94, 'AST', 688539600, -14400, '0', 0),
(94, 'AST', 719989200, -14400, '0', 0),
(94, 'AST', 752043600, -14400, '0', 0),
(94, 'AST', 783493200, -14400, '0', 0),
(94, 'AWT', -880221600, -10800, '1', 0),
(94, 'CDT', 954662400, -18000, '1', 0),
(94, 'CST', 941349600, -21600, '0', 0),
(94, 'EDT', 1018162800, -14400, '1', 1),
(94, 'EDT', 1049612400, -14400, '1', 1),
(94, 'EDT', 1081062000, -14400, '1', 1),
(94, 'EDT', 1112511600, -14400, '1', 1),
(94, 'EDT', 1143961200, -14400, '1', 1),
(94, 'EDT', 1173596400, -14400, '1', 1),
(94, 'EDT', 1205046000, -14400, '1', 1),
(94, 'EDT', 1236495600, -14400, '1', 1),
(94, 'EDT', 1268550000, -14400, '1', 1),
(94, 'EDT', 1299999600, -14400, '1', 1),
(94, 'EDT', 1331449200, -14400, '1', 1),
(94, 'EDT', 1362898800, -14400, '1', 1),
(94, 'EDT', 1394348400, -14400, '1', 1),
(94, 'EDT', 1425798000, -14400, '1', 1),
(94, 'EDT', 1457852400, -14400, '1', 1),
(94, 'EDT', 1489302000, -14400, '1', 1),
(94, 'EDT', 1520751600, -14400, '1', 1),
(94, 'EDT', 1552201200, -14400, '1', 1),
(94, 'EDT', 1583650800, -14400, '1', 1),
(94, 'EDT', 1615705200, -14400, '1', 1),
(94, 'EDT', 1647154800, -14400, '1', 1),
(94, 'EDT', 1678604400, -14400, '1', 1),
(94, 'EDT', 1710054000, -14400, '1', 1),
(94, 'EDT', 1741503600, -14400, '1', 1),
(94, 'EDT', 1772953200, -14400, '1', 1),
(94, 'EDT', 1805007600, -14400, '1', 1),
(94, 'EDT', 1836457200, -14400, '1', 1),
(94, 'EDT', 1867906800, -14400, '1', 1),
(94, 'EDT', 1899356400, -14400, '1', 1),
(94, 'EDT', 1930806000, -14400, '1', 1),
(94, 'EDT', 1962860400, -14400, '1', 1),
(94, 'EDT', 1994310000, -14400, '1', 1),
(94, 'EDT', 2025759600, -14400, '1', 1),
(94, 'EDT', 2057209200, -14400, '1', 1),
(94, 'EDT', 2088658800, -14400, '1', 1),
(94, 'EDT', 2120108400, -14400, '1', 1),
(94, 'EDT', 796802400, -14400, '1', 1),
(94, 'EDT', 828860400, -14400, '1', 1),
(94, 'EDT', 860310000, -14400, '1', 1),
(94, 'EDT', 891759600, -14400, '1', 1),
(94, 'EDT', 923209200, -14400, '1', 1),
(94, 'EDT', 986108400, -14400, '1', 1),
(94, 'EST', 1004248800, -18000, '0', 1),
(94, 'EST', 1035698400, -18000, '0', 1),
(94, 'EST', 1067148000, -18000, '0', 1),
(94, 'EST', 1099202400, -18000, '0', 1),
(94, 'EST', 1130652000, -18000, '0', 1),
(94, 'EST', 1162101600, -18000, '0', 1),
(94, 'EST', 1194156000, -18000, '0', 1),
(94, 'EST', 1225605600, -18000, '0', 1),
(94, 'EST', 1257055200, -18000, '0', 1),
(94, 'EST', 1289109600, -18000, '0', 1),
(94, 'EST', 1320559200, -18000, '0', 1),
(94, 'EST', 1352008800, -18000, '0', 1),
(94, 'EST', 1383458400, -18000, '0', 1),
(94, 'EST', 1414908000, -18000, '0', 1),
(94, 'EST', 1446357600, -18000, '0', 1),
(94, 'EST', 1478412000, -18000, '0', 1),
(94, 'EST', 1509861600, -18000, '0', 1),
(94, 'EST', 1541311200, -18000, '0', 1),
(94, 'EST', 1572760800, -18000, '0', 1),
(94, 'EST', 1604210400, -18000, '0', 1),
(94, 'EST', 1636264800, -18000, '0', 1),
(94, 'EST', 1667714400, -18000, '0', 1),
(94, 'EST', 1699164000, -18000, '0', 1),
(94, 'EST', 1730613600, -18000, '0', 1),
(94, 'EST', 1762063200, -18000, '0', 1),
(94, 'EST', 1793512800, -18000, '0', 1),
(94, 'EST', 1825567200, -18000, '0', 1),
(94, 'EST', 1857016800, -18000, '0', 1),
(94, 'EST', 1888466400, -18000, '0', 1),
(94, 'EST', 1919916000, -18000, '0', 1),
(94, 'EST', 1951365600, -18000, '0', 1),
(94, 'EST', 1983420000, -18000, '0', 1),
(94, 'EST', 2014869600, -18000, '0', 1),
(94, 'EST', 2046319200, -18000, '0', 1),
(94, 'EST', 2077768800, -18000, '0', 1),
(94, 'EST', 2109218400, -18000, '0', 1),
(94, 'EST', 2140668000, -18000, '0', 1),
(94, 'EST', 2147397247, -18000, '0', 1),
(94, 'EST', 2147483647, -18000, '0', 1),
(94, 'EST', 814946400, -18000, '0', 1),
(94, 'EST', 846396000, -18000, '0', 1),
(94, 'EST', 877845600, -18000, '0', 1),
(94, 'EST', 909295200, -18000, '0', 1),
(94, 'EST', 972802800, -18000, '0', 1),
(95, 'CDT', -1632067200, -18000, '1', 0),
(95, 'CDT', -923248800, -18000, '1', 0),
(95, 'CPT', -769395600, -18000, '1', 0),
(95, 'CST', -1615136400, -21600, '0', 0),
(95, 'CST', -2147397248, -21600, '0', 0),
(95, 'CST', -2147483648, -21600, '0', 0),
(95, 'CWT', -880214400, -18000, '1', 0),
(95, 'EST', -765392400, -18000, '0', 1),
(95, 'EST', 2147397247, -18000, '0', 1),
(95, 'EST', 2147483647, -18000, '0', 1),
(96, 'CDT', -1029686400, -18000, '1', 1),
(96, 'CDT', -116438400, -18000, '1', 1),
(96, 'CDT', -1632067200, -18000, '1', 1),
(96, 'CDT', -1694368800, -18000, '1', 1),
(96, 'CDT', -210787200, -18000, '1', 1),
(96, 'CDT', -21484800, -18000, '1', 1),
(96, 'CDT', -305740800, -18000, '1', 1),
(96, 'CDT', -337190400, -18000, '1', 1),
(96, 'CDT', -368640000, -18000, '1', 1),
(96, 'CDT', -400089600, -18000, '1', 1),
(96, 'CDT', -431539200, -18000, '1', 1),
(96, 'CDT', -463593600, -18000, '1', 1),
(96, 'CDT', -495043200, -18000, '1', 1),
(96, 'CDT', -526492800, -18000, '1', 1),
(96, 'CDT', -52934400, -18000, '1', 1),
(96, 'CDT', -557942400, -18000, '1', 1),
(96, 'CDT', -589392000, -18000, '1', 1),
(96, 'CDT', -620755200, -18000, '1', 1),
(96, 'CDT', -652896000, -18000, '1', 1),
(96, 'CDT', -684345600, -18000, '1', 1),
(96, 'CDT', -715795200, -18000, '1', 1),
(96, 'CDT', -746035200, -18000, '1', 1),
(96, 'CDT', -84384000, -18000, '1', 1),
(96, 'CDT', 1018166400, -18000, '1', 1),
(96, 'CDT', 104918400, -18000, '1', 1),
(96, 'CDT', 1049616000, -18000, '1', 1),
(96, 'CDT', 1081065600, -18000, '1', 1),
(96, 'CDT', 1112515200, -18000, '1', 1),
(96, 'CDT', 1143964800, -18000, '1', 1),
(96, 'CDT', 1173600000, -18000, '1', 1),
(96, 'CDT', 1205049600, -18000, '1', 1),
(96, 'CDT', 1236499200, -18000, '1', 1),
(96, 'CDT', 1268553600, -18000, '1', 1),
(96, 'CDT', 1300003200, -18000, '1', 1),
(96, 'CDT', 1331452800, -18000, '1', 1),
(96, 'CDT', 1362902400, -18000, '1', 1),
(96, 'CDT', 136368000, -18000, '1', 1),
(96, 'CDT', 1394352000, -18000, '1', 1),
(96, 'CDT', 1425801600, -18000, '1', 1),
(96, 'CDT', 1457856000, -18000, '1', 1),
(96, 'CDT', 1489305600, -18000, '1', 1),
(96, 'CDT', 1520755200, -18000, '1', 1),
(96, 'CDT', 1552204800, -18000, '1', 1),
(96, 'CDT', 1583654400, -18000, '1', 1),
(96, 'CDT', 1615708800, -18000, '1', 1),
(96, 'CDT', 1647158400, -18000, '1', 1),
(96, 'CDT', 167817600, -18000, '1', 1),
(96, 'CDT', 1678608000, -18000, '1', 1),
(96, 'CDT', 1710057600, -18000, '1', 1),
(96, 'CDT', 1741507200, -18000, '1', 1),
(96, 'CDT', 1772956800, -18000, '1', 1),
(96, 'CDT', 1805011200, -18000, '1', 1),
(96, 'CDT', 1836460800, -18000, '1', 1),
(96, 'CDT', 1867910400, -18000, '1', 1),
(96, 'CDT', 1899360000, -18000, '1', 1),
(96, 'CDT', 1930809600, -18000, '1', 1),
(96, 'CDT', 1962864000, -18000, '1', 1),
(96, 'CDT', 199267200, -18000, '1', 1),
(96, 'CDT', 1994313600, -18000, '1', 1),
(96, 'CDT', 2025763200, -18000, '1', 1),
(96, 'CDT', 2057212800, -18000, '1', 1),
(96, 'CDT', 2088662400, -18000, '1', 1),
(96, 'CDT', 2120112000, -18000, '1', 1),
(96, 'CDT', 230716800, -18000, '1', 1),
(96, 'CDT', 262771200, -18000, '1', 1),
(96, 'CDT', 294220800, -18000, '1', 1),
(96, 'CDT', 325670400, -18000, '1', 1),
(96, 'CDT', 357120000, -18000, '1', 1),
(96, 'CDT', 388569600, -18000, '1', 1),
(96, 'CDT', 41414400, -18000, '1', 1),
(96, 'CDT', 420019200, -18000, '1', 1),
(96, 'CDT', 452073600, -18000, '1', 1),
(96, 'CDT', 483523200, -18000, '1', 1),
(96, 'CDT', 514972800, -18000, '1', 1),
(96, 'CDT', 544608000, -18000, '1', 1),
(96, 'CDT', 576057600, -18000, '1', 1),
(96, 'CDT', 607507200, -18000, '1', 1),
(96, 'CDT', 638956800, -18000, '1', 1),
(96, 'CDT', 671011200, -18000, '1', 1),
(96, 'CDT', 702460800, -18000, '1', 1),
(96, 'CDT', 733910400, -18000, '1', 1),
(96, 'CDT', 73468800, -18000, '1', 1),
(96, 'CDT', 765360000, -18000, '1', 1),
(96, 'CDT', 796809600, -18000, '1', 1),
(96, 'CDT', 828864000, -18000, '1', 1),
(96, 'CDT', 860313600, -18000, '1', 1),
(96, 'CDT', 891763200, -18000, '1', 1),
(96, 'CDT', 923212800, -18000, '1', 1),
(96, 'CDT', 954662400, -18000, '1', 1),
(96, 'CDT', 986112000, -18000, '1', 1),
(96, 'CDT', 9964800, -18000, '1', 1),
(96, 'CPT', -769395600, -18000, '1', 1),
(96, 'CST', -100108800, -21600, '0', 1),
(96, 'CST', -1018198800, -21600, '0', 1),
(96, 'CST', -1615136400, -21600, '0', 1),
(96, 'CST', -1681671600, -21600, '0', 1),
(96, 'CST', -198090000, -21600, '0', 1),
(96, 'CST', -2147397248, -21600, '0', 1),
(96, 'CST', -2147483648, -21600, '0', 1);
INSERT INTO `tz_timezone` (`zone_id`, `abbreviation`, `time_start`, `gmt_offset`, `dst`, `is_valid_zone`) VALUES
(96, 'CST', -292438800, -21600, '0', 1),
(96, 'CST', -321469200, -21600, '0', 1),
(96, 'CST', -355338000, -21600, '0', 1),
(96, 'CST', -37209600, -21600, '0', 1),
(96, 'CST', -386787600, -21600, '0', 1),
(96, 'CST', -418237200, -21600, '0', 1),
(96, 'CST', -450291600, -21600, '0', 1),
(96, 'CST', -481741200, -21600, '0', 1),
(96, 'CST', -513190800, -21600, '0', 1),
(96, 'CST', -544640400, -21600, '0', 1),
(96, 'CST', -5760000, -21600, '0', 1),
(96, 'CST', -576090000, -21600, '0', 1),
(96, 'CST', -607626000, -21600, '0', 1),
(96, 'CST', -639594000, -21600, '0', 1),
(96, 'CST', -671043600, -21600, '0', 1),
(96, 'CST', -68659200, -21600, '0', 1),
(96, 'CST', -702493200, -21600, '0', 1),
(96, 'CST', -732733200, -21600, '0', 1),
(96, 'CST', -765392400, -21600, '0', 1),
(96, 'CST', 1004256000, -21600, '0', 1),
(96, 'CST', 1035705600, -21600, '0', 1),
(96, 'CST', 1067155200, -21600, '0', 1),
(96, 'CST', 1099209600, -21600, '0', 1),
(96, 'CST', 1130659200, -21600, '0', 1),
(96, 'CST', 1162105200, -21600, '0', 1),
(96, 'CST', 1194159600, -21600, '0', 1),
(96, 'CST', 120643200, -21600, '0', 1),
(96, 'CST', 1225609200, -21600, '0', 1),
(96, 'CST', 1257058800, -21600, '0', 1),
(96, 'CST', 1289113200, -21600, '0', 1),
(96, 'CST', 1320562800, -21600, '0', 1),
(96, 'CST', 1352012400, -21600, '0', 1),
(96, 'CST', 1383462000, -21600, '0', 1),
(96, 'CST', 1414911600, -21600, '0', 1),
(96, 'CST', 1446361200, -21600, '0', 1),
(96, 'CST', 1478415600, -21600, '0', 1),
(96, 'CST', 1509865200, -21600, '0', 1),
(96, 'CST', 152092800, -21600, '0', 1),
(96, 'CST', 1541314800, -21600, '0', 1),
(96, 'CST', 1572764400, -21600, '0', 1),
(96, 'CST', 1604214000, -21600, '0', 1),
(96, 'CST', 1636268400, -21600, '0', 1),
(96, 'CST', 1667718000, -21600, '0', 1),
(96, 'CST', 1699167600, -21600, '0', 1),
(96, 'CST', 1730617200, -21600, '0', 1),
(96, 'CST', 1762066800, -21600, '0', 1),
(96, 'CST', 1793516400, -21600, '0', 1),
(96, 'CST', 1825570800, -21600, '0', 1),
(96, 'CST', 183542400, -21600, '0', 1),
(96, 'CST', 1857020400, -21600, '0', 1),
(96, 'CST', 1888470000, -21600, '0', 1),
(96, 'CST', 1919919600, -21600, '0', 1),
(96, 'CST', 1951369200, -21600, '0', 1),
(96, 'CST', 1983423600, -21600, '0', 1),
(96, 'CST', 2014873200, -21600, '0', 1),
(96, 'CST', 2046322800, -21600, '0', 1),
(96, 'CST', 2077772400, -21600, '0', 1),
(96, 'CST', 2109222000, -21600, '0', 1),
(96, 'CST', 2140671600, -21600, '0', 1),
(96, 'CST', 2147397247, -21600, '0', 1),
(96, 'CST', 2147483647, -21600, '0', 1),
(96, 'CST', 215596800, -21600, '0', 1),
(96, 'CST', 247046400, -21600, '0', 1),
(96, 'CST', 25689600, -21600, '0', 1),
(96, 'CST', 278496000, -21600, '0', 1),
(96, 'CST', 309945600, -21600, '0', 1),
(96, 'CST', 341395200, -21600, '0', 1),
(96, 'CST', 372844800, -21600, '0', 1),
(96, 'CST', 404899200, -21600, '0', 1),
(96, 'CST', 436348800, -21600, '0', 1),
(96, 'CST', 467798400, -21600, '0', 1),
(96, 'CST', 499248000, -21600, '0', 1),
(96, 'CST', 530697600, -21600, '0', 1),
(96, 'CST', 562147200, -21600, '0', 1),
(96, 'CST', 57744000, -21600, '0', 1),
(96, 'CST', 594201600, -21600, '0', 1),
(96, 'CST', 625651200, -21600, '0', 1),
(96, 'CST', 657100800, -21600, '0', 1),
(96, 'CST', 688550400, -21600, '0', 1),
(96, 'CST', 720000000, -21600, '0', 1),
(96, 'CST', 752054400, -21600, '0', 1),
(96, 'CST', 783504000, -21600, '0', 1),
(96, 'CST', 814953600, -21600, '0', 1),
(96, 'CST', 846403200, -21600, '0', 1),
(96, 'CST', 877852800, -21600, '0', 1),
(96, 'CST', 89193600, -21600, '0', 1),
(96, 'CST', 909302400, -21600, '0', 1),
(96, 'CST', 941356800, -21600, '0', 1),
(96, 'CST', 972806400, -21600, '0', 1),
(96, 'CWT', -880214400, -18000, '1', 1),
(97, 'CDT', -1632067200, -18000, '1', 1),
(97, 'CDT', -923248800, -18000, '1', 1),
(97, 'CDT', 1018166400, -18000, '1', 1),
(97, 'CDT', 1049616000, -18000, '1', 1),
(97, 'CDT', 1081065600, -18000, '1', 1),
(97, 'CDT', 1112515200, -18000, '1', 1),
(97, 'CDT', 1143964800, -18000, '1', 1),
(97, 'CDT', 1173600000, -18000, '1', 1),
(97, 'CDT', 1205049600, -18000, '1', 1),
(97, 'CDT', 1236499200, -18000, '1', 1),
(97, 'CDT', 1268553600, -18000, '1', 1),
(97, 'CDT', 1300003200, -18000, '1', 1),
(97, 'CDT', 1331452800, -18000, '1', 1),
(97, 'CDT', 1362902400, -18000, '1', 1),
(97, 'CDT', 136368000, -18000, '1', 1),
(97, 'CDT', 1394352000, -18000, '1', 1),
(97, 'CDT', 1425801600, -18000, '1', 1),
(97, 'CDT', 1457856000, -18000, '1', 1),
(97, 'CDT', 1489305600, -18000, '1', 1),
(97, 'CDT', 1520755200, -18000, '1', 1),
(97, 'CDT', 1552204800, -18000, '1', 1),
(97, 'CDT', 1583654400, -18000, '1', 1),
(97, 'CDT', 1615708800, -18000, '1', 1),
(97, 'CDT', 1647158400, -18000, '1', 1),
(97, 'CDT', 167817600, -18000, '1', 1),
(97, 'CDT', 1678608000, -18000, '1', 1),
(97, 'CDT', 1710057600, -18000, '1', 1),
(97, 'CDT', 1741507200, -18000, '1', 1),
(97, 'CDT', 1772956800, -18000, '1', 1),
(97, 'CDT', 1805011200, -18000, '1', 1),
(97, 'CDT', 1836460800, -18000, '1', 1),
(97, 'CDT', 1867910400, -18000, '1', 1),
(97, 'CDT', 1899360000, -18000, '1', 1),
(97, 'CDT', 1930809600, -18000, '1', 1),
(97, 'CDT', 1962864000, -18000, '1', 1),
(97, 'CDT', 199267200, -18000, '1', 1),
(97, 'CDT', 1994313600, -18000, '1', 1),
(97, 'CDT', 2025763200, -18000, '1', 1),
(97, 'CDT', 2057212800, -18000, '1', 1),
(97, 'CDT', 2088662400, -18000, '1', 1),
(97, 'CDT', 2120112000, -18000, '1', 1),
(97, 'CDT', 230716800, -18000, '1', 1),
(97, 'CDT', 262771200, -18000, '1', 1),
(97, 'CDT', 294220800, -18000, '1', 1),
(97, 'CDT', 325670400, -18000, '1', 1),
(97, 'CDT', 357120000, -18000, '1', 1),
(97, 'CDT', 388569600, -18000, '1', 1),
(97, 'CDT', 420019200, -18000, '1', 1),
(97, 'CDT', 452073600, -18000, '1', 1),
(97, 'CDT', 483523200, -18000, '1', 1),
(97, 'CDT', 514972800, -18000, '1', 1),
(97, 'CDT', 544608000, -18000, '1', 1),
(97, 'CDT', 576057600, -18000, '1', 1),
(97, 'CDT', 607507200, -18000, '1', 1),
(97, 'CDT', 638956800, -18000, '1', 1),
(97, 'CDT', 671011200, -18000, '1', 1),
(97, 'CDT', 702460800, -18000, '1', 1),
(97, 'CDT', 733910400, -18000, '1', 1),
(97, 'CDT', 765360000, -18000, '1', 1),
(97, 'CDT', 796809600, -18000, '1', 1),
(97, 'CDT', 828864000, -18000, '1', 1),
(97, 'CDT', 860313600, -18000, '1', 1),
(97, 'CDT', 891763200, -18000, '1', 1),
(97, 'CDT', 923212800, -18000, '1', 1),
(97, 'CDT', 954662400, -18000, '1', 1),
(97, 'CDT', 986112000, -18000, '1', 1),
(97, 'CPT', -769395600, -18000, '1', 1),
(97, 'CST', -1615136400, -21600, '0', 1),
(97, 'CST', -2147397248, -21600, '0', 1),
(97, 'CST', -2147483648, -21600, '0', 1),
(97, 'CST', -765392400, -21600, '0', 1),
(97, 'CST', 1004252400, -21600, '0', 1),
(97, 'CST', 1035702000, -21600, '0', 1),
(97, 'CST', 1067151600, -21600, '0', 1),
(97, 'CST', 1099206000, -21600, '0', 1),
(97, 'CST', 1130655600, -21600, '0', 1),
(97, 'CST', 1162105200, -21600, '0', 1),
(97, 'CST', 1194159600, -21600, '0', 1),
(97, 'CST', 1225609200, -21600, '0', 1),
(97, 'CST', 1257058800, -21600, '0', 1),
(97, 'CST', 1289113200, -21600, '0', 1),
(97, 'CST', 1320562800, -21600, '0', 1),
(97, 'CST', 1352012400, -21600, '0', 1),
(97, 'CST', 1383462000, -21600, '0', 1),
(97, 'CST', 1414911600, -21600, '0', 1),
(97, 'CST', 1446361200, -21600, '0', 1),
(97, 'CST', 1478415600, -21600, '0', 1),
(97, 'CST', 1509865200, -21600, '0', 1),
(97, 'CST', 152089200, -21600, '0', 1),
(97, 'CST', 1541314800, -21600, '0', 1),
(97, 'CST', 1572764400, -21600, '0', 1),
(97, 'CST', 1604214000, -21600, '0', 1),
(97, 'CST', 1636268400, -21600, '0', 1),
(97, 'CST', 1667718000, -21600, '0', 1),
(97, 'CST', 1699167600, -21600, '0', 1),
(97, 'CST', 1730617200, -21600, '0', 1),
(97, 'CST', 1762066800, -21600, '0', 1),
(97, 'CST', 1793516400, -21600, '0', 1),
(97, 'CST', 1825570800, -21600, '0', 1),
(97, 'CST', 183538800, -21600, '0', 1),
(97, 'CST', 1857020400, -21600, '0', 1),
(97, 'CST', 1888470000, -21600, '0', 1),
(97, 'CST', 1919919600, -21600, '0', 1),
(97, 'CST', 1951369200, -21600, '0', 1),
(97, 'CST', 1983423600, -21600, '0', 1),
(97, 'CST', 2014873200, -21600, '0', 1),
(97, 'CST', 2046322800, -21600, '0', 1),
(97, 'CST', 2077772400, -21600, '0', 1),
(97, 'CST', 2109222000, -21600, '0', 1),
(97, 'CST', 2140671600, -21600, '0', 1),
(97, 'CST', 2147397247, -21600, '0', 1),
(97, 'CST', 2147483647, -21600, '0', 1),
(97, 'CST', 215593200, -21600, '0', 1),
(97, 'CST', 247042800, -21600, '0', 1),
(97, 'CST', 278492400, -21600, '0', 1),
(97, 'CST', 309942000, -21600, '0', 1),
(97, 'CST', 341391600, -21600, '0', 1),
(97, 'CST', 372841200, -21600, '0', 1),
(97, 'CST', 404895600, -21600, '0', 1),
(97, 'CST', 436345200, -21600, '0', 1),
(97, 'CST', 467794800, -21600, '0', 1),
(97, 'CST', 499244400, -21600, '0', 1),
(97, 'CST', 530694000, -21600, '0', 1),
(97, 'CST', 562143600, -21600, '0', 1),
(97, 'CST', 594198000, -21600, '0', 1),
(97, 'CST', 625647600, -21600, '0', 1),
(97, 'CST', 657097200, -21600, '0', 1),
(97, 'CST', 688546800, -21600, '0', 1),
(97, 'CST', 719996400, -21600, '0', 1),
(97, 'CST', 752050800, -21600, '0', 1),
(97, 'CST', 783500400, -21600, '0', 1),
(97, 'CST', 814950000, -21600, '0', 1),
(97, 'CST', 846399600, -21600, '0', 1),
(97, 'CST', 877849200, -21600, '0', 1),
(97, 'CST', 909298800, -21600, '0', 1),
(97, 'CST', 941353200, -21600, '0', 1),
(97, 'CST', 972802800, -21600, '0', 1),
(97, 'CWT', -880214400, -18000, '1', 1),
(98, 'CDDT', -147895200, -14400, '1', 0),
(98, 'CDT', 1018166400, -18000, '1', 1),
(98, 'CDT', 1049616000, -18000, '1', 1),
(98, 'CDT', 1081065600, -18000, '1', 1),
(98, 'CDT', 1112515200, -18000, '1', 1),
(98, 'CDT', 1143964800, -18000, '1', 1),
(98, 'CDT', 1173600000, -18000, '1', 1),
(98, 'CDT', 1205049600, -18000, '1', 1),
(98, 'CDT', 1236499200, -18000, '1', 1),
(98, 'CDT', 1268553600, -18000, '1', 1),
(98, 'CDT', 1300003200, -18000, '1', 1),
(98, 'CDT', 1331452800, -18000, '1', 1),
(98, 'CDT', 1362902400, -18000, '1', 1),
(98, 'CDT', 1394352000, -18000, '1', 1),
(98, 'CDT', 1425801600, -18000, '1', 1),
(98, 'CDT', 1457856000, -18000, '1', 1),
(98, 'CDT', 1489305600, -18000, '1', 1),
(98, 'CDT', 1520755200, -18000, '1', 1),
(98, 'CDT', 1552204800, -18000, '1', 1),
(98, 'CDT', 1583654400, -18000, '1', 1),
(98, 'CDT', 1615708800, -18000, '1', 1),
(98, 'CDT', 1647158400, -18000, '1', 1),
(98, 'CDT', 1678608000, -18000, '1', 1),
(98, 'CDT', 1710057600, -18000, '1', 1),
(98, 'CDT', 1741507200, -18000, '1', 1),
(98, 'CDT', 1772956800, -18000, '1', 1),
(98, 'CDT', 1805011200, -18000, '1', 1),
(98, 'CDT', 1836460800, -18000, '1', 1),
(98, 'CDT', 1867910400, -18000, '1', 1),
(98, 'CDT', 1899360000, -18000, '1', 1),
(98, 'CDT', 1930809600, -18000, '1', 1),
(98, 'CDT', 1962864000, -18000, '1', 1),
(98, 'CDT', 1994313600, -18000, '1', 1),
(98, 'CDT', 2025763200, -18000, '1', 1),
(98, 'CDT', 2057212800, -18000, '1', 1),
(98, 'CDT', 2088662400, -18000, '1', 1),
(98, 'CDT', 2120112000, -18000, '1', 1),
(98, 'CDT', 325670400, -18000, '1', 1),
(98, 'CDT', 357120000, -18000, '1', 1),
(98, 'CDT', 388569600, -18000, '1', 1),
(98, 'CDT', 420019200, -18000, '1', 1),
(98, 'CDT', 452073600, -18000, '1', 1),
(98, 'CDT', 483523200, -18000, '1', 1),
(98, 'CDT', 514972800, -18000, '1', 1),
(98, 'CDT', 544608000, -18000, '1', 1),
(98, 'CDT', 576057600, -18000, '1', 1),
(98, 'CDT', 607507200, -18000, '1', 1),
(98, 'CDT', 638956800, -18000, '1', 1),
(98, 'CDT', 671011200, -18000, '1', 1),
(98, 'CDT', 702460800, -18000, '1', 1),
(98, 'CDT', 733910400, -18000, '1', 1),
(98, 'CDT', 765360000, -18000, '1', 1),
(98, 'CDT', 796809600, -18000, '1', 1),
(98, 'CDT', 828864000, -18000, '1', 1),
(98, 'CDT', 860313600, -18000, '1', 1),
(98, 'CDT', 891763200, -18000, '1', 1),
(98, 'CDT', 923212800, -18000, '1', 1),
(98, 'CDT', 954662400, -18000, '1', 1),
(98, 'CDT', 986112000, -18000, '1', 1),
(98, 'CST', -131565600, -21600, '0', 1),
(98, 'CST', -704937600, -21600, '0', 1),
(98, 'CST', 1004252400, -21600, '0', 1),
(98, 'CST', 1035702000, -21600, '0', 1),
(98, 'CST', 1067151600, -21600, '0', 1),
(98, 'CST', 1099206000, -21600, '0', 1),
(98, 'CST', 1130655600, -21600, '0', 1),
(98, 'CST', 1194159600, -21600, '0', 1),
(98, 'CST', 1225609200, -21600, '0', 1),
(98, 'CST', 1257058800, -21600, '0', 1),
(98, 'CST', 1289113200, -21600, '0', 1),
(98, 'CST', 1320562800, -21600, '0', 1),
(98, 'CST', 1352012400, -21600, '0', 1),
(98, 'CST', 1383462000, -21600, '0', 1),
(98, 'CST', 1414911600, -21600, '0', 1),
(98, 'CST', 1446361200, -21600, '0', 1),
(98, 'CST', 1478415600, -21600, '0', 1),
(98, 'CST', 1509865200, -21600, '0', 1),
(98, 'CST', 1541314800, -21600, '0', 1),
(98, 'CST', 1572764400, -21600, '0', 1),
(98, 'CST', 1604214000, -21600, '0', 1),
(98, 'CST', 1636268400, -21600, '0', 1),
(98, 'CST', 1667718000, -21600, '0', 1),
(98, 'CST', 1699167600, -21600, '0', 1),
(98, 'CST', 1730617200, -21600, '0', 1),
(98, 'CST', 1762066800, -21600, '0', 1),
(98, 'CST', 1793516400, -21600, '0', 1),
(98, 'CST', 1825570800, -21600, '0', 1),
(98, 'CST', 1857020400, -21600, '0', 1),
(98, 'CST', 1888470000, -21600, '0', 1),
(98, 'CST', 1919919600, -21600, '0', 1),
(98, 'CST', 1951369200, -21600, '0', 1),
(98, 'CST', 1983423600, -21600, '0', 1),
(98, 'CST', 2014873200, -21600, '0', 1),
(98, 'CST', 2046322800, -21600, '0', 1),
(98, 'CST', 2077772400, -21600, '0', 1),
(98, 'CST', 2109222000, -21600, '0', 1),
(98, 'CST', 2140671600, -21600, '0', 1),
(98, 'CST', 2147397247, -21600, '0', 1),
(98, 'CST', 2147483647, -21600, '0', 1),
(98, 'CST', 341391600, -21600, '0', 1),
(98, 'CST', 372841200, -21600, '0', 1),
(98, 'CST', 404895600, -21600, '0', 1),
(98, 'CST', 436345200, -21600, '0', 1),
(98, 'CST', 467794800, -21600, '0', 1),
(98, 'CST', 499244400, -21600, '0', 1),
(98, 'CST', 530694000, -21600, '0', 1),
(98, 'CST', 562143600, -21600, '0', 1),
(98, 'CST', 594198000, -21600, '0', 1),
(98, 'CST', 625647600, -21600, '0', 1),
(98, 'CST', 657097200, -21600, '0', 1),
(98, 'CST', 688546800, -21600, '0', 1),
(98, 'CST', 719996400, -21600, '0', 1),
(98, 'CST', 752050800, -21600, '0', 1),
(98, 'CST', 783500400, -21600, '0', 1),
(98, 'CST', 814950000, -21600, '0', 1),
(98, 'CST', 846399600, -21600, '0', 1),
(98, 'CST', 877849200, -21600, '0', 1),
(98, 'CST', 909298800, -21600, '0', 1),
(98, 'CST', 941353200, -21600, '0', 1),
(98, 'EST', 1162105200, -18000, '0', 0),
(98, 'EST', 972802800, -18000, '0', 0),
(99, 'CDDT', -147895200, -14400, '1', 0),
(99, 'CDT', 1018166400, -18000, '1', 1),
(99, 'CDT', 1049616000, -18000, '1', 1),
(99, 'CDT', 1081065600, -18000, '1', 1),
(99, 'CDT', 1112515200, -18000, '1', 1),
(99, 'CDT', 1143964800, -18000, '1', 1),
(99, 'CDT', 1173600000, -18000, '1', 1),
(99, 'CDT', 1205049600, -18000, '1', 1),
(99, 'CDT', 1236499200, -18000, '1', 1),
(99, 'CDT', 1268553600, -18000, '1', 1),
(99, 'CDT', 1300003200, -18000, '1', 1),
(99, 'CDT', 1331452800, -18000, '1', 1),
(99, 'CDT', 1362902400, -18000, '1', 1),
(99, 'CDT', 1394352000, -18000, '1', 1),
(99, 'CDT', 1425801600, -18000, '1', 1),
(99, 'CDT', 1457856000, -18000, '1', 1),
(99, 'CDT', 1489305600, -18000, '1', 1),
(99, 'CDT', 1520755200, -18000, '1', 1),
(99, 'CDT', 1552204800, -18000, '1', 1),
(99, 'CDT', 1583654400, -18000, '1', 1),
(99, 'CDT', 1615708800, -18000, '1', 1),
(99, 'CDT', 1647158400, -18000, '1', 1),
(99, 'CDT', 1678608000, -18000, '1', 1),
(99, 'CDT', 1710057600, -18000, '1', 1),
(99, 'CDT', 1741507200, -18000, '1', 1),
(99, 'CDT', 1772956800, -18000, '1', 1),
(99, 'CDT', 1805011200, -18000, '1', 1),
(99, 'CDT', 1836460800, -18000, '1', 1),
(99, 'CDT', 1867910400, -18000, '1', 1),
(99, 'CDT', 1899360000, -18000, '1', 1),
(99, 'CDT', 1930809600, -18000, '1', 1),
(99, 'CDT', 1962864000, -18000, '1', 1),
(99, 'CDT', 1994313600, -18000, '1', 1),
(99, 'CDT', 2025763200, -18000, '1', 1),
(99, 'CDT', 2057212800, -18000, '1', 1),
(99, 'CDT', 2088662400, -18000, '1', 1),
(99, 'CDT', 2120112000, -18000, '1', 1),
(99, 'CDT', 325670400, -18000, '1', 1),
(99, 'CDT', 357120000, -18000, '1', 1),
(99, 'CDT', 388569600, -18000, '1', 1),
(99, 'CDT', 420019200, -18000, '1', 1),
(99, 'CDT', 452073600, -18000, '1', 1),
(99, 'CDT', 483523200, -18000, '1', 1),
(99, 'CDT', 514972800, -18000, '1', 1),
(99, 'CDT', 544608000, -18000, '1', 1),
(99, 'CDT', 576057600, -18000, '1', 1),
(99, 'CDT', 607507200, -18000, '1', 1),
(99, 'CDT', 638956800, -18000, '1', 1),
(99, 'CDT', 671011200, -18000, '1', 1),
(99, 'CDT', 702460800, -18000, '1', 1),
(99, 'CDT', 733910400, -18000, '1', 1),
(99, 'CDT', 765360000, -18000, '1', 1),
(99, 'CDT', 796809600, -18000, '1', 1),
(99, 'CDT', 828864000, -18000, '1', 1),
(99, 'CDT', 860313600, -18000, '1', 1),
(99, 'CDT', 891763200, -18000, '1', 1),
(99, 'CDT', 923212800, -18000, '1', 1),
(99, 'CDT', 954662400, -18000, '1', 1),
(99, 'CDT', 986112000, -18000, '1', 1),
(99, 'CST', -131565600, -21600, '0', 1),
(99, 'CST', -410227200, -21600, '0', 1),
(99, 'CST', 1004252400, -21600, '0', 1),
(99, 'CST', 1035702000, -21600, '0', 1),
(99, 'CST', 1067151600, -21600, '0', 1),
(99, 'CST', 1099206000, -21600, '0', 1),
(99, 'CST', 1130655600, -21600, '0', 1),
(99, 'CST', 1162105200, -21600, '0', 1),
(99, 'CST', 1194159600, -21600, '0', 1),
(99, 'CST', 1225609200, -21600, '0', 1),
(99, 'CST', 1257058800, -21600, '0', 1),
(99, 'CST', 1289113200, -21600, '0', 1),
(99, 'CST', 1320562800, -21600, '0', 1),
(99, 'CST', 1352012400, -21600, '0', 1),
(99, 'CST', 1383462000, -21600, '0', 1),
(99, 'CST', 1414911600, -21600, '0', 1),
(99, 'CST', 1446361200, -21600, '0', 1),
(99, 'CST', 1478415600, -21600, '0', 1),
(99, 'CST', 1509865200, -21600, '0', 1),
(99, 'CST', 1541314800, -21600, '0', 1),
(99, 'CST', 1572764400, -21600, '0', 1),
(99, 'CST', 1604214000, -21600, '0', 1),
(99, 'CST', 1636268400, -21600, '0', 1),
(99, 'CST', 1667718000, -21600, '0', 1),
(99, 'CST', 1699167600, -21600, '0', 1),
(99, 'CST', 1730617200, -21600, '0', 1),
(99, 'CST', 1762066800, -21600, '0', 1),
(99, 'CST', 1793516400, -21600, '0', 1),
(99, 'CST', 1825570800, -21600, '0', 1),
(99, 'CST', 1857020400, -21600, '0', 1),
(99, 'CST', 1888470000, -21600, '0', 1),
(99, 'CST', 1919919600, -21600, '0', 1),
(99, 'CST', 1951369200, -21600, '0', 1),
(99, 'CST', 1983423600, -21600, '0', 1),
(99, 'CST', 2014873200, -21600, '0', 1),
(99, 'CST', 2046322800, -21600, '0', 1),
(99, 'CST', 2077772400, -21600, '0', 1),
(99, 'CST', 2109222000, -21600, '0', 1),
(99, 'CST', 2140671600, -21600, '0', 1),
(99, 'CST', 2147397247, -21600, '0', 1),
(99, 'CST', 2147483647, -21600, '0', 1),
(99, 'CST', 341391600, -21600, '0', 1),
(99, 'CST', 372841200, -21600, '0', 1),
(99, 'CST', 404895600, -21600, '0', 1),
(99, 'CST', 436345200, -21600, '0', 1),
(99, 'CST', 467794800, -21600, '0', 1),
(99, 'CST', 499244400, -21600, '0', 1),
(99, 'CST', 530694000, -21600, '0', 1),
(99, 'CST', 562143600, -21600, '0', 1),
(99, 'CST', 594198000, -21600, '0', 1),
(99, 'CST', 625647600, -21600, '0', 1),
(99, 'CST', 657097200, -21600, '0', 1),
(99, 'CST', 688546800, -21600, '0', 1),
(99, 'CST', 719996400, -21600, '0', 1),
(99, 'CST', 752050800, -21600, '0', 1),
(99, 'CST', 783500400, -21600, '0', 1),
(99, 'CST', 814950000, -21600, '0', 1),
(99, 'CST', 846399600, -21600, '0', 1),
(99, 'CST', 877849200, -21600, '0', 1),
(99, 'CST', 909298800, -21600, '0', 1),
(99, 'CST', 941353200, -21600, '0', 1),
(99, 'EST', 972802800, -18000, '0', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tz_zone`
--

CREATE TABLE `tz_zone` (
  `zone_id` int(10) NOT NULL,
  `country_code` char(2) NOT NULL,
  `zone_name` varchar(35) NOT NULL,
  `is_active` tinyint(4) NOT NULL COMMENT '0 = "No" and 1 = "Yes"'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tz_zone`
--

INSERT INTO `tz_zone` (`zone_id`, `country_code`, `zone_name`, `is_active`) VALUES
(1, 'AD', 'Europe/Andorra', 0),
(2, 'AE', 'Asia/Dubai', 0),
(3, 'AF', 'Asia/Kabul', 0),
(4, 'AG', 'America/Antigua', 0),
(5, 'AI', 'America/Anguilla', 0),
(6, 'AL', 'Europe/Tirane', 0),
(7, 'AM', 'Asia/Yerevan', 0),
(8, 'AO', 'Africa/Luanda', 0),
(9, 'AQ', 'Antarctica/McMurdo', 0),
(10, 'AQ', 'Antarctica/Casey', 0),
(11, 'AQ', 'Antarctica/Davis', 0),
(12, 'AQ', 'Antarctica/DumontDUrville', 0),
(13, 'AQ', 'Antarctica/Mawson', 0),
(14, 'AQ', 'Antarctica/Palmer', 0),
(15, 'AQ', 'Antarctica/Rothera', 0),
(16, 'AQ', 'Antarctica/Syowa', 0),
(17, 'AQ', 'Antarctica/Troll', 0),
(18, 'AQ', 'Antarctica/Vostok', 0),
(19, 'AR', 'America/Argentina/Buenos_Aires', 0),
(20, 'AR', 'America/Argentina/Cordoba', 0),
(21, 'AR', 'America/Argentina/Salta', 0),
(22, 'AR', 'America/Argentina/Jujuy', 0),
(23, 'AR', 'America/Argentina/Tucuman', 0),
(24, 'AR', 'America/Argentina/Catamarca', 0),
(25, 'AR', 'America/Argentina/La_Rioja', 0),
(26, 'AR', 'America/Argentina/San_Juan', 0),
(27, 'AR', 'America/Argentina/Mendoza', 0),
(28, 'AR', 'America/Argentina/San_Luis', 0),
(29, 'AR', 'America/Argentina/Rio_Gallegos', 0),
(30, 'AR', 'America/Argentina/Ushuaia', 0),
(31, 'AS', 'Pacific/Pago_Pago', 0),
(32, 'AT', 'Europe/Vienna', 0),
(33, 'AU', 'Australia/Lord_Howe', 0),
(34, 'AU', 'Antarctica/Macquarie', 0),
(35, 'AU', 'Australia/Hobart', 0),
(36, 'AU', 'Australia/Currie', 0),
(37, 'AU', 'Australia/Melbourne', 0),
(38, 'AU', 'Australia/Sydney', 1),
(39, 'AU', 'Australia/Broken_Hill', 0),
(40, 'AU', 'Australia/Brisbane', 0),
(41, 'AU', 'Australia/Lindeman', 0),
(42, 'AU', 'Australia/Adelaide', 1),
(43, 'AU', 'Australia/Darwin', 0),
(44, 'AU', 'Australia/Perth', 1),
(45, 'AU', 'Australia/Eucla', 0),
(46, 'AW', 'America/Aruba', 0),
(47, 'AX', 'Europe/Mariehamn', 0),
(48, 'AZ', 'Asia/Baku', 0),
(49, 'BA', 'Europe/Sarajevo', 0),
(50, 'BB', 'America/Barbados', 0),
(51, 'BD', 'Asia/Dhaka', 1),
(52, 'BE', 'Europe/Brussels', 1),
(53, 'BF', 'Africa/Ouagadougou', 0),
(54, 'BG', 'Europe/Sofia', 0),
(55, 'BH', 'Asia/Bahrain', 0),
(56, 'BI', 'Africa/Bujumbura', 0),
(57, 'BJ', 'Africa/Porto-Novo', 0),
(58, 'BL', 'America/St_Barthelemy', 0),
(59, 'BM', 'Atlantic/Bermuda', 0),
(60, 'BN', 'Asia/Brunei', 0),
(61, 'BO', 'America/La_Paz', 0),
(62, 'BQ', 'America/Kralendijk', 0),
(63, 'BR', 'America/Noronha', 0),
(64, 'BR', 'America/Belem', 0),
(65, 'BR', 'America/Fortaleza', 0),
(66, 'BR', 'America/Recife', 0),
(67, 'BR', 'America/Araguaina', 0),
(68, 'BR', 'America/Maceio', 0),
(69, 'BR', 'America/Bahia', 0),
(70, 'BR', 'America/Sao_Paulo', 1),
(71, 'BR', 'America/Campo_Grande', 0),
(72, 'BR', 'America/Cuiaba', 0),
(73, 'BR', 'America/Santarem', 0),
(74, 'BR', 'America/Porto_Velho', 0),
(75, 'BR', 'America/Boa_Vista', 0),
(76, 'BR', 'America/Manaus', 0),
(77, 'BR', 'America/Eirunepe', 0),
(78, 'BR', 'America/Rio_Branco', 1),
(79, 'BS', 'America/Nassau', 0),
(80, 'BT', 'Asia/Thimphu', 0),
(81, 'BW', 'Africa/Gaborone', 0),
(82, 'BY', 'Europe/Minsk', 0),
(83, 'BZ', 'America/Belize', 0),
(84, 'CA', 'America/St_Johns', 0),
(85, 'CA', 'America/Halifax', 0),
(86, 'CA', 'America/Glace_Bay', 0),
(87, 'CA', 'America/Moncton', 0),
(88, 'CA', 'America/Goose_Bay', 0),
(89, 'CA', 'America/Blanc-Sablon', 0),
(90, 'CA', 'America/Toronto', 0),
(91, 'CA', 'America/Nipigon', 0),
(92, 'CA', 'America/Thunder_Bay', 0),
(93, 'CA', 'America/Iqaluit', 0),
(94, 'CA', 'America/Pangnirtung', 0),
(95, 'CA', 'America/Atikokan', 0),
(96, 'CA', 'America/Winnipeg', 0),
(97, 'CA', 'America/Rainy_River', 0),
(98, 'CA', 'America/Resolute', 0),
(99, 'CA', 'America/Rankin_Inlet', 0),
(100, 'CA', 'America/Regina', 0),
(101, 'CA', 'America/Swift_Current', 0),
(102, 'CA', 'America/Edmonton', 0),
(103, 'CA', 'America/Cambridge_Bay', 0),
(104, 'CA', 'America/Yellowknife', 0),
(105, 'CA', 'America/Inuvik', 0),
(106, 'CA', 'America/Creston', 0),
(107, 'CA', 'America/Dawson_Creek', 0),
(108, 'CA', 'America/Fort_Nelson', 0),
(109, 'CA', 'America/Vancouver', 0),
(110, 'CA', 'America/Whitehorse', 0),
(111, 'CA', 'America/Dawson', 0),
(112, 'CC', 'Indian/Cocos', 0),
(113, 'CD', 'Africa/Kinshasa', 0),
(114, 'CD', 'Africa/Lubumbashi', 0),
(115, 'CF', 'Africa/Bangui', 0),
(116, 'CG', 'Africa/Brazzaville', 0),
(117, 'CH', 'Europe/Zurich', 0),
(118, 'CI', 'Africa/Abidjan', 0),
(119, 'CK', 'Pacific/Rarotonga', 0),
(120, 'CL', 'America/Santiago', 0),
(121, 'CL', 'Pacific/Easter', 0),
(122, 'CM', 'Africa/Douala', 0),
(123, 'CN', 'Asia/Shanghai', 0),
(124, 'CN', 'Asia/Urumqi', 0),
(125, 'CO', 'America/Bogota', 0),
(126, 'CR', 'America/Costa_Rica', 0),
(127, 'CU', 'America/Havana', 0),
(128, 'CV', 'Atlantic/Cape_Verde', 0),
(129, 'CW', 'America/Curacao', 0),
(130, 'CX', 'Indian/Christmas', 0),
(131, 'CY', 'Asia/Nicosia', 0),
(132, 'CZ', 'Europe/Prague', 0),
(133, 'DE', 'Europe/Berlin', 1),
(134, 'DE', 'Europe/Busingen', 0),
(135, 'DJ', 'Africa/Djibouti', 0),
(136, 'DK', 'Europe/Copenhagen', 0),
(137, 'DM', 'America/Dominica', 0),
(138, 'DO', 'America/Santo_Domingo', 0),
(139, 'DZ', 'Africa/Algiers', 0),
(140, 'EC', 'America/Guayaquil', 0),
(141, 'EC', 'Pacific/Galapagos', 0),
(142, 'EE', 'Europe/Tallinn', 0),
(143, 'EG', 'Africa/Cairo', 0),
(144, 'EH', 'Africa/El_Aaiun', 0),
(145, 'ER', 'Africa/Asmara', 0),
(146, 'ES', 'Europe/Madrid', 0),
(147, 'ES', 'Africa/Ceuta', 0),
(148, 'ES', 'Atlantic/Canary', 0),
(149, 'ET', 'Africa/Addis_Ababa', 0),
(150, 'FI', 'Europe/Helsinki', 0),
(151, 'FJ', 'Pacific/Fiji', 0),
(152, 'FK', 'Atlantic/Stanley', 0),
(153, 'FM', 'Pacific/Chuuk', 0),
(154, 'FM', 'Pacific/Pohnpei', 0),
(155, 'FM', 'Pacific/Kosrae', 0),
(156, 'FO', 'Atlantic/Faroe', 0),
(157, 'FR', 'Europe/Paris', 0),
(158, 'GA', 'Africa/Libreville', 0),
(159, 'GB', 'Europe/London', 0),
(160, 'GD', 'America/Grenada', 0),
(161, 'GE', 'Asia/Tbilisi', 0),
(162, 'GF', 'America/Cayenne', 0),
(163, 'GG', 'Europe/Guernsey', 0),
(164, 'GH', 'Africa/Accra', 1),
(165, 'GI', 'Europe/Gibraltar', 0),
(166, 'GL', 'America/Godthab', 0),
(167, 'GL', 'America/Danmarkshavn', 0),
(168, 'GL', 'America/Scoresbysund', 0),
(169, 'GL', 'America/Thule', 0),
(170, 'GM', 'Africa/Banjul', 0),
(171, 'GN', 'Africa/Conakry', 0),
(172, 'GP', 'America/Guadeloupe', 0),
(173, 'GQ', 'Africa/Malabo', 0),
(174, 'GR', 'Europe/Athens', 0),
(175, 'GS', 'Atlantic/South_Georgia', 0),
(176, 'GT', 'America/Guatemala', 0),
(177, 'GU', 'Pacific/Guam', 0),
(178, 'GW', 'Africa/Bissau', 0),
(179, 'GY', 'America/Guyana', 0),
(180, 'HK', 'Asia/Hong_Kong', 1),
(181, 'HN', 'America/Tegucigalpa', 0),
(182, 'HR', 'Europe/Zagreb', 0),
(183, 'HT', 'America/Port-au-Prince', 0),
(184, 'HU', 'Europe/Budapest', 0),
(185, 'ID', 'Asia/Jakarta', 1),
(186, 'ID', 'Asia/Pontianak', 0),
(187, 'ID', 'Asia/Makassar', 1),
(188, 'ID', 'Asia/Jayapura', 1),
(189, 'IE', 'Europe/Dublin', 0),
(190, 'IL', 'Asia/Jerusalem', 1),
(191, 'IM', 'Europe/Isle_of_Man', 0),
(192, 'IN', 'Asia/Kolkata', 1),
(193, 'IO', 'Indian/Chagos', 0),
(194, 'IQ', 'Asia/Baghdad', 0),
(195, 'IR', 'Asia/Tehran', 1),
(196, 'IS', 'Atlantic/Reykjavik', 0),
(197, 'IT', 'Europe/Rome', 0),
(198, 'JE', 'Europe/Jersey', 0),
(199, 'JM', 'America/Jamaica', 1),
(200, 'JO', 'Asia/Amman', 0),
(201, 'JP', 'Asia/Tokyo', 0),
(202, 'KE', 'Africa/Nairobi', 0),
(203, 'KG', 'Asia/Bishkek', 0),
(204, 'KH', 'Asia/Phnom_Penh', 0),
(205, 'KI', 'Pacific/Tarawa', 0),
(206, 'KI', 'Pacific/Enderbury', 0),
(207, 'KI', 'Pacific/Kiritimati', 0),
(208, 'KM', 'Indian/Comoro', 0),
(209, 'KN', 'America/St_Kitts', 0),
(210, 'KP', 'Asia/Pyongyang', 0),
(211, 'KR', 'Asia/Seoul', 0),
(212, 'KW', 'Asia/Kuwait', 1),
(213, 'KY', 'America/Cayman', 0),
(214, 'KZ', 'Asia/Almaty', 0),
(215, 'KZ', 'Asia/Qyzylorda', 0),
(216, 'KZ', 'Asia/Aqtobe', 0),
(217, 'KZ', 'Asia/Aqtau', 0),
(218, 'KZ', 'Asia/Oral', 0),
(219, 'LA', 'Asia/Vientiane', 0),
(220, 'LB', 'Asia/Beirut', 0),
(221, 'LC', 'America/St_Lucia', 0),
(222, 'LI', 'Europe/Vaduz', 0),
(223, 'LK', 'Asia/Colombo', 0),
(224, 'LR', 'Africa/Monrovia', 0),
(225, 'LS', 'Africa/Maseru', 0),
(226, 'LT', 'Europe/Vilnius', 0),
(227, 'LU', 'Europe/Luxembourg', 0),
(228, 'LV', 'Europe/Riga', 0),
(229, 'LY', 'Africa/Tripoli', 0),
(230, 'MA', 'Africa/Casablanca', 0),
(231, 'MC', 'Europe/Monaco', 0),
(232, 'MD', 'Europe/Chisinau', 0),
(233, 'ME', 'Europe/Podgorica', 0),
(234, 'MF', 'America/Marigot', 0),
(235, 'MG', 'Indian/Antananarivo', 0),
(236, 'MH', 'Pacific/Majuro', 0),
(237, 'MH', 'Pacific/Kwajalein', 0),
(238, 'MK', 'Europe/Skopje', 0),
(239, 'ML', 'Africa/Bamako', 0),
(240, 'MM', 'Asia/Rangoon', 1),
(241, 'MN', 'Asia/Ulaanbaatar', 0),
(242, 'MN', 'Asia/Hovd', 0),
(243, 'MN', 'Asia/Choibalsan', 0),
(244, 'MO', 'Asia/Macau', 0),
(245, 'MP', 'Pacific/Saipan', 0),
(246, 'MQ', 'America/Martinique', 1),
(247, 'MR', 'Africa/Nouakchott', 0),
(248, 'MS', 'America/Montserrat', 0),
(249, 'MT', 'Europe/Malta', 0),
(250, 'MU', 'Indian/Mauritius', 1),
(251, 'MV', 'Indian/Maldives', 0),
(252, 'MW', 'Africa/Blantyre', 0),
(253, 'MX', 'America/Mexico_City', 0),
(254, 'MX', 'America/Cancun', 0),
(255, 'MX', 'America/Merida', 0),
(256, 'MX', 'America/Monterrey', 0),
(257, 'MX', 'America/Matamoros', 0),
(258, 'MX', 'America/Mazatlan', 0),
(259, 'MX', 'America/Chihuahua', 0),
(260, 'MX', 'America/Ojinaga', 0),
(261, 'MX', 'America/Hermosillo', 0),
(262, 'MX', 'America/Tijuana', 0),
(263, 'MX', 'America/Bahia_Banderas', 0),
(264, 'MY', 'Asia/Kuala_Lumpur', 0),
(265, 'MY', 'Asia/Kuching', 0),
(266, 'MZ', 'Africa/Maputo', 0),
(267, 'NA', 'Africa/Windhoek', 0),
(268, 'NC', 'Pacific/Noumea', 0),
(269, 'NE', 'Africa/Niamey', 0),
(270, 'NF', 'Pacific/Norfolk', 0),
(271, 'NG', 'Africa/Lagos', 0),
(272, 'NI', 'America/Managua', 0),
(273, 'NL', 'Europe/Amsterdam', 0),
(274, 'NO', 'Europe/Oslo', 0),
(275, 'NP', 'Asia/Kathmandu', 1),
(276, 'NR', 'Pacific/Nauru', 0),
(277, 'NU', 'Pacific/Niue', 0),
(278, 'NZ', 'Pacific/Auckland', 1),
(279, 'NZ', 'Pacific/Chatham', 0),
(280, 'OM', 'Asia/Muscat', 0),
(281, 'PA', 'America/Panama', 0),
(282, 'PE', 'America/Lima', 0),
(283, 'PF', 'Pacific/Tahiti', 0),
(284, 'PF', 'Pacific/Marquesas', 1),
(285, 'PF', 'Pacific/Gambier', 0),
(286, 'PG', 'Pacific/Port_Moresby', 0),
(287, 'PG', 'Pacific/Bougainville', 0),
(288, 'PH', 'Asia/Manila', 1),
(289, 'PK', 'Asia/Karachi', 0),
(290, 'PL', 'Europe/Warsaw', 0),
(291, 'PM', 'America/Miquelon', 0),
(292, 'PN', 'Pacific/Pitcairn', 0),
(293, 'PR', 'America/Puerto_Rico', 0),
(294, 'PS', 'Asia/Gaza', 0),
(295, 'PS', 'Asia/Hebron', 0),
(296, 'PT', 'Europe/Lisbon', 0),
(297, 'PT', 'Atlantic/Madeira', 0),
(298, 'PT', 'Atlantic/Azores', 0),
(299, 'PW', 'Pacific/Palau', 0),
(300, 'PY', 'America/Asuncion', 0),
(301, 'QA', 'Asia/Qatar', 0),
(302, 'RE', 'Indian/Reunion', 0),
(303, 'RO', 'Europe/Bucharest', 0),
(304, 'RS', 'Europe/Belgrade', 0),
(305, 'RU', 'Europe/Kaliningrad', 0),
(306, 'RU', 'Europe/Moscow', 1),
(307, 'RU', 'Europe/Simferopol', 0),
(308, 'RU', 'Europe/Volgograd', 0),
(309, 'RU', 'Europe/Kirov', 0),
(310, 'RU', 'Europe/Astrakhan', 0),
(311, 'RU', 'Europe/Samara', 0),
(312, 'RU', 'Europe/Ulyanovsk', 0),
(313, 'RU', 'Asia/Yekaterinburg', 0),
(314, 'RU', 'Asia/Omsk', 0),
(315, 'RU', 'Asia/Novosibirsk', 0),
(316, 'RU', 'Asia/Barnaul', 0),
(317, 'RU', 'Asia/Tomsk', 0),
(318, 'RU', 'Asia/Novokuznetsk', 0),
(319, 'RU', 'Asia/Krasnoyarsk', 0),
(320, 'RU', 'Asia/Irkutsk', 0),
(321, 'RU', 'Asia/Chita', 0),
(322, 'RU', 'Asia/Yakutsk', 0),
(323, 'RU', 'Asia/Khandyga', 0),
(324, 'RU', 'Asia/Vladivostok', 0),
(325, 'RU', 'Asia/Ust-Nera', 0),
(326, 'RU', 'Asia/Magadan', 0),
(327, 'RU', 'Asia/Sakhalin', 0),
(328, 'RU', 'Asia/Srednekolymsk', 0),
(329, 'RU', 'Asia/Kamchatka', 0),
(330, 'RU', 'Asia/Anadyr', 0),
(331, 'RW', 'Africa/Kigali', 0),
(332, 'SA', 'Asia/Riyadh', 0),
(333, 'SB', 'Pacific/Guadalcanal', 0),
(334, 'SC', 'Indian/Mahe', 0),
(335, 'SD', 'Africa/Khartoum', 0),
(336, 'SE', 'Europe/Stockholm', 0),
(337, 'SG', 'Asia/Singapore', 1),
(338, 'SH', 'Atlantic/St_Helena', 0),
(339, 'SI', 'Europe/Ljubljana', 0),
(340, 'SJ', 'Arctic/Longyearbyen', 0),
(341, 'SK', 'Europe/Bratislava', 0),
(342, 'SL', 'Africa/Freetown', 0),
(343, 'SM', 'Europe/San_Marino', 0),
(344, 'SN', 'Africa/Dakar', 0),
(345, 'SO', 'Africa/Mogadishu', 0),
(346, 'SR', 'America/Paramaribo', 0),
(347, 'SS', 'Africa/Juba', 0),
(348, 'ST', 'Africa/Sao_Tome', 0),
(349, 'SV', 'America/El_Salvador', 0),
(350, 'SX', 'America/Lower_Princes', 0),
(351, 'SY', 'Asia/Damascus', 0),
(352, 'SZ', 'Africa/Mbabane', 0),
(353, 'TC', 'America/Grand_Turk', 0),
(354, 'TD', 'Africa/Ndjamena', 0),
(355, 'TF', 'Indian/Kerguelen', 0),
(356, 'TG', 'Africa/Lome', 0),
(357, 'TH', 'Asia/Bangkok', 1),
(358, 'TJ', 'Asia/Dushanbe', 0),
(359, 'TK', 'Pacific/Fakaofo', 0),
(360, 'TL', 'Asia/Dili', 0),
(361, 'TM', 'Asia/Ashgabat', 0),
(362, 'TN', 'Africa/Tunis', 0),
(363, 'TO', 'Pacific/Tongatapu', 0),
(364, 'TR', 'Europe/Istanbul', 0),
(365, 'TT', 'America/Port_of_Spain', 0),
(366, 'TV', 'Pacific/Funafuti', 0),
(367, 'TW', 'Asia/Taipei', 0),
(368, 'TZ', 'Africa/Dar_es_Salaam', 0),
(369, 'UA', 'Europe/Kiev', 0),
(370, 'UA', 'Europe/Uzhgorod', 0),
(371, 'UA', 'Europe/Zaporozhye', 0),
(372, 'UG', 'Africa/Kampala', 0),
(373, 'UM', 'Pacific/Johnston', 0),
(374, 'UM', 'Pacific/Midway', 1),
(375, 'UM', 'Pacific/Wake', 0),
(376, 'US', 'America/New_York', 1),
(377, 'US', 'America/Detroit', 0),
(378, 'US', 'America/Kentucky/Louisville', 0),
(379, 'US', 'America/Kentucky/Monticello', 0),
(380, 'US', 'America/Indiana/Indianapolis', 0),
(381, 'US', 'America/Indiana/Vincennes', 0),
(382, 'US', 'America/Indiana/Winamac', 0),
(383, 'US', 'America/Indiana/Marengo', 0),
(384, 'US', 'America/Indiana/Petersburg', 0),
(385, 'US', 'America/Indiana/Vevay', 0),
(386, 'US', 'America/Chicago', 1),
(387, 'US', 'America/Indiana/Tell_City', 0),
(388, 'US', 'America/Indiana/Knox', 0),
(389, 'US', 'America/Menominee', 0),
(390, 'US', 'America/North_Dakota/Center', 0),
(391, 'US', 'America/North_Dakota/New_Salem', 0),
(392, 'US', 'America/North_Dakota/Beulah', 0),
(393, 'US', 'America/Denver', 1),
(394, 'US', 'America/Boise', 0),
(395, 'US', 'America/Phoenix', 0),
(396, 'US', 'America/Los_Angeles', 1),
(397, 'US', 'America/Anchorage', 1),
(398, 'US', 'America/Juneau', 0),
(399, 'US', 'America/Sitka', 0),
(400, 'US', 'America/Metlakatla', 0),
(401, 'US', 'America/Yakutat', 0),
(402, 'US', 'America/Nome', 0),
(403, 'US', 'America/Adak', 0),
(404, 'US', 'Pacific/Honolulu', 1),
(405, 'UY', 'America/Montevideo', 0),
(406, 'UZ', 'Asia/Samarkand', 0),
(407, 'UZ', 'Asia/Tashkent', 0),
(408, 'VA', 'Europe/Vatican', 0),
(409, 'VC', 'America/St_Vincent', 0),
(410, 'VE', 'America/Caracas', 0),
(411, 'VG', 'America/Tortola', 0),
(412, 'VI', 'America/St_Thomas', 0),
(413, 'VN', 'Asia/Ho_Chi_Minh', 0),
(414, 'VU', 'Pacific/Efate', 0),
(415, 'WF', 'Pacific/Wallis', 0),
(416, 'WS', 'Pacific/Apia', 0),
(417, 'YE', 'Asia/Aden', 0),
(418, 'YT', 'Indian/Mayotte', 0),
(419, 'ZA', 'Africa/Johannesburg', 0),
(420, 'ZM', 'Africa/Lusaka', 0),
(421, 'ZW', 'Africa/Harare', 0);

-- --------------------------------------------------------

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'users -> id',
  `portfolio_id` int(11) NOT NULL COMMENT 'portfolio -> id',
  `phone_number` varchar(255) DEFAULT NULL,
  `secondary_email` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `country` int(11) DEFAULT NULL,
  `skype_id` varchar(255) DEFAULT NULL,
  `facebook_url` varchar(255) DEFAULT NULL,
  `twitter_url` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `user_log`
--

CREATE TABLE `user_log` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'users -> id',
  `portfolio_id` int(11) NOT NULL COMMENT 'portfolio -> id',
  `action_by_admin` int(11) NOT NULL COMMENT 'admins -> id',
  `action_by_user` int(11) NOT NULL COMMENT 'users -> id',
  `action_status` int(11) NOT NULL COMMENT 'j1_statuses -> id',
  `action_note` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for table `admin_role`
--
ALTER TABLE `admin_role`
  ADD KEY `admin_id` (`admin_id`),
  ADD KEY `role_id` (`role_id`);

--
-- Indexes for table `agency`
--
ALTER TABLE `agency`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `agency_contract`
--
ALTER TABLE `agency_contract`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `agency_id` (`agency_id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD KEY `portfolio_id` (`portfolio_id`),
  ADD KEY `contract_type` (`contract_type`),
  ADD KEY `request_status` (`request_status`);

--
-- Indexes for table `application_status_steps`
--
ALTER TABLE `application_status_steps`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `as_order_key` (`as_order_key`),
  ADD KEY `as_stage_number` (`as_stage_number`),
  ADD KEY `j1_status_id` (`j1_status_id`);

--
-- Indexes for table `conversation_attachment`
--
ALTER TABLE `conversation_attachment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `message_id` (`message_id`);

--
-- Indexes for table `conversation_clear_chat`
--
ALTER TABLE `conversation_clear_chat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `room_id` (`room_id`),
  ADD KEY `member_id` (`member_id`);

--
-- Indexes for table `conversation_messages`
--
ALTER TABLE `conversation_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `room_id` (`room_id`),
  ADD KEY `from_id` (`from_id`);

--
-- Indexes for table `conversation_room`
--
ALTER TABLE `conversation_room`
  ADD PRIMARY KEY (`id`),
  ADD KEY `started_by_id` (`started_by_id`),
  ADD KEY `is_personal` (`is_personal`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `portfolio_id` (`portfolio_id`),
  ADD KEY `uploaded_by_admin` (`uploaded_by_admin`),
  ADD KEY `uploaded_by_user` (`uploaded_by_user`),
  ADD KEY `document_status` (`document_status`),
  ADD KEY `approved_by_admin` (`approved_by_admin`),
  ADD KEY `rejected_by_admin` (`rejected_by_admin`);

--
-- Indexes for table `document_requirements`
--
ALTER TABLE `document_requirements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `agency_id` (`agency_id`),
  ADD KEY `requirement_type` (`requirement_type`),
  ADD KEY `document_section` (`document_section`);

--
-- Indexes for table `domain_settings`
--
ALTER TABLE `domain_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `email_notification`
--
ALTER TABLE `email_notification`
  ADD PRIMARY KEY (`id`),
  ADD KEY `en_key` (`en_key`);

--
-- Indexes for table `faq_master`
--
ALTER TABLE `faq_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `forum_category`
--
ALTER TABLE `forum_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parent_category_id` (`parent_category_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `forum_tags`
--
ALTER TABLE `forum_tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forum_topics`
--
ALTER TABLE `forum_topics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `forum_subcategory_id` (`forum_subcategory_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `forum_topic_comments`
--
ALTER TABLE `forum_topic_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parent_comment_id` (`parent_comment_id`),
  ADD KEY `forum_topics_id` (`forum_topics_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `forum_topic_follow`
--
ALTER TABLE `forum_topic_follow`
  ADD PRIMARY KEY (`id`),
  ADD KEY `forum_topics_id` (`forum_topics_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `is_favorite` (`is_favorite`),
  ADD KEY `notification_status` (`notification_status`);

--
-- Indexes for table `forum_topic_likes`
--
ALTER TABLE `forum_topic_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `forum_topics_id` (`forum_topics_id`),
  ADD KEY `forum_comment_id` (`forum_comment_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `forum_topic_viewer`
--
ALTER TABLE `forum_topic_viewer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `forum_topics_id` (`forum_topics_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `friends`
--
ALTER TABLE `friends`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `friend_id` (`friend_id`),
  ADD KEY `request_status` (`request_status`),
  ADD KEY `request_is_read` (`request_is_read`);

--
-- Indexes for table `geo_airports`
--
ALTER TABLE `geo_airports`
  ADD PRIMARY KEY (`ap_id`);

--
-- Indexes for table `geo_country`
--
ALTER TABLE `geo_country`
  ADD PRIMARY KEY (`country_id`),
  ADD KEY `country_code` (`country_code`);

--
-- Indexes for table `geo_states`
--
ALTER TABLE `geo_states`
  ADD PRIMARY KEY (`state_id`);

--
-- Indexes for table `host_companies`
--
ALTER TABLE `host_companies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `host_company_positions`
--
ALTER TABLE `host_company_positions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hc_id` (`hc_id`),
  ADD KEY `status` (`status`),
  ADD KEY `is_housing` (`is_housing`),
  ADD KEY `created_by` (`created_by`);

--
-- Indexes for table `j1_statuses`
--
ALTER TABLE `j1_statuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category` (`category`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parent_id` (`parent_id`),
  ADD KEY `menu_section_id` (`permission_group_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notification_log`
--
ALTER TABLE `notification_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notification_type_id` (`notification_type_id`),
  ADD KEY `notification_message_id` (`notification_message_id`),
  ADD KEY `notified_to` (`notified_to`),
  ADD KEY `notified_by` (`notified_by`),
  ADD KEY `notified_by_type` (`notified_by_type`),
  ADD KEY `action_id` (`action_id`),
  ADD KEY `is_read` (`is_read`);

--
-- Indexes for table `notification_messages`
--
ALTER TABLE `notification_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notification_type_id` (`notification_type_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `notification_settings`
--
ALTER TABLE `notification_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notification_type_id` (`notification_type_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `j1app_status` (`j1app_status`),
  ADD KEY `email_status` (`email_status`),
  ADD KEY `sms_status` (`sms_status`);

--
-- Indexes for table `notification_types`
--
ALTER TABLE `notification_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `visible_to_user` (`visible_to_user`),
  ADD KEY `notification_mode` (`notification_mode`);

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`),
  ADD KEY `client_id` (`client_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `client_id` (`client_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permission_name` (`permission_name`),
  ADD KEY `permission_group_id` (`permission_group_id`);

--
-- Indexes for table `permission_group`
--
ALTER TABLE `permission_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `portfolio`
--
ALTER TABLE `portfolio`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `portfolio_number` (`portfolio_number`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `registration_agency_id` (`registration_agency_id`),
  ADD KEY `placement_agency_id` (`placement_agency_id`),
  ADD KEY `sponsor_agency_id` (`sponsor_agency_id`),
  ADD KEY `portfolio_status` (`portfolio_status`);

--
-- Indexes for table `profile_percentage`
--
ALTER TABLE `profile_percentage`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `resume`
--
ALTER TABLE `resume`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `resume_award`
--
ALTER TABLE `resume_award`
  ADD PRIMARY KEY (`id`),
  ADD KEY `resume_id` (`resume_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `resume_certificates`
--
ALTER TABLE `resume_certificates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `resume_id` (`resume_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `resume_eduback`
--
ALTER TABLE `resume_eduback`
  ADD PRIMARY KEY (`id`),
  ADD KEY `resume_id` (`resume_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `resume_exp`
--
ALTER TABLE `resume_exp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `resume_id` (`resume_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `role_name` (`role_name`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `role_permission`
--
ALTER TABLE `role_permission`
  ADD KEY `role_id` (`role_id`),
  ADD KEY `permission_id` (`permission_id`);

--
-- Indexes for table `socal_authorization`
--
ALTER TABLE `socal_authorization`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `google_email` (`google_email`),
  ADD KEY `google_id` (`google_id`),
  ADD KEY `twitter_email` (`twitter_email`),
  ADD KEY `twitter_id` (`twitter_id`),
  ADD KEY `facebook_email` (`facebook_email`),
  ADD KEY `facebook_id` (`facebook_id`);

--
-- Indexes for table `system_settings`
--
ALTER TABLE `system_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tz_abbreviation_name`
--
ALTER TABLE `tz_abbreviation_name`
  ADD PRIMARY KEY (`id`),
  ADD KEY `abbreviation` (`abbreviation`,`offset`);

--
-- Indexes for table `tz_country`
--
ALTER TABLE `tz_country`
  ADD KEY `idx_country_code` (`country_code`);

--
-- Indexes for table `tz_timezone`
--
ALTER TABLE `tz_timezone`
  ADD KEY `idx_zone_id` (`zone_id`),
  ADD KEY `idx_time_start` (`time_start`),
  ADD KEY `gmt_offset` (`gmt_offset`),
  ADD KEY `is_valid_zone` (`is_valid_zone`);

--
-- Indexes for table `tz_zone`
--
ALTER TABLE `tz_zone`
  ADD PRIMARY KEY (`zone_id`),
  ADD KEY `idx_zone_name` (`zone_name`),
  ADD KEY `country_code` (`country_code`),
  ADD KEY `is_active` (`is_active`);

--
-- Indexes for table `user_details`
--
ALTER TABLE `user_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `portfolio_id` (`portfolio_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `country` (`country`);

--
-- Indexes for table `user_log`
--
ALTER TABLE `user_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `portfolio_id` (`portfolio_id`),
  ADD KEY `action_by_admin` (`action_by_admin`),
  ADD KEY `action_by_user` (`action_by_user`),
  ADD KEY `action_status` (`action_status`);

--
-- AUTO_INCREMENT for table `agency`
--
ALTER TABLE `agency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `agency_contract`
--
ALTER TABLE `agency_contract`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `application_status_steps`
--
ALTER TABLE `application_status_steps`
  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `conversation_attachment`
--
ALTER TABLE `conversation_attachment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `conversation_clear_chat`
--
ALTER TABLE `conversation_clear_chat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `conversation_messages`
--
ALTER TABLE `conversation_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `conversation_room`
--
ALTER TABLE `conversation_room`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `document_requirements`
--
ALTER TABLE `document_requirements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `domain_settings`
--
ALTER TABLE `domain_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `email_notification`
--
ALTER TABLE `email_notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `faq_master`
--
ALTER TABLE `faq_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `forum_category`
--
ALTER TABLE `forum_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `forum_tags`
--
ALTER TABLE `forum_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `forum_topics`
--
ALTER TABLE `forum_topics`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `forum_topic_comments`
--
ALTER TABLE `forum_topic_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `forum_topic_follow`
--
ALTER TABLE `forum_topic_follow`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `forum_topic_likes`
--
ALTER TABLE `forum_topic_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `forum_topic_viewer`
--
ALTER TABLE `forum_topic_viewer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `friends`
--
ALTER TABLE `friends`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geo_airports`
--
ALTER TABLE `geo_airports`
  MODIFY `ap_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=727;

--
-- AUTO_INCREMENT for table `geo_country`
--
ALTER TABLE `geo_country`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=238;

--
-- AUTO_INCREMENT for table `geo_states`
--
ALTER TABLE `geo_states`
  MODIFY `state_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `host_companies`
--
ALTER TABLE `host_companies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `host_company_positions`
--
ALTER TABLE `host_company_positions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `j1_statuses`
--
ALTER TABLE `j1_statuses`
  MODIFY `id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6008;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `notification_log`
--
ALTER TABLE `notification_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_messages`
--
ALTER TABLE `notification_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_settings`
--
ALTER TABLE `notification_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_types`
--
ALTER TABLE `notification_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `permission_group`
--
ALTER TABLE `permission_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `portfolio`
--
ALTER TABLE `portfolio`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `profile_percentage`
--
ALTER TABLE `profile_percentage`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `resume`
--
ALTER TABLE `resume`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `resume_award`
--
ALTER TABLE `resume_award`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `resume_certificates`
--
ALTER TABLE `resume_certificates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `resume_eduback`
--
ALTER TABLE `resume_eduback`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `resume_exp`
--
ALTER TABLE `resume_exp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `socal_authorization`
--
ALTER TABLE `socal_authorization`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `system_settings`
--
ALTER TABLE `system_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tz_abbreviation_name`
--
ALTER TABLE `tz_abbreviation_name`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=229;

--
-- AUTO_INCREMENT for table `tz_zone`
--
ALTER TABLE `tz_zone`
  MODIFY `zone_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=422;

--
-- AUTO_INCREMENT for table `user_details`
--
ALTER TABLE `user_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_log`
--
ALTER TABLE `user_log`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
COMMIT;

