Subversion Repositories XServices

Rev

Go to most recent revision | Details | 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
)