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


1
2
3
4
5
6
7
8
9

CREATE TABLE trends_uint (
        itemid          bigint unsigned         DEFAULT '0'     NOT NULL,
        clock           integer         DEFAULT '0'     NOT NULL,
        num             integer         DEFAULT '0'     NOT NULL,
        value_min               bigint unsigned         DEFAULT '0'     NOT NULL,
        value_avg               bigint unsigned         DEFAULT '0'     NOT NULL,
        value_max               bigint unsigned         DEFAULT '0'     NOT NULL,
        PRIMARY KEY (itemid,clock)
) type=InnoDB;