From 9c483e9be881783af14ad68906e78ee557005eb4 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期六, 16 八月 2025 22:01:45 +0800
Subject: [PATCH] 修复dnc导出无header问题
---
doc/sql/mdm/mdm.mysql.all.create.sql | 104 ++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 85 insertions(+), 19 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 4d79bc8..7ea64e4 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -29,8 +29,9 @@
`manufacturer` varchar(100) COMMENT '鐢熶骇鍟�',
`polling_hours` int(11) COMMENT '妫�鏌ョ▼搴忓洖浼犵殑杞鏃堕棿锛堝皬鏃讹級',
`control_system` varchar(20) DEFAULT NULL COMMENT '鎺у埗绯荤粺锛堝鍙戦偅绉戯級锛屽湪涓氬姟瀛楀吀閰嶇疆(key=machine_controll_system)锛屼娇鐢ㄨ嫳鏂囧瓧姣�',
- `prog_send_dir` varchar(100) COMMENT '绋嬪簭涓嬪彂鐩綍',
- `prog_receive_dir` varchar(100) COMMENT '绋嬪簭鍥炰紶鐩綍',
+ `prog_send_dir` varchar(400) COMMENT '绋嬪簭涓嬪彂鐩綍',
+ `prog_receive_dir` varchar(400) COMMENT '绋嬪簭鍥炰紶鐩綍',
+ `prog_temp_dir` varchar(400) COMMENT '绋嬪簭闀挎湡瀛樺偍鐩綍',
`remark` varchar(200) COMMENT '澶囨敞',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬惎鐢紱0绂佺敤',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -140,6 +141,7 @@
`program_no` varchar(20) NULL COMMENT '绋嬪簭缂栧彿,鍙湁绋嬪簭鍖呭悕鑺傜偣鎵嶆湁鍊�',
`flow_program_file_id` bigint NULL COMMENT '鍏宠仈鐨勬祦绋嬬▼搴忔枃浠秈d锛岀▼搴忔枃浠剁被鍨嬬殑鑺傜偣鎵嶆湁鍊�',
`process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛岀▼搴忓寘 绫诲瀷鐨勮妭鐐规墠鏈夊��',
+ `deviation` varchar(100) NULL COMMENT '鍋忕鍗曞彿',
`version_number` int DEFAULT NULL COMMENT '鐗堟湰鍙�',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -234,6 +236,26 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='娴佺▼绋嬪簭鏂囦欢';
+DROP TABLE IF EXISTS `mdm_replace_program_file`;
+CREATE TABLE `mdm_replace_program_file` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `process_instance_id` varchar(64) NOT NULL COMMENT '娴佺▼瀹炰緥id',
+ `name` varchar(100) DEFAULT NULL COMMENT '鏂囦欢鍚�',
+ `program_name` varchar(100) DEFAULT NULL COMMENT '绋嬪簭鍚�/绋嬪簭鍖呭悕',
+ `oss_name` varchar(400) DEFAULT NULL COMMENT 'oss鏂囦欢鍚�',
+ `temp_id` bigint NULL,
+ `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_process_prog_ref`;
CREATE TABLE `mdm_process_prog_ref` (
@@ -286,6 +308,7 @@
`id` bigint NOT NULL,
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
`nc_node_id` bigint NOT NULL COMMENT '绋嬪簭鍖呭悕瀵瑰簲鐨刵odeid',
+ `title` varchar(200) NOT NULL COMMENT '娴佺▼鏍囬',
`program_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -316,24 +339,7 @@
PRIMARY KEY (`id`) USING BTREE
) 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` (
- `id` bigint NOT NULL,
- `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
- `nc_program_id` bigint NOT NULL COMMENT '绋嬪簭缂栫爜',
- `confirm_time` datetime DEFAULT NULL COMMENT '纭鏃堕棿',
- `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
- `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_dnc_back_file`;
CREATE TABLE `mdm_dnc_back_file` (
@@ -363,3 +369,63 @@
`lock_time` datetime DEFAULT NULL COMMENT '閿佸畾鏃堕棿',
PRIMARY KEY (`lock_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏂囦欢鐩戞帶閿佸畾琛�';
+
+
+
+DROP TABLE IF EXISTS `mdm_program_node`;
+CREATE TABLE `mdm_program_node` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `name` varchar(100) NOT NULL COMMENT '鑺傜偣鍚嶇О',
+ `parent_id` bigint DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID',
+ `parent_ids` varchar(200) DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID闆嗗悎锛宨d閫楀彿鍒嗛殧',
+ `node_type` varchar(20) DEFAULT NULL COMMENT '10:鏅�氳妭鐐癸紙鏈烘瀯锛屾満搴婏級锛�60锛氱▼搴忓寘锛�70锛氱▼搴忔枃浠�',
+ `program_file_id` bigint NULL COMMENT '鍏宠仈鐨勬祦绋嬬▼搴忔枃浠秈d锛岀▼搴忔枃浠剁被鍨嬬殑鑺傜偣鎵嶆湁鍊�',
+
+ `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_machine_back_file`;
+CREATE TABLE `mdm_machine_back_file` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `confirm_time` datetime DEFAULT NULL COMMENT '纭鏃堕棿',
+ `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
+ `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_machine_file`;
+CREATE TABLE `mdm_machine_file` (
+ `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',
+ `machine_code` varchar(100) DEFAULT NULL COMMENT '鏈哄簥缂栫爜',
+ `file_create_time` datetime DEFAULT NULL COMMENT '鏂囦欢鍒涘缓鏃堕棿',
+ `file_modify_date` datetime DEFAULT NULL COMMENT '鏂囦欢鍒涘缓鏃堕棿',
+ `md5` varchar(32) DEFAULT NULL COMMENT 'md5 hex',
+ `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='宸ユ帶缃戞満搴婃枃浠�';
--
Gitblit v1.9.3