vitess.io/vitess@v0.16.2/go/test/endtoend/vreplication/tz.sql (about)

     1  # install only US/Pacific and UTC timezones, for e2e tests
     2  # this file is a subset of the output of "mysql_tzinfo_to_sql /usr/share/zoneinfo"
     3  # each time zone set starts with an "insert into time_zone". So we cut/paste all inserts from the start of our
     4  # candidate time zone upto the next one.
     5  TRUNCATE TABLE time_zone;
     6  TRUNCATE TABLE time_zone_name;
     7  TRUNCATE TABLE time_zone_transition;
     8  TRUNCATE TABLE time_zone_transition_type;
     9  START TRANSACTION;
    10  INSERT INTO time_zone (Use_leap_seconds)
    11  VALUES ('N');
    12  SET
    13  @time_zone_id= LAST_INSERT_ID();
    14  INSERT INTO time_zone_name (Name, Time_zone_id)
    15  VALUES ('US/Pacific', @time_zone_id);
    16  INSERT INTO time_zone_transition (Time_zone_id, Transition_time, Transition_type_id)
    17  VALUES (@time_zone_id, -2147483648, 2)
    18       , (@time_zone_id, -1633269600, 1)
    19       , (@time_zone_id, -1615129200, 2)
    20       , (@time_zone_id, -1601820000, 1)
    21       , (@time_zone_id, -1583679600, 2)
    22       , (@time_zone_id, -880207200, 3)
    23       , (@time_zone_id, -769395600, 4)
    24       , (@time_zone_id, -765385200, 2)
    25       , (@time_zone_id, -687967140, 1)
    26       , (@time_zone_id, -662655600, 2)
    27       , (@time_zone_id, -620838000, 1)
    28       , (@time_zone_id, -608137200, 2)
    29       , (@time_zone_id, -589388400, 1)
    30       , (@time_zone_id, -576082800, 2)
    31       , (@time_zone_id, -557938800, 1)
    32       , (@time_zone_id, -544633200, 2)
    33       , (@time_zone_id, -526489200, 1)
    34       , (@time_zone_id, -513183600, 2)
    35       , (@time_zone_id, -495039600, 1)
    36       , (@time_zone_id, -481734000, 2)
    37       , (@time_zone_id, -463590000, 1)
    38       , (@time_zone_id, -450284400, 2)
    39       , (@time_zone_id, -431535600, 1)
    40       , (@time_zone_id, -418230000, 2)
    41       , (@time_zone_id, -400086000, 1)
    42       , (@time_zone_id, -386780400, 2)
    43       , (@time_zone_id, -368636400, 1)
    44       , (@time_zone_id, -355330800, 2)
    45       , (@time_zone_id, -337186800, 1)
    46       , (@time_zone_id, -323881200, 2)
    47       , (@time_zone_id, -305737200, 1)
    48       , (@time_zone_id, -292431600, 2)
    49       , (@time_zone_id, -273682800, 1)
    50       , (@time_zone_id, -260982000, 2)
    51       , (@time_zone_id, -242233200, 1)
    52       , (@time_zone_id, -226508400, 2)
    53       , (@time_zone_id, -210783600, 1)
    54       , (@time_zone_id, -195058800, 2)
    55       , (@time_zone_id, -179334000, 1)
    56       , (@time_zone_id, -163609200, 2)
    57       , (@time_zone_id, -147884400, 1)
    58       , (@time_zone_id, -131554800, 2)
    59       , (@time_zone_id, -116434800, 1)
    60       , (@time_zone_id, -100105200, 2)
    61       , (@time_zone_id, -84376800, 1)
    62       , (@time_zone_id, -68655600, 2)
    63       , (@time_zone_id, -52927200, 1)
    64       , (@time_zone_id, -37206000, 2)
    65       , (@time_zone_id, -21477600, 1)
    66       , (@time_zone_id, -5756400, 2)
    67       , (@time_zone_id, 9972000, 1)
    68       , (@time_zone_id, 25693200, 2)
    69       , (@time_zone_id, 41421600, 1)
    70       , (@time_zone_id, 57747600, 2)
    71       , (@time_zone_id, 73476000, 1)
    72       , (@time_zone_id, 89197200, 2)
    73       , (@time_zone_id, 104925600, 1)
    74       , (@time_zone_id, 120646800, 2)
    75       , (@time_zone_id, 126698400, 1)
    76       , (@time_zone_id, 152096400, 2)
    77       , (@time_zone_id, 162381600, 1)
    78       , (@time_zone_id, 183546000, 2)
    79       , (@time_zone_id, 199274400, 1)
    80       , (@time_zone_id, 215600400, 2)
    81       , (@time_zone_id, 230724000, 1)
    82       , (@time_zone_id, 247050000, 2)
    83       , (@time_zone_id, 262778400, 1)
    84       , (@time_zone_id, 278499600, 2)
    85       , (@time_zone_id, 294228000, 1)
    86       , (@time_zone_id, 309949200, 2)
    87       , (@time_zone_id, 325677600, 1)
    88       , (@time_zone_id, 341398800, 2)
    89       , (@time_zone_id, 357127200, 1)
    90       , (@time_zone_id, 372848400, 2)
    91       , (@time_zone_id, 388576800, 1)
    92       , (@time_zone_id, 404902800, 2)
    93       , (@time_zone_id, 420026400, 1)
    94       , (@time_zone_id, 436352400, 2)
    95       , (@time_zone_id, 452080800, 1)
    96       , (@time_zone_id, 467802000, 2)
    97       , (@time_zone_id, 483530400, 1)
    98       , (@time_zone_id, 499251600, 2)
    99       , (@time_zone_id, 514980000, 1)
   100       , (@time_zone_id, 530701200, 2)
   101       , (@time_zone_id, 544615200, 1)
   102       , (@time_zone_id, 562150800, 2)
   103       , (@time_zone_id, 576064800, 1)
   104       , (@time_zone_id, 594205200, 2)
   105       , (@time_zone_id, 607514400, 1)
   106       , (@time_zone_id, 625654800, 2)
   107       , (@time_zone_id, 638964000, 1)
   108       , (@time_zone_id, 657104400, 2)
   109       , (@time_zone_id, 671018400, 1)
   110       , (@time_zone_id, 688554000, 2)
   111       , (@time_zone_id, 702468000, 1)
   112       , (@time_zone_id, 720003600, 2)
   113       , (@time_zone_id, 733917600, 1)
   114       , (@time_zone_id, 752058000, 2)
   115       , (@time_zone_id, 765367200, 1)
   116       , (@time_zone_id, 783507600, 2)
   117       , (@time_zone_id, 796816800, 1)
   118       , (@time_zone_id, 814957200, 2)
   119       , (@time_zone_id, 828871200, 1)
   120       , (@time_zone_id, 846406800, 2)
   121       , (@time_zone_id, 860320800, 1)
   122       , (@time_zone_id, 877856400, 2)
   123       , (@time_zone_id, 891770400, 1)
   124       , (@time_zone_id, 909306000, 2)
   125       , (@time_zone_id, 923220000, 1)
   126       , (@time_zone_id, 941360400, 2)
   127       , (@time_zone_id, 954669600, 1)
   128       , (@time_zone_id, 972810000, 2)
   129       , (@time_zone_id, 986119200, 1)
   130       , (@time_zone_id, 1004259600, 2)
   131       , (@time_zone_id, 1018173600, 1)
   132       , (@time_zone_id, 1035709200, 2)
   133       , (@time_zone_id, 1049623200, 1)
   134       , (@time_zone_id, 1067158800, 2)
   135       , (@time_zone_id, 1081072800, 1)
   136       , (@time_zone_id, 1099213200, 2)
   137       , (@time_zone_id, 1112522400, 1)
   138       , (@time_zone_id, 1130662800, 2)
   139       , (@time_zone_id, 1143972000, 1)
   140       , (@time_zone_id, 1162112400, 2)
   141       , (@time_zone_id, 1173607200, 1)
   142       , (@time_zone_id, 1194166800, 2)
   143       , (@time_zone_id, 1205056800, 1)
   144       , (@time_zone_id, 1225616400, 2)
   145       , (@time_zone_id, 1236506400, 1)
   146       , (@time_zone_id, 1257066000, 2)
   147       , (@time_zone_id, 1268560800, 1)
   148       , (@time_zone_id, 1289120400, 2)
   149       , (@time_zone_id, 1300010400, 1)
   150       , (@time_zone_id, 1320570000, 2)
   151       , (@time_zone_id, 1331460000, 1)
   152       , (@time_zone_id, 1352019600, 2)
   153       , (@time_zone_id, 1362909600, 1)
   154       , (@time_zone_id, 1383469200, 2)
   155       , (@time_zone_id, 1394359200, 1)
   156       , (@time_zone_id, 1414918800, 2)
   157       , (@time_zone_id, 1425808800, 1)
   158       , (@time_zone_id, 1446368400, 2)
   159       , (@time_zone_id, 1457863200, 1)
   160       , (@time_zone_id, 1478422800, 2)
   161       , (@time_zone_id, 1489312800, 1)
   162       , (@time_zone_id, 1509872400, 2)
   163       , (@time_zone_id, 1520762400, 1)
   164       , (@time_zone_id, 1541322000, 2)
   165       , (@time_zone_id, 1552212000, 1)
   166       , (@time_zone_id, 1572771600, 2)
   167       , (@time_zone_id, 1583661600, 1)
   168       , (@time_zone_id, 1604221200, 2)
   169       , (@time_zone_id, 1615716000, 1)
   170       , (@time_zone_id, 1636275600, 2)
   171       , (@time_zone_id, 1647165600, 1)
   172       , (@time_zone_id, 1667725200, 2)
   173       , (@time_zone_id, 1678615200, 1)
   174       , (@time_zone_id, 1699174800, 2)
   175       , (@time_zone_id, 1710064800, 1)
   176       , (@time_zone_id, 1730624400, 2)
   177       , (@time_zone_id, 1741514400, 1)
   178       , (@time_zone_id, 1762074000, 2)
   179       , (@time_zone_id, 1772964000, 1)
   180       , (@time_zone_id, 1793523600, 2)
   181       , (@time_zone_id, 1805018400, 1)
   182       , (@time_zone_id, 1825578000, 2)
   183       , (@time_zone_id, 1836468000, 1)
   184       , (@time_zone_id, 1857027600, 2)
   185       , (@time_zone_id, 1867917600, 1)
   186       , (@time_zone_id, 1888477200, 2)
   187       , (@time_zone_id, 1899367200, 1)
   188       , (@time_zone_id, 1919926800, 2)
   189       , (@time_zone_id, 1930816800, 1)
   190       , (@time_zone_id, 1951376400, 2)
   191       , (@time_zone_id, 1962871200, 1)
   192       , (@time_zone_id, 1983430800, 2)
   193       , (@time_zone_id, 1994320800, 1)
   194       , (@time_zone_id, 2014880400, 2)
   195       , (@time_zone_id, 2025770400, 1)
   196       , (@time_zone_id, 2046330000, 2)
   197       , (@time_zone_id, 2057220000, 1)
   198       , (@time_zone_id, 2077779600, 2)
   199       , (@time_zone_id, 2088669600, 1)
   200       , (@time_zone_id, 2109229200, 2)
   201       , (@time_zone_id, 2120119200, 1)
   202       , (@time_zone_id, 2140678800, 2)
   203  ;
   204  INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation)
   205  VALUES (@time_zone_id, 0, -28378, 0, 'LMT')
   206       , (@time_zone_id, 1, -25200, 1, 'PDT')
   207       , (@time_zone_id, 2, -28800, 0, 'PST')
   208       , (@time_zone_id, 3, -25200, 1, 'PWT')
   209       , (@time_zone_id, 4, -25200, 1, 'PPT')
   210  ;
   211  INSERT INTO time_zone (Use_leap_seconds) VALUES ('N');
   212  SET @time_zone_id= LAST_INSERT_ID();
   213  INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('UTC', @time_zone_id);
   214  INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
   215      (@time_zone_id, 0, 0, 0, 'UTC')
   216  ;
   217  COMMIT;