70 |
brianR |
1 |
create table qrtz_cron_triggers(
|
|
|
2 |
sched_name varchar(120) not null,
|
|
|
3 |
trigger_name varchar(200) not null,
|
|
|
4 |
trigger_group varchar(200) not null,
|
|
|
5 |
cron_expression varchar(120) not null,
|
|
|
6 |
time_zone_id varchar(80),
|
|
|
7 |
primary key (sched_name,trigger_name,trigger_group),
|
|
|
8 |
foreign key (sched_name,trigger_name,trigger_group) references qrtz_triggers(sched_name,trigger_name,trigger_group)
|
|
|
9 |
)
|