E95z6gHR

1-- Thanks to Patrick Lightbody for submitting this...
2--
3-- In your Quartz properties file, you'll need to set 
4-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
5
6drop table if exists qrtz_fired_triggers;
7DROP TABLE if exists QRTZ_PAUSED_TRIGGER_GRPS;
8DROP TABLE if exists QRTZ_SCHEDULER_STATE;
9DROP TABLE if exists QRTZ_LOCKS;
10drop table if exists qrtz_simple_triggers;
11drop table if exists qrtz_cron_triggers;
12drop table if exists qrtz_simprop_triggers;
13DROP TABLE if exists QRTZ_BLOB_TRIGGERS;
14drop table if exists qrtz_triggers;
15drop table if exists qrtz_job_details;
16drop table if exists qrtz_calendars;
17
18CREATE TABLE qrtz_job_details
19  (
20    SCHED_NAME VARCHAR(120) NOT NULL,
21    JOB_NAME  VARCHAR(200) NOT NULL,
22    JOB_GROUP VARCHAR(200) NOT NULL,
23    DESCRIPTION VARCHAR(250) NULL,
24    JOB_CLASS_NAME   VARCHAR(250) NOT NULL, 
25    IS_DURABLE BOOL NOT NULL,
26    IS_NONCONCURRENT BOOL NOT NULL,
27    IS_UPDATE_DATA BOOL NOT NULL,
28    REQUESTS_RECOVERY BOOL NOT NULL,
29    JOB_DATA BYTEA NULL,
30    PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
31);
32
33CREATE TABLE qrtz_triggers
34  (
35    SCHED_NAME VARCHAR(120) NOT NULL,
36    TRIGGER_NAME VARCHAR(200) NOT NULL,
37    TRIGGER_GROUP VARCHAR(200) NOT NULL,
38    JOB_NAME  VARCHAR(200) NOT NULL, 
39    JOB_GROUP VARCHAR(200) NOT NULL,
40    DESCRIPTION VARCHAR(250) NULL,
41    NEXT_FIRE_TIME BIGINT NULL,
42    PREV_FIRE_TIME BIGINT NULL,
43    PRIORITY INTEGER NULL,
44    TRIGGER_STATE VARCHAR(16) NOT NULL,
45    TRIGGER_TYPE VARCHAR(8) NOT NULL,
46    START_TIME BIGINT NOT NULL,
47    END_TIME BIGINT NULL,
48    CALENDAR_NAME VARCHAR(200) NULL,
49    MISFIRE_INSTR SMALLINT NULL,
50    JOB_DATA BYTEA NULL,
51    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
52    FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP) 
53	REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP) 
54);
55
56CREATE TABLE qrtz_simple_triggers
57  (
58    SCHED_NAME VARCHAR(120) NOT NULL,
59    TRIGGER_NAME VARCHAR(200) NOT NULL,
60    TRIGGER_GROUP VARCHAR(200) NOT NULL,
61    REPEAT_COUNT BIGINT NOT NULL,
62    REPEAT_INTERVAL BIGINT NOT NULL,
63    TIMES_TRIGGERED BIGINT NOT NULL,
64    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
65    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
66	REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
67);
68
69CREATE TABLE qrtz_cron_triggers
70  (
71    SCHED_NAME VARCHAR(120) NOT NULL,
72    TRIGGER_NAME VARCHAR(200) NOT NULL,
73    TRIGGER_GROUP VARCHAR(200) NOT NULL,
74    CRON_EXPRESSION VARCHAR(120) NOT NULL,
75    TIME_ZONE_ID VARCHAR(80),
76    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
77    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
78	REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
79);
80
81CREATE TABLE qrtz_simprop_triggers
82  (          
83    SCHED_NAME VARCHAR(120) NOT NULL,
84    TRIGGER_NAME VARCHAR(200) NOT NULL,
85    TRIGGER_GROUP VARCHAR(200) NOT NULL,
86    STR_PROP_1 VARCHAR(512) NULL,
87    STR_PROP_2 VARCHAR(512) NULL,
88    STR_PROP_3 VARCHAR(512) NULL,
89    INT_PROP_1 INT NULL,
90    INT_PROP_2 INT NULL,
91    LONG_PROP_1 BIGINT NULL,
92    LONG_PROP_2 BIGINT NULL,
93    DEC_PROP_1 NUMERIC(13,4) NULL,
94    DEC_PROP_2 NUMERIC(13,4) NULL,
95    BOOL_PROP_1 BOOL NULL,
96    BOOL_PROP_2 BOOL NULL,
97    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
98    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
99    REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
100);
101
102CREATE TABLE qrtz_blob_triggers
103  (
104    SCHED_NAME VARCHAR(120) NOT NULL,
105    TRIGGER_NAME VARCHAR(200) NOT NULL,
106    TRIGGER_GROUP VARCHAR(200) NOT NULL,
107    BLOB_DATA BYTEA NULL,
108    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
109    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
110        REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
111);
112
113CREATE TABLE qrtz_calendars
114  (
115    SCHED_NAME VARCHAR(120) NOT NULL,
116    CALENDAR_NAME  VARCHAR(200) NOT NULL, 
117    CALENDAR BYTEA NOT NULL,
118    PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)
119);
120
121
122CREATE TABLE qrtz_paused_trigger_grps
123  (
124    SCHED_NAME VARCHAR(120) NOT NULL,
125    TRIGGER_GROUP  VARCHAR(200) NOT NULL, 
126    PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)
127);
128
129CREATE TABLE qrtz_fired_triggers 
130  (
131    SCHED_NAME VARCHAR(120) NOT NULL,
132    ENTRY_ID VARCHAR(95) NOT NULL,
133    TRIGGER_NAME VARCHAR(200) NOT NULL,
134    TRIGGER_GROUP VARCHAR(200) NOT NULL,
135    INSTANCE_NAME VARCHAR(200) NOT NULL,
136    FIRED_TIME BIGINT NOT NULL,
137    SCHED_TIME BIGINT NOT NULL,
138    PRIORITY INTEGER NOT NULL,
139    STATE VARCHAR(16) NOT NULL,
140    JOB_NAME VARCHAR(200) NULL,
141    JOB_GROUP VARCHAR(200) NULL,
142    IS_NONCONCURRENT BOOL NULL,
143    REQUESTS_RECOVERY BOOL NULL,
144    PRIMARY KEY (SCHED_NAME,ENTRY_ID)
145);
146
147CREATE TABLE qrtz_scheduler_state 
148  (
149    SCHED_NAME VARCHAR(120) NOT NULL,
150    INSTANCE_NAME VARCHAR(200) NOT NULL,
151    LAST_CHECKIN_TIME BIGINT NOT NULL,
152    CHECKIN_INTERVAL BIGINT NOT NULL,
153    PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)
154);
155
156CREATE TABLE qrtz_locks
157  (
158    SCHED_NAME VARCHAR(120) NOT NULL,
159    LOCK_NAME  VARCHAR(40) NOT NULL, 
160    PRIMARY KEY (SCHED_NAME,LOCK_NAME)
161);
162
163create index idx_qrtz_j_req_recovery on qrtz_job_details(SCHED_NAME,REQUESTS_RECOVERY);
164create index idx_qrtz_j_grp on qrtz_job_details(SCHED_NAME,JOB_GROUP);
165
166create index idx_qrtz_t_j on qrtz_triggers(SCHED_NAME,JOB_NAME,JOB_GROUP);
167create index idx_qrtz_t_jg on qrtz_triggers(SCHED_NAME,JOB_GROUP);
168create index idx_qrtz_t_c on qrtz_triggers(SCHED_NAME,CALENDAR_NAME);
169create index idx_qrtz_t_g on qrtz_triggers(SCHED_NAME,TRIGGER_GROUP);
170create index idx_qrtz_t_state on qrtz_triggers(SCHED_NAME,TRIGGER_STATE);
171create index idx_qrtz_t_n_state on qrtz_triggers(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
172create index idx_qrtz_t_n_g_state on qrtz_triggers(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
173create index idx_qrtz_t_next_fire_time on qrtz_triggers(SCHED_NAME,NEXT_FIRE_TIME);
174create index idx_qrtz_t_nft_st on qrtz_triggers(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);
175create index idx_qrtz_t_nft_misfire on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);
176create index idx_qrtz_t_nft_st_misfire on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);
177create index idx_qrtz_t_nft_st_misfire_grp on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);
178
179create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers(SCHED_NAME,INSTANCE_NAME);
180create index idx_qrtz_ft_inst_job_req_rcvry on qrtz_fired_triggers(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);
181create index idx_qrtz_ft_j_g on qrtz_fired_triggers(SCHED_NAME,JOB_NAME,JOB_GROUP);
182create index idx_qrtz_ft_jg on qrtz_fired_triggers(SCHED_NAME,JOB_GROUP);
183create index idx_qrtz_ft_t_g on qrtz_fired_triggers(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);
184create index idx_qrtz_ft_tg on qrtz_fired_triggers(SCHED_NAME,TRIGGER_GROUP);
185
186
187commit;