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