CREATE TABLE song (
  id int(11) NOT NULL auto_increment,
  title varchar(65) default NULL,
  album_id int(11) NOT NULL,
  PRIMARY KEY  (id),
  FOREIGN KEY index_album_id(album_id) 
    REFERENCES album(id)
);