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 /upgrades/dbpatches/1.0alpha7_to_1.0alpha8 | |
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 'upgrades/dbpatches/1.0alpha7_to_1.0alpha8')
-rw-r--r-- | upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql | 3 | ||||
-rw-r--r-- | upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql | 3 |
2 files changed, 6 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql index c0a1edbf..fc562faa 100644 --- a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql +++ b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql @@ -2,3 +2,6 @@ alter table graphs_items add color varchar(32) DEFAULT 'Dark Green' NOT NULL; alter table sysmaps_hosts add icon varchar(32) DEFAULT 'Server' NOT NULL; alter table alarms add key (triggerid,clock); alter table users modify passwd char(32) default '' not null; + +alter table hosts add useip int1 DEFAULT '0' NOT NULL; +alter table hosts add ip varchar(15) DEFAULT '127.0.0.1' NOT NULL; diff --git a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql index db47d6ec..2d66370f 100644 --- a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql +++ b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql @@ -1,3 +1,6 @@ alter table graphs_items add color varchar(32) DEFAULT 'Dark Green' NOT NULL; alter table sysmaps_hosts add icon varchar(32) DEFAULT 'Server' NOT NULL; create index alarms_trggerid_clock on alarms (triggerid,clock); + +alter table hosts add useip int4 DEFAULT '0' NOT NULL; +alter table hosts add ip varchar(15) DEFAULT '127.0.0.1' NOT NULL; |