Ok, here's the fixed query, thanks to futureal:
Code:
CREATE TABLE flash (
flashid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
name VARCHAR(100) NOT NULL,
filesize INT(5) DEFAULT '0' NOT NULL,
filename VARCHAR(50) NOT NULL,
thumb VARCHAR(100) NOT NULL,
author VARCHAR(50) NOT NULL,
type VARCHAR(50) NOT NULL,
height INT(5) DEFAULT '480' NOT NULL,
width INT(5) DEFAULT '640' NOT NULL,
dateline INT(10) UNSIGNED NOT NULL DEFAULT '0',
leaderboardurl VARCHAR(50) NOT NULL,
INDEX (userid)
)