php - #1067 - 'msg_created_at' 的默认值无效

Question

CREATE TABLE IF NOT EXISTS `messages` (
    `msg_id` INT(11) NOT NULL AUTO_INCREMENT,
    `msg_user_id` INT(11) NOT NULL,
    `msg_doc_id` INT(11) NOT NULL,
    `msg_question` TEXT NOT NULL,
    `msg_answer` TEXT DEFAULT NULL,
    `msg_files` TEXT DEFAULT NULL,
    `msg_status` TINYINT(3) NOT NULL DEFAULT 1,
    `msg_created_at` DATE NOT NULL DEFAULT CURRENT_TIMESTAMP(),
    PRIMARY KEY (`msg_id`)
)  ENGINE=MYISAM AUTO_INCREMENT=3 DEFAULT CHARSET=LATIN1

标签： phpmysql