summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-01-04 09:02:11 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-01-04 09:02:11 +0000
commit5d64930fe2b5ca25c3a7b4ad2182b9cb28a6dad3 (patch)
treee1f40c6ee1fee259770ad1d0c685ca642109124d /create/postgresql/schema.sql
parent0b6fa15a05ae6b3cb0397960022f6587c3263286 (diff)
downloadzabbix-5d64930fe2b5ca25c3a7b4ad2182b9cb28a6dad3.tar.gz
zabbix-5d64930fe2b5ca25c3a7b4ad2182b9cb28a6dad3.tar.xz
zabbix-5d64930fe2b5ca25c3a7b4ad2182b9cb28a6dad3.zip
- added columns color_on,color_off,drawtype_on,drawtype_off to table
sysmaps_links (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@1129 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 675b76b6..d316b4a1 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -369,6 +369,10 @@ CREATE TABLE sysmaps_links (
shostid2 int4 DEFAULT '0' NOT NULL,
-- may be NULL
triggerid int4,
+ drawtype_off int4 DEFAULT '0' NOT NULL,
+ color_off varchar(32) DEFAULT 'Black' NOT NULL,
+ drawtype_on int4 DEFAULT '0' NOT NULL,
+ color_on varchar(32) DEFAULT 'Dark Red' NOT NULL,
PRIMARY KEY (linkid),
FOREIGN KEY (sysmapid) REFERENCES sysmaps,
FOREIGN KEY (shostid1) REFERENCES sysmaps_hosts,