CREATE TABLE artists (
  first_name text default NULL,
  last_name  text default NULL,
  band       text default NULL,
  id         int(5)   NOT NULL auto_increment
);

##</code><code>##

INSERT INTO artists (first_name, last_name) VALUES ('Billy','Joel');
INSERT INTO artists (band)                  VALUES ('AC/DC');

##</code><code>##

CREATE TABLE albums (
  name   text       NOT NULL,
  year   int(4) default NULL,
  format enum('lp','cassette','cd','45'),
  artist int(5) default NULL,
  id     int(8)     NOT NULL auto_increment
);

##</code><code>##

INSERT INTO albums (name,year,format,artist) values ('Glass Houses','1980','lp',123);
INSERT INTO albums (name,format,artist)      VALUES ('Piano Man','45',123);
INSERT INTO albums (name,year,format,artist) VALUES ('Back in Black','1980','cd',456);