From c7bedefa30be9e17ed27758750aa85e997c9d9b9 Mon Sep 17 00:00:00 2001 From: Cosmin Stroe Date: Mon, 21 Mar 2016 03:24:24 -0500 Subject: Dates start from 1970 onward. --- install/piwigo_structure-mysql.sql | 16 ++++++++-------- 1 file 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, -- cgit v1.2.3