qimall/addons/ScoreBonus/console/migrations/M240624091137CreateQimallAddonsScoreBonusCommissionItemSetting.php

<?php

namespace addons\ScoreBonus\console\migrations;

use yii\db\Migration;

/**
 * Class M240624091137CreateQimallAddonsScoreBonusCommissionItemSetting
 */
class M240624091137CreateQimallAddonsScoreBonusCommissionItemSetting extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        // 创建表 qimall_addons_score_bonus_commission_item_setting
        $this->execute("
            CREATE TABLE `qimall_addons_score_bonus_commission_item_setting` (
                `id` int(11) NOT NULL AUTO_INCREMENT,
                `mall_id` int(11) NOT NULL COMMENT '商城ID',
                `is_enable` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否启用带货奖励：0:否;1是',
                `is_alone` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否独立设置：0:否;1是',
                `is_extra` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启额外分红：0:否;1是',
                `item_id` int(11) NOT NULL DEFAULT 0 COMMENT '项目id',
                `item_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '项目类型：商品goods',
                `commission_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '分佣类型：佣金：commission',
                `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
                `created_at` int(11) NOT NULL DEFAULT 0,
                `updated_at` int(11) NOT NULL DEFAULT 0,
                PRIMARY KEY (`id`) USING BTREE,
                INDEX `idx_mall_item_id`(`mall_id`, `item_id`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='积分分红奖励设置';
        ");

        // 创建表 qimall_addons_score_bonus_commission_item_setting_detail
        $this->execute("
            CREATE TABLE `qimall_addons_score_bonus_commission_item_setting_detail` (
                `id` int(11) NOT NULL AUTO_INCREMENT,
                `mall_id` int(11) NOT NULL COMMENT '商城ID',
                `score_bonus_commission_item_setting_id` int(11) NOT NULL,
                `level` int(11) NOT NULL DEFAULT 0,
                `calculate_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '计算方式，1：百分比，2：固定值',
                `value` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '值，calculate_type = 1 时表示百分比（计算时需要 /100）;calculate_type = 2 时表示设置的固定值',
                `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
                `created_at` int(11) NOT NULL DEFAULT 0,
                `updated_at` int(11) NOT NULL DEFAULT 0,
                PRIMARY KEY (`id`) USING BTREE,
                INDEX `idx_m_c_id`(`mall_id`, `score_bonus_commission_item_setting_id`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='积分分红奖励设置详情';
        ");
    }

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

        return false;
    }
}