-- ============================================================
-- 职业指导服务 - 移除/回滚 SQL (达梦 DM8 适配)
-- 所有表、视图均在 ZJRS_JEECG_BOOT 模式下
-- ============================================================

DROP VIEW IF EXISTS ZJRS_JEECG_BOOT.V_CAREER_GUIDANCE_SERVICE;

DROP TABLE IF EXISTS ZJRS_JEECG_BOOT.CAREER_GUIDANCE_RECORD;
DROP TABLE IF EXISTS ZJRS_JEECG_BOOT.CAREER_GUIDANCE_SERVICE;
DROP TABLE IF EXISTS ZJRS_JEECG_BOOT.CAREER_GUIDANCE_DOCUMENT;
DROP TABLE IF EXISTS ZJRS_JEECG_BOOT.CAREER_GUIDANCE_EXPERT;

DELETE FROM ZJRS_JEECG_BOOT.SYS_ROLE_PERMISSION
WHERE PERMISSION_ID IN ('178060100000003','178060100000031','178060100000032','178060100000033',
                        '178060300000000','178060300000001','178060300000002','178060300000003');
DELETE FROM ZJRS_JEECG_BOOT.SYS_PERMISSION
WHERE ID IN ('178060100000003','178060100000031','178060100000032','178060100000033',
             '178060300000000','178060300000001','178060300000002','178060300000003');