See server-guide.
CREATE DATABASE batch CHARACTER SET utf8;
CREATE USER 'batch' IDENTIFIED BY 'test';
GRANT ALL ON batch.* to 'batch';
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);