upgrades/dbpatches/1.4/mysql/patch/dservices.sql


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

CREATE TABLE dservices (
        dserviceid              bigint unsigned         DEFAULT '0'     NOT NULL,
        dhostid         bigint unsigned         DEFAULT '0'     NOT NULL,
        type            integer         DEFAULT '0'     NOT NULL,
        key_            varchar(255)            DEFAULT '0'     NOT NULL,
        value           varchar(255)            DEFAULT '0'     NOT NULL,
        port            integer         DEFAULT '0'     NOT NULL,
        status          integer         DEFAULT '0'     NOT NULL,
        lastup          integer         DEFAULT '0'     NOT NULL,
        lastdown        integer         DEFAULT '0'     NOT NULL,
        PRIMARY KEY (dserviceid)
) type=InnoDB;