<?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 Version20220427085050 extends AbstractMigration
{
public function getDescription(): string
{
return 'FIX onDelete CASCADE or SET NULL';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
ini_set('memory_limit', '-1');
$this->addSql('ALTER TABLE calendrier_commentaire DROP FOREIGN KEY FK_8488C62B58AFC4DE');
$this->addSql('ALTER TABLE calendrier_commentaire DROP FOREIGN KEY FK_8488C62B650E4B6D');
$this->addSql('ALTER TABLE calendrier_commentaire ADD CONSTRAINT FK_8488C62B58AFC4DE FOREIGN KEY (league_id) REFERENCES ligue (idligue) ON DELETE CASCADE');
$this->addSql('ALTER TABLE calendrier_commentaire ADD CONSTRAINT FK_8488C62B650E4B6D FOREIGN KEY (idsaison_calendrier_commentaire) REFERENCES saison (idsaison) ON DELETE CASCADE');
$this->addSql('ALTER TABLE equipe DROP FOREIGN KEY FK_2449BA1541859289');
$this->addSql('ALTER TABLE equipe DROP FOREIGN KEY FK_2449BA15F9E70E51');
$this->addSql('ALTER TABLE equipe ADD CONSTRAINT FK_2449BA1541859289 FOREIGN KEY (division_id) REFERENCES equipe_division (iddivision) ON DELETE SET NULL');
$this->addSql('ALTER TABLE equipe ADD CONSTRAINT FK_2449BA15F9E70E51 FOREIGN KEY (idniveau_equipe) REFERENCES equipe_niveau (idniveau) ON DELETE SET NULL');
$this->addSql('ALTER TABLE equipe_information DROP FOREIGN KEY FK_E3E9E95358AFC4DE');
$this->addSql('ALTER TABLE equipe_information DROP FOREIGN KEY FK_E3E9E953382FD7AB');
$this->addSql('ALTER TABLE equipe_information ADD CONSTRAINT FK_E3E9E95358AFC4DE FOREIGN KEY (league_id) REFERENCES ligue (idligue) ON DELETE CASCADE');
$this->addSql('ALTER TABLE equipe_information ADD CONSTRAINT FK_E3E9E953382FD7AB FOREIGN KEY (idsaison_equipe_information) REFERENCES saison (idsaison) ON DELETE CASCADE');
$this->addSql('ALTER TABLE equipe_nom DROP FOREIGN KEY FK_5FE4CDECF976DC32');
$this->addSql('ALTER TABLE equipe_nom ADD CONSTRAINT FK_93B380B9F976DC32 FOREIGN KEY (idsaison_equipeNom) REFERENCES saison (idsaison) ON DELETE CASCADE');
$this->addSql('ALTER TABLE ligue DROP FOREIGN KEY FK_FEC6101938D17818');
$this->addSql('ALTER TABLE ligue ADD CONSTRAINT FK_FEC6101938D17818 FOREIGN KEY (idpays_ligue) REFERENCES pays (idpays) ON DELETE SET NULL');
$this->addSql('ALTER TABLE `match` DROP FOREIGN KEY FK_7A5BC5056959745C');
$this->addSql('ALTER TABLE `match` ADD CONSTRAINT FK_7A5BC5056959745C FOREIGN KEY (idgroupe_match) REFERENCES groupe (idgroupe) ON DELETE SET NULL');
$this->addSql('ALTER TABLE roster DROP FOREIGN KEY FK_60B9ADF9296CD8AE');
$this->addSql('ALTER TABLE roster DROP FOREIGN KEY FK_60B9ADF999E6F5DF');
$this->addSql('ALTER TABLE roster DROP FOREIGN KEY FK_60B9ADF9B69D9EAA');
$this->addSql('ALTER TABLE roster ADD CONSTRAINT FK_60B9ADF9296CD8AE FOREIGN KEY (team_id) REFERENCES equipe (idequipe) ON DELETE CASCADE');
$this->addSql('ALTER TABLE roster ADD CONSTRAINT FK_60B9ADF999E6F5DF FOREIGN KEY (player_id) REFERENCES joueur (idjoueur) ON DELETE CASCADE');
$this->addSql('ALTER TABLE roster ADD CONSTRAINT FK_60B9ADF9B69D9EAA FOREIGN KEY (idsaison_roster) REFERENCES saison (idsaison) ON DELETE CASCADE');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E812182296CD8AE');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E8121826F4C4C40');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E812182E48FD905');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E81218258AFC4DE');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E81218299E6F5DF');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E812182296CD8AE FOREIGN KEY (team_id) REFERENCES equipe (idequipe) ON DELETE CASCADE');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E8121826F4C4C40 FOREIGN KEY (idsaison_stajournee) REFERENCES saison (idsaison) ON DELETE CASCADE');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E812182E48FD905 FOREIGN KEY (game_id) REFERENCES `match` (idmatch) ON DELETE CASCADE');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E81218258AFC4DE FOREIGN KEY (league_id) REFERENCES ligue (idligue) ON DELETE CASCADE');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E81218299E6F5DF FOREIGN KEY (player_id) REFERENCES joueur (idjoueur) ON DELETE CASCADE');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE calendrier_commentaire DROP FOREIGN KEY FK_8488C62B58AFC4DE');
$this->addSql('ALTER TABLE calendrier_commentaire DROP FOREIGN KEY FK_8488C62B650E4B6D');
$this->addSql('ALTER TABLE calendrier_commentaire ADD CONSTRAINT FK_8488C62B58AFC4DE FOREIGN KEY (league_id) REFERENCES ligue (idligue)');
$this->addSql('ALTER TABLE calendrier_commentaire ADD CONSTRAINT FK_8488C62B650E4B6D FOREIGN KEY (idsaison_calendrier_commentaire) REFERENCES saison (idsaison)');
$this->addSql('ALTER TABLE equipe DROP FOREIGN KEY FK_2449BA1541859289');
$this->addSql('ALTER TABLE equipe DROP FOREIGN KEY FK_2449BA15F9E70E51');
$this->addSql('ALTER TABLE equipe ADD CONSTRAINT FK_2449BA1541859289 FOREIGN KEY (division_id) REFERENCES equipe_division (iddivision)');
$this->addSql('ALTER TABLE equipe ADD CONSTRAINT FK_2449BA15F9E70E51 FOREIGN KEY (idniveau_equipe) REFERENCES equipe_niveau (idniveau)');
$this->addSql('ALTER TABLE equipe_information DROP FOREIGN KEY FK_E3E9E95358AFC4DE');
$this->addSql('ALTER TABLE equipe_information DROP FOREIGN KEY FK_E3E9E953382FD7AB');
$this->addSql('ALTER TABLE equipe_information ADD CONSTRAINT FK_E3E9E95358AFC4DE FOREIGN KEY (league_id) REFERENCES ligue (idligue)');
$this->addSql('ALTER TABLE equipe_information ADD CONSTRAINT FK_E3E9E953382FD7AB FOREIGN KEY (idsaison_equipe_information) REFERENCES saison (idsaison)');
$this->addSql('ALTER TABLE equipe_nom DROP FOREIGN KEY FK_93B380B9F976DC32');
$this->addSql('ALTER TABLE equipe_nom ADD CONSTRAINT FK_5FE4CDECF976DC32 FOREIGN KEY (idsaison_equipeNom) REFERENCES saison (idsaison)');
$this->addSql('ALTER TABLE ligue DROP FOREIGN KEY FK_FEC6101938D17818');
$this->addSql('ALTER TABLE ligue ADD CONSTRAINT FK_FEC6101938D17818 FOREIGN KEY (idpays_ligue) REFERENCES pays (idpays)');
$this->addSql('ALTER TABLE `match` DROP FOREIGN KEY FK_7A5BC5056959745C');
$this->addSql('ALTER TABLE `match` ADD CONSTRAINT FK_7A5BC5056959745C FOREIGN KEY (idgroupe_match) REFERENCES groupe (idgroupe)');
$this->addSql('ALTER TABLE roster DROP FOREIGN KEY FK_60B9ADF999E6F5DF');
$this->addSql('ALTER TABLE roster DROP FOREIGN KEY FK_60B9ADF9B69D9EAA');
$this->addSql('ALTER TABLE roster DROP FOREIGN KEY FK_60B9ADF9296CD8AE');
$this->addSql('ALTER TABLE roster ADD CONSTRAINT FK_60B9ADF999E6F5DF FOREIGN KEY (player_id) REFERENCES joueur (idjoueur)');
$this->addSql('ALTER TABLE roster ADD CONSTRAINT FK_60B9ADF9B69D9EAA FOREIGN KEY (idsaison_roster) REFERENCES saison (idsaison)');
$this->addSql('ALTER TABLE roster ADD CONSTRAINT FK_60B9ADF9296CD8AE FOREIGN KEY (team_id) REFERENCES equipe (idequipe)');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E81218299E6F5DF');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E8121826F4C4C40');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E81218258AFC4DE');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E812182296CD8AE');
$this->addSql('ALTER TABLE stajournee DROP FOREIGN KEY FK_E812182E48FD905');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E81218299E6F5DF FOREIGN KEY (player_id) REFERENCES joueur (idjoueur)');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E8121826F4C4C40 FOREIGN KEY (idsaison_stajournee) REFERENCES saison (idsaison)');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E81218258AFC4DE FOREIGN KEY (league_id) REFERENCES ligue (idligue)');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E812182296CD8AE FOREIGN KEY (team_id) REFERENCES equipe (idequipe)');
$this->addSql('ALTER TABLE stajournee ADD CONSTRAINT FK_E812182E48FD905 FOREIGN KEY (game_id) REFERENCES `match` (idmatch)');
}
}