qimall/addons/HuifuPay/console/migrations/M250708100056CreateHuifupayPayRequestLogTable.php

<?php

namespace addons\HuifuPay\console\migrations;

use yii\db\Migration;

/**
 * Handles the creation of table `{{%huifupay_pay_request_log}}`.
 */
class M250708100056CreateHuifupayPayRequestLogTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
CREATE TABLE `qimall_addons_huifupay_pay_request_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) unsigned NOT NULL DEFAULT '0',
  `url` varchar(2000) NOT NULL DEFAULT '' COMMENT 'url（可能包含get参数）',
  `path` varchar(50) NOT NULL DEFAULT '' COMMENT '请求路径',
  `method` varchar(7) NOT NULL DEFAULT '' COMMENT '请求方式',
  `request_data` json DEFAULT NULL COMMENT '请求数据',
  `response_data` text COMMENT '响应数据',
  `headers` json DEFAULT NULL COMMENT '请求头',
  `http_state_code` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'http 状态码',
  `err_msg` varchar(500) NOT NULL DEFAULT '' COMMENT '错误信息',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `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;
    }
}