complaint-system/sql/ry_dm_clean.sql

-- ============================================
-- 达梦数据库清理脚本（COMPLAINT 模式）
-- 用途：删除当前模式下所有业务表（含 QRTZ 表）
-- 注意：仅限开发/测试库使用，生产库严禁执行！
-- ============================================

-- QRTZ 表（按外键依赖顺序，先子后父）
drop table if exists QRTZ_FIRED_TRIGGERS;
drop table if exists QRTZ_PAUSED_TRIGGER_GRPS;
drop table if exists QRTZ_SCHEDULER_STATE;
drop table if exists QRTZ_LOCKS;
drop table if exists QRTZ_SIMPLE_TRIGGERS;
drop table if exists QRTZ_SIMPROP_TRIGGERS;
drop table if exists QRTZ_CRON_TRIGGERS;
drop table if exists QRTZ_BLOB_TRIGGERS;
drop table if exists QRTZ_TRIGGERS;
drop table if exists QRTZ_JOB_DETAILS;
drop table if exists QRTZ_CALENDARS;

-- 若依业务表
drop table if exists gen_table_column;
drop table if exists gen_table;
drop table if exists sys_notice_read;
drop table if exists sys_notice;
drop table if exists sys_job_log;
drop table if exists sys_job;
drop table if exists sys_logininfor;
drop table if exists sys_config;
drop table if exists sys_dict_data;
drop table if exists sys_dict_type;
drop table if exists sys_oper_log;
drop table if exists sys_user_post;
drop table if exists sys_role_dept;
drop table if exists sys_role_menu;
drop table if exists sys_user_role;
drop table if exists sys_menu;
drop table if exists sys_role;
drop table if exists sys_post;
drop table if exists sys_user;
drop table if exists sys_dept;

commit;