From 8d1904686cabb414eff5a2fb22098785a7d0bff0 Mon Sep 17 00:00:00 2001
From: vincentlu <t1341870251@gmail.com>
Date: 星期五, 27 二月 2026 16:33:04 +0800
Subject: [PATCH] #
---
version/db/new.sql | 62 +++++++++++++++++++++++++++++++
1 files changed, 62 insertions(+), 0 deletions(-)
diff --git a/version/db/new.sql b/version/db/new.sql
index df955d1..6602b0b 100644
--- a/version/db/new.sql
+++ b/version/db/new.sql
@@ -29,3 +29,65 @@
alter table man_sta
add outbound_wait int null comment '杩炵画鍑哄簱绛夊緟' after inbound_wait;
+
+
+alter table man_task
+ add uplink_sts varchar(64) null comment '涓婅鐘舵��' after empty_mk;
+
+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;
+
+
+
+
+-- auto-generated definition
+create table man_guarantee
+(
+ id bigint unsigned auto_increment comment 'ID'
+ primary key,
+ uuid varchar(255) null comment '鏍囪瘑',
+ name varchar(255) null comment '鍚嶇О(*)',
+ scope_type varchar(255) null comment '浣滅敤鑼冨洿',
+ scope_value varchar(255) null comment '鑼冨洿鍊�',
+ cron_expr varchar(255) null comment '璋冨害鏃堕棿',
+ required_count int null comment '鐩爣鏁伴噺',
+ min_soc int null comment '鏈�浣庣數閲�',
+ lead_time int null comment '鍑嗗鏃堕棿',
+ status int(1) default 1 not null comment '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
+ deleted int(1) default 0 not null comment '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ tenant_id int null comment '绉熸埛[sys_tenant]',
+ create_by bigint null comment '娣诲姞浜哄憳[sys_user]',
+ create_time timestamp default CURRENT_TIMESTAMP not null comment '娣诲姞鏃堕棿',
+ update_by bigint null comment '淇敼浜哄憳[sys_user]',
+ update_time timestamp default CURRENT_TIMESTAMP null comment '淇敼鏃堕棿',
+ memo varchar(255) null comment '澶囨敞'
+)
+ charset = utf8;
+
--
Gitblit v1.9.1