DROP TABLE IF EXISTS anthem;
CREATE TABLE anthem (
  id            int(6) unsigned zerofill NOT NULL auto_increment,
  account       varchar(32) NOT NULL,
  title         varchar(200) NOT NULL,
  composer      varchar(200),
  author        varchar(200),
  arranger      varchar(200),
  publisher     varchar(200),
  scripture     varchar(200),
  voicing       varchar(200),
  pages         int(6) NULL,
  length        int(6) NULL,
  copies        int(6) NULL,
  publish_date  varchar(32),
  purchase_date varchar(32),
  lyrics        text,
  notes         text,
  PRIMARY KEY (id)
);