From 6c229bdd8c538ef4990a6c54ecfc081a7e95c923 Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期五, 06 二月 2026 10:04:50 +0800
Subject: [PATCH] 1
---
version/db/new.sql | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/version/db/new.sql b/version/db/new.sql
index 1d792ab..f8396a3 100644
--- a/version/db/new.sql
+++ b/version/db/new.sql
@@ -36,3 +36,30 @@
alter table man_task_log
add uplink_sts varchar(64) null comment '涓婅鐘舵��' after empty_mk;
+
+CREATE TABLE `man_integration_record` (
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `uuid` VARCHAR(255) DEFAULT NULL COMMENT '缂栧彿',
+ `namespace` VARCHAR(255) DEFAULT NULL COMMENT '鍚嶇О绌洪棿(*)',
+ `url` VARCHAR(255) DEFAULT NULL COMMENT '鎺ュ彛鍦板潃',
+ `appkey` VARCHAR(255) DEFAULT NULL COMMENT '骞冲彴瀵嗛挜',
+ `caller` VARCHAR(255) DEFAULT NULL COMMENT '璋冪敤鏂规爣璇�',
+ `direction` int(1) NOT NULL DEFAULT 0 COMMENT '鏂瑰悜{1:琚皟鐢�,2:璋冪敤澶栭儴}',
+ `timestamp` VARCHAR(64) DEFAULT NULL COMMENT '鏃堕棿鎴�',
+ `client_ip` VARCHAR(64) DEFAULT NULL COMMENT '瀹㈡埛绔疘P',
+ `request` TEXT COMMENT '璇锋眰鍐呭',
+ `response` TEXT COMMENT '鍝嶅簲鍐呭',
+ `err` TEXT COMMENT '寮傚父鍐呭',
+ `result` int(1) DEFAULT NULL COMMENT '缁撴灉{1:鎴愬姛,0:澶辫触}',
+ `cost_ms` INT(11) DEFAULT NULL COMMENT '鑰楁椂',
+ `status` int(1) DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
+ `create_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
+ `update_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
+ `memo` VARCHAR(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+update man_loc set comp_direct =2 where comp_direct =0
+
+alter table man_sta
+ add act_dir int(1) null comment '璐у弶鏂瑰悜' after angle;
\ No newline at end of file
--
Gitblit v1.9.1