qimall/addons/BusinessBonus/console/migrations/M241122093010AlterTableAddonsBusinessBonusUpgradeCondition.php

<?php

namespace addons\BusinessBonus\console\migrations;

use yii\db\Migration;

/**
 * Class M241122092010AlterTableAddonsBusinessBonusUpgradeCondition
 */
class M241122093010AlterTableAddonsBusinessBonusUpgradeCondition extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql = <<<EOF
                ALTER TABLE `qimall_addons_business_bonus_upgrade_condition` 
ADD COLUMN `upgrade_store_goods_list` text NULL COMMENT '门店商品升级条件';
EOF;
            $this->execute($sql);

            $sql2 = <<<EOF
                ALTER TABLE `qimall_addons_business_bonus_upgrade_condition` MODIFY `upgrade_type` tinyint(4) COMMENT '升级方式：0未知，1无条件，2前端申请，3购买指定商品，4后台添加，5后台调整, 6购买门店商品';
EOF;

            $this->execute($sql2);

        } catch (\Exception $e) {

        }

    }

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

        return false;
    }

}