daily pastebin goal
71%
SHARE
TWEET

Untitled

a guest Jul 25th, 2012 18 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> CREATE TABLE `alias` (
  2.   `target` CHAR(128) NOT NULL DEFAULT '',
  3.   `forward` text NOT NULL,
  4.   `enabled` tinyint(1) NOT NULL DEFAULT '1',
  5.   `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  6.   `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  7. PRIMARY KEY (`target`)
  8. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  9.  
  10.  
  11. ERROR 1067 (42000): Invalid default value for 'created'
RAW Paste Data
Pastebin PRO WINTER Special!
Get 40% OFF Pastebin PRO accounts!
Top