qimall/addons/BossWeight/console/migrations/M250919150837AlertQimallAddonsBossWeightRewardOrderLog.php

<?php

namespace addons\BossWeight\console\migrations;

use yii\db\Migration;

/**
 * Class M250919150837AlertQimallAddonsBossWeightRewardOrderLog
 */
class M250919150837AlertQimallAddonsBossWeightRewardOrderLog extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "CREATE TABLE `qimall_addons_boss_weight_reward_order_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 '订单编号',
              `order_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单总支付金额',
              `amounts` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总计算金额',
              `settlement_method` tinyint(1) 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 `order_id` (`order_id`) USING BTREE,
              KEY `mall_id+date` (`mall_id`,`date`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='股东加分红奖励订单记录表';";
        $this->execute($sql);
        $sql = "ALTER TABLE `qimall_addons_boss_weight_reward_log` 
                ADD COLUMN `order_price` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '金额',
                ADD COLUMN `settle_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '结算总金额，单位：元';";
        $this->execute($sql);
        $sql = "ALTER TABLE `qimall_addons_boss_weight_commission_log` 
                ADD COLUMN `order_price` decimal(10,2) NOT NULL COMMENT '订单实付总金额，单位：元',
                ADD COLUMN `settle_price` decimal(10,2) NOT NULL COMMENT '结算总金额，单位：元',
                ADD COLUMN `settlement_config` text COMMENT '结算配置';";
        $this->execute($sql);
    }

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

        return false;
    }

}