From 2689c8fec95018952784bd8d032afb5a194a6616 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期二, 02 九月 2025 00:17:45 +0800
Subject: [PATCH] 增加文件监控
---
doc/sql/mdm/mdm.mysql.all.create.sql | 69 +++++++++++++++++++++++++++++++---
1 files changed, 62 insertions(+), 7 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 538e48d..382c69d 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -23,14 +23,16 @@
`name` varchar(100) NOT NULL COMMENT '鏈哄簥鎻忚堪/鍨嬪彿',
`avatar` varchar(400) DEFAULT NULL COMMENT '鍥剧墖鍦板潃',
`machine_group_code` varchar(255) NOT NULL COMMENT '鎵�灞炴満搴婄粍浠ｇ爜锛�,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_group锛�',
- `machine_spec` varchar(20) DEFAULT NULL COMMENT '鏈哄櫒瑙勬牸:01杞﹀簥/02閾ｅ簥,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_spec锛�',
+ `machine_spec` varchar(40) DEFAULT NULL COMMENT '鏈哄櫒瑙勬牸:01杞﹀簥/02閾ｅ簥,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_spec锛�',
`operator` varchar(100) COMMENT '鎿嶄綔鍛橈紝鏂囨湰褰曞叆',
`owner_dept` bigint DEFAULT NULL COMMENT '鎵�灞炲崟浣�/缁勭粐',
`manufacturer` varchar(100) COMMENT '鐢熶骇鍟�',
`polling_hours` int(11) COMMENT '妫�鏌ョ▼搴忓洖浼犵殑杞鏃堕棿锛堝皬鏃讹級',
`control_system` varchar(20) DEFAULT NULL COMMENT '鎺у埗绯荤粺锛堝鍙戦偅绉戯級锛屽湪涓氬姟瀛楀吀閰嶇疆(key=machine_controll_system)锛屼娇鐢ㄨ嫳鏂囧瓧姣�',
`prog_send_dir` varchar(400) COMMENT '绋嬪簭涓嬪彂鐩綍',
+ `send_dir_expiry_hours` int NOT NULL DEFAULT 8 COMMENT 'send鏂囦欢澶规枃浠舵湁鏁堟湡锛堝皬鏃�)',
`prog_receive_dir` varchar(400) COMMENT '绋嬪簭鍥炰紶鐩綍',
+ `receive_dir_expiry_hours` varchar(255) NOT NULL DEFAULT 8 COMMENT 'receive鏂囦欢澶规枃浠舵湁鏁堟湡锛堝皬鏃讹級',
`prog_temp_dir` varchar(400) COMMENT '绋嬪簭闀挎湡瀛樺偍鐩綍',
`remark` varchar(200) COMMENT '澶囨敞',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬惎鐢紱0绂佺敤',
@@ -71,6 +73,7 @@
`fg` varchar(40) NULL COMMENT '鍓',
`cjjhy` varchar(40) NULL COMMENT '杞﹂棿璁″垝鍛�',
`jhy` varchar(40) NULL COMMENT '璁″垝鍛�',
+ `source` varchar(5) NULL COMMENT '鏁版嵁鏉ユ簮',
update_time datetime null COMMENT '鏇存柊鏃堕棿'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鍕ゅ摬鍒嗗伐琛ㄦ湰鍦颁复鏃惰〃';
@@ -163,10 +166,12 @@
`process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
`craft_edition` varchar(40) DEFAULT NULL COMMENT '宸ヨ壓鐗堟',
`drawing_no_edition` varchar(100) NULL COMMENT '鍥惧彿鐗堟',
- `node_type` varchar(20) DEFAULT NULL COMMENT '鑺傜偣绫诲瀷锛氫笟鍔″瓧鍏稿畾涔�',
`product_model` varchar(100) NULL COMMENT '浜у搧鍨嬪彿',
+ `deviation` varchar(100) NULL COMMENT '鍋忕鍗曞彿',
+
+ `err_msg` varchar(200) NULL COMMENT '閿欒鎴栬�呮彁绀轰俊鎭�',
`process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛屾祦绋嬪彂璧峰悗濉厖',
- `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬垵濮嬪寲锛�2:娴佺▼宸插惎鍔�',
+ `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬垵濮嬪寲锛�2:娴佺▼宸插惎鍔� 3:閲嶅娲惧伐;4锛岄獙璇佸け璐�,5锛氬惎鍔ㄥ紓甯�',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT NULL,
`create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
@@ -414,12 +419,14 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='宸ユ帶缃戠▼搴忚妭鐐�';
-DROP TABLE IF EXISTS `mdm_machine_back_file`;
-CREATE TABLE `mdm_machine_back_file` (
+DROP TABLE IF EXISTS `mdm_machine_accepted_file`;
+CREATE TABLE `mdm_machine_accepted_file` (
`id` bigint NOT NULL,
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
- `confirm_time` datetime DEFAULT NULL COMMENT '纭鏃堕棿',
+ `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+ `export_time` datetime DEFAULT NULL COMMENT '瀵煎嚭鏃堕棿',
`oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
+ `machine_file_id` bigint NOT NULL COMMENT '鏈哄簥鏂囦欢id(mdm_machine_file.id)',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT NULL,
@@ -428,7 +435,7 @@
`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='鏈哄簥鍥炰紶鏂囦欢锛堝凡鎺ュ彈鐨勶級';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥宸叉帴鍙楁枃浠�';
DROP TABLE IF EXISTS `mdm_machine_file`;
CREATE TABLE `mdm_machine_file` (
@@ -442,6 +449,7 @@
`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鏈煡锛�',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT NULL,
@@ -452,3 +460,50 @@
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='宸ユ帶缃戞満搴婃枃浠�';
+
+DROP TABLE IF EXISTS `mdm_machine_file_change_his`;
+CREATE TABLE `mdm_machine_file_change_his` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `oss_name` varchar(100) NOT NULL COMMENT '淇敼鍓峯ss鏂囦欢鍚嶇О锛堟枃浠跺浠斤級',
+ `oss_name_after` varchar(100) NOT NULL COMMENT '淇敼鍚庣殑oss鏂囦欢鍚嶇О',
+ `machine_file_id` bigint DEFAULT NULL COMMENT '淇敼鏂囦欢鐨刬d(mdm_machine_file.id)',
+ `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+ `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='宸ユ帶缃戞満搴婃枃浠朵慨鏀瑰巻鍙�';
+
+
+
+DROP TABLE IF EXISTS `mdm_file_send_record`;
+CREATE TABLE `mdm_file_send_record` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+ `machine_code` varchar(100) DEFAULT NULL COMMENT '鏈哄簥缂栫爜',
+ `file_size` bigint DEFAULT NULL COMMENT '鏂囦欢瀛楄妭鏁�',
+ `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+ `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='宸ユ帶缃戞枃浠朵笅鍙戣褰�';
+
+DROP TABLE IF EXISTS `mdm_file_monitor_record`;
+CREATE TABLE `mdm_file_monitor_record` (
+ `id` bigint NOT NULL,
+ `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+ `dir_path` varchar(100) NOT NULL COMMENT '鏂囦欢鐩綍',
+ `event_type` int DEFAULT NULL COMMENT '浜嬩欢绫诲瀷锛�1:鍒涘缓;2锛氫慨鏀�;3鍒犻櫎',
+ `create_time` datetime 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