#3 mysql install bug

[blatant]

I got the following error when installing:

Creating table apa_albums : Can't create table CREATE
TABLE apa_albums( name varchar(255) not null, path
varchar(255) not null, nb_photos mediumint unsigned,
nb_comments int unsigned not null, nb_views int
unsigned not null, time timestamp, check tinyint
unsigned DEFAULT '0', ID smallint unsigned not null
auto_increment, PRIMARY KEY(ID) )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 'tinyint unsigned DEFAULT '0', ID smallint unsigned
not

I'm running mysql 4.0.18