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 | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 32638b7..382c69d 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -478,3 +478,32 @@
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