-
Help : Err 1067
Need Help on this error
[Err] 1067 - Invalid default value for 'level_up_date'
[Err] -- ----------------------------
-- Table structure for towns
-- ----------------------------
CREATE TABLE `towns` (
`id` int(11) NOT NULL,
`level` int(11) NOT NULL DEFAULT '1',
`points` int(10) NOT NULL DEFAULT '0',
`race` enum('ELYOS','ASMODIANS') NOT NULL,
`level_up_date` timestamp NOT NULL DEFAULT '1970-01-01 07:00:01',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully