qimall/addons/Redpack/console/migrations/M230703103825RedPackV2.php

<?php

namespace addons\Redpack\console\migrations;

use yii\db\Migration;

/**
 * Class M230703103825RedPackV2
 */
class M230703103825RedPackV2 extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->execute("ALTER TABLE `qimall_addons_redpack`
	ADD COLUMN `is_show_red_envelope_num` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '红包总个数/总奖池开关展示' AFTER `updated_at`,
	ADD COLUMN `is_show_invite_button` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '邀请人抢红包是否展示' AFTER `is_show_red_envelope_num`,
	ADD COLUMN `reward_parent_rate` DECIMAL(20,6) UNSIGNED NOT NULL DEFAULT 0 COMMENT '直推上级奖励比例' AFTER `is_show_invite_button`,
	ADD COLUMN `limit_user_level_num` JSON NULL DEFAULT NULL COMMENT '每日抢红包次数' AFTER `reward_parent_rate`,
	ADD COLUMN `is_limit_user_level_num` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否启用等级次数' AFTER `limit_user_level_num`,
    ADD COLUMN `is_show_reward_amount` TINYINT UNSIGNED NOT NULL DEFAULT '1' COMMENT '是否显示以奖励金额' AFTER `is_limit_user_level_num`;");
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}