drop database if exists dj;
create database dj character set utf8;
grant all on dj.* to dj identified by 'sensiblepassword';
use dj;

create table record(
  id integer primary key auto_increment,
  filename varchar(4096),
  lastplayed datetime,
  numplays integer,
  rating integer,
  title varchar(128),
  artist varchar(128),
  notes text);

create table tag(
  id integer primary key auto_increment,
  tag varchar(128));

create table record2tag(
  record_id integer,
  tag_id integer,
  foreign key (record_id) references dj_record (id),
  foreign key (tag_id) references dj_tag (id));