From a08832337f8de6a53edebbab1fb0b5a3bd1785aa Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期四, 27 八月 2026 17:23:04 +0800
Subject: [PATCH] feat(srm): 供应商准入审核接入协同办公(BPM)
---
sql/mysql/hrm_employee_post_multiselect_deploy.sql | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/hrm_employee_post_multiselect_deploy.sql b/sql/mysql/hrm_employee_post_multiselect_deploy.sql
new file mode 100644
index 0000000..786e944
--- /dev/null
+++ b/sql/mysql/hrm_employee_post_multiselect_deploy.sql
@@ -0,0 +1,20 @@
+-- =============================================
+-- HRM 鍛樺伐鍙拌处宀椾綅澶氶�� - 鏁版嵁搴撳彉鏇存眹鎬昏剼鏈�
+-- 閫傜敤锛歵est / prod 绛夐渶瑕佹墜宸ユ墽琛岀殑鐜
+-- 鍖呭惈锛�
+-- 1. hrm_employee 琛ㄦ柊澧炲矖浣岻D鍒楄〃(post_ids)鍒楋紝骞惰縼绉绘棫 post_id 鏁版嵁
+-- 2. hrm_salary_structure 琛ㄦ柊澧炰紤鎭棩/娉曞畾鑺傚亣鏃ュ姞鐝伐璧勫�嶇巼鍒楋紙淇鍛樺伐缂栬緫椤佃柂閰粨鏋勪笅鎷夋姤閿欙級
+-- 娉ㄦ剰锛歁ySQL 8 鐨� ALTER TABLE ADD COLUMN 涓嶆敮鎸� IF NOT EXISTS锛�
+-- 鑻ユ煇鍒楀凡瀛樺湪锛屽搴� ALTER 璇彞浼氭姤"Duplicate column"锛屽拷鐣ヨ鏉″嵆鍙户缁��
+-- =============================================
+
+-- ---------- 1. hrm_employee锛氭柊澧炲矖浣岻D鍒楄〃(JSON)锛屽苟杩佺Щ鏃� post_id ----------
+ALTER TABLE `hrm_employee` ADD COLUMN `post_ids` varchar(500) DEFAULT NULL COMMENT '宀椾綅ID鍒楄〃锛圝SON鏍煎紡锛�' AFTER `post_id`;
+UPDATE `hrm_employee` SET `post_ids` = CONCAT('[', `post_id`, ']') WHERE `post_id` IS NOT NULL AND (`post_ids` IS NULL OR `post_ids` = '');
+
+-- ---------- 2. hrm_salary_structure锛氭柊澧炰紤鎭棩/娉曞畾鑺傚亣鏃ュ姞鐝�嶇巼 ----------
+ALTER TABLE `hrm_salary_structure` ADD COLUMN `rest_day_overtime_pay_ratio` decimal(4,2) DEFAULT 2.00 COMMENT '浼戞伅鏃ュ姞鐝伐璧勫�嶇巼' AFTER `overtime_pay_ratio`;
+ALTER TABLE `hrm_salary_structure` ADD COLUMN `legal_holiday_overtime_pay_ratio` decimal(4,2) DEFAULT 3.00 COMMENT '娉曞畾鑺傚亣鏃ュ姞鐝伐璧勫�嶇巼' AFTER `rest_day_overtime_pay_ratio`;
+
+-- ---------- 瀹屾垚鎻愮ず ----------
+SELECT 'HRM 鍛樺伐鍙拌处宀椾綅澶氶�夋暟鎹簱鍙樻洿瀹屾垚锛�' AS result;
--
Gitblit v1.9.3