app/DoctrineMigrations/Version20251203100000.php line 1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * mtb_page_maxテーブルのデータを再構築するマイグレーション
 */
final class Version20251203100000 extends AbstractMigration
{
    const NAME = 'mtb_page_max';

    public function up(Schema $schema): void
    {
        if (!$schema->hasTable(self::NAME)) {
            return;
        }

        // 既存データを削除
        $this->addSql("DELETE FROM " . self::NAME);

        // 新規データを挿入
        $this->addSql("INSERT INTO " . self::NAME . " (id, name, sort_no, discriminator_type) VALUES ('10', '10', 0, 'pagemax')");
        $this->addSql("INSERT INTO " . self::NAME . " (id, name, sort_no, discriminator_type) VALUES ('50', '50', 4, 'pagemax')");
        $this->addSql("INSERT INTO " . self::NAME . " (id, name, sort_no, discriminator_type) VALUES ('100', '100', 9, 'pagemax')");
        $this->addSql("INSERT INTO " . self::NAME . " (id, name, sort_no, discriminator_type) VALUES ('200', '200', 20, 'pagemax')");
        $this->addSql("INSERT INTO " . self::NAME . " (id, name, sort_no, discriminator_type) VALUES ('300', '300', 30, 'pagemax')");
        $this->addSql("INSERT INTO " . self::NAME . " (id, name, sort_no, discriminator_type) VALUES ('400', '400', 40, 'pagemax')");
        $this->addSql("INSERT INTO " . self::NAME . " (id, name, sort_no, discriminator_type) VALUES ('500', '500', 50, 'pagemax')");
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
    }
}