From 56ea69ddff826c1a7b0cd4ce1d8ed257d9c8ff5f Mon Sep 17 00:00:00 2001 From: hugetoad Date: Fri, 22 Jul 2005 20:50:03 +0000 Subject: Minor changes. git-svn-id: svn://svn.zabbix.com/trunk@1904 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/mysql/schema.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 85eaded7..c81d5e0a 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -691,3 +691,23 @@ CREATE TABLE history_log ( PRIMARY KEY (id), KEY itemidclock (itemid, clock) ) type=InnoDB; + +-- +-- Table structure for table 'hosts_profiles' +-- + +CREATE TABLE hosts_profiles ( + hostid int(4) DEFAULT '0' NOT NULL, + devicetype varchar(64) DEFAULT '' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + os varchar(64) DEFAULT '' NOT NULL, + serialno varchar(64) DEFAULT '' NOT NULL, + tag varchar(64) DEFAULT '' NOT NULL, + macaddress varchar(64) DEFAULT '' NOT NULL, + hardware blob DEFAULT '' NOT NULL, + software blob DEFAULT '' NOT NULL, + contact blob DEFAULT '' NOT NULL, + location blob DEFAULT '' NOT NULL, + notes lob DEFAULT '' NOT NULL, + PRIMARY KEY (hostid) +) type=InnoDB; -- cgit