diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-02 18:55:32 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-02 18:55:32 +0000 |
| commit | 31be0f053d6ce0073e84c8bfc27348cf1a290a61 (patch) | |
| tree | 12c7ecff032eab7b4c36473f3b0265ed06d49bf9 /create/postgresql/schema.sql | |
| parent | 70706618a68f09f7bc1f283dc105dbabbb4c3566 (diff) | |
| download | zabbix-31be0f053d6ce0073e84c8bfc27348cf1a290a61.tar.gz zabbix-31be0f053d6ce0073e84c8bfc27348cf1a290a61.tar.xz zabbix-31be0f053d6ce0073e84c8bfc27348cf1a290a61.zip | |
IP address can be used fro connections to a host.
git-svn-id: svn://svn.zabbix.com/trunk@159 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index c153510c..1b060b7d 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -6,9 +6,11 @@ CREATE TABLE hosts ( hostid serial, - host varchar(64) DEFAULT '' NOT NULL, - port int4 DEFAULT '0' NOT NULL, - status int4 DEFAULT '0' NOT NULL, + host varchar(64) DEFAULT '' NOT NULL, + useip int4 DEFAULT '0' NOT NULL, + ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, + port int4 DEFAULT '0' NOT NULL, + status int4 DEFAULT '0' NOT NULL, PRIMARY KEY (hostid) ); |