You know, you really don't need those (14), et al., in there.
And TYPE=MYISAM is wrong.
And it's better to use DATETIME instead of TIMESTAMP.
Try something really simple:
DROP TABLE IF EXISTS sbprj_additional_info;
CREATE TABLE sbprj_additional_info (
sb_id bigint NOT NULL auto_increment PRIMARY KEY,
sb_project_id bigint NOT NULL default -1,
sb_temp datetime NOT NULL,
sb_posted_on datetime NOT NULL
That works. Tested it.
UPDATE: I checked your attempt: It simply doesn't like the (14) after timestamp
. If you omit the two (14)
and change TYPE
then yours works.