Help : Err 1067

Results 1 to 1 of 1
  1. #1
    Novice Sheng Yuan is offline
    MemberRank
    Jul 2015 Join Date
    1Posts

    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




Advertisement