
CREATE DATABASE dbname

if $bindir/mysql $* -f <<END-OF-DATA
CREATE DATABASE ${db_name};
END-OF-DATA
then...

CREATE TABLE artist (
  id int(11) NOT NULL AUTO_INCREMENT,
  artist varchar(128) DEFAULT NULL,
  num_plays int(11) DEFAULT NULL,
  last_play datetime DEFAULT NULL,
  date_added date DEFAULT NULL,
  PRIMARY KEY (id, artist)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=1 ROW_FORMAT=DYNAMIC;

CREATE TABLE disc (
  id int(11) NOT NULL AUTO_INCREMENT,
  disc varchar(100) DEFAULT NULL,
  artistid int(11) NOT NULL,
  num_plays int(11) DEFAULT NULL,
  last_play datetime DEFAULT NULL,
  genre varchar(20) DEFAULT NULL,
  year int(11) DEFAULT NULL,
  date_added date DEFAULT NULL,
  gain_adj tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (id),
  KEY artistid (artistid),
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=1 ROW_FORMAT=DYNAMIC;

CREATE TABLE song (
  id int(11) NOT NULL AUTO_INCREMENT,
  filename varchar(255) DEFAULT NULL,
  title varchar(80) DEFAULT NULL,
  artistid int(11) NOT NULL,
  discid int(11) NOT NULL,
  genre varchar(20) DEFAULT NULL,
  track_num int(11) DEFAULT NULL,
  play_time varchar(5) DEFAULT NULL,
  num_plays int(11) DEFAULT NULL,
  last_play datetime DEFAULT NULL,
  year int(11) DEFAULT NULL,
  date_added date DEFAULT NULL,
  gain_adj tinyint(2) NOT NULL DEFAULT '0',
  disable bit(64) NOT NULL DEFAULT b'0',
  next_id int(11) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY artistid (artistid),
  KEY discid (discid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=1 ROW_FORMAT=DYNAMIC;

CREATE TABLE db_info (
  db_version int(10) unsigned DEFAULT NULL
);

INSERT INTO db_info (db_version) VALUES ('5');
