<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20231017103026 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql("CREATE TABLE `countries` (
`id` int(11) NOT NULL,
`shortname` varchar(3) NOT NULL,
`name` varchar(150) NOT NULL,
`slug` varchar(150) DEFAULT NULL,
`phonecode` int(11) NOT NULL,
`status` int(1) DEFAULT 1,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;");
// this down() migration is auto-generated, please modify it to your needs
$this->addSql("INSERT INTO `countries` (`id`, `shortname`, `name`, `slug`, `phonecode`, `status`, `deleted_at`) VALUES
(1, 'AF', 'Afghanistan', 'afghanistan', 93, 1, NULL),
(2, 'AL', 'Albania', 'albania', 355, 1, NULL),
(3, 'DZ', 'Algeria', 'algeria', 213, 1, NULL),
(4, 'AS', 'American Samoa', 'american-samoa', 1684, 1, NULL),
(5, 'AD', 'Andorra', 'andorra', 376, 1, NULL),
(6, 'AO', 'Angola', 'angola', 244, 1, NULL),
(7, 'AI', 'Anguilla', 'anguilla', 1264, 1, NULL),
(8, 'AQ', 'Antarctica', 'antarctica', 1, 1, NULL),
(9, 'AG', 'Antigua And Barbuda', 'antigua-and-barbuda', 1268, 1, NULL),
(10, 'AR', 'Argentina', 'argentina', 54, 1, NULL),
(11, 'AM', 'Armenia', 'armenia', 374, 1, NULL),
(12, 'AW', 'Aruba', 'aruba', 297, 1, NULL),
(13, 'AU', 'Australia', 'australia', 61, 1, NULL),
(14, 'AT', 'Austria', 'austria', 43, 1, NULL),
(15, 'AZ', 'Azerbaijan', 'azerbaijan', 994, 1, NULL),
(16, 'BS', 'Bahamas The', 'bahamas-the', 1242, 1, NULL),
(17, 'BH', 'Bahrain', 'bahrain', 973, 1, NULL),
(18, 'BD', 'Bangladesh', 'bangladesh', 880, 1, NULL),
(19, 'BB', 'Barbados', 'barbados', 1246, 1, NULL),
(20, 'BY', 'Belarus', 'belarus', 375, 1, NULL),
(21, 'BE', 'Belgium', 'belgium', 32, 1, NULL),
(22, 'BZ', 'Belize', 'belize', 501, 1, NULL),
(23, 'BJ', 'Benin', 'benin', 229, 1, NULL),
(24, 'BM', 'Bermuda', 'bermuda', 1441, 1, NULL),
(25, 'BT', 'Bhutan', 'bhutan', 975, 1, NULL),
(26, 'BO', 'Bolivia', 'bolivia', 591, 1, NULL),
(27, 'BA', 'Bosnia and Herzegovina', 'bosnia-and-herzegovina', 387, 1, NULL),
(28, 'BW', 'Botswana', 'botswana', 267, 1, NULL),
(29, 'BV', 'Bouvet Island', 'bouvet-island', 1, 1, NULL),
(30, 'BR', 'Brazil', 'brazil', 55, 1, NULL),
(31, 'IO', 'British Indian Ocean Territory', 'british-indian-ocean-territory', 246, 1, NULL),
(32, 'BN', 'Brunei', 'brunei', 673, 1, NULL),
(33, 'BG', 'Bulgaria', 'bulgaria', 359, 1, NULL),
(34, 'BF', 'Burkina Faso', 'burkina-faso', 226, 1, NULL),
(35, 'BI', 'Burundi', 'burundi', 257, 1, NULL),
(36, 'KH', 'Cambodia', 'cambodia', 855, 1, NULL),
(37, 'CM', 'Cameroon', 'cameroon', 237, 1, NULL),
(38, 'CA', 'Canada', 'canada', 1, 1, NULL),
(39, 'CV', 'Cape Verde', 'cape-verde', 238, 1, NULL),
(40, 'KY', 'Cayman Islands', 'cayman-islands', 1345, 1, NULL),
(41, 'CF', 'Central African Republic', 'central-african-republic', 236, 1, NULL),
(42, 'TD', 'Chad', 'chad', 235, 1, NULL),
(43, 'CL', 'Chile', 'chile', 56, 1, NULL),
(44, 'CN', 'China', 'china', 86, 1, NULL),
(45, 'CX', 'Christmas Island', 'christmas-island', 61, 1, NULL),
(46, 'CC', 'Cocos (Keeling) Islands', 'cocos-(keeling)-islands', 672, 1, NULL),
(47, 'CO', 'Colombia', 'colombia', 57, 1, NULL),
(48, 'KM', 'Comoros', 'comoros', 269, 1, NULL),
(49, 'CG', 'Republic Of The Congo', 'republic-of-the-congo', 242, 1, NULL),
(50, 'CD', 'Democratic Republic Of The Congo', 'democratic-republic-of-the-congo', 242, 1, NULL),
(51, 'CK', 'Cook Islands', 'cook-islands', 682, 1, NULL),
(52, 'CR', 'Costa Rica', 'costa-rica', 506, 1, NULL),
(53, 'CI', 'Cote D\'Ivoire (Ivory Coast)', 'cote-d\'ivoire-(ivory-coast)', 225, 1, NULL),
(54, 'HR', 'Croatia (Hrvatska)', 'croatia-(hrvatska)', 385, 1, NULL),
(55, 'CU', 'Cuba', 'cuba', 53, 1, NULL),
(56, 'CY', 'Cyprus', 'cyprus', 357, 1, NULL),
(57, 'CZ', 'Czech Republic', 'czech-republic', 420, 1, NULL),
(58, 'DK', 'Denmark', 'denmark', 45, 1, NULL),
(59, 'DJ', 'Djibouti', 'djibouti', 253, 1, NULL),
(60, 'DM', 'Dominica', 'dominica', 1767, 1, NULL),
(61, 'DO', 'Dominican Republic', 'dominican-republic', 1809, 1, NULL),
(62, 'TP', 'East Timor', 'east-timor', 670, 1, NULL),
(63, 'EC', 'Ecuador', 'ecuador', 593, 1, NULL),
(64, 'EG', 'Egypt', 'egypt', 20, 1, NULL),
(65, 'SV', 'El Salvador', 'el-salvador', 503, 1, NULL),
(66, 'GQ', 'Equatorial Guinea', 'equatorial-guinea', 240, 1, NULL),
(67, 'ER', 'Eritrea', 'eritrea', 291, 1, NULL),
(68, 'EE', 'Estonia', 'estonia', 372, 1, NULL),
(69, 'ET', 'Ethiopia', 'ethiopia', 251, 1, NULL),
(70, 'XA', 'External Territories of Australia', 'external-territories-of-australia', 61, 1, NULL),
(71, 'FK', 'Falkland Islands', 'falkland-islands', 500, 1, NULL),
(72, 'FO', 'Faroe Islands', 'faroe-islands', 298, 1, NULL),
(73, 'FJ', 'Fiji Islands', 'fiji-islands', 679, 1, NULL),
(74, 'FI', 'Finland', 'finland', 358, 1, NULL),
(75, 'FR', 'France', 'france', 33, 1, NULL),
(76, 'GF', 'French Guiana', 'french-guiana', 594, 1, NULL),
(77, 'PF', 'French Polynesia', 'french-polynesia', 689, 1, NULL),
(78, 'TF', 'French Southern Territories', 'french-southern-territories', 1, 1, NULL),
(79, 'GA', 'Gabon', 'gabon', 241, 1, NULL),
(80, 'GM', 'Gambia The', 'gambia-the', 220, 1, NULL),
(81, 'GE', 'Georgia', 'georgia', 995, 1, NULL),
(82, 'DE', 'Germany', 'germany', 49, 1, NULL),
(83, 'GH', 'Ghana', 'ghana', 233, 1, NULL),
(84, 'GI', 'Gibraltar', 'gibraltar', 350, 1, NULL),
(85, 'GR', 'Greece', 'greece', 30, 1, NULL),
(86, 'GL', 'Greenland', 'greenland', 299, 1, NULL),
(87, 'GD', 'Grenada', 'grenada', 1473, 1, NULL),
(88, 'GP', 'Guadeloupe', 'guadeloupe', 590, 1, NULL),
(89, 'GU', 'Guam', 'guam', 1671, 1, NULL),
(90, 'GT', 'Guatemala', 'guatemala', 502, 1, NULL),
(91, 'XU', 'Guernsey and Alderney', 'guernsey-and-alderney', 44, 1, NULL),
(92, 'GN', 'Guinea', 'guinea', 224, 1, NULL),
(93, 'GW', 'Guinea-Bissau', 'guinea-bissau', 245, 1, NULL),
(94, 'GY', 'Guyana', 'guyana', 592, 1, NULL),
(95, 'HT', 'Haiti', 'haiti', 509, 1, NULL),
(96, 'HM', 'Heard and McDonald Islands', 'heard-and-mcdonald-islands', 1, 1, NULL),
(97, 'HN', 'Honduras', 'honduras', 504, 1, NULL),
(98, 'HK', 'Hong Kong S.A.R.', 'hong-kong-s.a.r.', 852, 1, NULL),
(99, 'HU', 'Hungary', 'hungary', 36, 1, NULL),
(100, 'IS', 'Iceland', 'iceland', 354, 1, NULL),
(101, 'IN', 'India', 'india', 91, 1, NULL),
(102, 'ID', 'Indonesia', 'indonesia', 62, 1, NULL),
(103, 'IR', 'Iran', 'iran', 98, 1, NULL),
(104, 'IQ', 'Iraq', 'iraq', 964, 1, NULL),
(105, 'IE', 'Ireland', 'ireland', 353, 1, NULL),
(106, 'IL', 'Israel', 'israel', 972, 1, NULL),
(107, 'IT', 'Italy', 'italy', 39, 1, NULL),
(108, 'JM', 'Jamaica', 'jamaica', 1876, 1, NULL),
(109, 'JP', 'Japan', 'japan', 81, 1, NULL),
(110, 'XJ', 'Jersey', 'jersey', 44, 1, NULL),
(111, 'JO', 'Jordan', 'jordan', 962, 1, NULL),
(112, 'KZ', 'Kazakhstan', 'kazakhstan', 7, 1, NULL),
(113, 'KE', 'Kenya', 'kenya', 254, 1, NULL),
(114, 'KI', 'Kiribati', 'kiribati', 686, 1, NULL),
(115, 'KP', 'Korea North', 'korea-north', 850, 1, NULL),
(116, 'KR', 'Korea South', 'korea-south', 82, 1, NULL),
(117, 'KW', 'Kuwait', 'kuwait', 965, 1, NULL),
(118, 'KG', 'Kyrgyzstan', 'kyrgyzstan', 996, 1, NULL),
(119, 'LA', 'Laos', 'laos', 856, 1, NULL),
(120, 'LV', 'Latvia', 'latvia', 371, 1, NULL),
(121, 'LB', 'Lebanon', 'lebanon', 961, 1, NULL),
(122, 'LS', 'Lesotho', 'lesotho', 266, 1, NULL),
(123, 'LR', 'Liberia', 'liberia', 231, 1, NULL),
(124, 'LY', 'Libya', 'libya', 218, 1, NULL),
(125, 'LI', 'Liechtenstein', 'liechtenstein', 423, 1, NULL),
(126, 'LT', 'Lithuania', 'lithuania', 370, 1, NULL),
(127, 'LU', 'Luxembourg', 'luxembourg', 352, 1, NULL),
(128, 'MO', 'Macau S.A.R.', 'macau-s.a.r.', 853, 1, NULL),
(129, 'MK', 'Macedonia', 'macedonia', 389, 1, NULL),
(130, 'MG', 'Madagascar', 'madagascar', 261, 1, NULL),
(131, 'MW', 'Malawi', 'malawi', 265, 1, NULL),
(132, 'MY', 'Malaysia', 'malaysia', 60, 1, NULL),
(133, 'MV', 'Maldives', 'maldives', 960, 1, NULL),
(134, 'ML', 'Mali', 'mali', 223, 1, NULL),
(135, 'MT', 'Malta', 'malta', 356, 1, NULL),
(136, 'XM', 'Man (Isle of)', 'man-(isle-of)', 44, 1, NULL),
(137, 'MH', 'Marshall Islands', 'marshall-islands', 692, 1, NULL),
(138, 'MQ', 'Martinique', 'martinique', 596, 1, NULL),
(139, 'MR', 'Mauritania', 'mauritania', 222, 1, NULL),
(140, 'MU', 'Mauritius', 'mauritius', 230, 1, NULL),
(141, 'YT', 'Mayotte', 'mayotte', 269, 1, NULL),
(142, 'MX', 'Mexico', 'mexico', 52, 1, NULL),
(143, 'FM', 'Micronesia', 'micronesia', 691, 1, NULL),
(144, 'MD', 'Moldova', 'moldova', 373, 1, NULL),
(145, 'MC', 'Monaco', 'monaco', 377, 1, NULL),
(146, 'MN', 'Mongolia', 'mongolia', 976, 1, NULL),
(147, 'MS', 'Montserrat', 'montserrat', 1664, 1, NULL),
(148, 'MA', 'Morocco', 'morocco', 212, 1, NULL),
(149, 'MZ', 'Mozambique', 'mozambique', 258, 1, NULL),
(150, 'MM', 'Myanmar', 'myanmar', 95, 1, NULL),
(151, 'NA', 'Namibia', 'namibia', 264, 1, NULL),
(152, 'NR', 'Nauru', 'nauru', 674, 1, NULL),
(153, 'NP', 'Nepal', 'nepal', 977, 1, NULL),
(154, 'AN', 'Netherlands Antilles', 'netherlands-antilles', 599, 1, NULL),
(155, 'NL', 'Netherlands', 'netherlands', 31, 1, NULL),
(156, 'NC', 'New Caledonia', 'new-caledonia', 687, 1, NULL),
(157, 'NZ', 'New Zealand', 'new-zealand', 64, 1, NULL),
(158, 'NI', 'Nicaragua', 'nicaragua', 505, 1, NULL),
(159, 'NE', 'Niger', 'niger', 227, 1, NULL),
(160, 'NG', 'Nigeria', 'nigeria', 234, 1, NULL),
(161, 'NU', 'Niue', 'niue', 683, 1, NULL),
(162, 'NF', 'Norfolk Island', 'norfolk-island', 672, 1, NULL),
(163, 'MP', 'Northern Mariana Islands', 'northern-mariana-islands', 1670, 1, NULL),
(164, 'NO', 'Norway', 'norway', 47, 1, NULL),
(165, 'OM', 'Oman', 'oman', 968, 1, NULL),
(166, 'PK', 'Pakistan', 'pakistan', 92, 1, NULL),
(167, 'PW', 'Palau', 'palau', 680, 1, NULL),
(168, 'PS', 'Palestinian Territory Occupied', 'palestinian-territory-occupied', 970, 1, NULL),
(169, 'PA', 'Panama', 'panama', 507, 1, NULL),
(170, 'PG', 'Papua new Guinea', 'papua-new-guinea', 675, 1, NULL),
(171, 'PY', 'Paraguay', 'paraguay', 595, 1, NULL),
(172, 'PE', 'Peru', 'peru', 51, 1, NULL),
(173, 'PH', 'Philippines', 'philippines', 63, 1, NULL),
(174, 'PN', 'Pitcairn Island', 'pitcairn-island', 1, 1, NULL),
(175, 'PL', 'Poland', 'poland', 48, 1, NULL),
(176, 'PT', 'Portugal', 'portugal', 351, 1, NULL),
(177, 'PR', 'Puerto Rico', 'puerto-rico', 1787, 1, NULL),
(178, 'QA', 'Qatar', 'qatar', 974, 1, NULL),
(179, 'RE', 'Reunion', 'reunion', 262, 1, NULL),
(180, 'RO', 'Romania', 'romania', 40, 1, NULL),
(181, 'RU', 'Russia', 'russia', 70, 1, NULL),
(182, 'RW', 'Rwanda', 'rwanda', 250, 1, NULL),
(183, 'SH', 'Saint Helena', 'saint-helena', 290, 1, NULL),
(184, 'KN', 'Saint Kitts And Nevis', 'saint-kitts-and-nevis', 1869, 1, NULL),
(185, 'LC', 'Saint Lucia', 'saint-lucia', 1758, 1, NULL),
(186, 'PM', 'Saint Pierre and Miquelon', 'saint-pierre-and-miquelon', 508, 1, NULL),
(187, 'VC', 'Saint Vincent And The Grenadines', 'saint-vincent-and-the-grenadines', 1784, 1, NULL),
(188, 'WS', 'Samoa', 'samoa', 684, 1, NULL),
(189, 'SM', 'San Marino', 'san-marino', 378, 1, NULL),
(190, 'ST', 'Sao Tome and Principe', 'sao-tome-and-principe', 239, 1, NULL),
(191, 'SA', 'Saudi Arabia', 'saudi-arabia', 966, 1, NULL),
(192, 'SN', 'Senegal', 'senegal', 221, 1, NULL),
(193, 'RS', 'Serbia', 'serbia', 381, 1, NULL),
(194, 'SC', 'Seychelles', 'seychelles', 248, 1, NULL),
(195, 'SL', 'Sierra Leone', 'sierra-leone', 232, 1, NULL),
(196, 'SG', 'Singapore', 'singapore', 65, 1, NULL),
(197, 'SK', 'Slovakia', 'slovakia', 421, 1, NULL),
(198, 'SI', 'Slovenia', 'slovenia', 386, 1, NULL),
(199, 'XG', 'Smaller Territories of the UK', 'smaller-territories-of-the-uk', 44, 1, NULL),
(200, 'SB', 'Solomon Islands', 'solomon-islands', 677, 1, NULL),
(201, 'SO', 'Somalia', 'somalia', 252, 1, NULL),
(202, 'ZA', 'South Africa', 'south-africa', 27, 1, NULL),
(203, 'GS', 'South Georgia', 'south-georgia', 1, 1, NULL),
(204, 'SS', 'South Sudan', 'south-sudan', 211, 1, NULL),
(205, 'ES', 'Spain', 'spain', 34, 1, NULL),
(206, 'LK', 'Sri Lanka', 'sri-lanka', 94, 1, NULL),
(207, 'SD', 'Sudan', 'sudan', 249, 1, NULL),
(208, 'SR', 'Suriname', 'suriname', 597, 1, NULL),
(209, 'SJ', 'Svalbard And Jan Mayen Islands', 'svalbard-and-jan-mayen-islands', 47, 1, NULL),
(210, 'SZ', 'Swaziland', 'swaziland', 268, 1, NULL),
(211, 'SE', 'Sweden', 'sweden', 46, 1, NULL),
(212, 'CH', 'Switzerland', 'switzerland', 41, 1, NULL),
(213, 'SY', 'Syria', 'syria', 963, 1, NULL),
(214, 'TW', 'Taiwan', 'taiwan', 886, 1, NULL),
(215, 'TJ', 'Tajikistan', 'tajikistan', 992, 1, NULL),
(216, 'TZ', 'Tanzania', 'tanzania', 255, 1, NULL),
(217, 'TH', 'Thailand', 'thailand', 66, 1, NULL),
(218, 'TG', 'Togo', 'togo', 228, 1, NULL),
(219, 'TK', 'Tokelau', 'tokelau', 690, 1, NULL),
(220, 'TO', 'Tonga', 'tonga', 676, 1, NULL),
(221, 'TT', 'Trinidad And Tobago', 'trinidad-and-tobago', 1868, 1, NULL),
(222, 'TN', 'Tunisia', 'tunisia', 216, 1, NULL),
(223, 'TR', 'Turkey', 'turkey', 90, 1, NULL),
(224, 'TM', 'Turkmenistan', 'turkmenistan', 7370, 1, NULL),
(225, 'TC', 'Turks And Caicos Islands', 'turks-and-caicos-islands', 1649, 1, NULL),
(226, 'TV', 'Tuvalu', 'tuvalu', 688, 1, NULL),
(227, 'UG', 'Uganda', 'uganda', 256, 1, NULL),
(228, 'UA', 'Ukraine', 'ukraine', 380, 1, NULL),
(229, 'AE', 'UAE', 'uae', 971, 1, NULL),
(230, 'GB', 'UK', 'uk', 44, 1, NULL),
(231, 'US', 'USA', 'usa', 1, 1, NULL),
(232, 'UM', 'United States Minor Outlying Islands', 'united-states-minor-outlying-islands', 1, 1, NULL),
(233, 'UY', 'Uruguay', 'uruguay', 598, 1, NULL),
(234, 'UZ', 'Uzbekistan', 'uzbekistan', 998, 1, NULL),
(235, 'VU', 'Vanuatu', 'vanuatu', 678, 1, NULL),
(236, 'VA', 'Vatican City State (Holy See)', 'vatican-city-state-(holy-see)', 39, 1, NULL),
(237, 'VE', 'Venezuela', 'venezuela', 58, 1, NULL),
(238, 'VN', 'Vietnam', 'vietnam', 84, 1, NULL),
(239, 'VG', 'Virgin Islands (British)', 'virgin-islands-(british)', 1284, 1, NULL),
(240, 'VI', 'Virgin Islands (US)', 'virgin-islands-(us)', 1340, 1, NULL),
(241, 'WF', 'Wallis And Futuna Islands', 'wallis-and-futuna-islands', 681, 1, NULL),
(242, 'EH', 'Western Sahara', 'western-sahara', 212, 1, NULL),
(243, 'YE', 'Yemen', 'yemen', 967, 1, NULL),
(244, 'YU', 'Yugoslavia', 'yugoslavia', 38, 1, NULL),
(245, 'ZM', 'Zambia', 'zambia', 260, 1, NULL),
(246, 'ZW', 'Zimbabwe', 'zimbabwe', 263, 1, NULL),
(247, 'sss', 'ssss', 'ssss', 484512, 1, '2022-02-04 05:13:02'),
(248, 'Mum', 'Mumbai', 'mumbai', 1, 1, '2022-02-16 12:14:56'),
(249, 'Mum', 'Mumbai', 'mumbai', 1, 1, NULL),
(250, 'dd', 'demo countrys s', 'demo-countrys-s', 456, 1, '2022-02-28 10:56:33'),
(251, 'EST', 'Republic of Estonia', 'republic-of-estonia', 372, 1, NULL);");
}
public function down(Schema $schema): void
{
}
}