From a1746c5bcb03b2e7f56bdf269097285e32486f17 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期二, 02 九月 2025 22:48:57 +0800
Subject: [PATCH] 首页零组件号加入防抖处理

---
 doc/sql/mdm/mdm.mysql.all.create.sql |   38 +++++++++++++++++++++++++++++++++++++-
 1 files changed, 37 insertions(+), 1 deletions(-)

diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 48227b7..79c7707 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -423,7 +423,8 @@
 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 '涓氬姟鐘舵��',
@@ -477,3 +478,38 @@
     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='宸ユ帶缃戞枃浠剁洃鎺ц褰�';
+
+DROP TABLE IF EXISTS `mdm_drawing_nos`;
+CREATE TABLE `mdm_drawing_nos` (
+   `drawing_no` varchar(100) NOT NULL COMMENT '闆剁粍浠跺彿',
+   PRIMARY KEY (`drawing_no`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='闆剁粍浠跺彿涓嬫媺鏁版嵁';
+

--
Gitblit v1.9.3