Added column icon to table sysmaps_hosts. Added table help.

git-svn-id: svn://svn.zabbix.com/trunk@134 97f52cf1-0a1b-0410-bd0e-c28be96e8082

3 files changed, 37 insertions, 3 deletions

diff --git a/create/data/data.sql b/create/data/data.sql
index 522c2517..adbe42b9 100644
--- a/create/data/data.sql
+++ b/create/data/data.sql
@@ -1,4 +1,10 @@
 --
+-- Data for table help
+--
+
+insert into help (helpid,topic,description) values (1,"What is SMTP server ?","... Example help text ...");
+
+--
 -- Data for table config
 --
 
@@ -109,6 +115,10 @@ insert into items_template (itemtemplateid,description,key_,delay)
 	values (44,'POP3 server is running','net[listen_110]', 60);
 insert into items_template (itemtemplateid,description,key_,delay)
 	values (45,'IMAP server is running','net[listen_143]', 60);
+insert into items_template (itemtemplateid,description,key_,delay)
+	values (46,'Checksum of /usr/sbin/sshd','cksum[/usr/sbin/sshd]', 600);
+insert into items_template (itemtemplateid,description,key_,delay)
+	values (47,'Checksum of /usr/bin/ssh','cksum[/usr/bin/ssh]', 600);
 
 --
 -- Data for table triggers_template
@@ -172,3 +182,7 @@ insert into triggers_template (triggertemplateid,itemtemplateid,description,expr
 	values (44,44,'POP3 server is down on %s','{:.last(0)}<1');
 insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
 	values (45,45,'IMAP server is down on %s','{:.last(0)}<1');
+insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
+	values (46,46,'/usr/sbin/sshd has been changed on server %s','{:.diff(0)}>0');
+insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
+	values (47,47,'/usr/bin/shd has been changed on server %s','{:.diff(0)}>0');
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql
index 0f73f6b9..57ed174f 100644
--- a/create/mysql/schema.sql
+++ b/create/mysql/schema.sql
@@ -1,4 +1,15 @@
 #
+# Table structure for table 'help'
+#
+
+CREATE TABLE help (
+  helpid		int(4)		NOT NULL auto_increment,
+  topic			varchar(128)	DEFAULT '' NOT NULL,
+  description		text		DEFAULT '' NOT NULL,
+  PRIMARY KEY (helpid)
+);
+
+#
 # Table structure for table 'graphs_items'
 #
 
@@ -9,7 +20,6 @@ CREATE TABLE graphs_items (
   color			varchar(32)	DEFAULT 'Dark Green' NOT NULL,
   PRIMARY KEY (gitemid)
 );
-# Foreign keys
 
 #
 # Table structure for table 'graphs'
@@ -23,7 +33,6 @@ CREATE TABLE graphs (
   PRIMARY KEY (graphid),
   UNIQUE (name)
 );
-# Foreign keys
 
 #
 # Table structure for table 'sysmaps_links'
@@ -36,7 +45,6 @@ CREATE TABLE sysmaps_links (
   shostid2		int(4)		DEFAULT '0' NOT NULL,
   PRIMARY KEY (linkid)
 );
-# Foreign keys
 
 #
 # Table structure for table 'sysmaps_hosts'
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index b170fad0..5ca0d532 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -1,6 +1,18 @@
 \connect zabbix
 
 --
+-- Table structure for table 'help'
+--
+
+CREATE TABLE help (
+  helpid	serial,
+  topic		varchar(128)	DEFAULT '' NOT NULL,
+  description	text		DEFAULT '' NOT NULL,
+  PRIMARY KEY (helpid)
+);
+
+
+--
 -- Table structure for table 'hosts'
 --