EmploymentSite/doc/业务数据清除脚本

-- 清除工作日志与工作任务
DELETE FROM pc_dowork WHERE 1=1;
DELETE FROM pc_dotask_user WHERE 1=1;
DELETE FROM pc_dotask WHERE 1=1;

-- 清除岗位与企业信息
DELETE FROM pc_post WHERE 1=1;
DELETE FROM pc_company WHERE 1=1;

-- 清除求职人员推荐信息库
DELETE FROM pc_recommend_mgt WHERE 1=1;
DELETE FROM pc_recommend WHERE 1=1;

-- 清除求职人员与求职意向基本信息
DELETE FROM pc_jobhunt WHERE 1=1;
DELETE FROM pc_education WHERE 1=1; -- 学历
DELETE FROM pc_experience WHERE 1=1; -- 工作经历
DELETE FROM pc_jobuser WHERE 1=1;

-- 清除运营机构与驿站人员、驿站基本信息
DELETE FROM pc_site_institution WHERE 1=1;
DELETE FROM pc_institution WHERE 1=1;
DELETE FROM pc_site_user WHERE 1=1;
DELETE FROM pc_site WHERE 1=1;

-- 删除用户表只保留admin
-- DELETE FROM sys_log WHERE 1=1;
-- DELETE FROM sys_user_sys_role WHERE UserID != '60ea0d5b-a75c-11ed-a6c5-7085c2a9999e';
-- DELETE FROM sys_user WHERE UserID != '60ea0d5b-a75c-11ed-a6c5-7085c2a9999e';