From 9914a035650ffb324655e1187f1bc822e4823b64 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Sun, 1 Jul 2001 11:34:17 +0000 Subject: Hosts displayed in network maps became clickable. git-svn-id: svn://svn.zabbix.com/trunk@118 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/postgresql/schema.sql | 20 ++++++++++++++++++-- 1 file changed, 18 insertions(+), 2 deletions(-) (limited to 'create/postgresql/schema.sql') diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 26a2d46b..c002a55b 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -248,8 +248,24 @@ CREATE TABLE sysmaps_links ( shostid2 int4 DEFAULT '0' NOT NULL, PRIMARY KEY (linkid), FOREIGN KEY (sysmapid) REFERENCES sysmaps, - FOREIGN KEY (shostid1) REFERENCES items, - FOREIGN KEY (shostid2) REFERENCES items + FOREIGN KEY (shostid1) REFERENCES sysmaps_hosts, + FOREIGN KEY (shostid2) REFERENCES sysmaps_hosts +); + +-- +-- Table structure for table 'sysmaps_hosts' +-- + +CREATE TABLE sysmaps_hosts ( + shostid serial, + sysmapid int4 DEFAULT '0' NOT NULL, + hostid int4 DEFAULT '0' NOT NULL, + label varchar(128) DEFAULT '' NOT NULL, + x int4 DEFAULT '0' NOT NULL, + y int4 DEFAULT '0' NOT NULL, + PRIMARY KEY (shostid), + FOREIGN KEY (sysmapid) REFERENCES sysmaps, + FOREIGN KEY (hostid) REFERENCES hosts ); -- -- cgit