summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-07-22 20:50:03 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-07-22 20:50:03 +0000
commit56ea69ddff826c1a7b0cd4ce1d8ed257d9c8ff5f (patch)
tree7784c9a5b206ed71b234446937af610b96ae7f7d
parentb78f379fdaad31612d7eb0fa4d4574ac304748a1 (diff)
downloadzabbix-56ea69ddff826c1a7b0cd4ce1d8ed257d9c8ff5f.tar.gz
zabbix-56ea69ddff826c1a7b0cd4ce1d8ed257d9c8ff5f.tar.xz
zabbix-56ea69ddff826c1a7b0cd4ce1d8ed257d9c8ff5f.zip
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@1904 97f52cf1-0a1b-0410-bd0e-c28be96e8082
-rw-r--r--create/mysql/schema.sql20
1 files changed, 20 insertions, 0 deletions
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;