app/DoctrineMigrations/Version20251125000002.php line 1

<?php

declare(strict_types=1);

/*
 * This file is part of EC-CUBE
 *
 * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
 *
 * http://www.ec-cube.co.jp/
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace DoctrineMigrations;

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

/**
 * 学校マスターに採寸情報ページ注意書き表示フラグとテキストを追加
 */
final class Version20251125000002 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        // display_saisun_noticeカラムが存在しない場合のみ追加
        $displaySaisunNoticeExists = $this->connection->fetchOne(
            "SELECT COUNT(*) FROM information_schema.COLUMNS 
             WHERE TABLE_SCHEMA = DATABASE() 
             AND TABLE_NAME = 'dtb_school' 
             AND COLUMN_NAME = 'display_saisun_notice'"
        );
        
        if ($displaySaisunNoticeExists == 0) {
            $this->addSql("ALTER TABLE dtb_school ADD display_saisun_notice BOOLEAN DEFAULT 0 NOT NULL");
        }
        
        // saisun_notice_textカラムが存在しない場合のみ追加
        $saisunNoticeTextExists = $this->connection->fetchOne(
            "SELECT COUNT(*) FROM information_schema.COLUMNS 
             WHERE TABLE_SCHEMA = DATABASE() 
             AND TABLE_NAME = 'dtb_school' 
             AND COLUMN_NAME = 'saisun_notice_text'"
        );
        
        if ($saisunNoticeTextExists == 0) {
            $this->addSql("ALTER TABLE dtb_school ADD saisun_notice_text TEXT DEFAULT NULL");
        }
    }

    public function down(Schema $schema): void
    {
        // display_saisun_noticeカラムが存在する場合のみ削除
        $displaySaisunNoticeExists = $this->connection->fetchOne(
            "SELECT COUNT(*) FROM information_schema.COLUMNS 
             WHERE TABLE_SCHEMA = DATABASE() 
             AND TABLE_NAME = 'dtb_school' 
             AND COLUMN_NAME = 'display_saisun_notice'"
        );
        
        if ($displaySaisunNoticeExists > 0) {
            $this->addSql("ALTER TABLE dtb_school DROP COLUMN display_saisun_notice");
        }
        
        // saisun_notice_textカラムが存在する場合のみ削除
        $saisunNoticeTextExists = $this->connection->fetchOne(
            "SELECT COUNT(*) FROM information_schema.COLUMNS 
             WHERE TABLE_SCHEMA = DATABASE() 
             AND TABLE_NAME = 'dtb_school' 
             AND COLUMN_NAME = 'saisun_notice_text'"
        );
        
        if ($saisunNoticeTextExists > 0) {
            $this->addSql("ALTER TABLE dtb_school DROP COLUMN saisun_notice_text");
        }
    }
}