[icinga-checkins] icinga.org: icinga-reports/mluebben/default: Add fields in tabel reports

git at icinga.org git at icinga.org
Wed Jun 29 14:51:39 CEST 2011


Module: icinga-reports
Branch: mluebben/default
Commit: 164fc40667a5c7ef5f713602e3a9e1dd7dad7810
URL:    https://git.icinga.org/?p=icinga-reports.git;a=commit;h=164fc40667a5c7ef5f713602e3a9e1dd7dad7810

Author: Michael Luebben <michael_luebben at web.de>
Date:   Wed Jun 29 14:51:10 2011 +0200

Add fields in tabel reports

---

 AvailReportParser/db/mysql/mysql.sql               |    4 +++-
 AvailReportParser/doc/database/Database-Schema.pdf |  Bin 73567 -> 73606 bytes
 2 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/AvailReportParser/db/mysql/mysql.sql b/AvailReportParser/db/mysql/mysql.sql
index 763e299..2a4ebca 100644
--- a/AvailReportParser/db/mysql/mysql.sql
+++ b/AvailReportParser/db/mysql/mysql.sql
@@ -56,6 +56,9 @@ CREATE  TABLE IF NOT EXISTS `reporting`.`reports` (
   `timeperiod` VARCHAR(45) NOT NULL ,
   `rpttimerperiod` VARCHAR(255) NULL ,
   `config_filename` VARCHAR(45) NOT NULL ,
+  `execution_time` VARCHAR(45) NOT NULL ,
+  `exit_status` TINYINT(4)  NOT NULL ,
+  `message` VARCHAR(255) NOT NULL ,
   PRIMARY KEY (`id`) )
 ENGINE = InnoDB;
 
@@ -281,4 +284,3 @@ INSERT INTO `reporting`.`objecttypes` (`id`, `name`) VALUES (1, 'host');
 INSERT INTO `reporting`.`objecttypes` (`id`, `name`) VALUES (2, 'service');
 
 COMMIT;
-
diff --git a/AvailReportParser/doc/database/Database-Schema.pdf b/AvailReportParser/doc/database/Database-Schema.pdf
index 8684f3b..322ed96 100644
Binary files a/AvailReportParser/doc/database/Database-Schema.pdf and b/AvailReportParser/doc/database/Database-Schema.pdf differ





More information about the icinga-checkins mailing list