CREATE TABLE album (
  id int(11) NOT NULL auto_increment,
  title varchar(65) default NULL,
  year varchar(4) default NULL,
  artist_id int(11) NOT NULL,
  PRIMARY KEY  (id),
  FOREIGN KEY index_artist_id(artist_id) 
    REFERENCES artist(id)
);