qimall/addons/GroupBuy/console/migrations/M250822085617RenameGroupBuyActiveTableIsShowCommanderNameToIsShowParticipantNickname.php

<?php

namespace addons\GroupBuy\console\migrations;

use yii\db\Migration;

/**
 * Class M250822085617RenameGroupBuyActiveTableIsShowCommanderNameToIsShowParticipantNickname
 */
class M250822085617RenameGroupBuyActiveTableIsShowCommanderNameToIsShowParticipantNickname extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $findExist = <<<SQL
SHOW COLUMNS FROM qimall_addons_group_buy_active WHERE Field = 'is_show_commander_name'
SQL;
            $result = $this->db->createCommand($findExist)->queryOne();
            // 如果旧列存在，则重命名
            if ($result) {
                $this->execute("ALTER TABLE `qimall_addons_group_buy_active` CHANGE `is_show_commander_name` `is_show_participant_nickname` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示参团人员昵称  0否 1是'");
            }
        }catch (\Exception $e) {}
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        return false;
    }

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

    }

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

        return false;
    }
    */
}