By ralx at 2015-10-29
0人收藏 • 2017人看过

Time : 14:18:54

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'DaysDate'

Raw SQL : CREATE TABLE `carbon_statistics` (

`DaysUsers` int(10) unsigned NOT NULL DEFAULT '0',

`DaysPosts` int(10) unsigned NOT NULL DEFAULT '0',

`DaysTopics` int(10) unsigned NOT NULL DEFAULT '0',

`TotalUsers` int(10) unsigned NOT NULL DEFAULT '0',

`TotalPosts` int(10) unsigned NOT NULL DEFAULT '0',

`TotalTopics` int(10) unsigned NOT NULL DEFAULT '0',

`DaysDate` date NOT NULL DEFAULT '0000-00-00',

`DateCreated` int(10) unsigned NOT NULL,

PRIMARY KEY (`DaysDate`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

我应该去找到这个setup的句子去改default value?

谢谢