From 9914a035650ffb324655e1187f1bc822e4823b64 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
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 

