diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-07-01 11:34:17 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-07-01 11:34:17 +0000 |
| commit | 9914a035650ffb324655e1187f1bc822e4823b64 (patch) | |
| tree | d4c7a0010dbc0c8af22a9a49ab28da6720559387 /create/postgresql/schema.sql | |
| parent | d1f643e5097215db8c0e4ac0ba472b5ebc6ba945 (diff) | |
| download | zabbix-9914a035650ffb324655e1187f1bc822e4823b64.tar.gz zabbix-9914a035650ffb324655e1187f1bc822e4823b64.tar.xz zabbix-9914a035650ffb324655e1187f1bc822e4823b64.zip | |
Hosts displayed in network maps became clickable.
git-svn-id: svn://svn.zabbix.com/trunk@118 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 20 |
1 files changed, 18 insertions, 2 deletions
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 ); -- |