Syntax Error in CREATE

Yup, vielen Dank!

[admin]

du hast keinen Wert für VARCHAR angegeben!

CREATE TABLE catlinks (
id INT UNSIGNED DEFAULT '0' not null AUTO_INCREMENT,
song_id INT UNSIGNED not null ,
description VARCHAR (100) not null ,
link VARCHAR (100) not null ,
user_id MEDIUMINT UNSIGNED not null ,
PRIMARY KEY (id), UNIQUE (id)
)

und es geht.

Cu
berni

[Sky]

What's wrong?

CREATE TABLE catlinks (
id INT UNSIGNED DEFAULT '0'  not null AUTO_INCREMENT,
song_id INT UNSIGNED  not null ,
description VARCHAR  not null ,
link VARCHAR  not null ,
user_id MEDIUMINT UNSIGNED  not null  ,
PRIMARY KEY (id), UNIQUE (id)
)

MySQL said:  You have an error in your SQL syntax near 'not null , link VARCHAR  not null , user_id MEDIUMINT UNSIGNED  not null  , PRIM' at line 1 

MySQL 3.23.40, PHPMyAdmin 2.2.0rc1