From 4b397a21eb979617f4fe9ff9fc1edb7a1be72900 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期一, 29 九月 2025 17:45:29 +0800
Subject: [PATCH] 工控网涉密网联调
---
doc/sql/mdm/mdm.mysql.all.create.sql | 30 ++++++++++++++++++++++++++++--
1 files changed, 28 insertions(+), 2 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index c73905b..96c91d9 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -350,15 +350,18 @@
`id` bigint NOT NULL,
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
`name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
- `dir_type` varchar(5) DEFAULT NULL COMMENT '鐩綍绫诲瀷锛歋END/REC/TEMP',
+ `dir_type` varchar(10) DEFAULT NULL COMMENT '鐩綍绫诲瀷锛歋END/REC/TEMP',
`machine_code` varchar(100) DEFAULT NULL COMMENT '鏈哄簥缂栫爜',
`file_create_time` datetime DEFAULT NULL COMMENT '鏂囦欢鍒涘缓鏃堕棿',
`file_modify_time` datetime DEFAULT NULL COMMENT '鏂囦欢鍒涘缓鏃堕棿',
`md5` varchar(32) DEFAULT NULL COMMENT 'md5 hex',
`file_size` bigint DEFAULT NULL COMMENT '鏂囦欢瀛楄妭鏁�',
`determine_time` datetime DEFAULT NULL COMMENT '鎺ュ彈/鎷掔粷鐨勬椂闂�',
- `program_status` int DEFAULT NULL COMMENT '绋嬪簭鐘舵�侊紙1璇曞垏锛�2鍥哄寲锛�3鍋忕锛�4鏈煡锛�',
+ `program_status` varchar(10) DEFAULT NULL COMMENT '绋嬪簭鐘舵�侊紙1璇曞垏锛�2鍥哄寲锛�3鍋忕锛�4鏈煡锛�',
`exception_type` int DEFAULT NULL COMMENT 'REC鐩綍鏂囦欢寮傚父绫诲瀷锛�0/null:姝ｅ父; 1闈炴枃鏈牸寮忥紱2:鏂囦欢鍚嶆牸寮忎笉鍚堟硶锛�3:鏂囦欢纭け(娈垫暟涓嶅)锛�4:鏂囦欢娈垫暟涓庝笅鍙戣褰曚笉鍖归厤锛堣溅搴�/鐜板満缂栧埗闄ゅ)',
+ `deviation` varchar(100) DEFAULT NULL COMMENT '涓存椂鏇存敼鍗曞彿',
+ `deviation_serial` varchar(100) DEFAULT NULL COMMENT '涓存椂鏇存敼鍗曞簭鍙�',
+ `oss_name` varchar(100) DEFAULT NULL COMMENT 'oss鏂囦欢鍚嶏紝鐢ㄤ簬program鏂囦欢澶�',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT NULL,
@@ -453,3 +456,26 @@
`update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鍚慚ES鍥炰紶鏁版嵁';
+
+
+DROP TABLE IF EXISTS `mdm_machine_back_task`;
+CREATE TABLE `mdm_machine_back_task` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `program_name` varchar(20) NULL COMMENT '绋嬪簭鍚嶇О',
+ `machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
+ `deviation` varchar(100) NULL COMMENT '涓存椂鏇存敼鍗曞彿',
+ `deviation_serial` varchar(100) NULL COMMENT '涓存椂鏇存敼鍗曞簭鍙�',
+ `seg_count` int NOT NULL DEFAULT 0 COMMENT'绋嬪簭鎬绘鏁�/鐜板満缂栧埗鐨�=0',
+ `task_type` int NULL COMMENT '浠诲姟绫诲埆,1:宸ヨ壓缂栧埗;2鐜板満缂栧埗',
+ `exported_seg_nos` varchar(100) DEFAULT NULL COMMENT '宸插鍑虹殑鏂囦欢搴忓彿鍒楄〃',
+ `finish_time` datetime DEFAULT NULL COMMENT '瀹屾垚鏃堕棿',
+ `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氭湭瀹屾垚锛�2:宸插畬鎴�',
+ `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
+ `is_deleted` int DEFAULT NULL,
+ `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `create_user` bigint DEFAULT NULL COMMENT '鍒涘缓浜�',
+ `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥鍥炰紶浠诲姟琛�';
--
Gitblit v1.9.3