Subversion Repositories XServices

Rev

Rev 70 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
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 
)