Subversion Repositories XServices

Rev

Go to most recent revision | Details | 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
)