qimall/addons/Boss/console/migrations/M230703091252QimallAddonsBossPerformanceLog.php

<?php

namespace addons\Boss\console\migrations;

use yii\db\Migration;

/**
 * Class M230703091252QimallAddonsBossPerformanceLog
 */
class M230703091252QimallAddonsBossPerformanceLog extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "CREATE TABLE `qimall_addons_boss_performance_log` (
            `id` int(10) NOT NULL AUTO_INCREMENT,
            `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
            `order_id` int(10) NOT NULL DEFAULT '0' COMMENT '订单ID',
            `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号',
            `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '用户ID',
            `level` tinyint(4) NOT NULL DEFAULT '-1' COMMENT '计算业绩时的股东等级',
            `performance` decimal(10,2) NOT NULL COMMENT '股东团队业绩',
            `order_detail_ids` text COMMENT '参与业绩计算的商品',
            `is_settlement` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否已结算【0否，1是】',
            `date` int(8) NOT NULL DEFAULT '0' COMMENT '数据生成日期',
            `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
            `created_at` int(10) NOT NULL DEFAULT '0',
            `updated_at` int(10) NOT NULL DEFAULT '0',
            PRIMARY KEY (`id`) USING BTREE,
            KEY `mall_id` (`mall_id`) USING BTREE,
            KEY `mall_id+user_id` (`mall_id`,`user_id`) USING BTREE,
            KEY `order_id` (`order_id`) USING BTREE,
            KEY `mall_id+date` (`mall_id`,`date`) USING BTREE
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='股东业绩日志表';";
          $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}