CREATE TABLE `internal_api_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `log_type` varchar(20) NOT NULL COMMENT 'send/receive/callback/error', `source` varchar(10) NOT NULL COMMENT '来源站点编号', `target` varchar(10) NOT NULL COMMENT '目标站点编号', `action` varchar(50) NOT NULL COMMENT '指令action', `request_data` text COMMENT '请求数据JSON', `response_data` text COMMENT '响应数据JSON', `http_code` int(11) DEFAULT '0', `status` varchar(20) DEFAULT 'success' COMMENT 'success/fail/timeout', `error_msg` text COMMENT '错误信息', `created_at` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_log_type` (`log_type`), KEY `idx_source` (`source`), KEY `idx_target` (`target`), KEY `idx_action` (`action`), KEY `idx_status` (`status`), KEY `idx_created_at` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='内部API通信日志';

点击上方文件查看内容

// config/database.php $dbConfig = [ 'host' => '127.0.0.1', 'port' => 3306, 'dbname' => 'cus_xiyun', 'username' => 'cus_xiyun', 'password' => 'sunli1323cus', 'charset' => 'utf8mb4', ];