github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20170120050000_alter_teacher.sql (about)

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  CREATE TABLE IF NOT EXISTS m_country (
     4    `id` SMALLINT unsigned NOT NULL,
     5    `name` varchar(255) NOT NULL,
     6    `name_ja` varchar(255) NOT NULL,
     7    `created_at` datetime NOT NULL,
     8    `updated_at` datetime NOT NULL
     9  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    10  
    11  ALTER TABLE teacher
    12    ADD COLUMN `country_id` SMALLINT NOT NULL DEFAULT 0 AFTER `name`,
    13    ADD COLUMN `gender` ENUM('female', 'male', 'other') NOT NULL DEFAULT 'other' AFTER `country_id`,
    14    ADD COLUMN `birthday` DATE NOT NULL AFTER `gender`,
    15    ADD COLUMN `years_of_experience` TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER `birthday`;
    16  
    17  BEGIN;
    18  INSERT INTO `m_country` VALUES (352,'Iceland','アイスランド','2017-01-20 19:49:29','2017-01-20 19:49:29');
    19  INSERT INTO `m_country` VALUES (372,'Ireland','アイルランド','2017-01-20 19:51:53','2017-01-20 19:51:53');
    20  INSERT INTO `m_country` VALUES (31,'Azerbaijan','アゼルバイジャン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    21  INSERT INTO `m_country` VALUES (4,'Afghanistan','アフガニスタン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    22  INSERT INTO `m_country` VALUES (840,'United States','アメリカ合衆国','2017-01-20 19:51:53','2017-01-20 19:51:53');
    23  INSERT INTO `m_country` VALUES (850,'Virgin Islands, U.S.','アメリカ領ヴァージン諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    24  INSERT INTO `m_country` VALUES (16,'American Samoa','アメリカ領サモア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    25  INSERT INTO `m_country` VALUES (784,'United Arab Emirates','アラブ首長国連邦','2017-01-20 19:51:53','2017-01-20 19:51:53');
    26  INSERT INTO `m_country` VALUES (12,'Algeria','アルジェリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    27  INSERT INTO `m_country` VALUES (32,'Argentina','アルゼンチン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    28  INSERT INTO `m_country` VALUES (533,'Aruba','アルバ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    29  INSERT INTO `m_country` VALUES (8,'Albania','アルバニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    30  INSERT INTO `m_country` VALUES (51,'Armenia','アルメニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    31  INSERT INTO `m_country` VALUES (660,'Anguilla','アンギラ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    32  INSERT INTO `m_country` VALUES (24,'Angola','アンゴラ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    33  INSERT INTO `m_country` VALUES (28,'Antigua and Barbuda','アンティグア・バーブーダ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    34  INSERT INTO `m_country` VALUES (20,'Andorra','アンドラ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    35  INSERT INTO `m_country` VALUES (887,'Yemen','イエメン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    36  INSERT INTO `m_country` VALUES (826,'United Kingdom','イギリス','2017-01-20 19:51:53','2017-01-20 19:51:53');
    37  INSERT INTO `m_country` VALUES (86,'British Indian Ocean Territory','イギリス領インド洋地域','2017-01-20 19:51:53','2017-01-20 19:51:53');
    38  INSERT INTO `m_country` VALUES (92,'Virgin Islands, British','イギリス領ヴァージン諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    39  INSERT INTO `m_country` VALUES (376,'Israel','イスラエル','2017-01-20 19:51:53','2017-01-20 19:51:53');
    40  INSERT INTO `m_country` VALUES (380,'Italy','イタリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    41  INSERT INTO `m_country` VALUES (368,'Iraq','イラク','2017-01-20 19:51:53','2017-01-20 19:51:53');
    42  INSERT INTO `m_country` VALUES (364,'Iran, Islamic Republic of','イラン|イラン・イスラム共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
    43  INSERT INTO `m_country` VALUES (356,'India','インド','2017-01-20 19:51:53','2017-01-20 19:51:53');
    44  INSERT INTO `m_country` VALUES (360,'Indonesia','インドネシア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    45  INSERT INTO `m_country` VALUES (876,'Wallis and Futuna','ウォリス・フツナ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    46  INSERT INTO `m_country` VALUES (800,'Uganda','ウガンダ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    47  INSERT INTO `m_country` VALUES (804,'Ukraine','ウクライナ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    48  INSERT INTO `m_country` VALUES (860,'Uzbekistan','ウズベキスタン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    49  INSERT INTO `m_country` VALUES (858,'Uruguay','ウルグアイ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    50  INSERT INTO `m_country` VALUES (218,'Ecuador','エクアドル','2017-01-20 19:51:53','2017-01-20 19:51:53');
    51  INSERT INTO `m_country` VALUES (818,'Egypt','エジプト','2017-01-20 19:51:53','2017-01-20 19:51:53');
    52  INSERT INTO `m_country` VALUES (233,'Estonia','エストニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    53  INSERT INTO `m_country` VALUES (231,'Ethiopia','エチオピア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    54  INSERT INTO `m_country` VALUES (232,'Eritrea','エリトリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    55  INSERT INTO `m_country` VALUES (222,'El Salvador','エルサルバドル','2017-01-20 19:51:53','2017-01-20 19:51:53');
    56  INSERT INTO `m_country` VALUES (36,'Australia','オーストラリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    57  INSERT INTO `m_country` VALUES (40,'Austria','オーストリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    58  INSERT INTO `m_country` VALUES (248,'Åland Islands','オーランド諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    59  INSERT INTO `m_country` VALUES (512,'Oman','オマーン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    60  INSERT INTO `m_country` VALUES (528,'Netherlands','オランダ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    61  INSERT INTO `m_country` VALUES (288,'Ghana','ガーナ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    62  INSERT INTO `m_country` VALUES (132,'Cape Verde','カーボベルデ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    63  INSERT INTO `m_country` VALUES (831,'Guernsey','ガーンジー','2017-01-20 19:51:53','2017-01-20 19:51:53');
    64  INSERT INTO `m_country` VALUES (328,'Guyana','ガイアナ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    65  INSERT INTO `m_country` VALUES (398,'Kazakhstan','カザフスタン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    66  INSERT INTO `m_country` VALUES (634,'Qatar','カタール','2017-01-20 19:51:53','2017-01-20 19:51:53');
    67  INSERT INTO `m_country` VALUES (581,'United States Minor Outlying Islands','合衆国領有小離島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    68  INSERT INTO `m_country` VALUES (124,'Canada','カナダ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    69  INSERT INTO `m_country` VALUES (266,'Gabon','ガボン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    70  INSERT INTO `m_country` VALUES (120,'Cameroon','カメルーン','2017-01-20 19:51:53','2017-01-20 19:51:53');
    71  INSERT INTO `m_country` VALUES (270,'Gambia','ガンビア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    72  INSERT INTO `m_country` VALUES (116,'Cambodia','カンボジア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    73  INSERT INTO `m_country` VALUES (580,'Northern Mariana Islands','北マリアナ諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    74  INSERT INTO `m_country` VALUES (324,'Guinea','ギニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    75  INSERT INTO `m_country` VALUES (624,'Guinea-Bissau','ギニアビサウ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    76  INSERT INTO `m_country` VALUES (196,'Cyprus','キプロス','2017-01-20 19:51:53','2017-01-20 19:51:53');
    77  INSERT INTO `m_country` VALUES (192,'Cuba','キューバ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    78  INSERT INTO `m_country` VALUES (531,'Curaçao','キュラソー島|キュラソー','2017-01-20 19:51:53','2017-01-20 19:51:53');
    79  INSERT INTO `m_country` VALUES (300,'Greece','ギリシャ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    80  INSERT INTO `m_country` VALUES (296,'Kiribati','キリバス','2017-01-20 19:51:53','2017-01-20 19:51:53');
    81  INSERT INTO `m_country` VALUES (417,'Kyrgyzstan','キルギス','2017-01-20 19:51:53','2017-01-20 19:51:53');
    82  INSERT INTO `m_country` VALUES (320,'Guatemala','グアテマラ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    83  INSERT INTO `m_country` VALUES (312,'Guadeloupe','グアドループ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    84  INSERT INTO `m_country` VALUES (316,'Guam','グアム','2017-01-20 19:51:53','2017-01-20 19:51:53');
    85  INSERT INTO `m_country` VALUES (414,'Kuwait','クウェート','2017-01-20 19:51:53','2017-01-20 19:51:53');
    86  INSERT INTO `m_country` VALUES (184,'Cook Islands','クック諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    87  INSERT INTO `m_country` VALUES (304,'Greenland','グリーンランド','2017-01-20 19:51:53','2017-01-20 19:51:53');
    88  INSERT INTO `m_country` VALUES (162,'Christmas Island','クリスマス島 (オーストラリア)|クリスマス島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    89  INSERT INTO `m_country` VALUES (268,'Georgia','グルジア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    90  INSERT INTO `m_country` VALUES (308,'Grenada','グレナダ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    91  INSERT INTO `m_country` VALUES (191,'Croatia','クロアチア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    92  INSERT INTO `m_country` VALUES (136,'Cayman Islands','ケイマン諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    93  INSERT INTO `m_country` VALUES (404,'Kenya','ケニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    94  INSERT INTO `m_country` VALUES (384,'Côte d\'Ivoire','コートジボワール','2017-01-20 19:51:53','2017-01-20 19:51:53');
    95  INSERT INTO `m_country` VALUES (166,'Cocos (Keeling) Islands','ココス諸島|ココス（キーリング）諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
    96  INSERT INTO `m_country` VALUES (188,'Costa Rica','コスタリカ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    97  INSERT INTO `m_country` VALUES (174,'Comoros','コモロ','2017-01-20 19:51:53','2017-01-20 19:51:53');
    98  INSERT INTO `m_country` VALUES (170,'Colombia','コロンビア','2017-01-20 19:51:53','2017-01-20 19:51:53');
    99  INSERT INTO `m_country` VALUES (178,'Congo','コンゴ共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   100  INSERT INTO `m_country` VALUES (180,'Congo, the Democratic Republic of the','コンゴ民主共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   101  INSERT INTO `m_country` VALUES (682,'Saudi Arabia','サウジアラビア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   102  INSERT INTO `m_country` VALUES (239,'South Georgia and the South Sandwich Islands','サウスジョージア・サウスサンドウィッチ諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   103  INSERT INTO `m_country` VALUES (882,'Samoa','サモア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   104  INSERT INTO `m_country` VALUES (678,'Sao Tome and Principe','サントメ・プリンシペ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   105  INSERT INTO `m_country` VALUES (652,'Saint Barthélemy','サン・バルテルミー島|サン・バルテルミー','2017-01-20 19:51:53','2017-01-20 19:51:53');
   106  INSERT INTO `m_country` VALUES (894,'Zambia','ザンビア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   107  INSERT INTO `m_country` VALUES (666,'Saint Pierre and Miquelon','サンピエール島・ミクロン島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   108  INSERT INTO `m_country` VALUES (674,'San Marino','サンマリノ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   109  INSERT INTO `m_country` VALUES (663,'Saint Martin (French part)','サン・マルタン (西インド諸島)|サン・マルタン（フランス領）','2017-01-20 19:51:53','2017-01-20 19:51:53');
   110  INSERT INTO `m_country` VALUES (694,'Sierra Leone','シエラレオネ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   111  INSERT INTO `m_country` VALUES (262,'Djibouti','ジブチ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   112  INSERT INTO `m_country` VALUES (292,'Gibraltar','ジブラルタル','2017-01-20 19:51:53','2017-01-20 19:51:53');
   113  INSERT INTO `m_country` VALUES (832,'Jersey','ジャージー','2017-01-20 19:51:53','2017-01-20 19:51:53');
   114  INSERT INTO `m_country` VALUES (388,'Jamaica','ジャマイカ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   115  INSERT INTO `m_country` VALUES (760,'Syrian Arab Republic','シリア|シリア・アラブ共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   116  INSERT INTO `m_country` VALUES (702,'Singapore','シンガポール','2017-01-20 19:51:53','2017-01-20 19:51:53');
   117  INSERT INTO `m_country` VALUES (534,'Sint Maarten (Dutch part)','シント・マールテン|シント・マールテン（オランダ領）','2017-01-20 19:51:53','2017-01-20 19:51:53');
   118  INSERT INTO `m_country` VALUES (716,'Zimbabwe','ジンバブエ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   119  INSERT INTO `m_country` VALUES (756,'Switzerland','スイス','2017-01-20 19:51:53','2017-01-20 19:51:53');
   120  INSERT INTO `m_country` VALUES (752,'Sweden','スウェーデン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   121  INSERT INTO `m_country` VALUES (729,'Sudan','スーダン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   122  INSERT INTO `m_country` VALUES (744,'Svalbard and Jan Mayen','スヴァールバル諸島およびヤンマイエン島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   123  INSERT INTO `m_country` VALUES (724,'Spain','スペイン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   124  INSERT INTO `m_country` VALUES (740,'Suriname','スリナム','2017-01-20 19:51:53','2017-01-20 19:51:53');
   125  INSERT INTO `m_country` VALUES (144,'Sri Lanka','スリランカ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   126  INSERT INTO `m_country` VALUES (703,'Slovakia','スロバキア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   127  INSERT INTO `m_country` VALUES (705,'Slovenia','スロベニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   128  INSERT INTO `m_country` VALUES (748,'Swaziland','スワジランド','2017-01-20 19:51:53','2017-01-20 19:51:53');
   129  INSERT INTO `m_country` VALUES (690,'Seychelles','セーシェル','2017-01-20 19:51:53','2017-01-20 19:51:53');
   130  INSERT INTO `m_country` VALUES (226,'Equatorial Guinea','赤道ギニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   131  INSERT INTO `m_country` VALUES (686,'Senegal','セネガル','2017-01-20 19:51:53','2017-01-20 19:51:53');
   132  INSERT INTO `m_country` VALUES (688,'Serbia','セルビア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   133  INSERT INTO `m_country` VALUES (659,'Saint Kitts and Nevis','セントクリストファー・ネイビス','2017-01-20 19:51:53','2017-01-20 19:51:53');
   134  INSERT INTO `m_country` VALUES (670,'Saint Vincent and the Grenadines','セントビンセント・グレナディーン|セントビンセントおよびグレナディーン諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   135  INSERT INTO `m_country` VALUES (654,'Saint Helena, Ascension and Tristan da Cunha','セントヘレナ・アセンションおよびトリスタンダクーニャ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   136  INSERT INTO `m_country` VALUES (662,'Saint Lucia','セントルシア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   137  INSERT INTO `m_country` VALUES (706,'Somalia','ソマリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   138  INSERT INTO `m_country` VALUES (90,'Solomon Islands','ソロモン諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   139  INSERT INTO `m_country` VALUES (796,'Turks and Caicos Islands','タークス・カイコス諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   140  INSERT INTO `m_country` VALUES (764,'Thailand','タイ王国|タイ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   141  INSERT INTO `m_country` VALUES (410,'Korea, Republic of','大韓民国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   142  INSERT INTO `m_country` VALUES (158,'Taiwan, Province of China','台湾','2017-01-20 19:51:53','2017-01-20 19:51:53');
   143  INSERT INTO `m_country` VALUES (762,'Tajikistan','タジキスタン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   144  INSERT INTO `m_country` VALUES (834,'Tanzania, United Republic of','タンザニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   145  INSERT INTO `m_country` VALUES (203,'Czech Republic','チェコ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   146  INSERT INTO `m_country` VALUES (148,'Chad','チャド','2017-01-20 19:51:53','2017-01-20 19:51:53');
   147  INSERT INTO `m_country` VALUES (140,'Central African Republic','中央アフリカ共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   148  INSERT INTO `m_country` VALUES (156,'China','中華人民共和国|中国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   149  INSERT INTO `m_country` VALUES (788,'Tunisia','チュニジア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   150  INSERT INTO `m_country` VALUES (408,'Korea, Democratic People\'s Republic of','朝鮮民主主義人民共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   151  INSERT INTO `m_country` VALUES (152,'Chile','チリ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   152  INSERT INTO `m_country` VALUES (798,'Tuvalu','ツバル','2017-01-20 19:51:53','2017-01-20 19:51:53');
   153  INSERT INTO `m_country` VALUES (208,'Denmark','デンマーク','2017-01-20 19:51:53','2017-01-20 19:51:53');
   154  INSERT INTO `m_country` VALUES (276,'Germany','ドイツ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   155  INSERT INTO `m_country` VALUES (768,'Togo','トーゴ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   156  INSERT INTO `m_country` VALUES (772,'Tokelau','トケラウ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   157  INSERT INTO `m_country` VALUES (214,'Dominican Republic','ドミニカ共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   158  INSERT INTO `m_country` VALUES (212,'Dominica','ドミニカ国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   159  INSERT INTO `m_country` VALUES (780,'Trinidad and Tobago','トリニダード・トバゴ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   160  INSERT INTO `m_country` VALUES (795,'Turkmenistan','トルクメニスタン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   161  INSERT INTO `m_country` VALUES (792,'Turkey','トルコ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   162  INSERT INTO `m_country` VALUES (776,'Tonga','トンガ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   163  INSERT INTO `m_country` VALUES (566,'Nigeria','ナイジェリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   164  INSERT INTO `m_country` VALUES (520,'Nauru','ナウル','2017-01-20 19:51:53','2017-01-20 19:51:53');
   165  INSERT INTO `m_country` VALUES (516,'Namibia','ナミビア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   166  INSERT INTO `m_country` VALUES (10,'Antarctica','南極','2017-01-20 19:51:53','2017-01-20 19:51:53');
   167  INSERT INTO `m_country` VALUES (570,'Niue','ニウエ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   168  INSERT INTO `m_country` VALUES (558,'Nicaragua','ニカラグア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   169  INSERT INTO `m_country` VALUES (562,'Niger','ニジェール','2017-01-20 19:51:53','2017-01-20 19:51:53');
   170  INSERT INTO `m_country` VALUES (392,'Japan','日本','2017-01-20 19:51:53','2017-01-20 19:51:53');
   171  INSERT INTO `m_country` VALUES (732,'Western Sahara','西サハラ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   172  INSERT INTO `m_country` VALUES (540,'New Caledonia','ニューカレドニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   173  INSERT INTO `m_country` VALUES (554,'New Zealand','ニュージーランド','2017-01-20 19:51:53','2017-01-20 19:51:53');
   174  INSERT INTO `m_country` VALUES (524,'Nepal','ネパール','2017-01-20 19:51:53','2017-01-20 19:51:53');
   175  INSERT INTO `m_country` VALUES (574,'Norfolk Island','ノーフォーク島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   176  INSERT INTO `m_country` VALUES (578,'Norway','ノルウェー','2017-01-20 19:51:53','2017-01-20 19:51:53');
   177  INSERT INTO `m_country` VALUES (334,'Heard Island and McDonald Islands','ハード島とマクドナルド諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   178  INSERT INTO `m_country` VALUES (48,'Bahrain','バーレーン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   179  INSERT INTO `m_country` VALUES (332,'Haiti','ハイチ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   180  INSERT INTO `m_country` VALUES (586,'Pakistan','パキスタン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   181  INSERT INTO `m_country` VALUES (336,'Holy See (Vatican City State)','バチカン|バチカン市国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   182  INSERT INTO `m_country` VALUES (591,'Panama','パナマ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   183  INSERT INTO `m_country` VALUES (548,'Vanuatu','バヌアツ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   184  INSERT INTO `m_country` VALUES (44,'Bahamas','バハマ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   185  INSERT INTO `m_country` VALUES (598,'Papua New Guinea','パプアニューギニア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   186  INSERT INTO `m_country` VALUES (60,'Bermuda','バミューダ諸島|バミューダ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   187  INSERT INTO `m_country` VALUES (585,'Palau','パラオ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   188  INSERT INTO `m_country` VALUES (600,'Paraguay','パラグアイ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   189  INSERT INTO `m_country` VALUES (52,'Barbados','バルバドス','2017-01-20 19:51:53','2017-01-20 19:51:53');
   190  INSERT INTO `m_country` VALUES (275,'Palestinian Territory, Occupied','パレスチナ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   191  INSERT INTO `m_country` VALUES (348,'Hungary','ハンガリー','2017-01-20 19:51:53','2017-01-20 19:51:53');
   192  INSERT INTO `m_country` VALUES (50,'Bangladesh','バングラデシュ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   193  INSERT INTO `m_country` VALUES (626,'Timor-Leste','東ティモール','2017-01-20 19:51:53','2017-01-20 19:51:53');
   194  INSERT INTO `m_country` VALUES (612,'Pitcairn','ピトケアン諸島|ピトケアン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   195  INSERT INTO `m_country` VALUES (242,'Fiji','フィジー','2017-01-20 19:51:53','2017-01-20 19:51:53');
   196  INSERT INTO `m_country` VALUES (608,'Philippines','フィリピン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   197  INSERT INTO `m_country` VALUES (246,'Finland','フィンランド','2017-01-20 19:51:53','2017-01-20 19:51:53');
   198  INSERT INTO `m_country` VALUES (64,'Bhutan','ブータン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   199  INSERT INTO `m_country` VALUES (74,'Bouvet Island','ブーベ島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   200  INSERT INTO `m_country` VALUES (630,'Puerto Rico','プエルトリコ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   201  INSERT INTO `m_country` VALUES (234,'Faroe Islands','フェロー諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   202  INSERT INTO `m_country` VALUES (238,'Falkland Islands (Malvinas)','フォークランド諸島|フォークランド（マルビナス）諸島','2017-01-20 19:51:53','2017-01-20 19:51:53');
   203  INSERT INTO `m_country` VALUES (76,'Brazil','ブラジル','2017-01-20 19:51:53','2017-01-20 19:51:53');
   204  INSERT INTO `m_country` VALUES (250,'France','フランス','2017-01-20 19:51:53','2017-01-20 19:51:53');
   205  INSERT INTO `m_country` VALUES (254,'French Guiana','フランス領ギアナ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   206  INSERT INTO `m_country` VALUES (258,'French Polynesia','フランス領ポリネシア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   207  INSERT INTO `m_country` VALUES (260,'French Southern Territories','フランス領南方・南極地域','2017-01-20 19:51:53','2017-01-20 19:51:53');
   208  INSERT INTO `m_country` VALUES (100,'Bulgaria','ブルガリア','2017-01-20 19:51:53','2017-01-20 19:51:53');
   209  INSERT INTO `m_country` VALUES (854,'Burkina Faso','ブルキナファソ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   210  INSERT INTO `m_country` VALUES (96,'Brunei Darussalam','ブルネイ|ブルネイ・ダルサラーム','2017-01-20 19:51:53','2017-01-20 19:51:53');
   211  INSERT INTO `m_country` VALUES (108,'Burundi','ブルンジ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   212  INSERT INTO `m_country` VALUES (704,'Viet Nam','ベトナム','2017-01-20 19:51:53','2017-01-20 19:51:53');
   213  INSERT INTO `m_country` VALUES (204,'Benin','ベナン','2017-01-20 19:51:53','2017-01-20 19:51:53');
   214  INSERT INTO `m_country` VALUES (862,'Venezuela, Bolivarian Republic of','ベネズエラ|ベネズエラ・ボリバル共和国','2017-01-20 19:51:53','2017-01-20 19:51:53');
   215  INSERT INTO `m_country` VALUES (112,'Belarus','ベラルーシ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   216  INSERT INTO `m_country` VALUES (84,'Belize','ベリーズ','2017-01-20 19:51:53','2017-01-20 19:51:53');
   217  INSERT INTO `m_country` VALUES (604,'Peru','ペルー','2017-01-20 19:51:53','2017-01-20 19:51:53');
   218  INSERT INTO `m_country` VALUES (56,'Belgium','ベルギー','2017-01-20 19:51:53','2017-01-20 19:51:53');
   219  INSERT INTO `m_country` VALUES (616,'Poland','ポーランド','2017-01-20 19:51:54','2017-01-20 19:51:54');
   220  INSERT INTO `m_country` VALUES (70,'Bosnia and Herzegovina','ボスニア・ヘルツェゴビナ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   221  INSERT INTO `m_country` VALUES (72,'Botswana','ボツワナ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   222  INSERT INTO `m_country` VALUES (535,'Bonaire, Saint Eustatius and Saba','BES諸島|ボネール、シント・ユースタティウスおよびサバ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   223  INSERT INTO `m_country` VALUES (68,'Bolivia, Plurinational State of','ボリビア|ボリビア多民族国','2017-01-20 19:51:54','2017-01-20 19:51:54');
   224  INSERT INTO `m_country` VALUES (620,'Portugal','ポルトガル','2017-01-20 19:51:54','2017-01-20 19:51:54');
   225  INSERT INTO `m_country` VALUES (344,'Hong Kong','香港','2017-01-20 19:51:54','2017-01-20 19:51:54');
   226  INSERT INTO `m_country` VALUES (340,'Honduras','ホンジュラス','2017-01-20 19:51:54','2017-01-20 19:51:54');
   227  INSERT INTO `m_country` VALUES (584,'Marshall Islands','マーシャル諸島','2017-01-20 19:51:54','2017-01-20 19:51:54');
   228  INSERT INTO `m_country` VALUES (446,'Macao','マカオ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   229  INSERT INTO `m_country` VALUES (807,'Macedonia, the former Yugoslav Republic of','マケドニア共和国|マケドニア旧ユーゴスラビア共和国','2017-01-20 19:51:54','2017-01-20 19:51:54');
   230  INSERT INTO `m_country` VALUES (450,'Madagascar','マダガスカル','2017-01-20 19:51:54','2017-01-20 19:51:54');
   231  INSERT INTO `m_country` VALUES (175,'Mayotte','マヨット','2017-01-20 19:51:54','2017-01-20 19:51:54');
   232  INSERT INTO `m_country` VALUES (454,'Malawi','マラウイ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   233  INSERT INTO `m_country` VALUES (466,'Mali','マリ共和国|マリ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   234  INSERT INTO `m_country` VALUES (470,'Malta','マルタ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   235  INSERT INTO `m_country` VALUES (474,'Martinique','マルティニーク','2017-01-20 19:51:54','2017-01-20 19:51:54');
   236  INSERT INTO `m_country` VALUES (458,'Malaysia','マレーシア','2017-01-20 19:51:54','2017-01-20 19:51:54');
   237  INSERT INTO `m_country` VALUES (833,'Isle of Man','マン島','2017-01-20 19:51:54','2017-01-20 19:51:54');
   238  INSERT INTO `m_country` VALUES (583,'Micronesia, Federated States of','ミクロネシア連邦','2017-01-20 19:51:54','2017-01-20 19:51:54');
   239  INSERT INTO `m_country` VALUES (710,'South Africa','南アフリカ共和国|南アフリカ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   240  INSERT INTO `m_country` VALUES (728,'South Sudan','南スーダン','2017-01-20 19:51:54','2017-01-20 19:51:54');
   241  INSERT INTO `m_country` VALUES (104,'Myanmar','ミャンマー','2017-01-20 19:51:54','2017-01-20 19:51:54');
   242  INSERT INTO `m_country` VALUES (484,'Mexico','メキシコ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   243  INSERT INTO `m_country` VALUES (480,'Mauritius','モーリシャス','2017-01-20 19:51:54','2017-01-20 19:51:54');
   244  INSERT INTO `m_country` VALUES (478,'Mauritania','モーリタニア','2017-01-20 19:51:54','2017-01-20 19:51:54');
   245  INSERT INTO `m_country` VALUES (508,'Mozambique','モザンビーク','2017-01-20 19:51:54','2017-01-20 19:51:54');
   246  INSERT INTO `m_country` VALUES (492,'Monaco','モナコ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   247  INSERT INTO `m_country` VALUES (462,'Maldives','モルディブ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   248  INSERT INTO `m_country` VALUES (498,'Moldova, Republic of','モルドバ|モルドバ共和国','2017-01-20 19:51:54','2017-01-20 19:51:54');
   249  INSERT INTO `m_country` VALUES (504,'Morocco','モロッコ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   250  INSERT INTO `m_country` VALUES (496,'Mongolia','モンゴル国|モンゴル','2017-01-20 19:51:54','2017-01-20 19:51:54');
   251  INSERT INTO `m_country` VALUES (499,'Montenegro','モンテネグロ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   252  INSERT INTO `m_country` VALUES (500,'Montserrat','モントセラト','2017-01-20 19:51:54','2017-01-20 19:51:54');
   253  INSERT INTO `m_country` VALUES (400,'Jordan','ヨルダン','2017-01-20 19:51:54','2017-01-20 19:51:54');
   254  INSERT INTO `m_country` VALUES (418,'Lao People\'s Democratic Republic','ラオス|ラオス人民民主共和国','2017-01-20 19:51:54','2017-01-20 19:51:54');
   255  INSERT INTO `m_country` VALUES (428,'Latvia','ラトビア','2017-01-20 19:51:54','2017-01-20 19:51:54');
   256  INSERT INTO `m_country` VALUES (440,'Lithuania','リトアニア','2017-01-20 19:51:54','2017-01-20 19:51:54');
   257  INSERT INTO `m_country` VALUES (434,'Libya','リビア','2017-01-20 19:51:54','2017-01-20 19:51:54');
   258  INSERT INTO `m_country` VALUES (438,'Liechtenstein','リヒテンシュタイン','2017-01-20 19:51:54','2017-01-20 19:51:54');
   259  INSERT INTO `m_country` VALUES (430,'Liberia','リベリア','2017-01-20 19:51:54','2017-01-20 19:51:54');
   260  INSERT INTO `m_country` VALUES (642,'Romania','ルーマニア','2017-01-20 19:51:54','2017-01-20 19:51:54');
   261  INSERT INTO `m_country` VALUES (442,'Luxembourg','ルクセンブルク','2017-01-20 19:51:54','2017-01-20 19:51:54');
   262  INSERT INTO `m_country` VALUES (646,'Rwanda','ルワンダ','2017-01-20 19:51:54','2017-01-20 19:51:54');
   263  INSERT INTO `m_country` VALUES (426,'Lesotho','レソト','2017-01-20 19:51:54','2017-01-20 19:51:54');
   264  INSERT INTO `m_country` VALUES (422,'Lebanon','レバノン','2017-01-20 19:51:54','2017-01-20 19:51:54');
   265  INSERT INTO `m_country` VALUES (638,'Réunion','レユニオン','2017-01-20 19:51:54','2017-01-20 19:51:54');
   266  INSERT INTO `m_country` VALUES (643,'Russian Federation','ロシア|ロシア連邦','2017-01-20 19:51:54','2017-01-20 19:51:54');
   267  COMMIT;
   268  
   269  -- +goose Down
   270  -- SQL section 'Down' is executed when this migration is rolled back
   271  DROP TABLE IF EXISTS m_country;
   272  ALTER TABLE teacher
   273    DROP COLUMN `country_id`,
   274    DROP COLUMN `gender`,
   275    DROP COLUMN `birthday`,
   276    DROP COLUMN `years_of_experience`;