Посмотрите так пойдёт:
CREATE TABLE artist (
ID int(11) NOT NULL auto_increment,
name char(255) default NULL,
PRIMARY KEY (ID),
KEY name (name)
) TYPE=MyISAM;
CREATE TABLE song (
ID int(11) NOT NULL auto_increment,
file text NOT NULL,
title varchar(255) NOT NULL default \'\',
comment text,
size varchar(10) NOT NULL default \'\',
length_min float NOT NULL default \'0\',
bitrate smallint(6) NOT NULL default \'0\',
freq mediumint(9) NOT NULL default \'0\',
artistID int(11) NOT NULL default \'0\',
PRIMARY KEY (ID),
KEY file (file(60)),
KEY title (title),
KEY artistID (artistID)
) TYPE=MyISAM;