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


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

CREATE TABLE proxy_history (
        id              bigint unsigned                 NOT NULL        auto_increment unique,
        host            varchar(64)             DEFAULT ''      NOT NULL,
        key_            varchar(255)            DEFAULT ''      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            DEFAULT ''      NOT NULL,
        PRIMARY KEY (id)
) type=InnoDB;
CREATE INDEX proxy_history_1 on proxy_history (clock);