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


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE proxy_history (
        id              bigint unsigned                 NOT NULL        auto_increment unique,
        itemid          bigint unsigned         DEFAULT '0'     NOT NULL,
        clock           integer         DEFAULT '0'     NOT NULL,
        timestamp               integer         DEFAULT '0'     NOT NULL,
        source          varchar(64)             DEFAULT ''      NOT NULL,
        severity                integer         DEFAULT '0'     NOT NULL,
        value           text                    NOT NULL,
        PRIMARY KEY (id)
) type=InnoDB;
CREATE INDEX proxy_history_1 on proxy_history (clock);