- added housekeeping procedure for table sessions (Alexei)

 - changed width=\"X%\" to width=X% in *.php (Alexei)
 - Status of a trigger will blink if it was changes during last 60
 seconds (Alexei)
 - Zabbix daemons to update triggers.lastchange when triggers.values
 is changed (Alexei)
 - added misc/init.d/debian/zabbix-[suckerd|trapperd] (Alexei)
 - removed misc/init.d/debian/zabbix-server (Alexei)
 - send_email() will timeout after 10 seconds (Alexei)
 - DBadd_alarm() renamed to add_alarm() (Alexei)
 - support for SCO OpenServer (Alexei). Thanks to Alexender Kirhenstein.
 - ./configure will correctly define socklen_t (Alexei)
 - <center> changed to <div align=center> (Alexei)
 - reason of problem in screen IT Services (Alexei)
 - added frontends.php/helpdesk.php (Alexei)
 - added tables: problems, problems_comments,categories (Alexei)
 - added "...#form" to button Change in form Configuration of Users (Alexei)
 - "Just for information" changed to "Information" (Alexei)
 - fixed ./configure to correctly find zlib (Alexei)
 - housekeeping to delete no more than HousekeepingFrequency*3600 records
 from table history and history_str at once (MySQL only) (Alexei)


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

2 files changed, 93 insertions, 1 deletions

diff --git a/upgrades/dbpatches/1.0beta5_to_1.0beta6/mysql/patch.sql b/upgrades/dbpatches/1.0beta5_to_1.0beta6/mysql/patch.sql
index 17a5ba09..6b5c5281 100644
--- a/upgrades/dbpatches/1.0beta5_to_1.0beta6/mysql/patch.sql
+++ b/upgrades/dbpatches/1.0beta5_to_1.0beta6/mysql/patch.sql
@@ -1 +1,47 @@
 alter table functions modify lastvalue varchar(255);
+
+
+--
+-- Table structure for table 'problems'
+--
+
+CREATE TABLE problems (
+  problemid		int(4)		NOT NULL auto_increment,
+  userid		int(4)		DEFAULT '0' NOT NULL,
+  triggerid		int(4),
+  lastupdate		int(4)		DEFAULT '0' NOT NULL,
+  clock			int(4)		DEFAULT '0' NOT NULL,
+  status		int(1)		DEFAULT '0' NOT NULL,
+  description		varchar(255)	DEFAULT '' NOT NULL,
+  categoryid		int(4),
+  priority		int(1)		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (problemid),
+  KEY (status),
+  KEY (categoryid),
+  KEY (priority)
+);
+
+--
+-- Table structure for table 'categories'
+--
+
+CREATE TABLE categories (
+  categoryid		int(4)		NOT NULL auto_increment,
+  descripion		varchar(64)	DEFAULT '' NOT NULL,
+  PRIMARY KEY (categoryid)
+);
+
+--
+-- Table structure for table 'problems_comments'
+--
+
+CREATE TABLE problems_comments (
+  commentid		int(4)		NOT NULL auto_increment,
+  problemid		int(4)		DEFAULT '0' NOT NULL,
+  clock			int(4),
+  status_before		int(1)		DEFAULT '0' NOT NULL,
+  status_after		int(1)		DEFAULT '0' NOT NULL,
+  comment		blob,
+  PRIMARY KEY (commentid),
+  KEY (problemid,clock)
+);
diff --git a/upgrades/dbpatches/1.0beta5_to_1.0beta6/postgresql/patch.sql b/upgrades/dbpatches/1.0beta5_to_1.0beta6/postgresql/patch.sql
index 17a5ba09..5962ac0c 100644
--- a/upgrades/dbpatches/1.0beta5_to_1.0beta6/postgresql/patch.sql
+++ b/upgrades/dbpatches/1.0beta5_to_1.0beta6/postgresql/patch.sql
@@ -1 +1,47 @@
-alter table functions modify lastvalue varchar(255);
+alter table functions alter lastvalue varchar(255);
+
+
+--
+-- Table structure for table 'problems'
+--
+
+CREATE TABLE problems (
+  problemid		int4		NOT NULL auto_increment,
+  userid		int4		DEFAULT '0' NOT NULL,
+  triggerid		int4,
+  lastupdate		int4		DEFAULT '0' NOT NULL,
+  clock			int4		DEFAULT '0' NOT NULL,
+  status		int1		DEFAULT '0' NOT NULL,
+  descripion		varchar(255)	DEFAULT '' NOT NULL,
+  categoryid		int4,
+  priority		int1		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (problemid),
+  KEY (status),
+  KEY (categoryid),
+  KEY (priority)
+);
+
+--
+-- Table structure for table 'categories'
+--
+
+CREATE TABLE categories (
+  categoryid		int(4)		NOT NULL auto_increment,
+  descripion		varchar(64)	DEFAULT '' NOT NULL,
+  PRIMARY KEY (categoryid)
+);
+
+--
+-- Table structure for table 'problems_comments'
+--
+
+CREATE TABLE problems_comments (
+  commentid		int(4)		NOT NULL auto_increment,
+  problemid		int(4)		DEFAULT '0' NOT NULL,
+  clock			int(4),
+  status_before		int(1)		DEFAULT '0' NOT NULL,
+  status_after		int(1)		DEFAULT '0' NOT NULL,
+  comment		blob,
+  PRIMARY KEY (commentid),
+  KEY (problemid,clock)
+);