Skip to content

Instantly share code, notes, and snippets.

@egyjs
Created October 14, 2019 17:27
Show Gist options
  • Save egyjs/6be3f1f3ce70a056778d39df88c27843 to your computer and use it in GitHub Desktop.
Save egyjs/6be3f1f3ce70a056778d39df88c27843 to your computer and use it in GitHub Desktop.
DB::table('data_location_country')->delete();
$data = array(
['slug' => 'AF', 'title' => 'Afghanistan', 'native' => 'غانستان'],
['slug' => 'AX', 'title' => 'Åland Islands', 'native' => 'Åland'],
['slug' => 'AL', 'title' => 'Albania', 'native' => 'Shqipëri'],
['slug' => 'DZ', 'title' => 'Algeria', 'native' => 'الجزائر'],
['slug' => 'AS', 'title' => 'American Samoa', 'native' => ''],
['slug' => 'AD', 'title' => 'Andorra', 'native' => ''],
['slug' => 'AO', 'title' => 'Angola', 'native' => ''],
['slug' => 'AI', 'title' => 'Anguilla', 'native' => ''],
['slug' => 'AQ', 'title' => 'Antarctica', 'native' => ''],
['slug' => 'AG', 'title' => 'Antigua and Barbuda', 'native' => ''],
['slug' => 'AR', 'title' => 'Argentina', 'native' => ''],
['slug' => 'AM', 'title' => 'Armenia', 'native' => 'Հայաստան'],
['slug' => 'AW', 'title' => 'Aruba', 'native' => ''],
['slug' => 'AC', 'title' => 'Ascension Island', 'native' => ''],
['slug' => 'AU', 'title' => 'Australia', 'native' => ''],
['slug' => 'AT', 'title' => 'Austria', 'native' => 'Österreich'],
['slug' => 'AZ', 'title' => 'Azerbaijan', 'native' => 'Azərbaycan'],
['slug' => 'BS', 'title' => 'Bahamas', 'native' => ''],
['slug' => 'BH', 'title' => 'Bahrain', 'native' => 'البحرين'],
['slug' => 'BD', 'title' => 'Bangladesh', 'native' => 'বাংলাদেশ'],
['slug' => 'BB', 'title' => 'Barbados', 'native' => ''],
['slug' => 'BY', 'title' => 'Belarus', 'native' => 'Беларусь'],
['slug' => 'BE', 'title' => 'Belgium', 'native' => 'België'],
['slug' => 'BZ', 'title' => 'Belize', 'native' => ''],
['slug' => 'BJ', 'title' => 'Benin', 'native' => 'Bénin'],
['slug' => 'BM', 'title' => 'Bermuda', 'native' => ''],
['slug' => 'BT', 'title' => 'Bhutan', 'native' => 'འབྲུག'],
['slug' => 'BO', 'title' => 'Bolivia', 'native' => ''],
['slug' => 'BA', 'title' => 'Bosnia and Herzegovina', 'native' => 'Босна и Херцеговина'],
['slug' => 'BW', 'title' => 'Botswana', 'native' => ''],
['slug' => 'BV', 'title' => 'Bouvet Island', 'native' => ''],
['slug' => 'BR', 'title' => 'Brazil', 'native' => 'Brasil'],
['slug' => 'IO', 'title' => 'British Indian Ocean Territory', 'native' => ''],
['slug' => 'VG', 'title' => 'British Virgin Islands', 'native' => ''],
['slug' => 'BN', 'title' => 'Brunei', 'native' => ''],
['slug' => 'BG', 'title' => 'Bulgaria', 'native' => 'България'],
['slug' => 'BF', 'title' => 'Burkina Faso', 'native' => ''],
['slug' => 'BI', 'title' => 'Burundi', 'native' => 'Uburundi'],
['slug' => 'KH', 'title' => 'Cambodia', 'native' => 'កម្ពុជា'],
['slug' => 'CM', 'title' => 'Cameroon', 'native' => 'Cameroun'],
['slug' => 'CA', 'title' => 'Canada', 'native' => ''],
['slug' => 'IC', 'title' => 'Canary Islands', 'native' => 'islas Canarias'],
['slug' => 'CV', 'title' => 'Cape Verde', 'native' => 'Kabu Verdi'],
['slug' => 'BQ', 'title' => 'Caribbean Netherlands', 'native' => ''],
['slug' => 'KY', 'title' => 'Cayman Islands', 'native' => ''],
['slug' => 'CF', 'title' => 'Central African Republic', 'native' => 'République centrafricaine'],
['slug' => 'EA', 'title' => 'Ceuta and Melilla', 'native' => 'Ceuta y Melilla'],
['slug' => 'TD', 'title' => 'Chad', 'native' => 'Tchad'],
['slug' => 'CL', 'title' => 'Chile', 'native' => ''],
['slug' => 'CN', 'title' => 'China', 'native' => '中国'],
['slug' => 'CX', 'title' => 'Christmas Island', 'native' => ''],
['slug' => 'CP', 'title' => 'Clipperton Island', 'native' => ''],
['slug' => 'CC', 'title' => 'Cocos (Keeling) Islands', 'native' => 'Kepulauan Cocos (Keeling)'],
['slug' => 'CO', 'title' => 'Colombia', 'native' => ''],
['slug' => 'KM', 'title' => 'Comoros', 'native' => 'جزر القمر'],
['slug' => 'CD', 'title' => 'Congo (DRC)', 'native' => 'Jamhuri ya Kidemokrasia ya Kongo'],
['slug' => 'CG', 'title' => 'Congo (Republic)', 'native' => 'Congo-Brazzaville'],
['slug' => 'CK', 'title' => 'Cook Islands', 'native' => ''],
['slug' => 'CR', 'title' => 'Costa Rica', 'native' => ''],
['slug' => 'CI', 'title' => 'Côte d’Ivoire', 'native' => ''],
['slug' => 'HR', 'title' => 'Croatia', 'native' => 'Hrvatska'],
['slug' => 'CU', 'title' => 'Cuba', 'native' => ''],
['slug' => 'CW', 'title' => 'Curaçao', 'native' => ''],
['slug' => 'CY', 'title' => 'Cyprus', 'native' => 'Κύπρος'],
['slug' => 'CZ', 'title' => 'Czech Republic', 'native' => 'Česká republika'],
['slug' => 'DK', 'title' => 'Denmark', 'native' => 'Danmark'],
['slug' => 'DG', 'title' => 'Diego Garcia', 'native' => ''],
['slug' => 'DJ', 'title' => 'Djibouti', 'native' => ''],
['slug' => 'DM', 'title' => 'Dominica', 'native' => ''],
['slug' => 'DO', 'title' => 'Dominican Republic', 'native' => 'República Dominicana'],
['slug' => 'EC', 'title' => 'Ecuador', 'native' => ''],
['slug' => 'EG', 'title' => 'Egypt', 'native' => 'مصر'],
['slug' => 'SV', 'title' => 'El Salvador', 'native' => ''],
['slug' => 'GQ', 'title' => 'Equatorial Guinea', 'native' => 'Guinea Ecuatorial'],
['slug' => 'ER', 'title' => 'Eritrea', 'native' => ''],
['slug' => 'EE', 'title' => 'Estonia', 'native' => 'Eesti'],
['slug' => 'ET', 'title' => 'Ethiopia', 'native' => ''],
['slug' => 'FK', 'title' => 'Falkland Islands', 'native' => 'Islas Malvinas'],
['slug' => 'FO', 'title' => 'Faroe Islands', 'native' => 'Føroyar'],
['slug' => 'FJ', 'title' => 'Fiji', 'native' => ''],
['slug' => 'FI', 'title' => 'Finland', 'native' => 'Suomi'],
['slug' => 'FR', 'title' => 'France', 'native' => ''],
['slug' => 'GF', 'title' => 'French Guiana', 'native' => 'Guyane française'],
['slug' => 'PF', 'title' => 'French Polynesia', 'native' => 'Polynésie française'],
['slug' => 'TF', 'title' => 'French Southern Territories', 'native' => 'Terres australes françaises'],
['slug' => 'GA', 'title' => 'Gabon', 'native' => ''],
['slug' => 'GM', 'title' => 'Gambia', 'native' => ''],
['slug' => 'GE', 'title' => 'Georgia', 'native' => 'საქართველო'],
['slug' => 'DE', 'title' => 'Germany', 'native' => 'Deutschland'],
['slug' => 'GH', 'title' => 'Ghana', 'native' => 'Gaana'],
['slug' => 'GI', 'title' => 'Gibraltar', 'native' => ''],
['slug' => 'GR', 'title' => 'Greece', 'native' => 'Ελλάδα'],
['slug' => 'GL', 'title' => 'Greenland', 'native' => 'Kalaallit Nunaat'],
['slug' => 'GD', 'title' => 'Grenada', 'native' => ''],
['slug' => 'GP', 'title' => 'Guadeloupe', 'native' => ''],
['slug' => 'GU', 'title' => 'Guam', 'native' => ''],
['slug' => 'GT', 'title' => 'Guatemala', 'native' => ''],
['slug' => 'GG', 'title' => 'Guernsey', 'native' => ''],
['slug' => 'GN', 'title' => 'Guinea', 'native' => 'Guinée'],
['slug' => 'GW', 'title' => 'Guinea-Bissau', 'native' => 'Guiné Bissau'],
['slug' => 'GY', 'title' => 'Guyana', 'native' => ''],
['slug' => 'HT', 'title' => 'Haiti', 'native' => ''],
['slug' => 'HM', 'title' => 'Heard & McDonald Islands', 'native' => ''],
['slug' => 'HN', 'title' => 'Honduras', 'native' => ''],
['slug' => 'HK', 'title' => 'Hong Kong', 'native' => '香港'],
['slug' => 'HU', 'title' => 'Hungary', 'native' => 'Magyarország'],
['slug' => 'IS', 'title' => 'Iceland', 'native' => 'Ísland'],
['slug' => 'IN', 'title' => 'India', 'native' => 'भारत'],
['slug' => 'ID', 'title' => 'Indonesia', 'native' => ''],
['slug' => 'IR', 'title' => 'Iran', 'native' => 'ایران'],
['slug' => 'IQ', 'title' => 'Iraq', 'native' => 'العراق'],
['slug' => 'IE', 'title' => 'Ireland', 'native' => ''],
['slug' => 'IM', 'title' => 'Isle of Man', 'native' => ''],
['slug' => 'IL', 'title' => 'Israel', 'native' => 'ישראל'],
['slug' => 'IT', 'title' => 'Italy', 'native' => 'Italia'],
['slug' => 'JM', 'title' => 'Jamaica', 'native' => ''],
['slug' => 'JP', 'title' => 'Japan', 'native' => '日本'],
['slug' => 'JE', 'title' => 'Jersey', 'native' => ''],
['slug' => 'JO', 'title' => 'Jordan', 'native' => 'الأردن'],
['slug' => 'KZ', 'title' => 'Kazakhstan', 'native' => 'Казахстан'],
['slug' => 'KE', 'title' => 'Kenya', 'native' => ''],
['slug' => 'KI', 'title' => 'Kiribati', 'native' => ''],
['slug' => 'XK', 'title' => 'Kosovo', 'native' => 'Kosovë'],
['slug' => 'KW', 'title' => 'Kuwait', 'native' => 'الكويت'],
['slug' => 'KG', 'title' => 'Kyrgyzstan', 'native' => 'Кыргызстан'],
['slug' => 'LA', 'title' => 'Laos', 'native' => 'ລາວ'],
['slug' => 'LV', 'title' => 'Latvia', 'native' => 'Latvija'],
['slug' => 'LB', 'title' => 'Lebanon', 'native' => 'لبنان'],
['slug' => 'LS', 'title' => 'Lesotho', 'native' => ''],
['slug' => 'LR', 'title' => 'Liberia', 'native' => ''],
['slug' => 'LY', 'title' => 'Libya', 'native' => 'ليبيا'],
['slug' => 'LI', 'title' => 'Liechtenstein', 'native' => ''],
['slug' => 'LT', 'title' => 'Lithuania', 'native' => 'Lietuva'],
['slug' => 'LU', 'title' => 'Luxembourg', 'native' => ''],
['slug' => 'MO', 'title' => 'Macau', 'native' => '澳門'],
['slug' => 'MK', 'title' => 'Macedonia (FYROM)', 'native' => 'Македонија'],
['slug' => 'MG', 'title' => 'Madagascar', 'native' => 'Madagasikara'],
['slug' => 'MW', 'title' => 'Malawi', 'native' => ''],
['slug' => 'MY', 'title' => 'Malaysia', 'native' => ''],
['slug' => 'MV', 'title' => 'Maldives', 'native' => ''],
['slug' => 'ML', 'title' => 'Mali', 'native' => ''],
['slug' => 'MT', 'title' => 'Malta', 'native' => ''],
['slug' => 'MH', 'title' => 'Marshall Islands', 'native' => ''],
['slug' => 'MQ', 'title' => 'Martinique', 'native' => ''],
['slug' => 'MR', 'title' => 'Mauritania', 'native' => 'موريتانيا'],
['slug' => 'MU', 'title' => 'Mauritius', 'native' => 'Moris'],
['slug' => 'YT', 'title' => 'Mayotte', 'native' => ''],
['slug' => 'MX', 'title' => 'Mexico', 'native' => ''],
['slug' => 'FM', 'title' => 'Micronesia', 'native' => ''],
['slug' => 'MD', 'title' => 'Moldova', 'native' => 'Republica Moldova'],
['slug' => 'MC', 'title' => 'Monaco', 'native' => ''],
['slug' => 'MN', 'title' => 'Mongolia', 'native' => 'Монгол'],
['slug' => 'ME', 'title' => 'Montenegro', 'native' => 'Crna Gora'],
['slug' => 'MS', 'title' => 'Montserrat', 'native' => ''],
['slug' => 'MA', 'title' => 'Morocco', 'native' => 'المغرب'],
['slug' => 'MZ', 'title' => 'Mozambique', 'native' => 'Moçambique'],
['slug' => 'MM', 'title' => 'Myanmar (Burma)', 'native' => 'မြန်မာ'],
['slug' => 'NA', 'title' => 'Namibia', 'native' => 'Namibië'],
['slug' => 'NR', 'title' => 'Nauru', 'native' => ''],
['slug' => 'NP', 'title' => 'Nepal', 'native' => 'नेपाल'],
['slug' => 'NL', 'title' => 'Netherlands', 'native' => 'Nederland'],
['slug' => 'NC', 'title' => 'New Caledonia', 'native' => 'Nouvelle-Calédonie'],
['slug' => 'NZ', 'title' => 'New Zealand', 'native' => ''],
['slug' => 'NI', 'title' => 'Nicaragua', 'native' => ''],
['slug' => 'NE', 'title' => 'Niger', 'native' => 'Nijar'],
['slug' => 'NG', 'title' => 'Nigeria', 'native' => ''],
['slug' => 'NU', 'title' => 'Niue', 'native' => ''],
['slug' => 'NF', 'title' => 'Norfolk Island', 'native' => ''],
['slug' => 'MP', 'title' => 'Northern Mariana Islands', 'native' => ''],
['slug' => 'KP', 'title' => 'North Korea', 'native' => '조선 민주주의 인민 공화국'],
['slug' => 'NO', 'title' => 'Norway', 'native' => 'Norge'],
['slug' => 'OM', 'title' => 'Oman', 'native' => 'عُمان'],
['slug' => 'PK', 'title' => 'Pakistan', 'native' => 'پاکستان'],
['slug' => 'PW', 'title' => 'Palau', 'native' => ''],
['slug' => 'PS', 'title' => 'Palestine', 'native' => 'فلسطين'],
['slug' => 'PA', 'title' => 'Panama', 'native' => ''],
['slug' => 'PG', 'title' => 'Papua New Guinea', 'native' => ''],
['slug' => 'PY', 'title' => 'Paraguay', 'native' => ''],
['slug' => 'PE', 'title' => 'Peru', 'native' => 'Perú'],
['slug' => 'PH', 'title' => 'Philippines', 'native' => ''],
['slug' => 'PN', 'title' => 'Pitcairn Islands', 'native' => ''],
['slug' => 'PL', 'title' => 'Poland', 'native' => 'Polska'],
['slug' => 'PT', 'title' => 'Portugal', 'native' => ''],
['slug' => 'PR', 'title' => 'Puerto Rico', 'native' => ''],
['slug' => 'QA', 'title' => 'Qatar', 'native' => 'قطر'],
['slug' => 'RE', 'title' => 'Réunion', 'native' => 'La Réunion'],
['slug' => 'RO', 'title' => 'Romania', 'native' => 'România'],
['slug' => 'RU', 'title' => 'Russia', 'native' => 'Россия'],
['slug' => 'RW', 'title' => 'Rwanda', 'native' => ''],
['slug' => 'BL', 'title' => 'Saint Barthélemy', 'native' => 'Saint-Barthélemy'],
['slug' => 'SH', 'title' => 'Saint Helena', 'native' => ''],
['slug' => 'KN', 'title' => 'Saint Kitts and Nevis', 'native' => ''],
['slug' => 'LC', 'title' => 'Saint Lucia', 'native' => ''],
['slug' => 'MF', 'title' => 'Saint Martin', 'native' => ''],
['slug' => 'PM', 'title' => 'Saint Pierre and Miquelon', 'native' => 'Saint-Pierre-et-Miquelon'],
['slug' => 'WS', 'title' => 'Samoa', 'native' => ''],
['slug' => 'SM', 'title' => 'San Marino', 'native' => ''],
['slug' => 'ST', 'title' => 'São Tomé and Príncipe', 'native' => 'São Tomé e Príncipe'],
['slug' => 'SA', 'title' => 'Saudi Arabia', 'native' => 'المملكة العربية السعودية'],
['slug' => 'SN', 'title' => 'Senegal', 'native' => 'Sénégal'],
['slug' => 'RS', 'title' => 'Serbia', 'native' => 'Србија'],
['slug' => 'SC', 'title' => 'Seychelles', 'native' => ''],
['slug' => 'SL', 'title' => 'Sierra Leone', 'native' => ''],
['slug' => 'SG', 'title' => 'Singapore', 'native' => ''],
['slug' => 'SX', 'title' => 'Sint Maarten', 'native' => ''],
['slug' => 'SK', 'title' => 'Slovakia', 'native' => 'Slovensko'],
['slug' => 'SI', 'title' => 'Slovenia', 'native' => 'Slovenija'],
['slug' => 'SB', 'title' => 'Solomon Islands', 'native' => ''],
['slug' => 'SO', 'title' => 'Somalia', 'native' => 'Soomaaliya'],
['slug' => 'ZA', 'title' => 'South Africa', 'native' => ''],
['slug' => 'GS', 'title' => 'South Georgia & South Sandwich Islands', 'native' => ''],
['slug' => 'KR', 'title' => 'South Korea', 'native' => '대한민국'],
['slug' => 'SS', 'title' => 'South Sudan', 'native' => 'جنوب السودان'],
['slug' => 'ES', 'title' => 'Spain', 'native' => 'España'],
['slug' => 'LK', 'title' => 'Sri Lanka', 'native' => 'ශ්‍රී ලංකාව'],
['slug' => 'VC', 'title' => 'St. Vincent & Grenadines', 'native' => ''],
['slug' => 'SD', 'title' => 'Sudan', 'native' => 'السودان'],
['slug' => 'SR', 'title' => 'Suriname', 'native' => ''],
['slug' => 'SJ', 'title' => 'Svalbard and Jan Mayen', 'native' => 'Svalbard og Jan Mayen'],
['slug' => 'SZ', 'title' => 'Swaziland', 'native' => ''],
['slug' => 'SE', 'title' => 'Sweden', 'native' => 'Sverige'],
['slug' => 'CH', 'title' => 'Switzerland', 'native' => 'Schweiz'],
['slug' => 'SY', 'title' => 'Syria', 'native' => 'سوريا'],
['slug' => 'TW', 'title' => 'Taiwan', 'native' => '台灣'],
['slug' => 'TJ', 'title' => 'Tajikistan', 'native' => ''],
['slug' => 'TZ', 'title' => 'Tanzania', 'native' => ''],
['slug' => 'TH', 'title' => 'Thailand', 'native' => 'ไทย'],
['slug' => 'TL', 'title' => 'Timor-Leste', 'native' => ''],
['slug' => 'TG', 'title' => 'Togo', 'native' => ''],
['slug' => 'TK', 'title' => 'Tokelau', 'native' => ''],
['slug' => 'TO', 'title' => 'Tonga', 'native' => ''],
['slug' => 'TT', 'title' => 'Trinidad and Tobago', 'native' => ''],
['slug' => 'TA', 'title' => 'Tristan da Cunha', 'native' => ''],
['slug' => 'TN', 'title' => 'Tunisia', 'native' => 'تونس'],
['slug' => 'TR', 'title' => 'Turkey', 'native' => 'Türkiye'],
['slug' => 'TM', 'title' => 'Turkmenistan', 'native' => ''],
['slug' => 'TC', 'title' => 'Turks and Caicos Islands', 'native' => ''],
['slug' => 'TV', 'title' => 'Tuvalu', 'native' => ''],
['slug' => 'UM', 'title' => 'U.S. Outlying Islands', 'native' => ''],
['slug' => 'VI', 'title' => 'U.S. Virgin Islands', 'native' => ''],
['slug' => 'UG', 'title' => 'Uganda', 'native' => ''],
['slug' => 'UA', 'title' => 'Ukraine', 'native' => 'Україна'],
['slug' => 'AE', 'title' => 'United Arab Emirates', 'native' => 'الإمارات العربية المتحدة'],
['slug' => 'GB', 'title' => 'United Kingdom', 'native' => ''],
['slug' => 'US', 'title' => 'United States', 'native' => ''],
['slug' => 'UY', 'title' => 'Uruguay', 'native' => ''],
['slug' => 'UZ', 'title' => 'Uzbekistan', 'native' => 'Oʻzbekiston'],
['slug' => 'VU', 'title' => 'Vanuatu', 'native' => ''],
['slug' => 'VA', 'title' => 'Vatican City', 'native' => 'Città del Vaticano'],
['slug' => 'VE', 'title' => 'Venezuela', 'native' => ''],
['slug' => 'VN', 'title' => 'Vietnam', 'native' => 'Việt Nam'],
['slug' => 'WF', 'title' => 'Wallis and Futuna', 'native' => ''],
['slug' => 'EH', 'title' => 'Western Sahara', 'native' => 'الصحراء الغربية'],
['slug' => 'YE', 'title' => 'Yemen', 'native' => 'اليمن'],
['slug' => 'ZM', 'title' => 'Zambia', 'native' => ''],
['slug' => 'ZW', 'title' => 'Zimbabwe', 'native' => '']
);
DB::table('data_location_country')->insert($data);
$country_us = DB::table('data_location_country')->select('id')->where('slug', '=', 'US')->first();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment