| 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) |
| ) |