summaryrefslogtreecommitdiffstats
path: root/sql/quartz-drop.sql
blob: 87b079722e60357c813b962f63a7c7ee2848873e (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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_simprop_triggers;
DROP TABLE IF EXISTS qrtz_simple_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 INDEX IF EXISTS idx_qrtz_j_req_recovery;
DROP INDEX IF EXISTS idx_qrtz_t_next_fire_time;
DROP INDEX IF EXISTS idx_qrtz_t_state;
DROP INDEX IF EXISTS idx_qrtz_t_nft_st;
DROP INDEX IF EXISTS idx_qrtz_ft_trig_name;
DROP INDEX IF EXISTS idx_qrtz_ft_trig_group;
DROP INDEX IF EXISTS idx_qrtz_ft_trig_nm_gp;
DROP INDEX IF EXISTS idx_qrtz_ft_trig_inst_name;
DROP INDEX IF EXISTS idx_qrtz_ft_job_name;
DROP INDEX IF EXISTS idx_qrtz_ft_job_group;
DROP INDEX IF EXISTS idx_qrtz_ft_job_req_recovery;