[icinga-checkins] icinga.org: icinga2/master: ido-mysql: Don' t set the SQL mode to NO_AUTO_VALUE_ON_ZERO

git at icinga.org git at icinga.org
Fri Nov 18 11:41:43 CET 2016


Module: icinga2
Branch: master
Commit: 0b9046a0303c2a3a6416d220bc9553df58710830
URL:    https://git.icinga.org/?p=icinga2.git;a=commit;h=0b9046a0303c2a3a6416d220bc9553df58710830

Author: Eric Lippmann <eric.lippmann at netways.de>
Date:   Thu Nov 17 12:22:00 2016 +0100

ido-mysql: Don't set the SQL mode to NO_AUTO_VALUE_ON_ZERO

This mode is obsolete because timestamp columns now default to NULL instead of '0000-00...'.

refs #10502

---

 lib/db_ido_mysql/schema/mysql.sql |    4 ----
 1 file changed, 4 deletions(-)

diff --git a/lib/db_ido_mysql/schema/mysql.sql b/lib/db_ido_mysql/schema/mysql.sql
index 97c9931..c16633a 100644
--- a/lib/db_ido_mysql/schema/mysql.sql
+++ b/lib/db_ido_mysql/schema/mysql.sql
@@ -6,15 +6,11 @@
 --
 -- -- --------------------------------------------------------
 
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-
-
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 /*!40101 SET NAMES utf8 */;
 
-
 --
 -- Database: icinga
 --



More information about the icinga-checkins mailing list