/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_SCHEDULER_STATE.ddl |
---|
0,0 → 1,8 |
create table qrtz_scheduler_state |
( |
sched_name varchar(120) not null, |
instance_name varchar(200) not null, |
last_checkin_time bigint not null, |
checkin_interval bigint not null, |
primary key (sched_name,instance_name) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_FIRED_TRIGGERS.ddl |
---|
0,0 → 1,15 |
create table qrtz_fired_triggers( |
sched_name varchar(120) not null, |
entry_id varchar(95) not null, |
trigger_name varchar(200) not null, |
trigger_group varchar(200) not null, |
instance_name varchar(200) not null, |
fired_time bigint not null, |
priority integer not null, |
state varchar(16) not null, |
job_name varchar(200), |
job_group varchar(200), |
is_nonconcurrent varchar(5), |
requests_recovery varchar(5), |
primary key (sched_name,entry_id) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_JOB_DETAILS.ddl |
---|
0,0 → 1,13 |
create table qrtz_job_details ( |
sched_name varchar(120) not null, |
job_name varchar(200) not null, |
job_group varchar(200) not null, |
description varchar(250) , |
job_class_name varchar(250) not null, |
is_durable varchar(5) not null, |
is_nonconcurrent varchar(5) not null, |
is_update_data varchar(5) not null, |
requests_recovery varchar(5) not null, |
job_data blob, |
primary key (sched_name,job_name,job_group) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_PAUSED_TRIGGER_GRPS.ddl |
---|
0,0 → 1,6 |
create table qrtz_paused_trigger_grps |
( |
sched_name varchar(120) not null, |
trigger_group varchar(200) not null, |
primary key (sched_name,trigger_group) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_SIMPLE_TRIGGERS.ddl |
---|
0,0 → 1,10 |
create table qrtz_simple_triggers( |
sched_name varchar(120) not null, |
trigger_name varchar(200) not null, |
trigger_group varchar(200) not null, |
repeat_count bigint not null, |
repeat_interval bigint not null, |
times_triggered bigint not null, |
primary key (sched_name,trigger_name,trigger_group), |
foreign key (sched_name,trigger_name,trigger_group) references qrtz_triggers(sched_name,trigger_name,trigger_group) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_SIMPROP_TRIGGERS.ddl |
---|
0,0 → 1,19 |
CREATE TABLE qrtz_simprop_triggers ( |
sched_name varchar(120) not null, |
TRIGGER_NAME VARCHAR(200) NOT NULL, |
TRIGGER_GROUP VARCHAR(200) NOT NULL, |
STR_PROP_1 VARCHAR(512), |
STR_PROP_2 VARCHAR(512), |
STR_PROP_3 VARCHAR(512), |
INT_PROP_1 INT, |
INT_PROP_2 INT, |
LONG_PROP_1 BIGINT, |
LONG_PROP_2 BIGINT, |
DEC_PROP_1 NUMERIC(13,4), |
DEC_PROP_2 NUMERIC(13,4), |
BOOL_PROP_1 varchar(5), |
BOOL_PROP_2 varchar(5), |
PRIMARY KEY (sched_name,TRIGGER_NAME,TRIGGER_GROUP), |
FOREIGN KEY (sched_name,TRIGGER_NAME,TRIGGER_GROUP) |
REFERENCES QRTZ_TRIGGERS(sched_name,TRIGGER_NAME,TRIGGER_GROUP) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_BLOB_TRIGGERS.ddl |
---|
0,0 → 1,8 |
create table qrtz_blob_triggers( |
sched_name varchar(120) not null, |
trigger_name varchar(200) not null, |
trigger_group varchar(200) not null, |
blob_data blob, |
primary key (sched_name,trigger_name,trigger_group), |
foreign key (sched_name,trigger_name,trigger_group) references qrtz_triggers(sched_name,trigger_name,trigger_group) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_TRIGGERS.ddl |
---|
0,0 → 1,20 |
create table qrtz_triggers( |
sched_name varchar(120) not null, |
trigger_name varchar(200) not null, |
trigger_group varchar(200) not null, |
job_name varchar(200) not null, |
job_group varchar(200) not null, |
description varchar(250), |
next_fire_time bigint, |
prev_fire_time bigint, |
priority integer, |
trigger_state varchar(16) not null, |
trigger_type varchar(8) not null, |
start_time bigint not null, |
end_time bigint, |
calendar_name varchar(200), |
misfire_instr smallint, |
job_data blob, |
primary key (sched_name,trigger_name,trigger_group), |
foreign key (sched_name,job_name,job_group) references qrtz_job_details(sched_name,job_name,job_group) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_CRON_TRIGGERS.ddl |
---|
0,0 → 1,9 |
create table qrtz_cron_triggers( |
sched_name varchar(120) not null, |
trigger_name varchar(200) not null, |
trigger_group varchar(200) not null, |
cron_expression varchar(120) not null, |
time_zone_id varchar(80), |
primary key (sched_name,trigger_name,trigger_group), |
foreign key (sched_name,trigger_name,trigger_group) references qrtz_triggers(sched_name,trigger_name,trigger_group) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_LOCKS.ddl |
---|
0,0 → 1,6 |
create table qrtz_locks |
( |
sched_name varchar(120) not null, |
lock_name varchar(40) not null, |
primary key (sched_name,lock_name) |
) |
/xservices/branches/xservices-jre6/web/WEB-INF/data/QRTZ_CALENDARS.ddl |
---|
0,0 → 1,6 |
create table qrtz_calendars( |
sched_name varchar(120) not null, |
calendar_name varchar(200) not null, |
calendar blob not null, |
primary key (sched_name,calendar_name) |
) |