From b6c4121c66b811ac56c960ad0f640158351edb8b Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期一, 18 八月 2025 15:00:04 +0800
Subject: [PATCH] 增加log配置
---
doc/sql/mdm/mdm.mysql.all.create.sql | 31 +++++++++++++++++++++++++++----
1 files changed, 27 insertions(+), 4 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 7ea64e4..538e48d 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -99,7 +99,6 @@
DROP TABLE IF EXISTS `mdm_produce_division`;
CREATE TABLE `mdm_produce_division` (
`id` bigint NOT NULL,
- `drawing_no` varchar(100) Not NULL COMMENT '鍥惧彿锛岄浂缁勪欢鍙�',
`team_leader_id` bigint COMMENT '涓撲笟缁勯暱璐﹀彿',
`programmer_id` bigint COMMENT '缂栧埗鍛樿处鍙�',
`checker_id` bigint COMMENT '鏍″鍛樿处鍙凤紙宸ヨ壓鍛樿鑹诧級',
@@ -224,6 +223,7 @@
`name` varchar(100) DEFAULT NULL COMMENT '鏂囦欢鍚�',
`program_name` varchar(100) DEFAULT NULL COMMENT '绋嬪簭鍚�/绋嬪簭鍖呭悕',
`oss_name` varchar(400) DEFAULT NULL COMMENT 'oss鏂囦欢鍚�',
+ `file_type` varchar(10) DEFAULT NULL COMMENT '鏂囦欢绫诲瀷(program/other)',
`is_cured` int DEFAULT 0 COMMENT '鏄惁鍥哄寲鐨�,1鏄�;0鍚︼紝娴佺▼鍙戣捣鏃跺彂鐜板浐鍖栫▼搴忚嚜鍔ㄦ彃鍏ョ殑涓哄浐鍖�1',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -308,6 +308,7 @@
`id` bigint NOT NULL,
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
`nc_node_id` bigint NOT NULL COMMENT '绋嬪簭鍖呭悕瀵瑰簲鐨刵odeid',
+ `programmer_id` bigint NOT NULL COMMENT '缂栫▼鍛樼敤鎴稩D',
`title` varchar(200) NOT NULL COMMENT '娴佺▼鏍囬',
`program_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
@@ -341,8 +342,8 @@
-DROP TABLE IF EXISTS `mdm_dnc_back_file`;
-CREATE TABLE `mdm_dnc_back_file` (
+DROP TABLE IF EXISTS `mdm_dnc_back_fileold`;
+CREATE TABLE `mdm_dnc_back_fileold` (
`id` bigint NOT NULL,
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
`nc_node_id` bigint NOT NULL COMMENT '绋嬪簭鍖呭悕 鑺傜偣id',
@@ -360,6 +361,26 @@
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='DNC鍥炰紶鏂囦欢璁板綍';
+
+
+DROP TABLE IF EXISTS `mdm_dnc_back_file`;
+CREATE TABLE `mdm_dnc_back_file` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `nc_node_id` bigint NOT NULL COMMENT '绋嬪簭鍖呭悕 鑺傜偣id',
+ `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚嶅洖浼犵殑zip鏂囦欢鍚�',
+ `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='DNC鍥炰紶鏂囦欢璁板綍鏂�';
+
DROP TABLE IF EXISTS `mdm_file_locks`;
@@ -417,9 +438,10 @@
`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 '鏂囦欢鍒涘缓鏃堕棿',
+ `file_modify_time` datetime DEFAULT NULL COMMENT '鏂囦欢鍒涘缓鏃堕棿',
`md5` varchar(32) DEFAULT NULL COMMENT 'md5 hex',
`file_size` bigint DEFAULT NULL COMMENT '鏂囦欢瀛楄妭鏁�',
+ `determine_time` datetime DEFAULT NULL COMMENT '鎺ュ彈/鎷掔粷鐨勬椂闂�',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT NULL,
@@ -429,3 +451,4 @@
`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