Merge pull request #444 from cstroe/fix_date_defaults

Fixes #443: Failure to create tables on fresh install with MySQL 5.7

1 files changed, 8 insertions, 8 deletions

diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql
index 0c50701c0..1c7853edc 100644
--- a/install/piwigo_structure-mysql.sql
+++ b/install/piwigo_structure-mysql.sql
@@ -51,7 +51,7 @@ DROP TABLE IF EXISTS `piwigo_comments`;
 CREATE TABLE `piwigo_comments` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `image_id` mediumint(8) unsigned NOT NULL default '0',
-  `date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `date` datetime NOT NULL default '1970-01-01 00:00:00',
   `author` varchar(255) default NULL,
   `email` varchar(255) default NULL,
   `author_id` mediumint(8) unsigned DEFAULT NULL,
@@ -121,7 +121,7 @@ CREATE TABLE `piwigo_groups` (
 DROP TABLE IF EXISTS `piwigo_history`;
 CREATE TABLE `piwigo_history` (
   `id` int(10) unsigned NOT NULL auto_increment,
-  `date` date NOT NULL default '0000-00-00',
+  `date` date NOT NULL default '1970-01-01',
   `time` time NOT NULL default '00:00:00',
   `user_id` mediumint(8) unsigned NOT NULL default '0',
   `IP` varchar(15) NOT NULL default '',
@@ -196,7 +196,7 @@ DROP TABLE IF EXISTS `piwigo_images`;
 CREATE TABLE `piwigo_images` (
   `id` mediumint(8) unsigned NOT NULL auto_increment,
   `file` varchar(255) binary NOT NULL default '',
-  `date_available` datetime NOT NULL default '0000-00-00 00:00:00',
+  `date_available` datetime NOT NULL default '1970-01-01 00:00:00',
   `date_creation` datetime default NULL,
   `name` varchar(255) default NULL,
   `comment` text,
@@ -248,7 +248,7 @@ DROP TABLE IF EXISTS `piwigo_old_permalinks`;
 CREATE TABLE `piwigo_old_permalinks` (
   `cat_id` smallint(5) unsigned NOT NULL default '0',
   `permalink` varchar(64) binary NOT NULL default '',
-  `date_deleted` datetime NOT NULL default '0000-00-00 00:00:00',
+  `date_deleted` datetime NOT NULL default '1970-01-01 00:00:00',
   `last_hit` datetime default NULL,
   `hit` int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (`permalink`)
@@ -276,7 +276,7 @@ CREATE TABLE `piwigo_rate` (
   `element_id` mediumint(8) unsigned NOT NULL default '0',
   `anonymous_id` varchar(45) NOT NULL default '',
   `rate` tinyint(2) unsigned NOT NULL default '0',
-  `date` date NOT NULL default '0000-00-00',
+  `date` date NOT NULL default '1970-01-01',
   PRIMARY KEY  (`element_id`,`user_id`,`anonymous_id`)
 ) ENGINE=MyISAM;
 
@@ -300,7 +300,7 @@ DROP TABLE IF EXISTS `piwigo_sessions`;
 CREATE TABLE `piwigo_sessions` (
   `id` varchar(255) binary NOT NULL default '',
   `data` mediumtext NOT NULL,
-  `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
+  `expiration` datetime NOT NULL default '1970-01-01 00:00:00',
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM;
 
@@ -350,7 +350,7 @@ CREATE TABLE `piwigo_themes` (
 DROP TABLE IF EXISTS `piwigo_upgrade`;
 CREATE TABLE `piwigo_upgrade` (
   `id` varchar(20) NOT NULL default '',
-  `applied` datetime NOT NULL default '0000-00-00 00:00:00',
+  `applied` datetime NOT NULL default '1970-01-01 00:00:00',
   `description` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM;
@@ -455,7 +455,7 @@ CREATE TABLE `piwigo_user_infos` (
   `show_nb_hits` enum('true','false') NOT NULL default 'false',
   `recent_period` tinyint(3) unsigned NOT NULL default '7',
   `theme` varchar(255) NOT NULL default 'elegant',
-  `registration_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `registration_date` datetime NOT NULL default '1970-01-01 00:00:00',
   `enabled_high` enum('true','false') NOT NULL default 'true',
   `level` tinyint unsigned NOT NULL default '0',
   `activation_key` varchar(255) default NULL,