qimall/console/migrations/M250325104820AddColumnAddonsNameToAttachment.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M250325104820AddColumnAddonsNameToAttachment
 */
class M250325104820AddColumnAddonsNameToAttachment extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
        SET @dbname = DATABASE();
        SET @tablename = 'qimall_attachment';
        SET @columnname = 'addons_name';
        SET @preparedStatement = (SELECT IF(
            (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
            WHERE TABLE_SCHEMA = @dbname
            AND TABLE_NAME = @tablename
            AND COLUMN_NAME = @columnname) > 0,
            'SELECT 1;',
            CONCAT('ALTER TABLE `', @tablename, '` ADD COLUMN `', @columnname, '` varchar(50) NOT NULL DEFAULT '''' COMMENT ''所属插件'';')
        ));
        PREPARE alterIfNotExists FROM @preparedStatement;
        EXECUTE alterIfNotExists;
        DEALLOCATE PREPARE alterIfNotExists;
SQL;
        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M250325104820AddColumnAddonsNameToAttachment cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M250325104820AddColumnAddonsNameToAttachment cannot be reverted.\n";

        return false;
    }
    */
}