From bbb2718178dcbc2908263926ffa0d8ebe7aef34d Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期六, 02 八月 2025 17:56:05 +0800
Subject: [PATCH] 修复编译错误
---
doc/sql/mdm/mdm.mysql.all.create.sql | 16 +++++++---------
1 files changed, 7 insertions(+), 9 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 3bf9113..f1fb379 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -59,7 +59,7 @@
DROP TABLE IF EXISTS `mdm_qinzhe_fgb`;
CREATE TABLE `mdm_qinzhe_fgb` (
- `cph` varchar(40) NULL COMMENT '浜у搧鍙�',
+ `cph` varchar(80) NULL COMMENT '浜у搧鍙�',
`ljh` varchar(80) NULL COMMENT '闆朵欢鍙�',
`ljmc` varchar(100) NULL COMMENT '闆朵欢鍚嶇О',
`zz` varchar(40) NULL COMMENT '涓诲埗',
@@ -96,12 +96,11 @@
DROP TABLE IF EXISTS `mdm_produce_division`;
CREATE TABLE `mdm_produce_division` (
`id` bigint NOT NULL,
- `drawing_no` varchar(100) NULL COMMENT '鍥惧彿锛岄浂缁勪欢鍙�',
- `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 '瀹℃壒楂樺笀璐﹀彿',
-
+ `drawing_no` varchar(100) Not NULL COMMENT '鍥惧彿锛岄浂缁勪欢鍙�',
+ `team_leader_id` bigint COMMENT '涓撲笟缁勯暱璐﹀彿',
+ `programmer_id` bigint COMMENT '缂栧埗鍛樿处鍙�',
+ `checker_id` bigint COMMENT '鏍″鍛樿处鍙凤紙宸ヨ壓鍛樿鑹诧級',
+ `senior_id` bigint 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 '鍒涘缓鍗曚綅',
@@ -110,8 +109,7 @@
`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
+ PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='涓诲埗鍒嗗伐琛�';
--
Gitblit v1.9.3