<?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 Version20210719154337 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('ALTER TABLE country ADD code VARCHAR(2) NOT NULL');
$this->addSql('UPDATE country SET code = "AF" WHERE id = 1');
$this->addSql('UPDATE country SET code = "AL" WHERE id = 2');
$this->addSql('UPDATE country SET code = "DZ" WHERE id = 3');
$this->addSql('UPDATE country SET code = "AD" WHERE id = 4');
$this->addSql('UPDATE country SET code = "AO" WHERE id = 5');
$this->addSql('UPDATE country SET code = "AG" WHERE id = 6');
$this->addSql('UPDATE country SET code = "AR" WHERE id = 7');
$this->addSql('UPDATE country SET code = "AM" WHERE id = 8');
$this->addSql('UPDATE country SET code = "AU" WHERE id = 9');
$this->addSql('UPDATE country SET code = "AT" WHERE id = 10');
$this->addSql('UPDATE country SET code = "AZ" WHERE id = 11');
$this->addSql('UPDATE country SET code = "BS" WHERE id = 12');
$this->addSql('UPDATE country SET code = "BH" WHERE id = 13');
$this->addSql('UPDATE country SET code = "BD" WHERE id = 14');
$this->addSql('UPDATE country SET code = "BB" WHERE id = 15');
$this->addSql('UPDATE country SET code = "BY" WHERE id = 16');
$this->addSql('UPDATE country SET code = "BE" WHERE id = 17');
$this->addSql('UPDATE country SET code = "BZ" WHERE id = 18');
$this->addSql('UPDATE country SET code = "BJ" WHERE id = 19');
$this->addSql('UPDATE country SET code = "BT" WHERE id = 20');
$this->addSql('UPDATE country SET code = "BO" WHERE id = 21');
$this->addSql('UPDATE country SET code = "BA" WHERE id = 22');
$this->addSql('UPDATE country SET code = "BW" WHERE id = 23');
$this->addSql('UPDATE country SET code = "BR" WHERE id = 24');
$this->addSql('UPDATE country SET code = "BN" WHERE id = 25');
$this->addSql('UPDATE country SET code = "BG" WHERE id = 26');
$this->addSql('UPDATE country SET code = "BF" WHERE id = 27');
$this->addSql('UPDATE country SET code = "BI" WHERE id = 28');
$this->addSql('UPDATE country SET code = "CI" WHERE id = 29');
$this->addSql('UPDATE country SET code = "CV" WHERE id = 30');
$this->addSql('UPDATE country SET code = "KH" WHERE id = 31');
$this->addSql('UPDATE country SET code = "CM" WHERE id = 32');
$this->addSql('UPDATE country SET code = "CA" WHERE id = 33');
$this->addSql('UPDATE country SET code = "CF" WHERE id = 34');
$this->addSql('UPDATE country SET code = "TD" WHERE id = 35');
$this->addSql('UPDATE country SET code = "CL" WHERE id = 36');
$this->addSql('UPDATE country SET code = "CN" WHERE id = 37');
$this->addSql('UPDATE country SET code = "CO" WHERE id = 38');
$this->addSql('UPDATE country SET code = "KM" WHERE id = 39');
$this->addSql('UPDATE country SET code = "CG" WHERE id = 40');
$this->addSql('UPDATE country SET code = "CR" WHERE id = 41');
$this->addSql('UPDATE country SET code = "HR" WHERE id = 42');
$this->addSql('UPDATE country SET code = "CU" WHERE id = 43');
$this->addSql('UPDATE country SET code = "CY" WHERE id = 44');
$this->addSql('UPDATE country SET code = "CZ" WHERE id = 45');
$this->addSql('UPDATE country SET code = "CC" WHERE id = 46');
$this->addSql('UPDATE country SET code = "DK" WHERE id = 47');
$this->addSql('UPDATE country SET code = "DJ" WHERE id = 48');
$this->addSql('UPDATE country SET code = "DM" WHERE id = 49');
$this->addSql('UPDATE country SET code = "DO" WHERE id = 50');
$this->addSql('UPDATE country SET code = "EC" WHERE id = 51');
$this->addSql('UPDATE country SET code = "EG" WHERE id = 52');
$this->addSql('UPDATE country SET code = "SV" WHERE id = 53');
$this->addSql('UPDATE country SET code = "GQ" WHERE id = 54');
$this->addSql('UPDATE country SET code = "ER" WHERE id = 55');
$this->addSql('UPDATE country SET code = "EE" WHERE id = 56');
$this->addSql('UPDATE country SET code = "SZ" WHERE id = 57');
$this->addSql('UPDATE country SET code = "ET" WHERE id = 58');
$this->addSql('UPDATE country SET code = "FJ" WHERE id = 59');
$this->addSql('UPDATE country SET code = "FI" WHERE id = 60');
$this->addSql('UPDATE country SET code = "FR" WHERE id = 61');
$this->addSql('UPDATE country SET code = "GA" WHERE id = 62');
$this->addSql('UPDATE country SET code = "GM" WHERE id = 63');
$this->addSql('UPDATE country SET code = "GE" WHERE id = 64');
$this->addSql('UPDATE country SET code = "DE" WHERE id = 65');
$this->addSql('UPDATE country SET code = "GH" WHERE id = 66');
$this->addSql('UPDATE country SET code = "GR" WHERE id = 67');
$this->addSql('UPDATE country SET code = "GD" WHERE id = 68');
$this->addSql('UPDATE country SET code = "GT" WHERE id = 69');
$this->addSql('UPDATE country SET code = "GN" WHERE id = 70');
$this->addSql('UPDATE country SET code = "GW" WHERE id = 71');
$this->addSql('UPDATE country SET code = "GY" WHERE id = 72');
$this->addSql('UPDATE country SET code = "HT" WHERE id = 73');
$this->addSql('UPDATE country SET code = "VA" WHERE id = 74');
$this->addSql('UPDATE country SET code = "HN" WHERE id = 75');
$this->addSql('UPDATE country SET code = "HU" WHERE id = 76');
$this->addSql('UPDATE country SET code = "IS" WHERE id = 77');
$this->addSql('UPDATE country SET code = "IN" WHERE id = 78');
$this->addSql('UPDATE country SET code = "ID" WHERE id = 79');
$this->addSql('UPDATE country SET code = "IR" WHERE id = 80');
$this->addSql('UPDATE country SET code = "IQ" WHERE id = 81');
$this->addSql('UPDATE country SET code = "IE" WHERE id = 82');
$this->addSql('UPDATE country SET code = "IL" WHERE id = 83');
$this->addSql('UPDATE country SET code = "IT" WHERE id = 84');
$this->addSql('UPDATE country SET code = "JM" WHERE id = 85');
$this->addSql('UPDATE country SET code = "JP" WHERE id = 86');
$this->addSql('UPDATE country SET code = "JO" WHERE id = 87');
$this->addSql('UPDATE country SET code = "KZ" WHERE id = 88');
$this->addSql('UPDATE country SET code = "KE" WHERE id = 89');
$this->addSql('UPDATE country SET code = "KI" WHERE id = 90');
$this->addSql('UPDATE country SET code = "KW" WHERE id = 91');
$this->addSql('UPDATE country SET code = "KG" WHERE id = 92');
$this->addSql('UPDATE country SET code = "LA" WHERE id = 93');
$this->addSql('UPDATE country SET code = "LV" WHERE id = 94');
$this->addSql('UPDATE country SET code = "LB" WHERE id = 95');
$this->addSql('UPDATE country SET code = "LS" WHERE id = 96');
$this->addSql('UPDATE country SET code = "LR" WHERE id = 97');
$this->addSql('UPDATE country SET code = "LY" WHERE id = 98');
$this->addSql('UPDATE country SET code = "LI" WHERE id = 99');
$this->addSql('UPDATE country SET code = "LT" WHERE id = 100');
$this->addSql('UPDATE country SET code = "LU" WHERE id = 101');
$this->addSql('UPDATE country SET code = "MG" WHERE id = 102');
$this->addSql('UPDATE country SET code = "MW" WHERE id = 103');
$this->addSql('UPDATE country SET code = "MY" WHERE id = 104');
$this->addSql('UPDATE country SET code = "MV" WHERE id = 105');
$this->addSql('UPDATE country SET code = "ML" WHERE id = 106');
$this->addSql('UPDATE country SET code = "MT" WHERE id = 107');
$this->addSql('UPDATE country SET code = "MH" WHERE id = 108');
$this->addSql('UPDATE country SET code = "MR" WHERE id = 109');
$this->addSql('UPDATE country SET code = "MU" WHERE id = 110');
$this->addSql('UPDATE country SET code = "MX" WHERE id = 111');
$this->addSql('UPDATE country SET code = "FM" WHERE id = 112');
$this->addSql('UPDATE country SET code = "MD" WHERE id = 113');
$this->addSql('UPDATE country SET code = "MC" WHERE id = 114');
$this->addSql('UPDATE country SET code = "MN" WHERE id = 115');
$this->addSql('UPDATE country SET code = "ME" WHERE id = 116');
$this->addSql('UPDATE country SET code = "MA" WHERE id = 117');
$this->addSql('UPDATE country SET code = "MZ" WHERE id = 118');
$this->addSql('UPDATE country SET code = "MM" WHERE id = 119');
$this->addSql('UPDATE country SET code = "NA" WHERE id = 120');
$this->addSql('UPDATE country SET code = "NR" WHERE id = 121');
$this->addSql('UPDATE country SET code = "NP" WHERE id = 122');
$this->addSql('UPDATE country SET code = "NL" WHERE id = 123');
$this->addSql('UPDATE country SET code = "NZ" WHERE id = 124');
$this->addSql('UPDATE country SET code = "NI" WHERE id = 125');
$this->addSql('UPDATE country SET code = "NE" WHERE id = 126');
$this->addSql('UPDATE country SET code = "NG" WHERE id = 127');
$this->addSql('UPDATE country SET code = "KP" WHERE id = 128');
$this->addSql('UPDATE country SET code = "MK" WHERE id = 129');
$this->addSql('UPDATE country SET code = "NO" WHERE id = 130');
$this->addSql('UPDATE country SET code = "OM" WHERE id = 131');
$this->addSql('UPDATE country SET code = "PK" WHERE id = 132');
$this->addSql('UPDATE country SET code = "PW" WHERE id = 133');
$this->addSql('UPDATE country SET code = "PS" WHERE id = 134');
$this->addSql('UPDATE country SET code = "PA" WHERE id = 135');
$this->addSql('UPDATE country SET code = "PG" WHERE id = 136');
$this->addSql('UPDATE country SET code = "PY" WHERE id = 137');
$this->addSql('UPDATE country SET code = "PE" WHERE id = 138');
$this->addSql('UPDATE country SET code = "PH" WHERE id = 139');
$this->addSql('UPDATE country SET code = "PL" WHERE id = 140');
$this->addSql('UPDATE country SET code = "PT" WHERE id = 141');
$this->addSql('UPDATE country SET code = "QA" WHERE id = 142');
$this->addSql('UPDATE country SET code = "RO" WHERE id = 143');
$this->addSql('UPDATE country SET code = "RU" WHERE id = 144');
$this->addSql('UPDATE country SET code = "RW" WHERE id = 145');
$this->addSql('UPDATE country SET code = "KN" WHERE id = 146');
$this->addSql('UPDATE country SET code = "LC" WHERE id = 147');
$this->addSql('UPDATE country SET code = "VC" WHERE id = 148');
$this->addSql('UPDATE country SET code = "WS" WHERE id = 149');
$this->addSql('UPDATE country SET code = "SM" WHERE id = 150');
$this->addSql('UPDATE country SET code = "ST" WHERE id = 151');
$this->addSql('UPDATE country SET code = "SA" WHERE id = 152');
$this->addSql('UPDATE country SET code = "SN" WHERE id = 153');
$this->addSql('UPDATE country SET code = "RS" WHERE id = 154');
$this->addSql('UPDATE country SET code = "SC" WHERE id = 155');
$this->addSql('UPDATE country SET code = "SK" WHERE id = 156');
$this->addSql('UPDATE country SET code = "SG" WHERE id = 157');
$this->addSql('UPDATE country SET code = "SK" WHERE id = 158');
$this->addSql('UPDATE country SET code = "SI" WHERE id = 159');
$this->addSql('UPDATE country SET code = "SB" WHERE id = 160');
$this->addSql('UPDATE country SET code = "SO" WHERE id = 161');
$this->addSql('UPDATE country SET code = "ZA" WHERE id = 162');
$this->addSql('UPDATE country SET code = "KR" WHERE id = 163');
$this->addSql('UPDATE country SET code = "SS" WHERE id = 164');
$this->addSql('UPDATE country SET code = "ES" WHERE id = 165');
$this->addSql('UPDATE country SET code = "LK" WHERE id = 166');
$this->addSql('UPDATE country SET code = "SD" WHERE id = 167');
$this->addSql('UPDATE country SET code = "SR" WHERE id = 168');
$this->addSql('UPDATE country SET code = "SE" WHERE id = 169');
$this->addSql('UPDATE country SET code = "CH" WHERE id = 170');
$this->addSql('UPDATE country SET code = "SY" WHERE id = 171');
$this->addSql('UPDATE country SET code = "TJ" WHERE id = 172');
$this->addSql('UPDATE country SET code = "TZ" WHERE id = 173');
$this->addSql('UPDATE country SET code = "TH" WHERE id = 174');
$this->addSql('UPDATE country SET code = "TL" WHERE id = 175');
$this->addSql('UPDATE country SET code = "TG" WHERE id = 176');
$this->addSql('UPDATE country SET code = "TO" WHERE id = 177');
$this->addSql('UPDATE country SET code = "TT" WHERE id = 178');
$this->addSql('UPDATE country SET code = "TN" WHERE id = 179');
$this->addSql('UPDATE country SET code = "TR" WHERE id = 180');
$this->addSql('UPDATE country SET code = "TM" WHERE id = 181');
$this->addSql('UPDATE country SET code = "TV" WHERE id = 182');
$this->addSql('UPDATE country SET code = "UG" WHERE id = 183');
$this->addSql('UPDATE country SET code = "UA" WHERE id = 184');
$this->addSql('UPDATE country SET code = "AE" WHERE id = 185');
$this->addSql('UPDATE country SET code = "UK" WHERE id = 186');
$this->addSql('UPDATE country SET code = "US" WHERE id = 187');
$this->addSql('UPDATE country SET code = "UY" WHERE id = 188');
$this->addSql('UPDATE country SET code = "UZ" WHERE id = 189');
$this->addSql('UPDATE country SET code = "VU" WHERE id = 190');
$this->addSql('UPDATE country SET code = "VE" WHERE id = 191');
$this->addSql('UPDATE country SET code = "VN" WHERE id = 192');
$this->addSql('UPDATE country SET code = "YE" WHERE id = 193');
$this->addSql('UPDATE country SET code = "ZM" WHERE id = 194');
$this->addSql('UPDATE country SET code = "ZW" WHERE id = 195');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE country DROP code');
}
}