batch.ws

Deployment

See server-guide.

MySQL

Database

CREATE DATABASE batch CHARACTER SET utf8;

User

CREATE USER 'batch' IDENTIFIED BY 'test';
GRANT ALL ON batch.* to 'batch';

Tables

CREATE TABLE episode
  (number TINYINT NOT NULL,
  date DATE NOT NULL,
  media_url VARCHAR(1024) NOT NULL,
  PRIMARY KEY (number),
  INDEX (date));

CREATE TABLE track
  (episode_number TINYINT NOT NULL,
  start_time TIME NOT NULL,
  title VARCHAR(255) NOT NULL,
  artist VARCHAR(255) NOT NULL,
  PRIMARY KEY (episode_number, start_time),
  FOREIGN KEY (episode_number) REFERENCES episode (number) ON DELETE CASCADE);

---