# phpMyAdmin MySQL-Dump
# version 2.2.6
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Aug 18, 2002 at 10:40 AM
# Server version: 3.23.36
# PHP Version: 3.0.15
# Database : `stoic`
# --------------------------------------------------------

#
# Table structure for table `archive`
#

CREATE TABLE archive (
  id int(10) unsigned NOT NULL auto_increment,
  prod_code varchar(15) NOT NULL default '',
  media_id varchar(15) NOT NULL default '',
  start mediumint(8) unsigned default NULL,
  comments text,
  PRIMARY KEY  (id),
  KEY prod_code (prod_code)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `archive_media`
#

CREATE TABLE archive_media (
  media_id varchar(15) NOT NULL default '',
  title varchar(30) NOT NULL default '',
  format varchar(15) NOT NULL default '',
  comments text,
  PRIMARY KEY  (media_id),
  KEY title (title)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `credits`
#

CREATE TABLE credits (
  id int(10) unsigned NOT NULL auto_increment,
  series_code varchar(15) NOT NULL default '',
  credit varchar(30) NOT NULL default '',
  person_id varchar(15) default NULL,
  name varchar(40) default NULL,
  locked tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY person_id (person_id),
  KEY series_code (series_code)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `people`
#

CREATE TABLE people (
  person_id varchar(15) NOT NULL default '',
  password varchar(20) default NULL,
  auth_level tinyint(4) NOT NULL default '0',
  surname varchar(40) NOT NULL default '',
  forename varchar(40) NOT NULL default '',
  email varchar(60) default NULL,
  telephone varchar(20) default NULL,
  mobile varchar(20) default NULL,
  comments text,
  PRIMARY KEY  (person_id),
  KEY surname (surname)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `programmes`
#

CREATE TABLE programmes (
  prod_code varchar(15) NOT NULL default '',
  series_code varchar(15) default NULL,
  episode_no smallint(5) unsigned default NULL,
  title varchar(50) NOT NULL default '',
  prod_date date NOT NULL default '0000-00-00',
  type varchar(20) NOT NULL default '',
  duration mediumint(8) unsigned NOT NULL default '0',
  comments text,
  PRIMARY KEY  (prod_code),
  KEY title (title)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `schedule`
#

CREATE TABLE schedule (
  id int(10) unsigned NOT NULL auto_increment,
  prod_code varchar(15) NOT NULL default '',
  start datetime NOT NULL default '0000-00-00 00:00:00',
  ready tinyint(3) unsigned NOT NULL default '0',
  comments text,
  PRIMARY KEY  (id),
  KEY prod_code (prod_code),
  KEY start (start)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `series`
#

CREATE TABLE series (
  series_code varchar(15) NOT NULL default '',
  title varchar(50) NOT NULL default '',
  year varchar(9) NOT NULL default '',
  comments text,
  PRIMARY KEY  (series_code),
  KEY title (title)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `series_credits`
#

CREATE TABLE series_credits (
  id int(10) unsigned NOT NULL auto_increment,
  prod_code varchar(15) NOT NULL default '',
  credit varchar(30) NOT NULL default '',
  person_id varchar(15) default NULL,
  name varchar(40) default NULL,
  PRIMARY KEY  (id),
  KEY prod_code (prod_code),
  KEY person_id (person_id)
) TYPE=MyISAM;