| /xservices/trunk/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/trunk/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/trunk/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/trunk/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/trunk/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/trunk/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/trunk/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/trunk/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/trunk/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/trunk/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/trunk/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) |
| ) |