From 5f2d0f9be3218b07bd7050c34a8e2328a0567856 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@local>
Date: 星期四, 05 十一月 2026 13:22:02 +0800
Subject: [PATCH] chore(lyzy): 清空员工信息与用户管理(保留 admin 与配置类数据)

---
 sql/mysql/lyzy_clear_employee_and_user.sql |   54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 54 insertions(+), 0 deletions(-)

diff --git a/sql/mysql/lyzy_clear_employee_and_user.sql b/sql/mysql/lyzy_clear_employee_and_user.sql
new file mode 100644
index 0000000..76c9870
--- /dev/null
+++ b/sql/mysql/lyzy_clear_employee_and_user.sql
@@ -0,0 +1,54 @@
+-- =====================================================================
+-- 钃濈窘绾镐笟锛氭竻绌哄憳宸ヤ俊鎭笌鐢ㄦ埛绠$悊锛堜繚鐣� admin 涓庢墍鏈夐厤缃被鏁版嵁锛�
+--
+-- 鎵ц鍓嶆彁锛氬凡鐢� CREATE TABLE *_bak20261104 AS SELECT 鍏ㄩ噺澶囦唤 22 寮犺〃
+--
+-- 娓呯悊鑼冨洿锛�
+--   A. HR 鍛樺伐绾т笟鍔℃暟鎹紙18 寮犺〃鍏ㄦ竻锛�
+--   B. 绯荤粺鐢ㄦ埛锛堜繚鐣� admin id=1锛夈�佺敤鎴疯鑹�/宀椾綅鍏宠仈銆佺珯鍐呬俊銆佺櫥褰曚护鐗�
+--
+-- 淇濈暀涓嶅姩锛�
+--   - HR 閰嶇疆绫伙細鑰冨嫟瑙勫垯銆佽妭鍋囨棩銆佽鍋囩被鍨嬨�佽柂璧勭粨鏋勩�佺彮娆°�佺ぞ淇濇柟妗堛�佺◣鐜�
+--   - 绯荤粺鍩虹锛氶儴闂ㄣ�佽鑹层�佽彍鍗曘�佸瓧鍏�
+--   - 鍏朵粬妯″潡涓氬姟鍗曟嵁锛歝rm_*/erp_*/mes_* 绛夛紙鍏惰礋璐d汉瀛楁浼氬彉涓哄绔嬪紩鐢級
+-- =====================================================================
+
+-- A. HR 鍛樺伐绾т笟鍔℃暟鎹紙鍏堝瓙琛紝鍚庝富琛級
+DELETE FROM hrm_salary_payment_detail;
+DELETE FROM hrm_salary_payment;
+DELETE FROM hrm_salary_calculation;
+DELETE FROM hrm_attendance_summary;
+DELETE FROM hrm_attendance_exception;
+DELETE FROM hrm_attendance_record;
+DELETE FROM hrm_overtime_application;
+DELETE FROM hrm_leave_application;
+DELETE FROM hrm_resignation_application;
+DELETE FROM hrm_transfer_application;
+DELETE FROM hrm_employee_work_history;
+DELETE FROM hrm_employee_emergency_contact;
+DELETE FROM hrm_employee_education;
+DELETE FROM hrm_employee_contract;
+DELETE FROM hrm_employee_schedule;
+DELETE FROM hrm_employee_social_security;
+DELETE FROM hrm_employee_salary;
+DELETE FROM hrm_employee;
+
+-- B. 绯荤粺鐢ㄦ埛涓庡叧鑱旓紙淇濈暀 admin锛宨d=1锛�
+DELETE FROM system_user_role WHERE user_id <> 1;
+DELETE FROM system_user_post WHERE user_id <> 1;
+DELETE FROM system_notify_message;
+DELETE FROM system_oauth2_access_token;
+DELETE FROM system_users WHERE id <> 1;
+
+-- 楠岃瘉
+SELECT 'hrm_employee' AS 琛�, COUNT(*) AS 鍓╀綑 FROM hrm_employee
+UNION ALL SELECT 'hrm_employee_salary', COUNT(*) FROM hrm_employee_salary
+UNION ALL SELECT 'hrm_employee_social_security', COUNT(*) FROM hrm_employee_social_security
+UNION ALL SELECT 'hrm_salary_calculation', COUNT(*) FROM hrm_salary_calculation
+UNION ALL SELECT 'hrm_salary_payment', COUNT(*) FROM hrm_salary_payment
+UNION ALL SELECT 'hrm_attendance_record', COUNT(*) FROM hrm_attendance_record
+UNION ALL SELECT 'system_users', COUNT(*) FROM system_users
+UNION ALL SELECT 'system_user_role', COUNT(*) FROM system_user_role
+UNION ALL SELECT 'hrm_attendance_rule', COUNT(*) FROM hrm_attendance_rule
+UNION ALL SELECT 'hrm_salary_structure', COUNT(*) FROM hrm_salary_structure
+UNION ALL SELECT 'system_dept', COUNT(*) FROM system_dept;

--
Gitblit v1.9.3