mysql> CREATE TABLE `alias` (
  `target` CHAR(128) NOT NULL DEFAULT '',
  `forward` text NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
PRIMARY KEY (`target`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


ERROR 1067 (42000): Invalid default value for 'created'