qimall/console/migrations/M241108110255CreatePaymentTypeRefundStatisticsTable.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Handles the creation of table `{{%payment_type_refund_statistics}}`.
 */
class M241108110255CreatePaymentTypeRefundStatisticsTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
CREATE TABLE `qimall_payment_type_refund_statistics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `payment_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '支付方式',
  `payment_identifier` varchar(255) NOT NULL DEFAULT '' COMMENT '数据唯一性标识符（支付方式加具体的支付方法拼接而成，如果是组合支付则用 , 分割，例如：7|WEIXIN_XCX,16|W06-CASHIER）',
  `trade_type` varchar(100) NOT NULL DEFAULT '' COMMENT '聚合支付具体的支付方式',
  `is_pay_group` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` int(10) unsigned NOT NULL DEFAULT '0',
  `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='统计每种支付方式的退款数据';
SQL;

        $this->execute($sql);
    }

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