app/DoctrineMigrations/Version20251128000000.php line 1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

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

/**
 * 発送ツールテンプレート管理テーブルを追加
 */
final class Version20251128000000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return '発送ツールテンプレート管理テーブル(dtb_shipping_label_template)を追加';
    }

    public function up(Schema $schema): void
    {
        if ($schema->hasTable('dtb_shipping_label_template')) {
            return;
        }

        $table = $schema->createTable('dtb_shipping_label_template');
        $table->addColumn('id', 'integer', ['autoincrement' => true, 'notnull' => true]);
        $table->addColumn('name', 'string', ['length' => 255, 'notnull' => true]);
        $table->addColumn('seal_count_vertical', 'integer', ['notnull' => true]);
        $table->addColumn('seal_count_horizontal', 'integer', ['notnull' => true]);
        $table->addColumn('margin_vertical', 'decimal', ['precision' => 10, 'scale' => 2, 'notnull' => true]);
        $table->addColumn('margin_horizontal', 'decimal', ['precision' => 10, 'scale' => 2, 'notnull' => true]);
        $table->addColumn('seal_spacing_vertical', 'decimal', ['precision' => 10, 'scale' => 2, 'notnull' => true]);
        $table->addColumn('seal_spacing_horizontal', 'decimal', ['precision' => 10, 'scale' => 2, 'notnull' => true]);
        $table->addColumn('items_config', 'text', ['notnull' => false, 'comment' => 'JSON format for items configuration']);
        $table->addColumn('create_date', 'datetime', ['notnull' => true]);
        $table->addColumn('update_date', 'datetime', ['notnull' => true]);
        $table->setPrimaryKey(['id']);
    }

    public function down(Schema $schema): void
    {
        $schema->dropTable('dtb_shipping_label_template');
    }
}