From 299a34dcbb52d5a90cc97edf4640fae0a1cd1528 Mon Sep 17 00:00:00 2001
From: bradymiller <bradymiller@users.sourceforge.net>
Date: Mon, 25 Apr 2016 01:46:35 -0700
Subject: [PATCH] Fix of lists_touch sql table bug in mysql verion 5.7 and
 higher.

Do not need to modify upgrade scripts, because in the past, mysql basically
ignored setting default to NULL for primary keys; Mysql 5.7 throws an error
rather than continuing behavior of prior mysql version..
---
 sql/database.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sql/database.sql b/sql/database.sql
index 2fc3b550f..508d3b207 100644
--- a/sql/database.sql
+++ b/sql/database.sql
@@ -4490,8 +4490,8 @@ CREATE TABLE `lists` (
 
 DROP TABLE IF EXISTS `lists_touch`;
 CREATE TABLE `lists_touch` (
-  `pid` bigint(20) default NULL,
-  `type` varchar(255) default NULL,
+  `pid` bigint(20) NOT NULL default '0',
+  `type` varchar(255) NOT NULL default '',
   `date` datetime default NULL,
   PRIMARY KEY  (`pid`,`type`)
 ) ENGINE=MyISAM ;
-- 
2.11.4.GIT