From 2644b8799770ef75905e08d2dc9d95e4843d5ee6 Mon Sep 17 00:00:00 2001
From: Marcin Krol <hawk@tld-linux.org>
Date: Tue, 10 Jun 2014 12:58:36 +0000
Subject: [PATCH] - turn off nonstandard TIMESTAMP behaviors

---
 mysqld.conf | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/mysqld.conf b/mysqld.conf
index 632ab02..ce56802 100644
--- a/mysqld.conf
+++ b/mysqld.conf
@@ -143,6 +143,7 @@ slow-query-log_file = /var/log/mysql/slow.log
 # Internal server variables
 #
 
+explicit_defaults_for_timestamp = true
 #back_log=5
 #connect_timeout=5
 #delayed_insert_timeout=300
@@ -179,6 +180,10 @@ slow-query-log_file = /var/log/mysql/slow.log
 # Fulltext search options
 #ft_min_word_len=2
 
+# Turn off nonstandard TIMESTAMP behaviors
+# http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp
+explicit_defaults_for_timestamp = true
+
 #
 # MyISAM tables options
 #
-- 
2.46.0