From 18d9c0bdc04e71cf3903c30c139f59dab744cf3f Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期五, 22 八月 2025 15:09:35 +0800
Subject: [PATCH] 偏离回传 流程改名

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

diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 538e48d..a747ce2 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -30,7 +30,9 @@
   `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='鍕ゅ摬鍒嗗伐琛ㄦ湰鍦颁复鏃惰〃';
 

--
Gitblit v1.9.3