<?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 Version20221205093659 extends AbstractMigration
{
public function getDescription(): string
{
return 'add Group.description, TeamInfo.group and TeamInfo.subGroup';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE equipe_information ADD group_id INT DEFAULT NULL, ADD sub_group_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE equipe_information ADD CONSTRAINT FK_E3E9E953FE54D947 FOREIGN KEY (group_id) REFERENCES groupe (idgroupe) ON DELETE SET NULL');
$this->addSql('ALTER TABLE equipe_information ADD CONSTRAINT FK_E3E9E95344FB371E FOREIGN KEY (sub_group_id) REFERENCES groupe (idgroupe) ON DELETE SET NULL');
$this->addSql('CREATE INDEX IDX_E3E9E953FE54D947 ON equipe_information (group_id)');
$this->addSql('CREATE INDEX IDX_E3E9E95344FB371E ON equipe_information (sub_group_id)');
$this->addSql('ALTER TABLE groupe ADD description LONGTEXT DEFAULT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE equipe_information DROP FOREIGN KEY FK_E3E9E953FE54D947');
$this->addSql('ALTER TABLE equipe_information DROP FOREIGN KEY FK_E3E9E95344FB371E');
$this->addSql('DROP INDEX IDX_E3E9E953FE54D947 ON equipe_information');
$this->addSql('DROP INDEX IDX_E3E9E95344FB371E ON equipe_information');
$this->addSql('ALTER TABLE equipe_information DROP group_id, DROP sub_group_id');
$this->addSql('ALTER TABLE groupe DROP description');
}
}