From bee96a1d36c86068cd5a7eb69f4e3294a8123b04 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期五, 03 七月 2026 18:02:55 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_business' into dev_business

---
 docs/sql/mes_pd_init.sql |  160 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 160 insertions(+), 0 deletions(-)

diff --git a/docs/sql/mes_pd_init.sql b/docs/sql/mes_pd_init.sql
new file mode 100644
index 0000000..6289a32
--- /dev/null
+++ b/docs/sql/mes_pd_init.sql
@@ -0,0 +1,160 @@
+-- =============================================
+-- MES 浜у搧璁捐妯″潡 - 鍒濆鍖栬剼鏈�
+-- =============================================
+
+-- ----------------------------
+-- 璁捐椤圭洰
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_project` (
+    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+    `task_code` varchar(64) DEFAULT NULL COMMENT '浠诲姟缂栫爜',
+    `task_name` varchar(255) DEFAULT NULL COMMENT '浠诲姟鍚嶇О',
+    `product_code` varchar(64) DEFAULT NULL COMMENT '浜у搧缂栫爜',
+    `product_name` varchar(255) DEFAULT NULL COMMENT '浜у搧鍚嶇О',
+    `version` varchar(64) DEFAULT NULL COMMENT '鐗堟湰鍙�',
+    `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵�侊紙0=寰呭彂甯� 1=寰呬笂浼� 2=寰呭鏍� 3=寰呭綊妗� 4=宸插綊妗ｏ級',
+    `chief_designer` bigint DEFAULT NULL COMMENT '涓昏璁″笀',
+    `reviewer` bigint DEFAULT NULL COMMENT '瀹℃牳浜�',
+    `plan_finish_time` datetime DEFAULT NULL COMMENT '璁″垝瀹屾垚鏃堕棿',
+    `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+    `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+    `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+    `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+    `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+    PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 璁捐椤圭洰';
+
+-- ----------------------------
+-- 璁捐璧勬枡瀛愯〃
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_document` (
+    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+    `project_id` bigint NOT NULL COMMENT '璁捐椤圭洰ID',
+    `document_type` varchar(64) DEFAULT NULL COMMENT '璧勬枡绫诲瀷',
+    `document_name` varchar(255) DEFAULT NULL COMMENT '璧勬枡鍚嶇О',
+    `document_version` varchar(64) DEFAULT NULL COMMENT '鐗堟湰',
+    `file_name` varchar(255) DEFAULT NULL COMMENT '鏂囦欢鍚�',
+    `upload_user_id` bigint DEFAULT NULL COMMENT '涓婁紶浜�',
+    `upload_time` datetime DEFAULT NULL COMMENT '涓婁紶鏃堕棿',
+    `file_url` varchar(512) DEFAULT NULL COMMENT '鏂囦欢URL锛堥鐣欙級',
+    `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+    `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+    `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+    `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+    `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+    PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 璁捐璧勬枡';
+
+-- ----------------------------
+-- 璧勬枡瀹℃牳琛�
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_document_audit` (
+    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+    `audit_no` varchar(64) DEFAULT NULL COMMENT '瀹℃牳鍗曞彿',
+    `document_id` bigint NOT NULL COMMENT '璧勬枡ID',
+    `document_name` varchar(255) DEFAULT NULL COMMENT '璧勬枡鍚嶇О锛堝啑浣欙級',
+    `document_version` varchar(64) DEFAULT NULL COMMENT '璧勬枡鐗堟湰锛堝啑浣欙級',
+    `reviewer` bigint DEFAULT NULL COMMENT '瀹℃牳浜�',
+    `audit_status` tinyint DEFAULT NULL COMMENT '瀹℃牳鐘舵��',
+    `audit_time` datetime DEFAULT NULL COMMENT '瀹℃牳鏃堕棿',
+    `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+    `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+    `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+    `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+    `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+    PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 璧勬枡瀹℃牳';
+
+-- ----------------------------
+-- 褰掓。鍙拌处
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_archive` (
+    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+    `archive_code` varchar(64) DEFAULT NULL COMMENT '褰掓。缂栧彿',
+    `project_id` bigint NOT NULL COMMENT '璁捐椤圭洰ID',
+    `archiver` bigint DEFAULT NULL COMMENT '褰掓。浜�',
+    `archive_status` tinyint DEFAULT NULL COMMENT '褰掓。鐘舵��',
+    `archive_time` datetime DEFAULT NULL COMMENT '褰掓。鏃堕棿',
+    `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+    `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+    `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+    `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+    `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+    PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 褰掓。鍙拌处';
+
+-- ----------------------------
+-- 瀛楀吀绫诲瀷
+-- ----------------------------
+INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('璁捐椤圭洰鐘舵��', 'mes_pd_project_status', 0, '璁捐椤圭洰鐘舵��', '1', NOW(), '1', NOW(), b'0'),
+('璧勬枡绫诲瀷', 'mes_pd_document_type', 0, '璧勬枡绫诲瀷', '1', NOW(), '1', NOW(), b'0'),
+('璧勬枡瀹℃牳鐘舵��', 'mes_pd_document_audit_status', 0, '璧勬枡瀹℃牳鐘舵��', '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鐘舵��', 'mes_pd_archive_status', 0, '褰掓。鐘舵��', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 瀛楀吀鏁版嵁 - 璁捐椤圭洰鐘舵��
+-- ----------------------------
+INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+(0, '寰呭彂甯�', '0', 'mes_pd_project_status', 0, 'info', '', '', '1', NOW(), '1', NOW(), b'0'),
+(1, '寰呬笂浼�', '1', 'mes_pd_project_status', 0, 'primary', '', '', '1', NOW(), '1', NOW(), b'0'),
+(2, '寰呭鏍�', '2', 'mes_pd_project_status', 0, 'warning', '', '', '1', NOW(), '1', NOW(), b'0'),
+(3, '寰呭綊妗�', '3', 'mes_pd_project_status', 0, 'success', '', '', '1', NOW(), '1', NOW(), b'0'),
+(4, '宸插綊妗�', '4', 'mes_pd_project_status', 0, 'danger', '', '', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 瀛楀吀鏁版嵁 - 璧勬枡瀹℃牳鐘舵��
+-- ----------------------------
+INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+(0, '寰呭鏍�', '0', 'mes_pd_document_audit_status', 0, 'info', '', '', '1', NOW(), '1', NOW(), b'0'),
+(1, '瀹℃牳閫氳繃', '1', 'mes_pd_document_audit_status', 0, 'success', '', '', '1', NOW(), '1', NOW(), b'0'),
+(2, '瀹℃牳涓嶉�氳繃', '2', 'mes_pd_document_audit_status', 0, 'danger', '', '', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 瀛楀吀鏁版嵁 - 褰掓。鐘舵��
+-- ----------------------------
+INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+(0, '寰呭綊妗�', '0', 'mes_pd_archive_status', 0, 'info', '', '', '1', NOW(), '1', NOW(), b'0'),
+(1, '宸插綊妗�', '1', 'mes_pd_archive_status', 0, 'success', '', '', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 鑿滃崟 - 涓�绾х洰褰曪細浜у搧璁捐
+-- 娉ㄦ剰锛歱arent_id 闇�瑕佹牴鎹疄闄匨ES鐖惰彍鍗旾D璋冩暣
+-- ----------------------------
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('浜у搧璁捐', '', 2, 20, 0, 'pd', '', '', 0, '1', NOW(), '1', NOW(), b'0');
+SET @pd_menu_id = LAST_INSERT_ID();
+
+-- 浜岀骇鑿滃崟锛氳璁￠」鐩�
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('璁捐椤圭洰', '', 2, 1, @pd_menu_id, 'project', '', 'mes/pd/project/index', 0, '1', NOW(), '1', NOW(), b'0');
+SET @project_menu_id = LAST_INSERT_ID();
+
+-- 璁捐椤圭洰鎸夐挳鏉冮檺
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('璁捐椤圭洰鏌ヨ', 'mes:pd-project:query', 3, 1, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰鍒涘缓', 'mes:pd-project:create', 3, 2, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰鏇存柊', 'mes:pd-project:update', 3, 3, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰鍒犻櫎', 'mes:pd-project:delete', 3, 4, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰瀵煎嚭', 'mes:pd-project:export', 3, 5, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0');
+
+-- 浜岀骇鑿滃崟锛氬綊妗ｅ彴璐�
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('褰掓。鍙拌处', '', 2, 2, @pd_menu_id, 'archive', '', 'mes/pd/archive/index', 0, '1', NOW(), '1', NOW(), b'0');
+SET @archive_menu_id = LAST_INSERT_ID();
+
+-- 褰掓。鍙拌处鎸夐挳鏉冮檺
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('褰掓。鍙拌处鏌ヨ', 'mes:pd-archive:query', 3, 1, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处鍒涘缓', 'mes:pd-archive:create', 3, 2, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处鏇存柊', 'mes:pd-archive:update', 3, 3, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处鍒犻櫎', 'mes:pd-archive:delete', 3, 4, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处瀵煎嚭', 'mes:pd-archive:export', 3, 5, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0');

--
Gitblit v1.9.3