Subversion Repositories XServices

Rev

Rev 70 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
70 brianR 1 
CREATE TABLE qrtz_simprop_triggers (
2 
    sched_name varchar(120) not null,
3 
    TRIGGER_NAME VARCHAR(200) NOT NULL,
4 
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
5 
    STR_PROP_1 VARCHAR(512),
6 
    STR_PROP_2 VARCHAR(512),
7 
    STR_PROP_3 VARCHAR(512),
8 
    INT_PROP_1 INT,
9 
    INT_PROP_2 INT,
10 
    LONG_PROP_1 BIGINT,
11 
    LONG_PROP_2 BIGINT,
12 
    DEC_PROP_1 NUMERIC(13,4),
13 
    DEC_PROP_2 NUMERIC(13,4),
14 
    BOOL_PROP_1 varchar(5),
15 
    BOOL_PROP_2 varchar(5),
16 
    PRIMARY KEY (sched_name,TRIGGER_NAME,TRIGGER_GROUP),
17 
    FOREIGN KEY (sched_name,TRIGGER_NAME,TRIGGER_GROUP)
18 
    REFERENCES QRTZ_TRIGGERS(sched_name,TRIGGER_NAME,TRIGGER_GROUP)
19 
)