| 70 |
brianR |
1 |
create table qrtz_triggers(
|
|
|
2 |
sched_name varchar(120) not null,
|
|
|
3 |
trigger_name varchar(200) not null,
|
|
|
4 |
trigger_group varchar(200) not null,
|
|
|
5 |
job_name varchar(200) not null,
|
|
|
6 |
job_group varchar(200) not null,
|
|
|
7 |
description varchar(250),
|
|
|
8 |
next_fire_time bigint,
|
|
|
9 |
prev_fire_time bigint,
|
|
|
10 |
priority integer,
|
|
|
11 |
trigger_state varchar(16) not null,
|
|
|
12 |
trigger_type varchar(8) not null,
|
|
|
13 |
start_time bigint not null,
|
|
|
14 |
end_time bigint,
|
|
|
15 |
calendar_name varchar(200),
|
|
|
16 |
misfire_instr smallint,
|
|
|
17 |
job_data blob,
|
|
|
18 |
primary key (sched_name,trigger_name,trigger_group),
|
|
|
19 |
foreign key (sched_name,job_name,job_group) references qrtz_job_details(sched_name,job_name,job_group)
|
|
|
20 |
)
|