<?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 Version20220331100413 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('DROP TABLE school_school_fee');
$this->addSql('ALTER TABLE admission_info CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE admission_page CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE article CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE article_category CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_course CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_level CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_level_and_course CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_level_item CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE club CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE comment CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE event_school CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL, CHANGE date_event date_event DATETIME NOT NULL');
$this->addSql('ALTER TABLE fee CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE gallery_item CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE infrastructure CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE notification CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL, CHANGE expired_at expired_at DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE open_day CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE page CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE partner ADD phone VARCHAR(255) NOT NULL, CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE phone CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE story CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE team CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE user CHANGE date date DATETIME NOT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE TABLE school_school_fee (school_id INT NOT NULL, school_fee_id INT NOT NULL, INDEX IDX_F4D69EC56F9AD06 (school_fee_id), INDEX IDX_F4D69ECC32A47EE (school_id), PRIMARY KEY(school_id, school_fee_id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
$this->addSql('ALTER TABLE school_school_fee ADD CONSTRAINT FK_F4D69EC56F9AD06 FOREIGN KEY (school_fee_id) REFERENCES school_fee (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE school_school_fee ADD CONSTRAINT FK_F4D69ECC32A47EE FOREIGN KEY (school_id) REFERENCES school (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE admission_info CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE admission_page CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE article CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE article_category CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_course CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_level CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_level_and_course CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE class_level_item CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE club CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE comment CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE event_school CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL, CHANGE date_event date_event DATETIME NOT NULL');
$this->addSql('ALTER TABLE fee CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE gallery_item CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE infrastructure CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE notification CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL, CHANGE expired_at expired_at DATETIME DEFAULT NULL');
$this->addSql('ALTER TABLE open_day CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE page CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE partner DROP phone, CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE phone CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE story CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE team CHANGE date date DATETIME NOT NULL, CHANGE update_at update_at DATETIME NOT NULL');
$this->addSql('ALTER TABLE user CHANGE date date DATETIME NOT NULL');
}
}