title: Mysql date error creating a table
body: <p>I'm getting an error when I try to create an sql table which I can't fix:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `#__websitemanager_magazine` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
  `date` DATE NOT NULL DEFAULT '',
  `magazine_file` TEXT NOT NULL,
  PRIMARY KEY  (`id`),
  </code></pre>
  
  <p>) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;</p>
  
  <p>it throws an Invalid default value for 'date'.  I'm using mysql 5.7 </p>