-- ===================================================================== -- 蓝羽纸业:清空员工信息与用户管理(保留 admin 与所有配置类数据) -- -- 执行前提:已用 CREATE TABLE *_bak20261104 AS SELECT 全量备份 22 张表 -- -- 清理范围: -- A. HR 员工级业务数据(18 张表全清) -- B. 系统用户(保留 admin id=1)、用户角色/岗位关联、站内信、登录令牌 -- -- 保留不动: -- - HR 配置类:考勤规则、节假日、请假类型、薪资结构、班次、社保方案、税率 -- - 系统基础:部门、角色、菜单、字典 -- - 其他模块业务单据:crm_*/erp_*/mes_* 等(其负责人字段会变为孤立引用) -- ===================================================================== -- 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,id=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;