From dc0fea5a5f163e6bfcf7cb887b741b13d86728c4 Mon Sep 17 00:00:00 2001 From: yangys <y_ys79@sina.com> Date: 星期三, 11 六月 2025 16:50:01 +0800 Subject: [PATCH] 增加dnc导入 --- doc/sql/mdm/mdm.all.create.sql | 26 ++++++++++++++++++++++---- 1 files changed, 22 insertions(+), 4 deletions(-) diff --git a/doc/sql/mdm/mdm.all.create.sql b/doc/sql/mdm/mdm.all.create.sql index fb6d791..27fbbd2 100644 --- a/doc/sql/mdm/mdm.all.create.sql +++ b/doc/sql/mdm/mdm.all.create.sql @@ -11,7 +11,7 @@ `status` int DEFAULT '1' COMMENT '鐘舵��', `is_deleted` int DEFAULT '0' COMMENT '鏄惁宸插垹闄�', PRIMARY KEY (`id`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鏈哄簥缁�'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci COMMENT='鏈哄簥缁�'; CREATE TABLE `mdm_machine` ( @@ -39,8 +39,26 @@ `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥'; +CREATE TABLE `mdm_produce_plan` ( + `id` bigint NOT NULL, + `team_leader_id` bigint NOT NULL COMMENT '涓撲笟缁勯暱璐﹀彿', + `programmer_id` bigint NOT NULL COMMENT '缂栧埗鍛樿处鍙�', + `checker_id` bigint NOT NULL COMMENT '鏍″鍛樿处鍙凤紙宸ヨ壓鍛樿鑹诧級', + `senior_id` bigint NOT NULL COMMENT '瀹℃壒楂樺笀璐﹀彿', + + `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID', + `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��', + `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅', + `is_deleted` int DEFAULT 0, + `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, + UNIQUE KEY `uniqueCheckIndex` (`team_leader_id`,`programmer_id`,`checker_id`,`senior_id`,`is_deleted`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='涓诲埗璁″垝琛�'; CREATE TABLE `mdm_nc_program` ( `id` bigint NOT NULL, @@ -59,7 +77,7 @@ `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�' PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE, -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭'; CREATE TABLE `mdm_task_receive` ( @@ -77,4 +95,4 @@ `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�' PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`name`,`is_deleted`) USING BTREE, -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='浠诲姟鎺ユ敹琛�'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='浠诲姟鎺ユ敹琛�'; -- Gitblit v1.9.3