| 70 |
brianR |
1 |
create table qrtz_simple_triggers(
|
|
|
2 |
sched_name varchar(120) not null,
|
|
|
3 |
trigger_name varchar(200) not null,
|
|
|
4 |
trigger_group varchar(200) not null,
|
|
|
5 |
repeat_count bigint not null,
|
|
|
6 |
repeat_interval bigint not null,
|
|
|
7 |
times_triggered bigint not null,
|
|
|
8 |
primary key (sched_name,trigger_name,trigger_group),
|
|
|
9 |
foreign key (sched_name,trigger_name,trigger_group) references qrtz_triggers(sched_name,trigger_name,trigger_group)
|
|
|
10 |
)
|