qYkrgBjY

1Creating contests table...A database query syntax error has occurred.
2The last attempted database query was:
3"CREATE TABLE IF NOT EXISTS `mw_contest_comments` (
4 comment_id                   INT unsigned        NOT NULL auto_increment PRIMARY KEY,
5 comment_contestant_id        INT unsigned        NOT NULL, -- Foreign key on contest_contestants.contestant_id
6 comment_user_id              INT(10) unsigned    NOT NULL, -- Judge user id
7 comment_text                 TEXT                NOT NULL, -- The comment text
8 comment_time                 binary(14) binary   NOT NULL default '' -- The time at which the comment was made
9 ) ENGINE=InnoDB, DEFAULT CHARSET=binary
10"
11from within function "DatabaseBase::sourceFile( /home/jeroen/root/extensions/Contest/Contest.sql )".
12Database returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'binary   NOT NULL default '' -- The time at which the comment was made
13 ) ENGINE' at line 6 (localhost)"