<?php
declare(strict_types=1);
namespace CustomersBundleMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
final class Version20240621093252 extends AbstractMigration
{
public function up(Schema $schema): void
{
$this->addSql('ALTER TABLE customers_bundle__customer ADD service_code VARCHAR(128) DEFAULT NULL');
$this->addSql('CREATE INDEX service_code ON customers_bundle__customer (service_code)');
}
public function down(Schema $schema): void
{
$this->addSql('DROP INDEX service_code ON customers_bundle__customer');
$this->addSql('ALTER TABLE customers_bundle__customer DROP service_code');
}
}