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