[icinga-checkins] icinga.org: icinga-core/mfriedrich/core: fix slashistory acknowledgement_time timestamp default

git at icinga.org git at icinga.org
Mon Nov 7 10:14:10 CET 2011


Module: icinga-core
Branch: mfriedrich/core
Commit: f7a69e8b0423db3c0083e6fc16324508be3bd8b8
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=f7a69e8b0423db3c0083e6fc16324508be3bd8b8

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Nov  7 10:13:40 2011 +0100

fix slashistory acknowledgement_time timestamp default

---

 module/idoutils/db/mysql/mysql.sql                 |    2 +-
 .../db/mysql/upgrade/mysql-upgrade-1.6.0.sql       |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/module/idoutils/db/mysql/mysql.sql b/module/idoutils/db/mysql/mysql.sql
index 84a942e..715aa41 100644
--- a/module/idoutils/db/mysql/mysql.sql
+++ b/module/idoutils/db/mysql/mysql.sql
@@ -1378,7 +1378,7 @@ CREATE TABLE IF NOT EXISTS icinga_slahistory (
   instance_id bigint unsigned default 0,
   start_time timestamp default '0000-00-00 00:00:00',
   end_time timestamp default '0000-00-00 00:00:00',
-  acknowledgement_time timestamp default NULL,
+  acknowledgement_time timestamp default '0000-00-00 00:00:00',
   object_id bigint unsigned default 0,
   state smallint default 0,
   state_type smallint default '0',
diff --git a/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql b/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql
index a214ace..68cd4b3 100644
--- a/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql
+++ b/module/idoutils/db/mysql/upgrade/mysql-upgrade-1.6.0.sql
@@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS icinga_slahistory (
   instance_id bigint unsigned default 0,
   start_time timestamp default '0000-00-00 00:00:00',
   end_time timestamp default '0000-00-00 00:00:00',
-  acknowledgement_time timestamp default NULL,
+  acknowledgement_time timestamp default '0000-00-00 00:00:00',
   object_id bigint unsigned default 0,
   state smallint default 0,
   state_type smallint default '0',





More information about the icinga-checkins mailing list