diff options
author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-06-19 06:39:16 +0000 |
---|---|---|
committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-06-19 06:39:16 +0000 |
commit | 4a1028be33431cddaadcc8645e5b78ecb6fe4a16 (patch) | |
tree | 30b1c9bf26be92ccc3b0e9938695c4d91e335940 /create | |
parent | 9b0e385a4c92f2876a4c0a17620c8b3ff75ff8cd (diff) | |
download | zabbix-4a1028be33431cddaadcc8645e5b78ecb6fe4a16.tar.gz zabbix-4a1028be33431cddaadcc8645e5b78ecb6fe4a16.tar.xz zabbix-4a1028be33431cddaadcc8645e5b78ecb6fe4a16.zip |
Added column type for table items.
git-svn-id: svn://svn.zabbix.com/trunk@84 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
-rw-r--r-- | create/mysql/schema.sql | 1 | ||||
-rw-r--r-- | create/postgresql/schema.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index ccd4d132..fd7cef41 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -139,6 +139,7 @@ CREATE TABLE triggers_template ( CREATE TABLE items ( itemid int(4) NOT NULL auto_increment, + type int(4) DEFAULT '0' NOT NULL, hostid int(4) NOT NULL, description varchar(255) DEFAULT '' NOT NULL, key_ varchar(64) DEFAULT '' NOT NULL, diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 50d20dae..e6b489dd 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -20,6 +20,7 @@ CREATE INDEX hosts_status on hosts (status); CREATE TABLE items ( itemid serial, + type int4 NOT NULL, hostid int4 NOT NULL, description varchar(255) DEFAULT '' NOT NULL, key_ varchar(64) DEFAULT '' NOT NULL, |