qimall/addons/Bargain/console/migrations/M250719104109AddBargainBanner.php

<?php

namespace addons\Bargain\console\migrations;

use yii\db\Migration;

/**
 * Class M240326104109AddCloseActiveCrontab
 */
class M250719104109AddBargainBanner extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "
        CREATE TABLE `qimall_addons_bargain_banners` (
          `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
          `mall_id` int(10) unsigned NOT NULL,
          `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序 越大越往前',
          `pic_link` varchar(1000) NOT NULL DEFAULT '' COMMENT '图片跳转链接',
          `pic_path` varchar(255) NOT NULL DEFAULT '' COMMENT '图片保存路径',
          `is_show` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否展示，1：是，0：不是',
          `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '活动状态，1：启用，0：禁用，-1删除',
          `created_at` int(10) unsigned NOT NULL DEFAULT '0',
          `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
          PRIMARY KEY (`id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='轮播图记录表';

        ALTER TABLE `qimall_addons_bargain_active`
            ADD COLUMN `join_limit_user_level` json DEFAULT NULL COMMENT '用户发起砍价参与等级，json格式',
            ADD COLUMN `join_time`  int NOT NULL DEFAULT '0' COMMENT '用户可发起砍价次数',
            ADD COLUMN `is_creator_exempt` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否发起者砍价无限制：0-否，1-是',
            ADD COLUMN `bargain_limit_user_level` json DEFAULT NULL COMMENT '帮砍参与等级，json格式',
            ADD COLUMN `bargain_time` int NOT NULL DEFAULT '0' COMMENT '用户可帮砍次数',
            ADD COLUMN `is_repeat_bargain` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否允许重复帮砍：0-否，1-是',
            ADD COLUMN `introduction` varchar(255) NOT NULL DEFAULT '' COMMENT '聚合页活动规则',
            ADD COLUMN `description` text COMMENT '完整活动规则';
            ";
        $this->execute($sql);
    }

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

        return false;
    }
}