summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-09-13 13:59:16 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-09-13 13:59:16 +0000
commit6982fb3d2443946171de306f5078925dfaeae359 (patch)
tree704951b6c60210abddd4b1570c70a12e2aa25b9f /create/postgresql/schema.sql
parentf7f74958b31cb3c8009d5946497911bfcf00cac0 (diff)
downloadzabbix-6982fb3d2443946171de306f5078925dfaeae359.tar.gz
zabbix-6982fb3d2443946171de306f5078925dfaeae359.tar.xz
zabbix-6982fb3d2443946171de306f5078925dfaeae359.zip
- different icons depending on a triger status for sysmaps (Alexei)
- added column sysmaps_hosts.icon_on (Alexei) - hierarchial maps (Alexei) - added column sysmaps_hosts.url (Alexei) - upgrades/dbpatches/1.0_to_1.1alpha1/data/images/ (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@1421 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 48be44b0..01f696ae 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -349,6 +349,7 @@ CREATE TABLE sysmaps (
name varchar(128) DEFAULT '' NOT NULL,
width int4 DEFAULT '0' NOT NULL,
height int4 DEFAULT '0' NOT NULL,
+ background varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (sysmapid)
);
@@ -363,9 +364,11 @@ CREATE TABLE sysmaps_hosts (
sysmapid int4 DEFAULT '0' NOT NULL,
hostid int4 DEFAULT '0' NOT NULL,
icon varchar(32) DEFAULT 'Server' NOT NULL,
+ icon_on varchar(32) DEFAULT 'Server' NOT NULL,
label varchar(128) DEFAULT '' NOT NULL,
x int4 DEFAULT '0' NOT NULL,
y int4 DEFAULT '0' NOT NULL,
+ url varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (shostid),
FOREIGN KEY (sysmapid) REFERENCES sysmaps,
FOREIGN KEY (hostid) REFERENCES hosts