wx98 / yunnote Goto Github PK

mysql> DROP TABLE IF EXISTS ndata; CREATE TABLE ndata(Ndataint(11) NOT NULL AUTO_INCREMENT,UIDint(11) NOT NULL DEFAULT '0',Titlevarchar(255) DEFAULT NULL,Datadate DEFAULT NULL,DateTime datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (Ndata), KEY UID (UID), CONSTRAINT ndata_ibfk_1 FOREIGN KEY (UID) REFERENCES user (UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query OK, 0 rows affected (0.03 sec)

1067 - Invalid default value for 'DateTime'
mysql> `