I got this free script that is no longer supported and I am trying to upload the SQL file to my database but I am returning errors.

This is the sql:

CREATE TABLE `lyrics_albums` (
  `id` int(11) NOT NULL auto_increment,
  `artist` int(11) NOT NULL default '0',
  `album` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
  UNIQUE KEY `album` (`album`)
) TYPE=MyISAM;


CREATE TABLE `lyrics_artist` (
  `id` int(11) NOT NULL auto_increment,
  `artist` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `artist` (`artist`)
) TYPE=MyISAM;


CREATE TABLE `lyrics_songs` (
  `id` int(11) NOT NULL auto_increment,
  `album` int(11) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;

The lyrics_artist one uploads if I do them seperately. However the lyrics_songs and lyrics_album return these errors:

#1064 - 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 'UNIQUE KEY `album` (`album`)
) TYPE=MyISAM' at line 6

#1064 - 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 'UNIQUE KEY `name` (`name`)
) TYPE=MyISAM' at line 7

Any help is appreciated and an explanation of why one of them works and the other two doesnt would help me understand why it is doing this. I am trying to learn SQL

looks like you're missing a comma

CREATE TABLE `lyrics_albums` (
  `id` int(11) NOT NULL auto_increment,
  `artist` int(11) NOT NULL default '0',
  `album` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`),  <-- Missing comma here
  UNIQUE KEY `album` (`album`)
) TYPE=MyISAM;


CREATE TABLE `lyrics_artist` (
  `id` int(11) NOT NULL auto_increment,
  `artist` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `artist` (`artist`)
) TYPE=MyISAM;


CREATE TABLE `lyrics_songs` (
  `id` int(11) NOT NULL auto_increment,
  `album` int(11) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`),  <-- Missing comma here
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;

ah thank you