qimall/addons/Rebate/console/migrations/M240717142910CreateRebateGoods.php

<?php

namespace addons\Rebate\console\migrations;

use yii\db\Migration;

/**
 * Class M240717142910CreateRebateGoods
 */
class M240717142910CreateRebateGoods extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<CREATETABLE
CREATE TABLE `qimall_addons_rebate_goods`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NOT NULL COMMENT '商城id',
  `is_enable` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否开启',
  `commission_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'commission' COMMENT '\'分佣类型; score积分分佣, commission佣金分佣\'',
  `initiate_type` tinyint(2) NULL DEFAULT 0 COMMENT '发起人权限类型[0:全部;1:新会员;2:等级会员]',
  `initiate_level` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '等级会员json串[initiate_type=2时使用]',
  `consume_type` tinyint(2) NULL DEFAULT 0 COMMENT '参与人权限类型[0:全部;1:新会员;2:等级会员]',
  `consume_level` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '等级会员json串[consume_type=2时使用]',
  `item_id` int(10) NOT NULL DEFAULT 0 COMMENT '活动商品id',
  `item_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'goods' COMMENT '项目类型：商品goods',
  `reward_type` tinyint(2) NOT NULL DEFAULT 1 COMMENT '奖励类型[1:奖励条件;2:阶梯奖励]',
  `reward_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '奖励详情json',
  `is_repeat` tinyint(2) NULL DEFAULT 0 COMMENT '阶梯奖励是否重复奖励[0=否，1=是]',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` bigint(20) NULL DEFAULT NULL,
  `updated_at` bigint(20) NULL DEFAULT NULL,
  `join_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0:平台会员;1:推三返一用户',
  `repeat_setting` tinyint(2) NULL DEFAULT 0 COMMENT '是否开启触发奖励设置[0=否，1=是]',
  `agent_limit_num` int(11) NULL DEFAULT 0 COMMENT '渠道分红订单限制',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id`(`mall_id`) USING BTREE,
  INDEX `item_id`(`item_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '推三返一商品单独设置表' ROW_FORMAT = COMPACT;
CREATETABLE;
        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
    }

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

    }

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

        return false;
    }
    */
}