#1067 - Invalid default value for

CREATE TABLE imooc_admin(

id INT  UNSIGNED NOT NULL  AUTO_INCREMENT KEY ,

adminuser varchar(50) NOT NULL DEFAULT '',

adminpass CHAR(32) NOT NULL DEFAULT '',

created_at DATETIME NOT NULL DEFAULT NOW(),

login_at datetime not null  default now(),

login_ip bigint not null default '0'

)ENGINE=INNODB DEFAULT CHATSET=UTF8;