app/DoctrineMigrations/Version20260115000000.php line 1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

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

/**
 * セット商品学校テーブルに購入必須と男女別フィールドを追加
 */
final class Version20260115000000 extends AbstractMigration
{
    public function up(Schema $schema): void
    {
        // dtb_set_product_school テーブルの存在確認
        if ($schema->hasTable('dtb_set_product_school')) {
            $table = $schema->getTable('dtb_set_product_school');

            // セット商品学校テーブルに購入必須（対象、備考）と男女別フィールドを追加
            if (!$table->hasColumn('commodity_type')) {
                $this->addSql('ALTER TABLE dtb_set_product_school ADD commodity_type SMALLINT UNSIGNED DEFAULT NULL COMMENT \'購入必須対象: 0=なし, 1=男性, 2=女性, 3=共通\'');
            }

            if (!$table->hasColumn('commodity_note')) {
                $this->addSql('ALTER TABLE dtb_set_product_school ADD commodity_note TEXT DEFAULT NULL COMMENT \'購入必須備考\'');
            }

            if (!$table->hasColumn('gender_type')) {
                $this->addSql('ALTER TABLE dtb_set_product_school ADD gender_type SMALLINT DEFAULT NULL COMMENT \'男女別: 0=なし, 1=男性, 2=女性, 3=共通\'');
            }
        }
    }

    public function down(Schema $schema): void
    {
        // ロールバック処理: dtb_set_product_school から削除
        if ($schema->hasTable('dtb_set_product_school')) {
            $table = $schema->getTable('dtb_set_product_school');

            if ($table->hasColumn('commodity_type')) {
                $this->addSql('ALTER TABLE dtb_set_product_school DROP commodity_type');
            }

            if ($table->hasColumn('commodity_note')) {
                $this->addSql('ALTER TABLE dtb_set_product_school DROP commodity_note');
            }

            if ($table->hasColumn('gender_type')) {
                $this->addSql('ALTER TABLE dtb_set_product_school DROP gender_type');
            }
        }
    }
}