upgrades/dbpatches/1.6/mysql/patch/escalations.sql


1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE escalations (
        escalationid            bigint unsigned         DEFAULT '0'     NOT NULL,
        actionid                bigint unsigned         DEFAULT '0'     NOT NULL,
        triggerid               bigint unsigned         DEFAULT '0'     NOT NULL,
        eventid         bigint unsigned         DEFAULT '0'     NOT NULL,
        r_eventid               bigint unsigned         DEFAULT '0'     NOT NULL,
        nextcheck               integer         DEFAULT '0'     NOT NULL,
        esc_step                integer         DEFAULT '0'     NOT NULL,
        status          integer         DEFAULT '0'     NOT NULL,
        PRIMARY KEY (escalationid)
) type=InnoDB;
CREATE INDEX escalations_1 on escalations (actionid,triggerid);