qimall/console/migrations/M241120171232AddTablePaymentTradeItemRefund.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M241120171232AddTablePaymentTradeItemRefund
 */
class M241120171232AddTablePaymentTradeItemRefund extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
        CREATE TABLE `qimall_payment_trade_item_refund` (
            `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
            `mall_id` int(10) NOT NULL,
            `trade_id` int(10) unsigned NOT NULL COMMENT '支付流水ID',
            `item_id` int(10) NOT NULL COMMENT '组合支付ID',
            `refund_id` int(10) NOT NULL COMMENT '售后订单ID',
            `refund_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '售后金额',
            `refund_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '售后状态',
            `pay_mode` tinyint(1) NOT NULL COMMENT '支付模式',
            `pay_type` tinyint(4) NOT NULL COMMENT '支付类型',
            `refund_at` int(10) DEFAULT '0' COMMENT '售后时间',
            `updated_at` int(10) DEFAULT NULL,
            `created_at` int(10) DEFAULT NULL,
            PRIMARY KEY (`id`)
        ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='组合支付售后表';
SQL;
        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        return false;
    }
}