Bison, I figured this part out.
This is the query you should use.
CREATE TABLE flash (
flashid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
userid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
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 ) UNSIGNE DDEFAULT '0' NOT NULL ,
leaderboardurl VARCHAR( 50 ) NOT NULL ,
INDEX ( userid )
);
|