INSERT INTO time_zone (Use_leap_seconds) VALUES ('N');
SET @time_zone_id= LAST_INSERT_ID();
INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('Canada/Atlantic', @time_zone_id);
INSERT INTO time_zone_transition (Time_zone_id, Transition_time, Transition_type_id) VALUES
 (@time_zone_id, -2147483648, 0)
,(@time_zone_id, -2131645536, 2)
,(@time_zone_id, -1696276800, 1)
,(@time_zone_id, -1680469200, 2)
,(@time_zone_id, -1632074400, 1)
,(@time_zone_id, -1615143600, 2)
,(@time_zone_id, -1566763200, 1)
,(@time_zone_id, -1557090000, 2)
,(@time_zone_id, -1535486400, 1)
,(@time_zone_id, -1524949200, 2)
,(@time_zone_id, -1504468800, 1)
,(@time_zone_id, -1493413200, 2)
,(@time_zone_id, -1472414400, 1)
,(@time_zone_id, -1461963600, 2)
,(@time_zone_id, -1440964800, 1)
,(@time_zone_id, -1429390800, 2)
,(@time_zone_id, -1409515200, 1)
,(@time_zone_id, -1396731600, 2)
,(@time_zone_id, -1376856000, 1)
,(@time_zone_id, -1366491600, 2)
,(@time_zone_id, -1346616000, 1)
,(@time_zone_id, -1333832400, 2)
,(@time_zone_id, -1313956800, 1)
,(@time_zone_id, -1303678800, 2)
,(@time_zone_id, -1282507200, 1)
,(@time_zone_id, -1272661200, 2)
,(@time_zone_id, -1251057600, 1)
,(@time_zone_id, -1240088400, 2)
,(@time_zone_id, -1219608000, 1)
,(@time_zone_id, -1207429200, 2)
,(@time_zone_id, -1188763200, 1)
,(@time_zone_id, -1175979600, 2)
,(@time_zone_id, -1157313600, 1)
,(@time_zone_id, -1143925200, 2)
,(@time_zone_id, -1124049600, 1)
,(@time_zone_id, -1113771600, 2)
,(@time_zone_id, -1091390400, 1)
,(@time_zone_id, -1081026000, 2)
,(@time_zone_id, -1059854400, 1)
,(@time_zone_id, -1050786000, 2)
,(@time_zone_id, -1030910400, 1)
,(@time_zone_id, -1018126800, 2)
,(@time_zone_id, -999460800, 1)
,(@time_zone_id, -986677200, 2)
,(@time_zone_id, -965592000, 1)
,(@time_zone_id, -955227600, 2)
,(@time_zone_id, -935956800, 1)
,(@time_zone_id, -923173200, 2)
,(@time_zone_id, -904507200, 1)
,(@time_zone_id, -891723600, 2)
,(@time_zone_id, -880221600, 3)
,(@time_zone_id, -769395600, 4)
,(@time_zone_id, -765399600, 2)
,(@time_zone_id, -747252000, 1)
,(@time_zone_id, -733950000, 2)
,(@time_zone_id, -715802400, 1)
,(@time_zone_id, -702500400, 2)
,(@time_zone_id, -684352800, 1)
,(@time_zone_id, -671050800, 2)
,(@time_zone_id, -652903200, 1)
,(@time_zone_id, -639601200, 2)
,(@time_zone_id, -589399200, 1)
,(@time_zone_id, -576097200, 2)
,(@time_zone_id, -557949600, 1)
,(@time_zone_id, -544647600, 2)
,(@time_zone_id, -526500000, 1)
,(@time_zone_id, -513198000, 2)
,(@time_zone_id, -495050400, 1)
,(@time_zone_id, -481748400, 2)
,(@time_zone_id, -431546400, 1)
,(@time_zone_id, -418244400, 2)
,(@time_zone_id, -400096800, 1)
,(@time_zone_id, -386794800, 2)
,(@time_zone_id, -368647200, 1)
,(@time_zone_id, -355345200, 2)
,(@time_zone_id, -337197600, 1)
,(@time_zone_id, -323895600, 2)
,(@time_zone_id, -242244000, 1)
,(@time_zone_id, -226522800, 2)
,(@time_zone_id, -210794400, 1)
,(@time_zone_id, -195073200, 2)
,(@time_zone_id, -179344800, 1)
,(@time_zone_id, -163623600, 2)
,(@time_zone_id, -147895200, 1)
,(@time_zone_id, -131569200, 2)
,(@time_zone_id, -116445600, 1)
,(@time_zone_id, -100119600, 2)
,(@time_zone_id, -84391200, 1)
,(@time_zone_id, -68670000, 2)
,(@time_zone_id, -52941600, 1)
,(@time_zone_id, -37220400, 2)
,(@time_zone_id, -21492000, 1)
,(@time_zone_id, -5770800, 2)
,(@time_zone_id, 9957600, 1)
,(@time_zone_id, 25678800, 2)
,(@time_zone_id, 41407200, 1)
,(@time_zone_id, 57733200, 2)
,(@time_zone_id, 73461600, 1)
,(@time_zone_id, 89182800, 2)
,(@time_zone_id, 104911200, 1)
,(@time_zone_id, 120632400, 2)
,(@time_zone_id, 136360800, 1)
,(@time_zone_id, 152082000, 2)
,(@time_zone_id, 167810400, 1)
,(@time_zone_id, 183531600, 2)
,(@time_zone_id, 199260000, 1)
,(@time_zone_id, 215586000, 2)
,(@time_zone_id, 230709600, 1)
,(@time_zone_id, 247035600, 2)
,(@time_zone_id, 262764000, 1)
,(@time_zone_id, 278485200, 2)
,(@time_zone_id, 294213600, 1)
,(@time_zone_id, 309934800, 2)
,(@time_zone_id, 325663200, 1)
,(@time_zone_id, 341384400, 2)
,(@time_zone_id, 357112800, 1)
,(@time_zone_id, 372834000, 2)
,(@time_zone_id, 388562400, 1)
,(@time_zone_id, 404888400, 2)
,(@time_zone_id, 420012000, 1)
,(@time_zone_id, 436338000, 2)
,(@time_zone_id, 452066400, 1)
,(@time_zone_id, 467787600, 2)
,(@time_zone_id, 483516000, 1)
,(@time_zone_id, 499237200, 2)
,(@time_zone_id, 514965600, 1)
,(@time_zone_id, 530686800, 2)
,(@time_zone_id, 544600800, 1)
,(@time_zone_id, 562136400, 2)
,(@time_zone_id, 576050400, 1)
,(@time_zone_id, 594190800, 2)
,(@time_zone_id, 607500000, 1)
,(@time_zone_id, 625640400, 2)
,(@time_zone_id, 638949600, 1)
,(@time_zone_id, 657090000, 2)
,(@time_zone_id, 671004000, 1)
,(@time_zone_id, 688539600, 2)
,(@time_zone_id, 702453600, 1)
,(@time_zone_id, 719989200, 2)
,(@time_zone_id, 733903200, 1)
,(@time_zone_id, 752043600, 2)
,(@time_zone_id, 765352800, 1)
,(@time_zone_id, 783493200, 2)
,(@time_zone_id, 796802400, 1)
,(@time_zone_id, 814942800, 2)
,(@time_zone_id, 828856800, 1)
,(@time_zone_id, 846392400, 2)
,(@time_zone_id, 860306400, 1)
,(@time_zone_id, 877842000, 2)
,(@time_zone_id, 891756000, 1)
,(@time_zone_id, 909291600, 2)
,(@time_zone_id, 923205600, 1)
,(@time_zone_id, 941346000, 2)
,(@time_zone_id, 954655200, 1)
,(@time_zone_id, 972795600, 2)
,(@time_zone_id, 986104800, 1)
,(@time_zone_id, 1004245200, 2)
,(@time_zone_id, 1018159200, 1)
,(@time_zone_id, 1035694800, 2)
,(@time_zone_id, 1049608800, 1)
,(@time_zone_id, 1067144400, 2)
,(@time_zone_id, 1081058400, 1)
,(@time_zone_id, 1099198800, 2)
,(@time_zone_id, 1112508000, 1)
,(@time_zone_id, 1130648400, 2)
,(@time_zone_id, 1143957600, 1)
,(@time_zone_id, 1162098000, 2)
,(@time_zone_id, 1173592800, 1)
,(@time_zone_id, 1194152400, 2)
,(@time_zone_id, 1205042400, 1)
,(@time_zone_id, 1225602000, 2)
,(@time_zone_id, 1236492000, 1)
,(@time_zone_id, 1257051600, 2)
,(@time_zone_id, 1268546400, 1)
,(@time_zone_id, 1289106000, 2)
,(@time_zone_id, 1299996000, 1)
,(@time_zone_id, 1320555600, 2)
,(@time_zone_id, 1331445600, 1)
,(@time_zone_id, 1352005200, 2)
,(@time_zone_id, 1362895200, 1)
,(@time_zone_id, 1383454800, 2)
,(@time_zone_id, 1394344800, 1)
,(@time_zone_id, 1414904400, 2)
,(@time_zone_id, 1425794400, 1)
,(@time_zone_id, 1446354000, 2)
,(@time_zone_id, 1457848800, 1)
,(@time_zone_id, 1478408400, 2)
,(@time_zone_id, 1489298400, 1)
,(@time_zone_id, 1509858000, 2)
,(@time_zone_id, 1520748000, 1)
,(@time_zone_id, 1541307600, 2)
,(@time_zone_id, 1552197600, 1)
,(@time_zone_id, 1572757200, 2)
,(@time_zone_id, 1583647200, 1)
,(@time_zone_id, 1604206800, 2)
,(@time_zone_id, 1615701600, 1)
,(@time_zone_id, 1636261200, 2)
,(@time_zone_id, 1647151200, 1)
,(@time_zone_id, 1667710800, 2)
,(@time_zone_id, 1678600800, 1)
,(@time_zone_id, 1699160400, 2)
,(@time_zone_id, 1710050400, 1)
,(@time_zone_id, 1730610000, 2)
,(@time_zone_id, 1741500000, 1)
,(@time_zone_id, 1762059600, 2)
,(@time_zone_id, 1772949600, 1)
,(@time_zone_id, 1793509200, 2)
,(@time_zone_id, 1805004000, 1)
,(@time_zone_id, 1825563600, 2)
,(@time_zone_id, 1836453600, 1)
,(@time_zone_id, 1857013200, 2)
,(@time_zone_id, 1867903200, 1)
,(@time_zone_id, 1888462800, 2)
,(@time_zone_id, 1899352800, 1)
,(@time_zone_id, 1919912400, 2)
,(@time_zone_id, 1930802400, 1)
,(@time_zone_id, 1951362000, 2)
,(@time_zone_id, 1962856800, 1)
,(@time_zone_id, 1983416400, 2)
,(@time_zone_id, 1994306400, 1)
,(@time_zone_id, 2014866000, 2)
,(@time_zone_id, 2025756000, 1)
,(@time_zone_id, 2046315600, 2)
,(@time_zone_id, 2057205600, 1)
,(@time_zone_id, 2077765200, 2)
,(@time_zone_id, 2088655200, 1)
,(@time_zone_id, 2109214800, 2)
,(@time_zone_id, 2120104800, 1)
,(@time_zone_id, 2140664400, 2)
;
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
 (@time_zone_id, 0, -15264, 0, 'LMT')
,(@time_zone_id, 1, -10800, 1, 'ADT')
,(@time_zone_id, 2, -14400, 0, 'AST')
,(@time_zone_id, 3, -10800, 1, 'AWT')
,(@time_zone_id, 4, -10800, 1, 'APT')
;


INSERT INTO time_zone (Use_leap_seconds) VALUES ('N');
SET @time_zone_id= LAST_INSERT_ID();
INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('Europe/Paris', @time_zone_id);
INSERT INTO time_zone_transition (Time_zone_id, Transition_time, Transition_type_id) VALUES
 (@time_zone_id, -2147483648, 1)
,(@time_zone_id, -1855958901, 5)
,(@time_zone_id, -1689814800, 2)
,(@time_zone_id, -1680397200, 3)
,(@time_zone_id, -1665363600, 2)
,(@time_zone_id, -1648342800, 3)
,(@time_zone_id, -1635123600, 2)
,(@time_zone_id, -1616893200, 3)
,(@time_zone_id, -1604278800, 2)
,(@time_zone_id, -1585443600, 3)
,(@time_zone_id, -1574038800, 2)
,(@time_zone_id, -1552266000, 3)
,(@time_zone_id, -1539997200, 2)
,(@time_zone_id, -1520557200, 3)
,(@time_zone_id, -1507510800, 2)
,(@time_zone_id, -1490576400, 3)
,(@time_zone_id, -1470618000, 2)
,(@time_zone_id, -1459126800, 3)
,(@time_zone_id, -1444006800, 2)
,(@time_zone_id, -1427677200, 3)
,(@time_zone_id, -1411952400, 2)
,(@time_zone_id, -1396227600, 3)
,(@time_zone_id, -1379293200, 2)
,(@time_zone_id, -1364778000, 3)
,(@time_zone_id, -1348448400, 2)
,(@time_zone_id, -1333328400, 3)
,(@time_zone_id, -1316394000, 2)
,(@time_zone_id, -1301274000, 3)
,(@time_zone_id, -1284339600, 2)
,(@time_zone_id, -1269824400, 3)
,(@time_zone_id, -1253494800, 2)
,(@time_zone_id, -1238374800, 3)
,(@time_zone_id, -1221440400, 2)
,(@time_zone_id, -1206925200, 3)
,(@time_zone_id, -1191200400, 2)
,(@time_zone_id, -1175475600, 3)
,(@time_zone_id, -1160355600, 2)
,(@time_zone_id, -1143421200, 3)
,(@time_zone_id, -1127696400, 2)
,(@time_zone_id, -1111971600, 3)
,(@time_zone_id, -1096851600, 2)
,(@time_zone_id, -1080522000, 3)
,(@time_zone_id, -1063587600, 2)
,(@time_zone_id, -1049072400, 3)
,(@time_zone_id, -1033347600, 2)
,(@time_zone_id, -1017622800, 3)
,(@time_zone_id, -1002502800, 2)
,(@time_zone_id, -986173200, 3)
,(@time_zone_id, -969238800, 2)
,(@time_zone_id, -950490000, 3)
,(@time_zone_id, -942012000, 4)
,(@time_zone_id, -932436000, 8)
,(@time_zone_id, -857257200, 6)
,(@time_zone_id, -844556400, 7)
,(@time_zone_id, -828226800, 6)
,(@time_zone_id, -812502000, 7)
,(@time_zone_id, -800071200, 9)
,(@time_zone_id, -796266000, 4)
,(@time_zone_id, -781052400, 9)
,(@time_zone_id, -766623600, 10)
,(@time_zone_id, 196819200, 8)
,(@time_zone_id, 212540400, 10)
,(@time_zone_id, 228877200, 11)
,(@time_zone_id, 243997200, 12)
,(@time_zone_id, 260326800, 11)
,(@time_zone_id, 276051600, 12)
,(@time_zone_id, 291776400, 11)
,(@time_zone_id, 307501200, 12)
,(@time_zone_id, 323830800, 11)
,(@time_zone_id, 338950800, 12)
,(@time_zone_id, 354675600, 11)
,(@time_zone_id, 370400400, 12)
,(@time_zone_id, 386125200, 11)
,(@time_zone_id, 401850000, 12)
,(@time_zone_id, 417574800, 11)
,(@time_zone_id, 433299600, 12)
,(@time_zone_id, 449024400, 11)
,(@time_zone_id, 465354000, 12)
,(@time_zone_id, 481078800, 11)
,(@time_zone_id, 496803600, 12)
,(@time_zone_id, 512528400, 11)
,(@time_zone_id, 528253200, 12)
,(@time_zone_id, 543978000, 11)
,(@time_zone_id, 559702800, 12)
,(@time_zone_id, 575427600, 11)
,(@time_zone_id, 591152400, 12)
,(@time_zone_id, 606877200, 11)
,(@time_zone_id, 622602000, 12)
,(@time_zone_id, 638326800, 11)
,(@time_zone_id, 654656400, 12)
,(@time_zone_id, 670381200, 11)
,(@time_zone_id, 686106000, 12)
,(@time_zone_id, 701830800, 11)
,(@time_zone_id, 717555600, 12)
,(@time_zone_id, 733280400, 11)
,(@time_zone_id, 749005200, 12)
,(@time_zone_id, 764730000, 11)
,(@time_zone_id, 780454800, 12)
,(@time_zone_id, 796179600, 11)
,(@time_zone_id, 811904400, 12)
,(@time_zone_id, 828234000, 11)
,(@time_zone_id, 846378000, 12)
,(@time_zone_id, 859683600, 11)
,(@time_zone_id, 877827600, 12)
,(@time_zone_id, 891133200, 11)
,(@time_zone_id, 909277200, 12)
,(@time_zone_id, 922582800, 11)
,(@time_zone_id, 941331600, 12)
,(@time_zone_id, 954032400, 11)
,(@time_zone_id, 972781200, 12)
,(@time_zone_id, 985482000, 11)
,(@time_zone_id, 1004230800, 12)
,(@time_zone_id, 1017536400, 11)
,(@time_zone_id, 1035680400, 12)
,(@time_zone_id, 1048986000, 11)
,(@time_zone_id, 1067130000, 12)
,(@time_zone_id, 1080435600, 11)
,(@time_zone_id, 1099184400, 12)
,(@time_zone_id, 1111885200, 11)
,(@time_zone_id, 1130634000, 12)
,(@time_zone_id, 1143334800, 11)
,(@time_zone_id, 1162083600, 12)
,(@time_zone_id, 1174784400, 11)
,(@time_zone_id, 1193533200, 12)
,(@time_zone_id, 1206838800, 11)
,(@time_zone_id, 1224982800, 12)
,(@time_zone_id, 1238288400, 11)
,(@time_zone_id, 1256432400, 12)
,(@time_zone_id, 1269738000, 11)
,(@time_zone_id, 1288486800, 12)
,(@time_zone_id, 1301187600, 11)
,(@time_zone_id, 1319936400, 12)
,(@time_zone_id, 1332637200, 11)
,(@time_zone_id, 1351386000, 12)
,(@time_zone_id, 1364691600, 11)
,(@time_zone_id, 1382835600, 12)
,(@time_zone_id, 1396141200, 11)
,(@time_zone_id, 1414285200, 12)
,(@time_zone_id, 1427590800, 11)
,(@time_zone_id, 1445734800, 12)
,(@time_zone_id, 1459040400, 11)
,(@time_zone_id, 1477789200, 12)
,(@time_zone_id, 1490490000, 11)
,(@time_zone_id, 1509238800, 12)
,(@time_zone_id, 1521939600, 11)
,(@time_zone_id, 1540688400, 12)
,(@time_zone_id, 1553994000, 11)
,(@time_zone_id, 1572138000, 12)
,(@time_zone_id, 1585443600, 11)
,(@time_zone_id, 1603587600, 12)
,(@time_zone_id, 1616893200, 11)
,(@time_zone_id, 1635642000, 12)
,(@time_zone_id, 1648342800, 11)
,(@time_zone_id, 1667091600, 12)
,(@time_zone_id, 1679792400, 11)
,(@time_zone_id, 1698541200, 12)
,(@time_zone_id, 1711846800, 11)
,(@time_zone_id, 1729990800, 12)
,(@time_zone_id, 1743296400, 11)
,(@time_zone_id, 1761440400, 12)
,(@time_zone_id, 1774746000, 11)
,(@time_zone_id, 1792890000, 12)
,(@time_zone_id, 1806195600, 11)
,(@time_zone_id, 1824944400, 12)
,(@time_zone_id, 1837645200, 11)
,(@time_zone_id, 1856394000, 12)
,(@time_zone_id, 1869094800, 11)
,(@time_zone_id, 1887843600, 12)
,(@time_zone_id, 1901149200, 11)
,(@time_zone_id, 1919293200, 12)
,(@time_zone_id, 1932598800, 11)
,(@time_zone_id, 1950742800, 12)
,(@time_zone_id, 1964048400, 11)
,(@time_zone_id, 1982797200, 12)
,(@time_zone_id, 1995498000, 11)
,(@time_zone_id, 2014246800, 12)
,(@time_zone_id, 2026947600, 11)
,(@time_zone_id, 2045696400, 12)
,(@time_zone_id, 2058397200, 11)
,(@time_zone_id, 2077146000, 12)
,(@time_zone_id, 2090451600, 11)
,(@time_zone_id, 2108595600, 12)
,(@time_zone_id, 2121901200, 11)
,(@time_zone_id, 2140045200, 12)
;
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
 (@time_zone_id, 0, 561, 0, 'LMT')
,(@time_zone_id, 1, 561, 0, 'PMT')
,(@time_zone_id, 2, 3600, 1, 'WEST')
,(@time_zone_id, 3, 0, 0, 'WET')
,(@time_zone_id, 4, 3600, 1, 'WEST')
,(@time_zone_id, 5, 0, 0, 'WET')
,(@time_zone_id, 6, 3600, 0, 'CET')
,(@time_zone_id, 7, 7200, 1, 'CEST')
,(@time_zone_id, 8, 7200, 1, 'CEST')
,(@time_zone_id, 9, 7200, 1, 'WEMT')
,(@time_zone_id, 10, 3600, 0, 'CET')
,(@time_zone_id, 11, 7200, 1, 'CEST')
,(@time_zone_id, 12, 3600, 0, 'CET')
;