<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
final class Version20221205134436 extends AbstractMigration
{
public function getDescription(): string
{
return 'Add Rank field - [City]';
}
public function up(Schema $schema): void
{
$this->addSql('ALTER TABLE city ADD rank INT DEFAULT NULL');
$this->addSql("UPDATE city SET rank = 1 WHERE name = 'Casablanca'");
$this->addSql("UPDATE city SET rank = 2 WHERE name = 'Rabat'");
$this->addSql("UPDATE city SET rank = 3 WHERE name = 'Fès'");
$this->addSql("UPDATE city SET rank = 4 WHERE name = 'Marrakech'");
$this->addSql("UPDATE city SET rank = 5 WHERE name = 'Tanger'");
}
public function down(Schema $schema): void
{
$this->addSql('ALTER TABLE city DROP rank');
}
}