-- phpMyAdmin SQL Dump
-- version 4.8.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 14, 2019 at 03:00 PM
-- Server version: 8.0.13
-- PHP Version: 7.1.19

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `doctorwho`
--
CREATE DATABASE IF NOT EXISTS `doctorwho`;
USE `doctorwho`;

-- --------------------------------------------------------

--
-- Table structure for table `actors`
--

DROP TABLE IF EXISTS `actors`;
CREATE TABLE IF NOT EXISTS `actors` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `gender` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

--
-- Dumping data for table `actors`
--

INSERT INTO `actors` (`id`, `name`, `gender`) VALUES
(1, 'William Hartnell', 'male'),
(2, 'Patrick Troughton', 'male'),
(3, 'Jon Pertwee', 'male'),
(4, 'Tom Baker', 'male'),
(5, 'Peter Davison', 'male'),
(6, 'Colin Baker', 'male'),
(7, 'Sylvester McCoy', 'male'),
(8, 'Paul McGann', 'male'),
(9, 'John Hurt', 'male'),
(10, 'Chris Eccleston', 'male'),
(11, 'David Tennant', 'male'),
(12, 'Matt Smith', 'male'),
(13, 'Peter Capaldi', 'male'),
(14, 'Peter Cushing', 'male'),
(15, 'Jodie Whittaker', 'female'),
(16, 'Carole Ann Ford', 'female'),
(17, 'Jacqueline Hill', 'female'),
(18, 'William Russell', 'male'),
(19, 'Maureen O\'Brien', 'female'),
(20, 'Peter Purves', 'male'),
(21, 'Adrienne Hill', 'female'),
(22, 'Jean Marsh', 'female'),
(23, 'Jackie Lane', 'female'),
(24, 'Anneke Wills', 'female'),
(25, 'Michael Craze', 'male'),
(26, 'Frazer Hines', 'male'),
(27, 'Deborah Watling', 'female'),
(28, 'Wendy Padbury', 'female'),
(29, 'Caroline John', 'female'),
(30, 'Katy Manning', 'female'),
(31, 'Elisabeth Sladen', 'female'),
(32, 'Ian Marter', 'male'),
(33, 'Louise Jameson', 'female'),
(34, 'John Leeson', 'male'),
(35, 'Mary Tamm', 'female'),
(36, 'Lalla Ward', 'female'),
(37, 'Matthew Waterhouse', 'male'),
(38, 'Janet Fielding', 'female'),
(39, 'Sarah Sutton', 'female'),
(40, 'Mark Strickson', 'male'),
(41, 'Gerald Flood', 'male'),
(42, 'Nicola Bryant', 'female'),
(43, 'Bonnie Langford', 'female'),
(44, 'Sophie Aldred', 'female'),
(45, 'Daphne Ashbrook', 'female'),
(46, 'Billie Piper', 'female'),
(47, 'Bruno Langley', 'male'),
(48, 'John Barrowman', 'male'),
(49, 'Noel Clarke', 'male'),
(50, 'Catherine Tate', 'female'),
(51, 'Freema Agyeman', 'female'),
(52, 'Kylie Minogue', 'female'),
(53, 'Bernard Cribbins', 'male'),
(54, 'Karen Gillan', 'female'),
(55, 'Arthur Darvill', 'male'),
(56, 'Alex Kingston', 'female'),
(57, 'James Corden', 'male'),
(58, 'Jenna Coleman', 'female'),
(59, 'Neve McIntosh', 'female'),
(60, 'Catrin Stewart', 'female'),
(61, 'Dan Starkey', 'male'),
(62, 'Pearl Mackie', 'female'),
(63, 'Matt Lucas', 'male');

-- --------------------------------------------------------

--
-- Table structure for table `doctors`
--

DROP TABLE IF EXISTS `doctors`;
CREATE TABLE IF NOT EXISTS `doctors` (
  `id` int(11) NOT NULL,
  `incarnation` text NOT NULL,
  `primary_actor` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `primary_actor` (`primary_actor`)
) ENGINE=InnoDB;

--
-- Dumping data for table `doctors`
--

INSERT INTO `doctors` (`id`, `incarnation`, `primary_actor`) VALUES
(1, 'First Doctor', 1),
(2, 'Second Doctor', 2),
(3, 'Third Doctor', 3),
(4, 'Fourth Doctor', 4),
(5, 'Fifth Doctor', 5),
(6, 'Sixth Doctor', 6),
(7, 'Seventh Doctor', 7),
(8, 'Eighth Doctor', 8),
(9, 'War Doctor', 9),
(10, 'Ninth Doctor', 10),
(11, 'Tenth Doctor', 11),
(12, 'Eleventh Doctor', 12),
(13, 'Twelfth Doctor', 13),
(14, 'Dr. Who', 14),
(15, 'Thirteenth Doctor', 15);

-- --------------------------------------------------------

--
-- Table structure for table `episodes`
--

DROP TABLE IF EXISTS `episodes`;
CREATE TABLE IF NOT EXISTS `episodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `serial_id` int(11) NOT NULL,
  `story` text,
  `episode_order` text NOT NULL,
  `original_air_date` text NOT NULL,
  `runtime` text,
  `uk_viewers_mm` decimal(10,0) DEFAULT NULL,
  `appreciation_index` int(11) DEFAULT NULL,
  `missing` int(11) DEFAULT '0',
  `recreated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `serial_id_idx` (`serial_id`)
) ENGINE=InnoDB AUTO_INCREMENT=851;

--
-- Dumping data for table `episodes`
--

INSERT INTO `episodes` (`id`, `title`, `serial_id`, `story`, `episode_order`, `original_air_date`, `runtime`, `uk_viewers_mm`, `appreciation_index`, `missing`, `recreated`) VALUES
(1, 'An Unearthly Child', 1, '1', '1.0', '1963-11-23', '23:24', '4', 63, 0, 0),
(2, 'The Cave of Skulls', 1, '1', '2.0', '1963-11-30', '24:26', '6', 59, 0, 0),
(3, 'The Forest of Fear', 1, '1', '3.0', '1963-12-07', '23:38', '7', 56, 0, 0),
(4, 'The Firemaker', 1, '1', '4.0', '1963-12-14', '24:22', '6', 55, 0, 0),
(5, 'The Dead Planet', 2, '2', '1.0', '1963-12-21', '24:22', '7', 59, 0, 0),
(6, 'The Survivors', 2, '2', '2.0', '1963-12-28', '24:27', '6', 58, 0, 0),
(7, 'The Escape', 2, '2', '3.0', '1964-01-04', '25:10', '9', 63, 0, 0),
(8, 'The Ambush', 2, '2', '4.0', '1964-01-11', '24:37', '10', 63, 0, 0),
(9, 'The Expedition', 2, '2', '5.0', '1964-01-18', '24:31', '10', 63, 0, 0),
(10, 'The Ordeal', 2, '2', '6.0', '1964-01-25', '26:14', '10', 63, 0, 0),
(11, 'The Rescue', 2, '2', '7.0', '1964-02-01', '22:24', '10', 65, 0, 0),
(12, 'The Edge of Destruction', 3, '3', '1.0', '1964-02-08', '25:04', '10', 61, 0, 0),
(13, 'The Brink of Disaster', 3, '3', '2.0', '1964-02-15', '22:11', '10', 60, 0, 0),
(14, 'The Roof of the World', 4, '4', '1.0', '1964-02-22', '24:12', '9', 63, 1, 0),
(15, 'The Singing Sands', 4, '4', '2.0', '1964-02-29', '26:34', '9', 62, 1, 0),
(16, 'Five Hundred Eyes', 4, '4', '3.0', '1964-03-07', '22:20', '9', 62, 1, 0),
(17, 'The Wall of Lies', 4, '4', '4.0', '1964-03-14', '24:48', '10', 60, 1, 0),
(18, 'Rider from Shang-Tu', 4, '4', '5.0', '1964-03-21', '23:26', '9', 59, 1, 0),
(19, 'Mighty Kublai Khan', 4, '4', '6.0', '1964-03-28', '25:36', '8', 59, 1, 0),
(20, 'Assassain at Peking', 4, '4', '7.0', '1964-04-04', '24:48', '10', 59, 1, 0),
(21, 'The Sea of Death', 5, '5', '1.0', '1964-04-11', '23:20', '10', 62, 0, 0),
(22, 'The Velvet Web', 5, '5', '2.0', '1964-04-18', '25:37', '9', 60, 0, 0),
(23, 'The Screaming Jungle', 5, '5', '3.0', '1964-04-25', '23:45', '10', 61, 0, 0),
(24, 'The Snows of Terror', 5, '5', '4.0', '1964-05-02', '24:54', '10', 60, 0, 0),
(25, 'Sentence of Death', 5, '5', '5.0', '1964-05-09', '25:03', '8', 61, 0, 0),
(26, 'The Keys of Marinus', 5, '5', '6.0', '1964-05-16', '25:11', '7', 63, 0, 0),
(27, 'The Temple of Evil', 6, '6', '1.0', '1964-05-23', '23:56', '7', 62, 0, 0),
(28, 'The Warriors of Death', 6, '6', '2.0', '1964-05-30', '24:11', '7', 62, 0, 0),
(29, 'The Bride of Sacrifice', 6, '6', '3.0', '1964-06-06', '25:27', '8', 57, 0, 0),
(30, 'The Day of Darkness', 6, '6', '4.0', '1964-06-13', '25:30', '7', 58, 0, 0),
(31, 'Strangers in Space', 7, '7', '1.0', '1964-06-20', '24:46', '8', 59, 0, 0),
(32, 'The Unwilling Warriors', 7, '7', '2.0', '1964-06-27', '24:44', '7', 59, 0, 0),
(33, 'Hidden Danger', 7, '7', '3.0', '1964-07-11', '24:53', '7', 56, 0, 0),
(34, 'A Race Against Death', 7, '7', '4.0', '1964-07-18', '24:49', '6', 60, 0, 0),
(35, 'Kidnap', 7, '7', '5.0', '1964-07-25', '25:47', '7', 57, 0, 0),
(36, 'A Desperate Venture', 7, '7', '6.0', '1964-08-01', '24:29', '7', 57, 0, 0),
(37, 'A Land of Fear', 8, '8', '1.0', '1964-08-08', '24:24', '7', 58, 0, 0),
(38, 'Guests of Madame Guillotine', 8, '8', '2.0', '1964-08-15', '24:04', '7', 54, 0, 0),
(39, 'A Change of Identity', 8, '8', '3.0', '1964-08-22', '25:23', '7', 55, 0, 0),
(40, 'The Tyrant of France', 8, '8', '4.0', '1964-08-29', '24:46', '6', 53, 1, 1),
(41, 'A Bargain of Necessity', 8, '8', '5.0', '1964-09-05', '23:51', '7', 53, 1, 1),
(42, 'Prisoners of Conciergerie', 8, '8', '6.0', '1964-09-12', '25:04', '6', 55, 0, 0),
(43, 'Planet of Giants', 9, '9', '1.0', '1964-10-31', '23:15', '8', 57, 0, 0),
(44, 'Dangerous Journey', 9, '9', '2.0', '1964-11-07', '23:40', '8', 58, 0, 0),
(45, 'Crisis', 9, '9', '3.0', '1964-11-14', '26:35', '9', 59, 0, 0),
(46, 'World\'s End', 10, '10', '1.0', '1964-11-21', '23:42', '11', 63, 0, 0),
(47, 'The Daleks', 10, '10', '2.0', '1964-11-28', '24:19', '12', 59, 0, 0),
(48, 'Day of Reckoning', 10, '10', '3.0', '1964-12-05', '26:50', '12', 59, 0, 0),
(49, 'The End of Tomorrow', 10, '10', '4.0', '1964-12-12', '23:23', '12', 59, 0, 0),
(50, 'The Waking Ally', 10, '10', '5.0', '1964-12-19', '24:29', '11', 58, 0, 0),
(51, 'Flashpoint', 10, '10', '6.0', '1964-12-26', '25:21', '12', 63, 0, 0),
(52, 'The Powerful Enemy', 11, '11', '1.0', '1965-01-02', '26:15', '12', 57, 0, 0),
(53, 'Desperate Measures', 11, '11', '2.0', '1965-01-09', '24:36', '13', 59, 0, 0),
(54, 'The Slave Traders', 12, '12', '1.0', '1965-01-16', '24:14', '13', 53, 0, 0),
(55, 'All Roads Lead to Rome', 12, '12', '2.0', '1965-01-23', '23:14', '12', 51, 0, 0),
(56, 'Conspiracy', 12, '12', '3.0', '1965-01-30', '26:18', '10', 50, 0, 0),
(57, 'Inferno', 12, '12', '4.0', '1965-02-06', '23:09', '12', 50, 0, 0),
(58, 'The Web Planet', 13, '13', '1.0', '1965-02-13', '23:57', '14', 56, 0, 0),
(59, 'The Zarbi', 13, '13', '2.0', '1965-02-20', '23:20', '13', 53, 0, 0),
(60, 'Escape to Danger', 13, '13', '3.0', '1965-02-27', '22:52', '13', 53, 0, 0),
(61, 'Crater of Needles', 13, '13', '4.0', '1965-03-06', '25:50', '13', 49, 0, 0),
(62, 'Invasion', 13, '13', '5.0', '1965-03-13', '26:04', '12', 48, 0, 0),
(63, 'The Centre', 13, '13', '6.0', '1965-03-20', '24:32', '12', 42, 0, 0),
(64, 'The Lion', 14, '14', '1.0', '1965-03-27', '24:56', '11', 51, 0, 0),
(65, 'The Kinght of Jaffa', 14, '14', '2.0', '1965-04-03', '23:28', '9', 50, 1, 0),
(66, 'The Wheel of Fortune', 14, '14', '3.0', '1965-04-10', '24:51', '9', 49, 0, 0),
(67, 'The Warlords', 14, '14', '4.0', '1965-04-17', '23:40', '10', 48, 1, 0),
(68, 'The Space Museum', 15, '15', '1.0', '1965-04-24', '23:38', '11', 61, 0, 0),
(69, 'The Dimensions of Time', 15, '15', '2.0', '1965-05-01', '22:00', '9', 53, 0, 0),
(70, 'The Search', 15, '15', '3.0', '1965-05-08', '23:33', '9', 56, 0, 0),
(71, 'The Final Phase', 15, '15', '4.0', '1965-05-15', '22:15', '9', 49, 0, 0),
(72, 'The Executioners', 16, '16', '1.0', '1965-05-22', '25:25', '10', 57, 0, 0),
(73, 'The Death of Time', 16, '16', '2.0', '1965-05-29', '23:32', '10', 56, 0, 0),
(74, 'Flight Through Eternity', 16, '16', '3.0', '1965-06-05', '25:23', '9', 55, 0, 0),
(75, 'Journey Into Terror', 16, '16', '4.0', '1965-06-12', '23:49', '10', 54, 0, 0),
(76, 'The Death of Doctor Who', 16, '16', '5.0', '1965-06-19', '23:27', '9', 56, 0, 0),
(77, 'The Planet of Decision', 16, '16', '6.0', '1965-06-26', '26:29', '10', 57, 0, 0),
(78, 'The Watcher', 17, '17', '1.0', '1965-07-03', '24:05', '9', 57, 0, 0),
(79, 'The Meddling Monk', 17, '17', '2.0', '1965-07-10', '25:17', '9', 49, 0, 0),
(80, 'A Battle of Wits', 17, '17', '3.0', '1965-07-17', '24:10', '8', 53, 0, 0),
(81, 'Checkmate', 17, '17', '4.0', '1965-07-24', '24:00', '8', 54, 0, 0),
(82, 'Four Hundred Dawns', 18, '18', '1.0', '1965-09-11', '22:21', '9', 56, 1, 0),
(83, 'Trap of Steel', 18, '18', '2.0', '1965-09-18', '24:51', '10', 55, 1, 0),
(84, 'Air Lock', 18, '18', '3.0', '1965-09-25', '24:19', '11', 54, 0, 0),
(85, 'The Exploding Planet', 18, '18', '4.0', '1965-10-02', '24:47', '10', 53, 1, 0),
(86, 'Mission to the Unknown', 19, '19', '1.0', '1965-10-09', '24:42', '8', 54, 0, 0),
(87, 'Temple of Secrets', 20, '20', '1.0', '1965-10-16', '24:45', '8', 48, 1, 0),
(88, 'Small Prophet, Quick Return', 20, '20', '2.0', '1965-10-23', '24:43', '8', 51, 1, 0),
(89, 'Death of a Spy', 20, '20', '3.0', '1965-10-30', '25:39', '9', 49, 1, 0),
(90, 'Horse of Destruction', 20, '20', '4.0', '1965-11-06', '24:25', '8', 52, 1, 0),
(91, 'The Nightmare Begins', 21, '21', '1.0', '1965-11-13', '22:52', '9', 54, 1, 0),
(92, 'Day of Armageddon', 21, '21', '2.0', '1965-11-20', '24:25', '10', 52, 0, 0),
(93, 'Devil\'s Planet', 21, '21', '3.0', '1965-11-27', '24:30', '10', 52, 1, 0),
(94, 'The Traitors', 21, '21', '4.0', '1965-12-04', '24:42', '10', 51, 1, 0),
(95, 'Counter Plot', 21, '21', '5.0', '1965-12-11', '24:03', '10', 53, 0, 0),
(96, 'Coronas of the Sun', 21, '21', '6.0', '1965-12-18', '24:45', '9', 56, 1, 0),
(97, 'The Feast of Steven', 21, '21', '7.0', '1965-12-25', '24:36', '8', 39, 1, 0),
(98, 'Volcano', 21, '21', '8.0', '1966-01-01', '24:42', '10', 49, 1, 0),
(99, 'Golden Death', 21, '21', '9.0', '1966-01-08', '24:38', '9', 52, 1, 0),
(100, 'Escape Switch', 21, '21', '10.0', '1966-01-15', '23:37', '10', 50, 0, 0),
(101, 'The Abandoned Planet', 21, '21', '11.0', '1966-01-22', '24:34', '10', 49, 1, 0),
(102, 'Destruction of Time', 21, '21', '12.0', '1966-01-29', '23:31', '9', 57, 1, 0),
(103, 'War of God', 22, '22', '1.0', '1966-02-05', '24:51', '8', 52, 1, 0),
(104, 'The Sea Beggar', 22, '22', '2.0', '1966-02-12', '24:43', '6', 52, 1, 0),
(105, 'Priest of Death', 22, '22', '3.0', '1966-02-19', '24:33', '6', 49, 1, 0),
(106, 'Bell of Doom', 22, '22', '4.0', '1966-02-26', '25:06', '6', 53, 1, 0),
(107, 'The Steel Sky', 23, '23', '1.0', '1966-03-05', '24:00', '6', 55, 0, 0),
(108, 'The Plague', 23, '23', '2.0', '1966-03-12', '25:00', '7', 56, 0, 0),
(109, 'The Return', 23, '23', '3.0', '1966-03-19', '24:19', '6', 51, 0, 0),
(110, 'The Bomb', 23, '23', '4.0', '1966-03-26', '24:37', '7', 50, 0, 0),
(111, 'The Celestial Toyroom', 24, '24', '1.0', '1966-04-02', '24:40', '8', 48, 1, 0),
(112, 'The Hall of Dolls', 24, '24', '2.0', '1966-04-09', '24:45', '8', 49, 1, 0),
(113, 'The Dancing Floor', 24, '24', '3.0', '1966-04-16', '24:10', '9', 44, 1, 0),
(114, 'The Final Test', 24, '24', '4.0', '1966-04-23', '23:57', '8', 43, 0, 0),
(115, 'A Holiday for the Doctor', 25, '25', '1.0', '1966-04-30', '23:48', '7', 45, 0, 0),
(116, 'Don\'t Shoot the Pianist', 25, '25', '2.0', '1966-05-07', '23:47', '7', 39, 0, 0),
(117, 'Johnny Ringo', 25, '25', '3.0', '1966-05-14', '23:52', '6', 36, 0, 0),
(118, 'The OK Corral', 25, '25', '4.0', '1966-05-21', '23:53', '6', 30, 0, 0),
(119, 'Episode 1', 26, '26', '1.0', '1966-05-28', '23:41', '5', 48, 1, 0),
(120, 'Episode 2', 26, '26', '2.0', '1966-06-04', '23:57', '6', 49, 1, 0),
(121, 'Episode 3', 26, '26', '3.0', '1966-06-11', '24:59', '5', 48, 1, 0),
(122, 'Episode 4', 26, '26', '4.0', '1966-06-18', '24:41', '5', 48, 1, 0),
(123, 'Episode 1', 27, '27', '1.0', '1966-06-25', '24:01', '5', 49, 0, 0),
(124, 'Episode 2', 27, '27', '2.0', '1966-07-02', '24:00', '5', 45, 0, 0),
(125, 'Episode 3', 27, '27', '3.0', '1966-07-09', '23:58', '5', 44, 0, 0),
(126, 'Episode 4', 27, '27', '4.0', '1966-07-16', '23:11', '6', 39, 0, 0),
(127, 'Episode 1', 28, '28', '1.0', '1966-09-10', '24:36', '4', 47, 1, 0),
(128, 'Episode 2', 28, '28', '2.0', '1966-09-17', '24:27', '5', 45, 1, 0),
(129, 'Episode 3', 28, '28', '3.0', '1966-09-24', '23:55', '4', 43, 1, 0),
(130, 'Episode 4', 28, '28', '4.0', '1966-10-01', '23:37', '5', 43, 1, 0),
(131, 'Episode 1', 29, '29', '1.0', '1966-10-08', '23:08', '6', 50, 0, 0),
(132, 'Episode 2', 29, '29', '2.0', '1966-10-15', '23:15', '6', 48, 0, 0),
(133, 'Episode 3', 29, '29', '3.0', '1966-10-22', '23:31', '8', 48, 0, 0),
(134, 'Episode 4', 29, '29', '4.0', '1966-10-29', '24:02', '8', 47, 1, 0),
(135, 'Episode 1', 30, '30', '1.0', '1966-11-05', '25:43', '8', 43, 1, 0),
(136, 'Episode 2', 30, '30', '2.0', '1966-11-12', '24:29', '8', 45, 1, 0),
(137, 'Episode 3', 30, '30', '3.0', '1966-11-19', '23:31', '8', 44, 1, 0),
(138, 'Episode 4', 30, '30', '4.0', '1966-11-26', '24:23', '8', 47, 1, 0),
(139, 'Episode 5', 30, '30', '5.0', '1966-12-03', '23:38', '8', 48, 1, 0),
(140, 'Episode 6', 30, '30', '6.0', '1966-12-10', '23:46', '8', 47, 1, 0),
(141, 'Episode 1', 31, '31', '1.0', '1966-12-17', '24:38', '7', 47, 1, 0),
(142, 'Episode 2', 31, '31', '2.0', '1966-12-24', '23:41', '7', 46, 1, 0),
(143, 'Episode 3', 31, '31', '3.0', '1966-12-31', '22:54', '7', 47, 1, 0),
(144, 'Episode 4', 31, '31', '4.0', '1967-01-07', '24:19', '7', 47, 1, 0),
(145, 'Episode 1', 32, '32', '1.0', '1967-01-14', '24:18', '8', 48, 1, 0),
(146, 'Episode 2', 32, '32', '2.0', '1967-01-21', '25:00', '8', 46, 0, 0),
(147, 'Episode 3', 32, '32', '3.0', '1967-01-28', '24:09', '7', 45, 0, 0),
(148, 'Episode 4', 32, '32', '4.0', '1967-02-04', '23:20', '7', 47, 1, 0),
(149, 'Episode 1', 33, '33', '1.0', '1967-02-11', '24:12', '8', 50, 1, 0),
(150, 'Episode 2', 33, '33', '2.0', '1967-02-18', '24:42', '9', 49, 0, 0),
(151, 'Episode 3', 33, '33', '3.0', '1967-02-25', '26:11', '8', 53, 1, 0),
(152, 'Episode 4', 33, '33', '4.0', '1967-03-04', '23:28', '8', 58, 0, 0),
(153, 'Episode 1', 34, '34', '1.0', '1967-03-11', '22:58', '8', 50, 1, 0),
(154, 'Episode 2', 34, '34', '2.0', '1967-03-18', '23:21', '8', 48, 1, 0),
(155, 'Episode 3', 34, '34', '3.0', '1967-03-25', '23:24', '9', 52, 1, 0),
(156, 'Episode 4', 34, '34', '4.0', '1967-04-01', '24:41', '8', 49, 1, 0),
(157, 'Episode 1', 35, '35', '1.0', '1967-04-08', '23:47', '8', 51, 0, 0),
(158, 'Episode 2', 35, '35', '2.0', '1967-04-15', '25:22', '6', 50, 1, 0),
(159, 'Episode 3', 35, '35', '3.0', '1967-04-22', '23:10', '8', 53, 0, 0),
(160, 'Episode 4', 35, '35', '4.0', '1967-04-29', '24:28', '7', 55, 1, 0),
(161, 'Episode 5', 35, '35', '5.0', '1967-05-06', '23:34', '7', 55, 1, 0),
(162, 'Episode 6', 35, '35', '6.0', '1967-05-13', '23:38', '8', 52, 1, 0),
(163, 'Episode 1', 36, '36', '1.0', '1967-05-20', '24:07', '8', 51, 1, 0),
(164, 'Episode 2', 36, '36', '2.0', '1967-05-27', '25:13', '8', 51, 0, 0),
(165, 'Episode 3', 36, '36', '3.0', '1967-06-03', '24:27', '6', 52, 1, 0),
(166, 'Episode 4', 36, '36', '4.0', '1967-06-10', '24:43', '5', 51, 1, 0),
(167, 'Episode 5', 36, '36', '5.0', '1967-06-17', '25:23', '5', 53, 1, 0),
(168, 'Episode 6', 36, '36', '6.0', '1967-06-24', '24:48', '7', 49, 1, 0),
(169, 'Episode 7', 36, '36', '7.0', '1967-07-01', '24:33', '6', 56, 1, 0),
(170, 'Episode 1', 37, '37', '1.0', '1967-09-02', '23:58', '6', 53, 0, 0),
(171, 'Episode 2', 37, '37', '2.0', '1967-09-09', '24:44', '6', 52, 0, 0),
(172, 'Episode 3', 37, '37', '3.0', '1967-09-16', '24:14', '7', 49, 0, 0),
(173, 'Episode 4', 37, '37', '4.0', '1967-09-23', '23:22', '7', 50, 0, 0),
(174, 'Episode 1', 38, '38', '1.0', '1967-09-30', '24:15', '6', 50, 1, 0),
(175, 'Episode 2', 38, '38', '2.0', '1967-10-07', '23:15', '6', 52, 0, 0),
(176, 'Episode 3', 38, '38', '3.0', '1967-10-14', '23:55', '7', 51, 1, 0),
(177, 'Episode 4', 38, '38', '4.0', '1967-10-21', '24:11', '7', 50, 1, 0),
(178, 'Episode 5', 38, '38', '5.0', '1967-10-28', '23:51', '7', 51, 1, 0),
(179, 'Episode 6', 38, '38', '6.0', '1967-11-04', '23:31', '7', 52, 1, 0),
(180, 'Episode 1', 39, '39', '1.0', '1967-11-11', '24:21', '7', 52, 0, 0),
(181, 'Episode 2', 39, '39', '2.0', '1967-11-18', '24:16', '7', 52, 1, 0),
(182, 'Episode 3', 39, '39', '3.0', '1967-11-25', '23:58', '7', 51, 1, 0),
(183, 'Episode 4', 39, '39', '4.0', '1967-12-02', '24:23', '7', 51, 0, 0),
(184, 'Episode 5', 39, '39', '5.0', '1967-12-09', '24:25', '8', 50, 0, 0),
(185, 'Episode 6', 39, '39', '6.0', '1967-12-16', '23:58', '8', 51, 0, 0),
(186, 'Episode 1', 40, '40', '1.0', '1967-12-23', '23:45', '7', 50, 0, 0),
(187, 'Episode 2', 40, '40', '2.0', '1967-12-30', '23:48', '8', 49, 0, 0),
(188, 'Episode 3', 40, '40', '3.0', '1968-01-06', '23:05', '7', 48, 0, 0),
(189, 'Episode 4', 40, '40', '4.0', '1968-01-13', '23:46', '8', 49, 0, 0),
(190, 'Episode 5', 40, '40', '5.0', '1968-01-20', '24:22', '7', 49, 0, 0),
(191, 'Episode 6', 40, '40', '6.0', '1968-01-27', '21:41', '8', 52, 0, 0),
(192, 'Episode 1', 41, '41', '1.0', '1968-02-03', '24:53', '7', 54, 0, 0),
(193, 'Episode 2', 41, '41', '2.0', '1968-02-10', '24:38', '7', 53, 0, 0),
(194, 'Episode 3', 41, '41', '3.0', '1968-02-17', '24:34', '7', 51, 1, 0),
(195, 'Episode 4', 41, '41', '4.0', '1968-02-24', '24:50', '8', 53, 0, 0),
(196, 'Episode 5', 41, '41', '5.0', '1968-03-02', '24:19', '8', 55, 0, 0),
(197, 'Episode 6', 41, '41', '6.0', '1968-03-09', '24:41', '8', 55, 0, 0),
(198, 'Episode 1', 42, '42', '1.0', '1968-03-16', '24:54', '8', 55, 1, 0),
(199, 'Episode 2', 42, '42', '2.0', '1968-03-23', '23:08', '8', 55, 1, 0),
(200, 'Episode 3', 42, '42', '3.0', '1968-03-30', '20:29', '8', 56, 1, 0),
(201, 'Episode 4', 42, '42', '4.0', '1968-04-06', '24:17', '7', 56, 1, 0),
(202, 'Episode 5', 42, '42', '5.0', '1968-04-13', '23:40', '6', 56, 1, 0),
(203, 'Episode 6', 42, '42', '6.0', '1968-04-20', '24:24', '7', 57, 1, 0),
(204, 'Episode 1', 43, '43', '1.0', '1968-04-27', '23:47', '7', 57, 1, 0),
(205, 'Episode 2', 43, '43', '2.0', '1968-05-04', '22:50', '7', 60, 1, 0),
(206, 'Episode 3', 43, '43', '3.0', '1968-05-11', '24:25', '8', 55, 0, 0),
(207, 'Episode 4', 43, '43', '4.0', '1968-05-18', '24:14', '9', 56, 1, 0),
(208, 'Episode 5', 43, '43', '5.0', '1968-05-25', '21:55', '7', 57, 1, 0),
(209, 'Episode 6', 43, '43', '6.0', '1968-06-01', '23:10', '7', 62, 0, 0),
(210, 'Episode 1', 44, '44', '1.0', '1968-08-10', '24:25', '6', 52, 0, 0),
(211, 'Episode 2', 44, '44', '2.0', '1968-08-17', '24:07', '6', 55, 0, 0),
(212, 'Episode 3', 44, '44', '3.0', '1968-08-24', '24:06', '5', 55, 0, 0),
(213, 'Episode 4', 44, '44', '4.0', '1968-08-31', '23:54', '8', 51, 0, 0),
(214, 'Episode 5', 44, '44', '5.0', '1968-09-07', '24:10', '6', 53, 0, 0),
(215, 'Episode 1', 45, '45', '1.0', '1968-09-14', '21:27', '7', 51, 0, 0),
(216, 'Episode 2', 45, '45', '2.0', '1968-09-21', '21:39', '7', 49, 0, 0),
(217, 'Episode 3', 45, '45', '3.0', '1968-09-28', '19:29', '7', 53, 0, 0),
(218, 'Episode 4', 45, '45', '4.0', '1968-10-05', '19:14', '7', 56, 0, 0),
(219, 'Episode 5', 45, '45', '5.0', '1968-10-12', '18:00', '7', 49, 0, 0),
(220, 'Episode 1', 46, '46', '1.0', '1968-11-02', '24:32', '7', 55, 1, 0),
(221, 'Episode 2', 46, '46', '2.0', '1968-11-09', '24:26', '7', 53, 0, 0),
(222, 'Episode 3', 46, '46', '3.0', '1968-11-16', '23:44', '7', 54, 0, 0),
(223, 'Episode 4', 46, '46', '4.0', '1968-11-23', '24:18', '6', 51, 1, 0),
(224, 'Episode 5', 46, '46', '5.0', '1968-11-30', '23:25', '7', 52, 0, 0),
(225, 'Episode 6', 46, '46', '6.0', '1968-12-07', '23:20', '7', 56, 0, 0),
(226, 'Episode 7', 46, '46', '7.0', '1968-12-14', '24:46', '7', 55, 0, 0),
(227, 'Episode 8', 46, '46', '8.0', '1968-12-21', '25:03', '7', 53, 0, 0),
(228, 'Episode 1', 47, '47', '1.0', '1968-12-28', '23:00', '9', 59, 0, 0),
(229, 'Episode 2', 47, '47', '2.0', '1969-01-04', '23:03', '8', 57, 0, 0),
(230, 'Episode 3', 47, '47', '3.0', '1969-01-11', '21:47', '8', 56, 0, 0),
(231, 'Episode 4', 47, '47', '4.0', '1969-01-18', '22:39', '7', 55, 0, 0),
(232, 'Episode 1', 48, '48', '1.0', '1969-01-25', '23:11', '7', 57, 0, 0),
(233, 'Episode 2', 48, '48', '2.0', '1969-02-01', '24:26', '7', 59, 0, 0),
(234, 'Episode 3', 48, '48', '3.0', '1969-02-08', '24:10', '8', 55, 0, 0),
(235, 'Episode 4', 48, '48', '4.0', '1969-02-15', '24:57', '7', 55, 0, 0),
(236, 'Episode 5', 48, '48', '5.0', '1969-02-22', '24:56', '8', 57, 0, 0),
(237, 'Episode 6', 48, '48', '6.0', '1969-03-01', '24:31', '8', 59, 0, 0),
(238, 'Episode 1', 49, '49', '1.0', '1969-03-08', '24:11', '6', 57, 1, 0),
(239, 'Episode 2', 49, '49', '2.0', '1969-03-15', '25:02', '7', 52, 0, 0),
(240, 'Episode 3', 49, '49', '3.0', '1969-03-22', '23:50', '6', 55, 1, 0),
(241, 'Episode 4', 49, '49', '4.0', '1969-03-29', '22:25', '6', 53, 1, 0),
(242, 'Episode 5', 49, '49', '5.0', '1969-04-05', '24:44', '6', 56, 1, 0),
(243, 'Episode 6', 49, '49', '6.0', '1969-04-12', '24:26', '5', 52, 1, 0),
(244, 'Episode 1', 50, '50', '1.0', '1969-04-19', '25:00', '6', 55, 0, 0),
(245, 'Episode 2', 50, '50', '2.0', '1969-04-26', '25:00', '6', 54, 0, 0),
(246, 'Episode 3', 50, '50', '3.0', '1969-05-03', '24:30', '5', 53, 0, 0),
(247, 'Episode 4', 50, '50', '4.0', '1969-05-10', '23:30', '6', 50, 0, 0),
(248, 'Episode 5', 50, '50', '5.0', '1969-05-17', '24:30', '5', 53, 0, 0),
(249, 'Episode 6', 50, '50', '6.0', '1969-05-24', '22:53', '4', 53, 0, 0),
(250, 'Episode 7', 50, '50', '7.0', '1969-05-31', '22:28', '5', 53, 0, 0),
(251, 'Episode 8', 50, '50', '8.0', '1969-06-07', '24:37', '4', 53, 0, 0),
(252, 'Episode 9', 50, '50', '9.0', '1969-06-14', '24:34', '4', 57, 0, 0),
(253, 'Episode 10', 50, '50', '10.0', '1969-06-21', '24:23', '5', 58, 0, 0),
(254, 'Episode 1', 51, '51', '1.0', '1970-01-03', '23:38', '8', 54, 0, 0),
(255, 'Episode 2', 51, '51', '2.0', '1970-01-10', '24:21', '8', NULL, 0, 0),
(256, 'Episode 3', 51, '51', '3.0', '1970-01-17', '24:16', '8', NULL, 0, 0),
(257, 'Episode 4', 51, '51', '4.0', '1970-01-24', '24:47', '8', 57, 0, 0),
(258, 'Episode 1', 52, '52', '1.0', '1970-01-31', '24:15', '9', 58, 0, 0),
(259, 'Episode 2', 52, '52', '2.0', '1970-02-07', '23:08', '7', 58, 0, 0),
(260, 'Episode 3', 52, '52', '3.0', '1970-02-14', '23:16', '8', 57, 0, 0),
(261, 'Episode 4', 52, '52', '4.0', '1970-02-21', '25:00', '8', 60, 0, 0),
(262, 'Episode 5', 52, '52', '5.0', '1970-02-28', '23:58', '8', 58, 0, 0),
(263, 'Episode 6', 52, '52', '6.0', '1970-03-07', '24:15', '7', 57, 0, 0),
(264, 'Episode 7', 52, '52', '7.0', '1970-03-14', '22:55', '8', 58, 0, 0),
(265, 'Episode 1', 53, '53', '1.0', '1970-03-21', '24:33', '7', 60, 0, 0),
(266, 'Episode 2', 53, '53', '2.0', '1970-03-28', '24:39', '8', 61, 0, 0),
(267, 'Episode 3', 53, '53', '3.0', '1970-04-04', '24:38', '8', 59, 0, 0),
(268, 'Episode 4', 53, '53', '4.0', '1970-04-11', '24:37', '9', 58, 0, 0),
(269, 'Episode 5', 53, '53', '5.0', '1970-04-18', '24:17', '7', NULL, 0, 0),
(270, 'Episode 6', 53, '53', '6.0', '1970-04-25', '24:31', '7', 61, 0, 0),
(271, 'Episode 7', 53, '53', '7.0', '1970-05-02', '24:32', '6', 62, 0, 0),
(272, 'Episode 1', 54, '54', '1.0', '1970-05-09', '23:21', '6', 61, 0, 0),
(273, 'Episode 2', 54, '54', '2.0', '1970-05-16', '22:04', '6', 61, 0, 0),
(274, 'Episode 3', 54, '54', '3.0', '1970-05-23', '24:34', '5', 60, 0, 0),
(275, 'Episode 4', 54, '54', '4.0', '1970-05-30', '24:57', '6', 60, 0, 0),
(276, 'Episode 5', 54, '54', '5.0', '1970-06-06', '23:42', '5', NULL, 0, 0),
(277, 'Episode 6', 54, '54', '6.0', '1970-06-13', '23:32', '7', 58, 0, 0),
(278, 'Episode 7', 54, '54', '7.0', '1970-06-20', '24:33', '6', 60, 0, 0),
(279, 'Episode 1', 55, '55', '1.0', '1971-01-02', '24:36', '7', NULL, 0, 0),
(280, 'Episode 2', 55, '55', '2.0', '1971-01-09', '24:48', '8', NULL, 0, 0),
(281, 'Episode 3', 55, '55', '3.0', '1971-01-16', '23:28', '8', NULL, 0, 0),
(282, 'Episode 4', 55, '55', '4.0', '1971-01-23', '22:10', '8', NULL, 0, 0),
(283, 'Episode 1', 56, '56', '1.0', '1971-01-30', '24:39', '6', NULL, 0, 0),
(284, 'Episode 2', 56, '56', '2.0', '1971-02-06', '24:31', '9', NULL, 0, 0),
(285, 'Episode 3', 56, '56', '3.0', '1971-02-13', '24:30', '8', NULL, 0, 0),
(286, 'Episode 4', 56, '56', '4.0', '1971-02-20', '24:40', '7', NULL, 0, 0),
(287, 'Episode 5', 56, '56', '5.0', '1971-02-27', '23:34', '8', NULL, 0, 0),
(288, 'Episode 6', 56, '56', '6.0', '1971-03-06', '24:48', '7', NULL, 0, 0),
(289, 'Episode 1', 57, '57', '1.0', '1971-03-13', '23:51', '7', NULL, 0, 0),
(290, 'Episode 2', 57, '57', '2.0', '1971-03-20', '24:00', '8', NULL, 0, 0),
(291, 'Episode 3', 57, '57', '3.0', '1971-03-27', '24:05', '6', NULL, 0, 0),
(292, 'Episode 4', 57, '57', '4.0', '1971-04-03', '25:16', '8', NULL, 0, 0),
(293, 'Episode 1', 58, '58', '1.0', '1971-04-10', '24:19', '8', NULL, 0, 0),
(294, 'Episode 2', 58, '58', '2.0', '1971-04-17', '22:43', '9', NULL, 0, 0),
(295, 'Episode 3', 58, '58', '3.0', '1971-04-24', '23:47', '10', NULL, 0, 0),
(296, 'Episode 4', 58, '58', '4.0', '1971-05-01', '24:20', '8', NULL, 0, 0),
(297, 'Episode 5', 58, '58', '5.0', '1971-05-08', '25:22', '9', NULL, 0, 0),
(298, 'Episode 6', 58, '58', '6.0', '1971-05-15', '25:22', '9', NULL, 0, 0),
(299, 'Episode 1', 59, '59', '1.0', '1971-05-22', '25:05', '9', NULL, 0, 0),
(300, 'Episode 2', 59, '59', '2.0', '1971-05-29', '24:20', '8', NULL, 0, 0),
(301, 'Episode 3', 59, '59', '3.0', '1971-06-05', '24:27', '8', NULL, 0, 0),
(302, 'Episode 4', 59, '59', '4.0', '1971-06-12', '24:25', '8', NULL, 0, 0),
(303, 'Episode 5', 59, '59', '5.0', '1971-06-19', '24:04', '8', NULL, 0, 0),
(304, 'Episode 1', 60, '60', '1.0', '1972-01-01', '23:36', '10', NULL, 0, 0),
(305, 'Episode 2', 60, '60', '2.0', '1972-01-08', '23:52', '10', NULL, 0, 0),
(306, 'Episode 3', 60, '60', '3.0', '1972-01-15', '24:18', '9', NULL, 0, 0),
(307, 'Episode 4', 60, '60', '4.0', '1972-01-22', '24:17', '9', NULL, 0, 0),
(308, 'Episode 1', 61, '61', '1.0', '1972-01-29', '24:32', '10', NULL, 0, 0),
(309, 'Episode 2', 61, '61', '2.0', '1972-02-05', '24:33', '11', NULL, 0, 0),
(310, 'Episode 3', 61, '61', '3.0', '1972-02-12', '24:21', '8', NULL, 0, 0),
(311, 'Episode 4', 61, '61', '4.0', '1972-02-19', '24:16', '8', NULL, 0, 0),
(312, 'Episode 1', 62, '62', '1.0', '1972-02-26', '24:40', '6', NULL, 0, 0),
(313, 'Episode 2', 62, '62', '2.0', '1972-03-04', '24:30', '10', NULL, 0, 0),
(314, 'Episode 3', 62, '62', '3.0', '1972-03-11', '24:05', '8', NULL, 0, 0),
(315, 'Episode 4', 62, '62', '4.0', '1972-03-18', '24:21', '8', NULL, 0, 0),
(316, 'Episode 5', 62, '62', '5.0', '1972-03-25', '24:53', '8', NULL, 0, 0),
(317, 'Episode 6', 62, '62', '6.0', '1972-04-01', '25:24', '9', NULL, 0, 0),
(318, 'Episode 1', 63, '63', '1.0', '1972-04-08', '24:25', '9', NULL, 0, 0),
(319, 'Episode 2', 63, '63', '2.0', '1972-04-15', '24:24', '8', NULL, 0, 0),
(320, 'Episode 3', 63, '63', '3.0', '1972-04-22', '24:32', '8', NULL, 0, 0),
(321, 'Episode 4', 63, '63', '4.0', '1972-04-29', '24:00', '8', NULL, 0, 0),
(322, 'Episode 5', 63, '63', '5.0', '1972-05-06', '24:37', '8', NULL, 0, 0),
(323, 'Episode 6', 63, '63', '6.0', '1972-05-13', '23:43', '7', NULL, 0, 0),
(324, 'Episode 1', 64, '64', '1.0', '1972-05-20', '25:04', '8', NULL, 0, 0),
(325, 'Episode 2', 64, '64', '2.0', '1972-05-27', '25:05', '7', NULL, 0, 0),
(326, 'Episode 3', 64, '64', '3.0', '1972-06-03', '23:59', '8', NULL, 0, 0),
(327, 'Episode 4', 64, '64', '4.0', '1972-06-10', '23:55', '8', NULL, 0, 0),
(328, 'Episode 5', 64, '64', '5.0', '1972-06-17', '24:29', '6', NULL, 0, 0),
(329, 'Episode 6', 64, '64', '6.0', '1972-06-24', '24:55', '8', NULL, 0, 0),
(330, 'Episode 1', 65, '65', '1.0', '1972-12-30', '24:39', '10', NULL, 0, 0),
(331, 'Episode 2', 65, '65', '2.0', '1973-01-06', '24:18', '11', NULL, 0, 0),
(332, 'Episode 3', 65, '65', '3.0', '1973-01-13', '24:22', '9', NULL, 0, 0),
(333, 'Episode 4', 65, '65', '4.0', '1973-01-20', '25:07', '12', NULL, 0, 0),
(334, 'Episode 1', 66, '66', '1.0', '1973-01-27', '24:46', '10', NULL, 0, 0),
(335, 'Episode 2', 66, '66', '2.0', '1973-02-03', '24:11', '9', NULL, 0, 0),
(336, 'Episode 3', 66, '66', '3.0', '1973-02-10', '24:49', '9', NULL, 0, 0),
(337, 'Episode 4', 66, '66', '4.0', '1973-02-17', '24:10', '9', NULL, 0, 0),
(338, 'Episode 1', 67, '67', '1.0', '1973-02-24', '23:27', '9', NULL, 0, 0),
(339, 'Episode 2', 67, '67', '2.0', '1973-03-03', '24:10', '8', NULL, 0, 0),
(340, 'Episode 3', 67, '67', '3.0', '1973-03-10', '24:00', '8', NULL, 0, 0),
(341, 'Episode 4', 67, '67', '4.0', '1973-03-17', '23:35', '7', NULL, 0, 0),
(342, 'Episode 5', 67, '67', '5.0', '1973-03-24', '23:57', '8', NULL, 0, 0),
(343, 'Episode 6', 67, '67', '6.0', '1973-03-31', '24:44', '9', NULL, 0, 0),
(344, 'Episode 1', 68, '68', '1.0', '1973-04-07', '24:51', '11', NULL, 0, 0),
(345, 'Episode 2', 68, '68', '2.0', '1973-04-14', '24:08', '11', NULL, 0, 0),
(346, 'Episode 3', 68, '68', '3.0', '1973-04-21', '22:34', '10', NULL, 0, 0),
(347, 'Episode 4', 68, '68', '4.0', '1973-04-28', '23:36', '8', NULL, 0, 0),
(348, 'Episode 5', 68, '68', '5.0', '1973-05-05', '22:31', '10', NULL, 0, 0),
(349, 'Episode 6', 68, '68', '6.0', '1973-05-12', '23:02', '9', NULL, 0, 0),
(350, 'Episode 1', 69, '69', '1.0', '1973-05-19', '25:55', '9', NULL, 0, 0),
(351, 'Episode 2', 69, '69', '2.0', '1973-05-26', '25:56', '7', NULL, 0, 0),
(352, 'Episode 3', 69, '69', '3.0', '1973-06-02', '25:12', '8', NULL, 0, 0),
(353, 'Episode 4', 69, '69', '4.0', '1973-06-09', '25:47', '7', NULL, 0, 0),
(354, 'Episode 5', 69, '69', '5.0', '1973-06-16', '25:20', '8', NULL, 0, 0),
(355, 'Episode 6', 69, '69', '6.0', '1973-06-23', '26:06', '7', NULL, 0, 0),
(356, 'Part One', 70, '70', '1.0', '1973-12-15', '24:15', '9', 59, 0, 0),
(357, 'Part Two', 70, '70', '2.0', '1973-12-22', '24:10', '7', NULL, 0, 0),
(358, 'Part Three', 70, '70', '3.0', '1973-12-29', '23:30', '7', NULL, 0, 0),
(359, 'Part Four', 70, '70', '4.0', '1974-01-05', '24:57', '11', 60, 0, 0),
(360, 'Part One', 71, '71', '1.0', '1974-01-12', '25:29', '11', 62, 0, 0),
(361, 'Part Two', 71, '71', '2.0', '1974-01-19', '24:43', '10', NULL, 0, 0),
(362, 'Part Three', 71, '71', '3.0', '1974-01-26', '23:26', '11', 63, 0, 0),
(363, 'Part Four', 71, '71', '4.0', '1974-02-02', '23:33', '9', NULL, 0, 0),
(364, 'Part Five', 71, '71', '5.0', '1974-02-09', '24:30', '9', NULL, 0, 0),
(365, 'Part Six', 71, '71', '6.0', '1974-02-16', '25:34', '8', 62, 0, 0),
(366, 'Part One', 72, '72', '1.0', '1974-02-23', '24:32', '8', 61, 0, 0),
(367, 'Part Two', 72, '72', '2.0', '1974-03-02', '24:25', '10', NULL, 0, 0),
(368, 'Part Three', 72, '72', '3.0', '1974-03-09', '24:24', '11', 61, 0, 0),
(369, 'Part Four', 72, '72', '4.0', '1974-03-16', '24:35', '10', 62, 0, 0),
(370, 'Part One', 73, '73', '1.0', '1974-03-23', '24:59', '9', NULL, 0, 0),
(371, 'Part Two', 73, '73', '2.0', '1974-03-30', '23:26', '7', NULL, 0, 0),
(372, 'Part Three', 73, '73', '3.0', '1974-04-06', '24:47', '7', NULL, 0, 0),
(373, 'Part Four', 73, '73', '4.0', '1974-04-13', '24:50', '7', NULL, 0, 0),
(374, 'Part Five', 73, '73', '5.0', '1974-04-20', '23:56', '8', NULL, 0, 0),
(375, 'Part Six', 73, '73', '6.0', '1974-04-27', '23:48', '8', NULL, 0, 0),
(376, 'Part One', 74, '74', '1.0', '1974-05-04', '24:40', '10', NULL, 0, 0),
(377, 'Part Two', 74, '74', '2.0', '1974-05-11', '25:02', '9', NULL, 0, 0),
(378, 'Part Three', 74, '74', '3.0', '1974-05-18', '24:58', '9', NULL, 0, 0),
(379, 'Part Four', 74, '74', '4.0', '1974-05-25', '23:53', '8', NULL, 0, 0),
(380, 'Part Five', 74, '74', '5.0', '1974-06-01', '24:01', '9', NULL, 0, 0),
(381, 'Part Six', 74, '74', '6.0', '1974-06-08', '24:43', '9', NULL, 0, 0),
(382, 'Part One', 75, '75', '1.0', '1974-12-28', '24:11', '11', 53, 0, 0),
(383, 'Part Two', 75, '75', '2.0', '1975-01-04', '25:00', '11', 53, 0, 0),
(384, 'Part Three', 75, '75', '3.0', '1975-01-11', '24:29', '10', NULL, 0, 0),
(385, 'Part Four', 75, '75', '4.0', '1975-01-18', '24:29', '9', 51, 0, 0),
(386, 'Part One', 76, '76', '1.0', '1975-01-25', '24:58', '9', NULL, 0, 0),
(387, 'Part Two', 76, '76', '2.0', '1975-02-01', '24:49', '14', NULL, 0, 0),
(388, 'Part Three', 76, '76', '3.0', '1975-02-08', '24:05', '11', NULL, 0, 0),
(389, 'Part Four', 76, '76', '4.0', '1975-02-15', '24:37', '10', NULL, 0, 0),
(390, 'Part One', 77, '77', '1.0', '1975-02-22', '24:27', '11', NULL, 0, 0),
(391, 'Part Two', 77, '77', '2.0', '1975-03-01', '25:00', '11', 55, 0, 0),
(392, 'Part One', 78, '78', '1.0', '1975-03-08', '24:30', '11', NULL, 0, 0),
(393, 'Part Two', 78, '78', '2.0', '1975-03-15', '24:51', '11', 57, 0, 0),
(394, 'Part Three', 78, '78', '3.0', '1975-03-22', '22:38', '9', NULL, 0, 0),
(395, 'Part Four', 78, '78', '4.0', '1975-03-29', '23:38', '9', 58, 0, 0),
(396, 'Part Five', 78, '78', '5.0', '1975-04-05', '23:27', '10', 57, 0, 0),
(397, 'Part Six', 78, '78', '6.0', '1975-04-12', '23:30', '9', 56, 0, 0),
(398, 'Part One', 79, '79', '1.0', '1975-04-19', '24:19', '10', 57, 0, 0),
(399, 'Part Two', 79, '79', '2.0', '1975-04-26', '24:24', '8', NULL, 0, 0),
(400, 'Part Three', 79, '79', '3.0', '1975-05-03', '24:32', '9', NULL, 0, 0),
(401, 'Part Four', 79, '79', '4.0', '1975-05-10', '23:21', '9', 58, 0, 0),
(402, 'Part One', 80, '80', '1.0', '1975-08-30', '21:41', '8', 59, 0, 0),
(403, 'Part Two', 80, '80', '2.0', '1975-09-06', '25:08', '6', NULL, 0, 0),
(404, 'Part Three', 80, '80', '3.0', '1975-09-13', '24:09', '8', 54, 0, 0),
(405, 'Part Four', 80, '80', '4.0', '1975-09-20', '25:22', '7', NULL, 0, 0),
(406, 'Part One', 81, '81', '1.0', '1975-09-27', '24:02', '10', NULL, 0, 0),
(407, 'Part Two', 81, '81', '2.0', '1975-10-04', '22:30', '10', 56, 0, 0),
(408, 'Part Three', 81, '81', '3.0', '1975-10-11', '23:50', '9', 57, 0, 0),
(409, 'Part Four', 81, '81', '4.0', '1975-10-18', '23:43', '10', 54, 0, 0),
(410, 'Part One', 82, '82', '1.0', '1975-10-25', '25:22', '11', NULL, 0, 0),
(411, 'Part Two', 82, '82', '2.0', '1975-11-01', '23:53', '11', NULL, 0, 0),
(412, 'Part Three', 82, '82', '3.0', '1975-11-08', '24:32', '9', NULL, 0, 0),
(413, 'Part Four', 82, '82', '4.0', '1975-11-15', '24:52', '12', 60, 0, 0),
(414, 'Part One', 83, '83', '1.0', '1975-11-22', '24:21', '12', 58, 0, 0),
(415, 'Part Two', 83, '83', '2.0', '1975-11-29', '24:30', '11', NULL, 0, 0),
(416, 'Part Three', 83, '83', '3.0', '1975-12-06', '24:50', '12', NULL, 0, 0),
(417, 'Part Four', 83, '83', '4.0', '1975-12-13', '24:30', '11', NULL, 0, 0),
(418, 'Part One', 84, '84', '1.0', '1976-01-03', '25:25', '10', NULL, 0, 0),
(419, 'Part Two', 84, '84', '2.0', '1976-01-10', '24:46', '9', NULL, 0, 0),
(420, 'Part Three', 84, '84', '3.0', '1976-01-17', '25:07', '10', NULL, 0, 0),
(421, 'Part Four', 84, '84', '4.0', '1976-01-24', '24:18', '10', 60, 0, 0),
(422, 'Part One', 85, '85', '1.0', '1976-01-31', '24:10', '11', 59, 0, 0),
(423, 'Part Two', 85, '85', '2.0', '1976-02-07', '24:09', '11', NULL, 0, 0),
(424, 'Part Three', 85, '85', '3.0', '1976-02-14', '24:51', '10', NULL, 0, 0),
(425, 'Part Four', 85, '85', '4.0', '1976-02-21', '24:26', '11', NULL, 0, 0),
(426, 'Part Five', 85, '85', '5.0', '1976-02-28', '25:06', '10', NULL, 0, 0),
(427, 'Part Six', 85, '85', '6.0', '1976-03-06', '21:51', '12', NULL, 0, 0),
(428, 'Part One', 86, '86', '1.0', '1976-09-04', '24:31', '8', 58, 0, 0),
(429, 'Part Two', 86, '86', '2.0', '1976-09-11', '24:44', '10', 56, 0, 0),
(430, 'Part Three', 86, '86', '3.0', '1976-09-18', '24:34', '9', NULL, 0, 0),
(431, 'Part Four', 86, '86', '4.0', '1976-09-25', '24:45', '11', 56, 0, 0),
(432, 'Part One', 87, '87', '1.0', '1976-10-02', '24:50', '11', NULL, 0, 0),
(433, 'Part Two', 87, '87', '2.0', '1976-10-09', '24:48', '10', NULL, 0, 0),
(434, 'Part Three', 87, '87', '3.0', '1976-10-16', '24:22', '11', 62, 0, 0),
(435, 'Part Four', 87, '87', '4.0', '1976-10-23', '25:00', '12', NULL, 0, 0),
(436, 'Part One', 88, '88', '1.0', '1976-10-30', '21:13', '12', NULL, 0, 0),
(437, 'Part Two', 88, '88', '2.0', '1976-11-06', '24:44', '12', 59, 0, 0),
(438, 'Part Three', 88, '88', '3.0', '1976-11-13', '24:24', '13', NULL, 0, 0),
(439, 'Part Four', 88, '88', '4.0', '1976-11-20', '24:23', '12', 61, 0, 0),
(440, 'Part One', 89, '89', '1.0', '1977-01-01', '24:58', '11', 61, 0, 0),
(441, 'Part Two', 89, '89', '2.0', '1977-01-08', '24:58', '11', NULL, 0, 0),
(442, 'Part Three', 89, '89', '3.0', '1977-01-15', '24:40', '11', 59, 0, 0),
(443, 'Part Four', 89, '89', '4.0', '1977-01-22', '24:46', '12', 60, 0, 0),
(444, 'Part One', 90, '90', '1.0', '1977-01-29', '24:06', '13', 62, 0, 0),
(445, 'Part Two', 90, '90', '2.0', '1977-02-05', '24:15', '12', NULL, 0, 0),
(446, 'Part Three', 90, '90', '3.0', '1977-02-12', '23:51', '13', NULL, 0, 0),
(447, 'Part Four', 90, '90', '4.0', '1977-02-19', '23:42', '13', 57, 0, 0),
(448, 'Part One', 91, '91', '1.0', '1977-02-26', '24:44', '11', NULL, 0, 0),
(449, 'Part Two', 91, '91', '2.0', '1977-03-05', '24:26', '10', NULL, 0, 0),
(450, 'Part Three', 91, '91', '3.0', '1977-03-12', '21:56', '10', NULL, 0, 0),
(451, 'Part Four', 91, '91', '4.0', '1977-03-19', '24:30', '11', 60, 0, 0),
(452, 'Part Five', 91, '91', '5.0', '1977-03-26', '24:49', '10', NULL, 0, 0),
(453, 'Part Six', 91, '91', '6.0', '1977-04-02', '23:26', '9', 58, 0, 0),
(454, 'Part One', 92, '92', '1.0', '1977-09-03', '24:10', '7', 58, 0, 0),
(455, 'Part Two', 92, '92', '2.0', '1977-09-10', '24:10', '7', NULL, 0, 0),
(456, 'Part Three', 92, '92', '3.0', '1977-09-17', '23:12', '10', 60, 0, 0),
(457, 'Part Four', 92, '92', '4.0', '1977-09-24', '23:49', '10', 57, 0, 0),
(458, 'Part One', 93, '93', '1.0', '1977-10-01', '23:09', '9', NULL, 0, 0),
(459, 'Part Two', 93, '93', '2.0', '1977-10-08', '25:13', '7', NULL, 0, 0),
(460, 'Part Three', 93, '93', '3.0', '1977-10-15', '23:28', '8', NULL, 0, 0),
(461, 'Part Four', 93, '93', '4.0', '1977-10-22', '21:22', '8', NULL, 60, 0),
(462, 'Part One', 94, '94', '1.0', '1977-10-29', '24:38', '7', NULL, 0, 0),
(463, 'Part Two', 94, '94', '2.0', '1977-11-05', '24:44', '8', NULL, 0, 0),
(464, 'Part Three', 94, '94', '3.0', '1977-11-12', '24:22', '8', NULL, 0, 0),
(465, 'Part Four', 94, '94', '4.0', '1977-11-19', '20:32', '9', 61, 0, 0),
(466, 'Part One', 95, '95', '1.0', '1977-11-26', '24:59', '9', NULL, 0, 0),
(467, 'Part Two', 95, '95', '2.0', '1977-12-03', '24:57', '10', NULL, 0, 0),
(468, 'Part Three', 95, '95', '3.0', '1977-12-10', '24:57', '9', 68, 0, 0),
(469, 'Part Four', 95, '95', '4.0', '1977-12-17', '24:57', '8', 59, 0, 0),
(470, 'Part One', 96, '96', '1.0', '1978-01-07', '22:36', '9', 65, 0, 0),
(471, 'Part Two', 96, '96', '2.0', '1978-01-14', '21:27', '9', NULL, 0, 0),
(472, 'Part Three', 96, '96', '3.0', '1978-01-21', '22:21', '9', NULL, 0, 0),
(473, 'Part Four', 96, '96', '4.0', '1978-01-28', '22:53', '12', NULL, 0, 0),
(474, 'Part One', 97, '97', '1.0', '1978-02-04', '25:00', '11', 56, 0, 0),
(475, 'Part Two', 97, '97', '2.0', '1978-02-11', '25:00', '11', NULL, 0, 0),
(476, 'Part Three', 97, '97', '3.0', '1978-02-18', '25:00', '10', NULL, 0, 0),
(477, 'Part Four', 97, '97', '4.0', '1978-02-25', '23:31', '11', NULL, 0, 0),
(478, 'Part Five', 97, '97', '5.0', '1978-03-04', '25:00', '10', NULL, 0, 0),
(479, 'Part Six', 97, '97', '6.0', '1978-03-11', '25:44', '10', NULL, 0, 0),
(480, 'Part One', 98, '98', '1.0', '1978-09-02', '25:02', '8', 59, 0, 0),
(481, 'Part Two', 98, '98', '2.0', '1978-09-09', '24:46', '8', NULL, 0, 0),
(482, 'Part Three', 98, '98', '3.0', '1978-09-16', '24:42', '8', NULL, 0, 0),
(483, 'Part Four', 98, '98', '4.0', '1978-09-23', '24:50', '8', 67, 0, 0),
(484, 'Part One', 99, '99', '1.0', '1978-09-30', '25:05', '9', 61, 0, 0),
(485, 'Part Two', 99, '99', '2.0', '1978-10-07', '25:30', '7', NULL, 0, 0),
(486, 'Part Three', 99, '99', '3.0', '1978-10-14', '25:47', '8', 64, 0, 0),
(487, 'Part Four', 99, '99', '4.0', '1978-10-21', '25:16', '8', 64, 0, 0),
(488, 'Part One', 100, '100', '1.0', '1978-10-28', '24:20', '9', NULL, 0, 0),
(489, 'Part Two', 100, '100', '2.0', '1978-11-04', '23:53', '7', NULL, 0, 0),
(490, 'Part Three', 100, '100', '3.0', '1978-11-11', '24:27', '9', NULL, 0, 0),
(491, 'Part Four', 100, '100', '4.0', '1978-11-18', '23:07', '8', 67, 0, 0),
(492, 'Part One', 101, '101', '1.0', '1978-11-25', '24:53', '10', NULL, 0, 0),
(493, 'Part Two', 101, '101', '2.0', '1978-12-02', '24:27', '10', 65, 0, 0),
(494, 'Part Three', 101, '101', '3.0', '1978-12-09', '23:52', '9', NULL, 0, 0),
(495, 'Part Four', 101, '101', '4.0', '1978-12-16', '24:49', '9', 66, 0, 0),
(496, 'Part One', 102, '102', '1.0', '1978-12-23', '23:16', '7', NULL, 0, 0),
(497, 'Part Two', 102, '102', '2.0', '1978-12-30', '23:57', '12', NULL, 0, 0),
(498, 'Part Three', 102, '102', '3.0', '1979-01-06', '21:56', '9', NULL, 0, 0),
(499, 'Part Four', 102, '102', '4.0', '1979-01-13', '21:58', '10', 63, 0, 0),
(500, 'Part One', 103, '103', '1.0', '1979-01-20', '24:39', '8', 65, 0, 0),
(501, 'Part Two', 103, '103', '2.0', '1979-01-27', '23:56', '9', NULL, 0, 0),
(502, 'Part Three', 103, '103', '3.0', '1979-02-03', '25:03', '8', NULL, 0, 0),
(503, 'Part Four', 103, '103', '4.0', '1979-02-10', '25:09', '9', NULL, 0, 0),
(504, 'Part Five', 103, '103', '5.0', '1979-02-17', '24:42', '9', NULL, 0, 0),
(505, 'Part Six', 103, '103', '6.0', '1979-02-24', '25:09', '10', 66, 0, 0),
(506, 'Episode One', 104, '104', '1.0', '1979-09-01', '24:03', '13', 67, 0, 0),
(507, 'Episode Two', 104, '104', '2.0', '1979-09-08', '25:14', '13', NULL, 0, 0),
(508, 'Episode Three', 104, '104', '3.0', '1979-09-15', '24:32', '14', 63, 0, 0),
(509, 'Episode Four', 104, '104', '4.0', '1979-09-22', '26:05', '14', 64, 0, 0),
(510, 'Part One', 105, '105', '1.0', '1979-09-29', '24:25', '12', NULL, 0, 0),
(511, 'Part Two', 105, '105', '2.0', '1979-10-06', '24:33', '14', 64, 0, 0),
(512, 'Part Three', 105, '105', '3.0', '1979-10-13', '25:25', '15', NULL, 0, 0),
(513, 'Part Four', 105, '105', '4.0', '1979-10-20', '25:08', '16', 64, 0, 0),
(514, 'Part One', 106, '106', '1.0', '1979-10-27', '23:32', '9', NULL, 0, 0),
(515, 'Part Two', 106, '106', '2.0', '1979-11-03', '24:03', '11', 67, 0, 0),
(516, 'Part Three', 106, '106', '3.0', '1979-11-10', '23:55', '10', NULL, 0, 0),
(517, 'Part Four', 106, '106', '4.0', '1979-11-17', '24:07', '10', NULL, 0, 0),
(518, 'Part One', 107, '107', '1.0', '1979-11-24', '24:17', '9', NULL, 0, 0),
(519, 'Part Two', 107, '107', '2.0', '1979-12-01', '22:44', '10', NULL, 0, 0),
(520, 'Part Three', 107, '107', '3.0', '1979-12-08', '24:06', '10', NULL, 0, 0),
(521, 'Part Four', 107, '107', '4.0', '1979-12-15', '24:31', '9', 65, 0, 0),
(522, 'Part One', 108, '108', '1.0', '1979-12-22', '25:41', '6', NULL, 0, 0),
(523, 'Part Two', 108, '108', '2.0', '1979-12-29', '25:00', '9', NULL, 0, 0),
(524, 'Part Three', 108, '108', '3.0', '1980-01-05', '23:26', '10', NULL, 0, 0),
(525, 'Part Four', 108, '108', '4.0', '1980-01-12', '26:45', '10', 67, 0, 0),
(526, 'Part One', 109, '', '1.0', '', '24:34', NULL, NULL, 0, 0),
(527, 'Part Two', 109, '', '2.0', '', '17:56', NULL, NULL, 0, 0),
(528, 'Part Three', 109, '', '3.0', '', '17:29', NULL, NULL, 0, 0),
(529, 'Part Four', 109, '', '4.0', '', '17:43', NULL, NULL, 0, 0),
(530, 'Part Five', 109, '', '5.0', '', '14:11', NULL, NULL, 0, 0),
(531, 'Part Six', 109, '', '6.0', '', '17:43', NULL, NULL, 0, 0),
(532, 'Part One', 110, '109', '1.0', '1980-08-30', '23:33', '6', NULL, 0, 0),
(533, 'Part Two', 110, '109', '2.0', '1980-09-06', '20:45', '5', NULL, 0, 0),
(534, 'Part Three', 110, '109', '3.0', '1980-09-13', '21:21', '5', NULL, 0, 0),
(535, 'Part Four', 110, '109', '4.0', '1980-09-20', '21:19', '5', 65, 0, 0),
(536, 'Part One', 111, '110', '1', '1980-09-27', '24:43', '5', 61, 0, 0),
(537, 'Part Two', 111, '110', '2', '1980-10-04', '21:24', '4', 64, 0, 0),
(538, 'Part Three', 111, '110', '3', '1980-10-11', '21:19', '5', NULL, 0, 0),
(539, 'Part Four', 111, '110', '4', '1980-10-18', '19:30', '5', 63, 0, 0),
(540, 'Part One', 112, '111', '1', '1980-10-25', '24:23', '6', NULL, 0, 0),
(541, 'Part Two', 112, '111', '2', '1980-11-01', '22:11', '4', NULL, 0, 0),
(542, 'Part Three', 112, '111', '3', '1980-11-08', '22:00', '6', NULL, 0, 0),
(543, 'Part Four', 112, '111', '4', '1980-11-15', '24:16', '5', 65, 0, 0),
(544, 'Part One', 113, '112', '1', '1980-11-22', '22:24', '6', NULL, 0, 0),
(545, 'Part Two', 113, '112', '2', '1980-11-29', '23:16', '5', NULL, 0, 0),
(546, 'Part Three', 113, '112', '3', '1980-12-06', '24:13', '4', NULL, 0, 0),
(547, 'Part Four', 113, '112', '4', '1980-12-13', '24:54', '5', 69, 0, 0),
(548, 'Part One', 114, '113', '1', '1981-01-03', '22:54', '7', 59, 0, 0),
(549, 'Part Two', 114, '113', '2', '1981-01-10', '23:47', '7', NULL, 0, 0),
(550, 'Part Three', 114, '113', '3', '1981-01-17', '22:15', '8', NULL, 0, 0),
(551, 'Part Four', 114, '113', '4', '1981-01-24', '24:53', '8', 59, 0, 0),
(552, 'Part One', 115, '114', '1', '1981-01-31', '24:05', '8', NULL, 0, 0),
(553, 'Part Two', 115, '114', '2', '1981-02-07', '24:50', '6', NULL, 0, 0),
(554, 'Part Three', 115, '114', '3', '1981-02-14', '23:49', '5', NULL, 0, 0),
(555, 'Part Four', 115, '114', '4', '1981-02-21', '25:11', '6', 63, 0, 0),
(556, 'Part One', 116, '115', '1', '1981-02-28', '24:32', '8', NULL, 0, 0),
(557, 'Part Two', 116, '115', '2', '1981-03-07', '24:03', '8', 61, 0, 0),
(558, 'Part Three', 116, '115', '3', '1981-03-14', '24:32', '6', NULL, 0, 0),
(559, 'Part Four', 116, '115', '4', '1981-03-21', '25:10', '6', 65, 0, 0),
(560, 'Part One', 117, '116', '1', '1982-01-04', '24:14', '9', NULL, 0, 0),
(561, 'Part Two', 117, '116', '2', '1982-01-05', '24:13', '9', NULL, 0, 0),
(562, 'Part Three', 117, '116', '3', '1982-01-11', '23:35', '10', NULL, 0, 0),
(563, 'Part Four', 117, '116', '4', '1982-01-12', '24:12', '10', NULL, 0, 0),
(564, 'Part One', 118, '117', '1', '1982-01-18', '23:36', '8', NULL, 0, 0),
(565, 'Part Two', 118, '117', '2', '1982-01-19', '24:11', '9', NULL, 0, 0),
(566, 'Part Three', 118, '117', '3', '1982-01-25', '24:09', '9', NULL, 0, 0),
(567, 'Part Four', 118, '117', '4', '1982-01-26', '24:53', '9', NULL, 0, 0),
(568, 'Part One', 119, '118', '1', '1982-02-01', '24:50', '8', NULL, 0, 0),
(569, 'Part Two', 119, '118', '2', '1982-02-02', '24:58', '9', NULL, 0, 0),
(570, 'Part Three', 119, '118', '3', '1982-02-08', '24:17', '9', NULL, 0, 0),
(571, 'Part Four', 119, '118', '4', '1982-02-09', '24:28', '9', NULL, 0, 0),
(572, 'Part One', 120, '119', '1', '1982-02-15', '24:11', '9', NULL, 0, 0),
(573, 'Part Two', 120, '119', '2', '1982-02-16', '24:26', '9', NULL, 0, 0),
(574, 'Part Three', 120, '119', '3', '1982-02-22', '24:24', '10', NULL, 0, 0),
(575, 'Part Four', 120, '119', '4', '1982-02-23', '23:32', '10', NULL, 0, 0),
(576, 'Part One', 121, '120', '1', '1982-03-01', '24:56', '10', NULL, 0, 0),
(577, 'Part Two', 121, '120', '2', '1982-03-02', '24:41', '10', NULL, 0, 0),
(578, 'Part One', 122, '121', '1', '1982-03-08', '24:22', '9', NULL, 0, 0),
(579, 'Part Two', 122, '121', '2', '1982-03-09', '24:23', '9', NULL, 0, 0),
(580, 'Part Three', 122, '121', '3', '1982-03-15', '24:24', '10', NULL, 0, 0),
(581, 'Part Four', 122, '121', '4', '1982-03-16', '24:28', '10', NULL, 0, 0),
(582, 'Part One', 123, '122', '1', '1982-03-22', '24:56', '10', NULL, 0, 0),
(583, 'Part Two', 123, '122', '2', '1982-03-23', '23:58', '9', NULL, 0, 0),
(584, 'Part Three', 123, '122', '3', '1982-03-29', '24:29', '9', NULL, 0, 0),
(585, 'Part Four', 123, '122', '4', '1982-03-30', '24:30', '8', NULL, 0, 0),
(586, 'Part One', 124, '123', '1', '1983-01-03', '24:37', '7', 69, 0, 0),
(587, 'Part Two', 124, '123', '2', '1983-01-05', '24:42', '7', 70, 0, 0),
(588, 'Part Three', 124, '123', '3', '1983-01-11', '24:37', '7', 67, 0, 0),
(589, 'Part Four', 124, '123', '4', '1983-01-12', '24:28', '7', 66, 0, 0),
(590, 'Part One', 125, '124', '1', '1983-01-18', '24:26', '7', 65, 0, 0),
(591, 'Part Two', 125, '124', '2', '1983-01-19', '24:35', '8', 66, 0, 0),
(592, 'Part Three', 125, '124', '3', '1983-01-25', '24:29', '7', 67, 0, 0),
(593, 'Part Four', 125, '124', '4', '1983-01-26', '24:29', '7', 67, 0, 0),
(594, 'Part One', 126, '125', '1', '1983-02-01', '24:03', '7', 67, 0, 0),
(595, 'Part Two', 126, '125', '2', '1983-02-02', '24:33', '8', 70, 0, 0),
(596, 'Part Three', 126, '125', '3', '1983-02-08', '24:32', '7', 67, 0, 0),
(597, 'Part Four', 126, '125', '4', '1983-02-09', '24:33', '8', 68, 0, 0),
(598, 'Part One', 127, '126', '1', '1983-02-15', '24:58', '7', 65, 0, 0),
(599, 'Part Two', 127, '126', '2', '1983-02-16', '24:40', '8', 67, 0, 0),
(600, 'Part Three', 127, '126', '3', '1983-02-22', '24:39', '7', 64, 0, 0),
(601, 'Part Four', 127, '126', '4', '1983-02-23', '24:49', '7', 67, 0, 0),
(602, 'Part One', 128, '127', '1', '1983-03-01', '24:12', '7', 67, 0, 0),
(603, 'Part Two', 128, '127', '2', '1983-03-02', '24:23', '7', 65, 0, 0),
(604, 'Part Three', 128, '127', '3', '1983-03-08', '24:38', '6', 68, 0, 0),
(605, 'Part Four', 128, '127', '4', '1983-03-09', '24:34', '7', 70, 0, 0),
(606, 'Part One', 129, '128', '1', '1983-03-15', '24:48', '6', 65, 0, 0),
(607, 'Part Two', 129, '128', '2', '1983-03-16', '24:27', '7', 63, 0, 0),
(609, 'The Five Doctors', 130, NULL, '1', '1983-11-25', '90:23', '8', 75, 0, 0),
(610, 'Part One', 131, '130', '1', '1984-01-05', '24:48', '8', 65, 0, 0),
(611, 'Part Two', 131, '130', '2', '1984-01-06', '24:04', '8', 64, 0, 0),
(612, 'Part Three', 131, '130', '3', '1984-01-12', '24:02', '7', 62, 0, 0),
(613, 'Part Four', 131, '130', '4', '1984-01-13', '24:48', '7', 65, 0, 0),
(614, 'Part One', 132, '131', '1', '1984-01-19', '25:18', '8', 65, 0, 0),
(615, 'Part Two', 132, '131', '2', '1984-01-20', '24:47', '7', 63, 0, 0),
(616, 'Part One', 133, '132', '1', '1984-01-26', '24:39', '8', 66, 0, 0),
(617, 'Part Two', 133, '132', '2', '1984-01-27', '24:35', '6', 69, 0, 0),
(618, 'Part Three', 133, '132', '3', '1984-02-02', '24:30', '8', 65, 0, 0),
(619, 'Part Four', 133, '132', '4', '1984-02-03', '24:26', '6', 65, 0, 0),
(620, 'Part One', 134, '133', '1', '1984-02-08', '46:24', '7', 69, 0, 0),
(621, 'Part Two', 134, '133', '2', '1984-02-15', '46:52', '8', 65, 0, 0),
(622, 'Part One', 135, '134', '1', '1984-02-23', '24:26', '7', NULL, 0, 0),
(623, 'Part Two', 135, '134', '2', '1984-02-24', '24:20', '6', NULL, 0, 0),
(624, 'Part Three', 135, '134', '3', '1984-03-01', '23:57', '7', NULL, 0, 0),
(625, 'Part Four', 135, '134', '4', '1984-03-02', '24:44', '7', NULL, 0, 0),
(626, 'Part One', 136, '135', '1', '1984-03-08', '24:33', '7', 65, 0, 0),
(627, 'Part Two', 136, '135', '2', '1984-03-09', '25:00', '7', NULL, 0, 0),
(628, 'Part Three', 136, '135', '3', '1984-03-15', '24:36', '8', 65, 0, 0),
(629, 'Part Four', 136, '135', '4', '1984-03-16', '25:37', '8', 68, 0, 0),
(630, 'Part One', 137, '136', '1', '1984-03-22', '24:42', '8', 61, 0, 0),
(631, 'Part Two', 137, '136', '2', '1984-03-23', '25:09', '7', 66, 0, 0),
(632, 'Part Three', 137, '136', '3', '1984-03-29', '24:27', '7', 59, 0, 0),
(633, 'Part Four', 137, '136', '4', '1984-03-30', '25:04', '6', 67, 0, 0),
(634, 'Part One', 138, '137', '1', '1985-01-05', '44:17', '9', 61, 0, 0),
(635, 'Part Two', 138, '137', '2', '1985-01-12', '44:29', '7', 65, 0, 0),
(636, 'Part One', 139, '138', '1', '1985-01-19', '44:46', '7', 63, 0, 0),
(637, 'Part Two', 139, '138', '2', '1985-01-26', '44:46', '7', 65, 0, 0),
(638, 'Part One', 140, '139', '1', '1985-02-02', '45:01', '6', 64, 0, 0),
(639, 'Part Two', 140, '139', '2', '1985-02-09', '44:32', '7', 64, 0, 0),
(640, 'Part One', 141, '140', '1', '1985-02-16', '44:22', '7', 65, 0, 0),
(641, 'Part Two', 141, '140', '2', '1985-02-23', '44:49', '6', 62, 0, 0),
(642, 'Part Three', 141, '140', '3', '1985-03-02', '44:45', '7', 65, 0, 0),
(643, 'Part One', 142, '141', '1', '1985-03-09', '45:00', '7', 66, 0, 0),
(644, 'Part Two', 142, '141', '2', '1985-03-16', '44:36', '7', 64, 0, 0),
(645, 'Part One', 143, '142', '1', '1985-03-23', '44:31', '7', 67, 0, 0),
(646, 'Part Two', 143, '142', '2', '1985-03-30', '45:27', '8', 65, 0, 0),
(647, 'Part One', 144, '143a', '1', '1986-09-06', '24:57', '5', 72, 0, 0),
(648, 'Part Two', 144, '143a', '2', '1986-09-13', '24:44', '5', 69, 0, 0),
(649, 'Part Three', 144, '143a', '3', '1986-09-20', '24:18', '4', 70, 0, 0),
(650, 'Part Four', 144, '143a', '4', '1986-09-27', '24:20', '4', 72, 0, 0),
(651, 'Part Five', 145, '143b', '1', '1986-10-04', '24:42', '5', 71, 0, 0),
(652, 'Part Six', 145, '143b', '2', '1986-10-11', '24:45', '5', 69, 0, 0),
(653, 'Part Seven', 145, '143b', '3', '1986-10-18', '24:33', '5', 66, 0, 0),
(654, 'Part Eight', 145, '143b', '4', '1986-10-25', '24:44', '5', 72, 0, 0),
(655, 'Part Nine', 146, '143c', '1', '1986-11-01', '24:56', '5', 66, 0, 0),
(656, 'Part Ten', 146, '143c', '2', '1986-11-08', '24:18', '5', 69, 0, 0),
(657, 'Part Eleven', 146, '143c', '3', '1986-11-15', '24:07', '5', 69, 0, 0),
(658, 'Part Twelve', 146, '143c', '4', '1986-11-22', '24:45', '5', 69, 0, 0),
(659, 'Part Thirteen', 147, '143d', '1', '1986-11-29', '24:42', '4', 69, 0, 0),
(660, 'Part Fourteen', 147, '143d', '2', '1986-12-06', '29:30', '6', 69, 0, 0),
(661, 'Part One', 148, '144', '1', '1987-09-07', '24:44', '5', 58, 0, 0),
(662, 'Part Two', 148, '144', '2', '1987-09-14', '24:36', '4', 63, 0, 0),
(663, 'Part Three', 148, '144', '3', '1987-09-21', '24:23', '4', 57, 0, 0),
(664, 'Part Four', 148, '144', '4', '1987-09-28', '24:38', '5', 59, 0, 0),
(665, 'Part One', 149, '145', '1', '1987-10-05', '24:33', '5', 61, 0, 0),
(666, 'Part Two', 149, '145', '2', '1987-10-12', '24:39', '5', 58, 0, 0);
INSERT INTO `episodes` (`id`, `title`, `serial_id`, `story`, `episode_order`, `original_air_date`, `runtime`, `uk_viewers_mm`, `appreciation_index`, `missing`, `recreated`) VALUES
(667, 'Part Three', 149, '145', '3', '1987-10-19', '24:30', '5', 58, 0, 0),
(668, 'Part Four', 149, '145', '4', '1987-10-26', '24:21', '5', 57, 0, 0),
(669, 'Part One', 150, '146', '1', '1987-11-02', '24:47', '5', 63, 0, 0),
(670, 'Part Two', 150, '146', '2', '1987-11-09', '24:23', '5', 60, 0, 0),
(671, 'Part Three', 150, '146', '3', '1987-11-16', '24:22', '5', 60, 0, 0),
(672, 'Part One', 151, '147', '1', '1987-11-23', '24:01', '6', 61, 0, 0),
(673, 'Part Two', 151, '147', '2', '1987-11-30', '24:40', '5', 61, 0, 0),
(674, 'Part Three', 151, '147', '3', '1987-12-07', '24:26', '5', 64, 0, 0),
(675, 'Part One', 152, '148', '1', '1988-10-05', '24:33', '6', 68, 0, 0),
(676, 'Part Two', 152, '148', '2', '1988-10-12', '24:31', '6', 69, 0, 0),
(677, 'Part Three', 152, '148', '3', '1988-10-19', '24:30', '5', 70, 0, 0),
(678, 'Part Four', 152, '148', '4', '1988-10-26', '24:36', '5', 72, 0, 0),
(679, 'Part One', 153, '149', '1', '1988-11-02', '24:51', '5', 67, 0, 0),
(680, 'Part Two', 153, '149', '2', '1988-11-09', '24:48', '5', 65, 0, 0),
(681, 'Part Three', 153, '149', '3', '1988-11-16', '24:25', '5', 65, 0, 0),
(682, 'Part One', 154, '150', '1', '1988-11-23', '24:31', '6', 71, 0, 0),
(683, 'Part Two', 154, '150', '2', '1988-11-30', '24:12', '5', 70, 0, 0),
(684, 'Part Three', 154, '150', '3', '1988-12-07', '24:36', '5', 70, 0, 0),
(685, 'Part One', 155, '151', '1', '1988-12-14', '24:23', '5', 68, 0, 0),
(686, 'Part Two', 155, '151', '2', '1988-12-21', '24:20', '5', 66, 0, 0),
(687, 'Part Three', 155, '151', '3', '1988-12-28', '24:30', '5', 69, 0, 0),
(688, 'Part Four', 155, '151', '4', '1989-01-04', '24:24', '7', 64, 0, 0),
(689, 'Part One', 156, '152', '1', '1989-09-06', '24:06', '3', 69, 0, 0),
(690, 'Part Two', 156, '152', '2', '1989-09-13', '24:07', '4', 68, 0, 0),
(691, 'Part Three', 156, '152', '3', '1989-09-20', '24:13', '4', 67, 0, 0),
(692, 'Part Four', 156, '152', '4', '1989-09-27', '24:14', '4', 65, 0, 0),
(693, 'Part One', 157, '153', '1', '1989-10-04', '24:17', '4', 68, 0, 0),
(694, 'Part Two', 157, '153', '2', '1989-10-11', '24:18', '4', 68, 0, 0),
(695, 'Part Three', 157, '153', '3', '1989-10-18', '24:17', '4', 64, 0, 0),
(696, 'Part One', 158, '154', '1', '1989-10-25', '24:23', '4', 67, 0, 0),
(697, 'Part Two', 158, '154', '2', '1989-11-01', '24:09', '4', 68, 0, 0),
(698, 'Part Three', 158, '154', '3', '1989-11-08', '24:11', '4', 68, 0, 0),
(699, 'Part Four', 158, '154', '4', '1989-11-15', '24:16', '4', 68, 0, 0),
(700, 'Part One', 159, '155', '1', '1989-11-22', '24:14', '5', 69, 0, 0),
(701, 'Part Two', 159, '155', '2', '1989-11-29', '24:13', '5', 69, 0, 0),
(702, 'Part Three', 159, '155', '3', '1989-12-06', '24:20', '5', 71, 0, 0),
(703, 'Doctor Who', 160, '156', '1', '1996-05-27', '85:00', '9', 75, 0, 0),
(704, 'Rose', 161, '157', '1', '2005-03-26', '45:00', '11', 81, 0, 0),
(705, 'The End of the World', 162, '158', '1', '2005-04-02', '44:00', '8', 79, 0, 0),
(706, 'The Unquiet Dead', 163, '159', '1', '2005-04-09', '44:00', '9', 80, 0, 0),
(707, 'Aliens of London', 164, '160a', '1', '2005-04-16', '45:00', '8', 81, 0, 0),
(708, 'World War Three', 165, '160b', '2', '2005-04-23', '42:00', '8', 82, 0, 0),
(709, 'Dalek', 166, '161', '1', '2005-04-30', '45:00', '9', 84, 0, 0),
(710, 'The Long Game', 167, '162', '1', '2005-05-07', '44:00', '8', 81, 0, 0),
(711, 'Father\'s Day', 168, '163', '1', '2005-05-14', '45:00', '8', 83, 0, 0),
(712, 'The Empty Child', 169, '164a', '1', '2005-05-21', '45:00', '7', 84, 0, 0),
(713, 'The Doctor Dances', 170, '164b', '2', '2005-05-28', '45:00', '7', 85, 0, 0),
(714, 'Boom Town', 171, '165', '1', '2005-06-04', '45:00', '8', 82, 0, 0),
(715, 'Bad Wolf', 172, '166a', '1', '2005-06-11', '45:00', '7', 85, 0, 0),
(716, 'The Parting of the Ways', 173, '166b', '2', '2005-06-18', '45:00', '7', 89, 0, 0),
(717, 'The Christmas Invasion', 174, '167', '1', '2005-12-25', '60:00', '10', 84, 0, 0),
(718, 'New Earth', 175, '168', '1', '2006-04-15', '45:00', '9', 85, 0, 0),
(719, 'Tooth and Claw', 176, '169', '1', '2006-04-22', '45:00', '9', 83, 0, 0),
(720, 'School Reunion', 177, '170', '1', '2006-04-29', '45:00', '8', 85, 0, 0),
(721, 'The Girl in the Fireplace', 178, '171', '1', '2006-05-06', '45:00', '8', 84, 0, 0),
(722, 'Rise of the Cybermen', 179, '172a', '1', '2006-05-13', '45:00', '9', 86, 0, 0),
(723, 'The Age of Steel', 180, '172b', '2', '2006-05-20', '45:00', '8', 86, 0, 0),
(724, 'The Idiot\'s Lantern', 181, '173', '1', '2006-05-27', '45:00', '7', 84, 0, 0),
(725, 'The Impossible Planet', 182, '174a', '1', '2006-06-03', '45:00', '6', 85, 0, 0),
(726, 'The Satan Pit', 183, '174b', '2', '2006-06-10', '45:00', '6', 86, 0, 0),
(727, 'Love & Monsters', 184, '175', '1', '2006-06-17', '45:00', '7', 76, 0, 0),
(728, 'Fear Her', 185, '176', '1', '2006-06-24', '45:00', '7', 83, 0, 0),
(729, 'Army of Ghosts', 186, '177a', '1', '2006-07-01', '45:00', '8', 86, 0, 0),
(730, 'Doomsday', 187, '177b', '2', '2006-07-08', '45:00', '8', 89, 0, 0),
(731, 'The Runaway Bride', 188, '178', '1', '2006-12-25', '60:00', '9', 84, 0, 0),
(732, 'Smith and Jones', 189, '179', '1', '2007-03-31', '45:00', '9', 88, 0, 0),
(733, 'The Shakespeare Code', 190, '180', '1', '2007-04-07', '45:00', '7', 87, 0, 0),
(734, 'Gridlock', 191, '181', '1', '2007-04-14', '45:00', '8', 85, 0, 0),
(735, 'Daleks in Manhattan', 192, '182a', '1', '2007-04-21', '45:00', '7', 86, 0, 0),
(736, 'Evolution of the Daleks', 193, '182b', '2', '2007-04-28', '45:00', '7', 85, 0, 0),
(737, 'The Lazarus Experiment', 194, '183', '1', '2007-05-05', '45:00', '7', 86, 0, 0),
(738, '42', 195, '184', '1', '2007-05-19', '45:00', '7', 85, 0, 0),
(739, 'Human Nature', 196, '185a', '1', '2007-05-26', '45:00', '8', 86, 0, 0),
(740, 'The Family of Blood', 197, '185b', '2', '2007-06-02', '45:00', '7', 86, 0, 0),
(741, 'Blink', 198, '186', '1', '2007-06-09', '45:00', '7', 87, 0, 0),
(742, 'Utopia', 199, '187a', '1', '2007-06-16', '45:00', '8', 87, 0, 0),
(743, 'The Sound of Drums', 200, '187b', '2', '2007-06-23', '45:00', '8', 87, 0, 0),
(744, 'Last of the Time Lords', 201, '187c', '3', '2007-06-30', '52:00', '9', 88, 0, 0),
(745, 'Voyage of the Damned', 202, '188', '1', '2007-12-25', '72:00', '13', 86, 0, 0),
(746, 'Partners in Crime', 203, '189', '1', '2008-04-05', '50:00', '9', 88, 0, 0),
(747, 'The Fires of Pompeii', 204, '190', '1', '2008-04-12', '50:00', '9', 87, 0, 0),
(748, 'Planet of the Ood', 205, '191', '1', '2008-04-19', '45:00', '8', 87, 0, 0),
(749, 'The Sontaran Stratagem', 206, '192a', '1', '2008-04-26', '45:00', '7', 87, 0, 0),
(750, 'The Poison Sky', 207, '192b', '2', '2008-05-03', '45:00', '7', 88, 0, 0),
(751, 'The Doctor\'s Daughter', 208, '193', '1', '2008-05-10', '45:00', '7', 88, 0, 0),
(752, 'The Unicorn and the Wasp', 209, '194', '1', '2008-05-17', '45:00', '8', 86, 0, 0),
(753, 'Silence in the Library', 210, '195a', '1', '2008-05-31', '45:00', '6', 89, 0, 0),
(754, 'Forest of the Dead', 211, '195b', '2', '2008-06-07', '45:00', '8', 89, 0, 0),
(755, 'Midnight', 212, '196', '1', '2008-06-14', '45:00', '8', 86, 0, 0),
(756, 'Turn Left', 213, '197', '1', '2008-06-21', '50:00', '8', 88, 0, 0),
(757, 'The Stolen Earth', 214, '198a', '1', '2008-06-28', '45:00', '9', 91, 0, 0),
(758, 'Journey\'s End', 215, '198b', '2', '2008-07-05', '65:00', '11', 91, 0, 0),
(759, 'The Next Doctor', 216, '199', '1', '2008-12-25', '60:00', '13', 86, 0, 0),
(760, 'Planet of the Dead', 217, '200', '1', '2009-04-11', '60:00', '10', 88, 0, 0),
(761, 'The Waters of Mars', 218, '201', '1', '2009-11-15', '60:00', '10', 88, 0, 0),
(762, 'Part One', 219, '202', '1', '2009-12-25', '60:00', '12', 87, 0, 0),
(763, 'Part Two', 220, '202', '2', '2010-01-01', '75:00', '12', 89, 0, 0),
(764, 'The Eleventh Hour', 221, '203', '1', '2010-04-03', '65:00', '10', 86, 0, 0),
(765, 'The Beast Below', 222, '204', '1', '2010-04-10', '45:00', '8', 86, 0, 0),
(766, 'Victory of the Daleks', 223, '205', '1', '2010-04-17', '45:00', '8', 84, 0, 0),
(767, 'The Time of Angels', 224, '206a', '1', '2010-04-24', '45:00', '9', 87, 0, 0),
(768, 'Flesh and Stone', 225, '206b', '1', '2010-05-01', '50:00', '9', 86, 0, 0),
(769, 'The Vampires of Venice', 226, '207', '1', '2010-05-08', '50:00', '8', 86, 0, 0),
(770, 'Amy\'s Choice', 227, '208', '1', '2010-05-15', '45:00', '8', 84, 0, 0),
(771, 'The Hungry Earth', 228, '209a', '1', '2010-05-22', '45:00', '6', 86, 0, 0),
(772, 'Cold Blood', 229, '209b', '1', '2010-05-29', '45:00', '7', 85, 0, 0),
(773, 'Vincent and the Doctor', 230, '210', '1', '2010-06-05', '45:00', '7', 86, 0, 0),
(774, 'The Lodger', 231, '211', '1', '2010-06-12', '45:00', '6', 87, 0, 0),
(775, 'The Pandorica Opens', 232, '212a', '1', '2010-06-19', '50:00', '8', 88, 0, 0),
(776, 'The Big Bang', 233, '212b', '1', '2010-06-26', '55:00', '7', 89, 0, 0),
(777, 'A Christmas Carol', 234, '213', '1', '2010-12-25', '60:00', '12', 83, 0, 0),
(778, 'The Impossible Astronaut', 235, '214a', '1', '2011-04-23', '45:00', '9', 88, 0, 0),
(779, 'Day of the Moon', 236, '214b', '2', '2011-04-30', '45:00', '7', 87, 0, 0),
(780, 'The Curse of the Black Spot', 237, '215', '1', '2011-05-07', '45:00', '8', 86, 0, 0),
(781, 'The Doctor\'s Wife', 238, '216', '1', '2011-05-14', '45:00', '8', 87, 0, 0),
(782, 'The Rebel Flesh', 239, '217a', '1', '2011-05-21', '45:00', '7', 85, 0, 0),
(783, 'The Almost People', 240, '217b', '2', '2011-05-28', '45:00', '7', 86, 0, 0),
(784, 'A Good Man Goes to War', 241, '218', '1', '2011-06-04', '50:00', '8', 88, 0, 0),
(785, 'Let\'s Kill Hitler', 242, '219', '1', '2011-08-27', '50:00', '8', 85, 0, 0),
(786, 'Night Terrors', 243, '220', '1', '2011-09-03', '45:00', '7', 86, 0, 0),
(787, 'The Girl Who Waited', 244, '221', '1', '2011-09-10', '45:00', '8', 85, 0, 0),
(788, 'The God Complex', 245, '222', '1', '2011-09-17', '50:00', '7', 86, 0, 0),
(789, 'Closing Time', 246, '223', '1', '2011-09-24', '45:00', '7', 86, 0, 0),
(790, 'The Wedding of River Song', 247, '224', '1', '2011-10-01', '45:00', '8', 86, 0, 0),
(791, 'The Doctor, the Widow and the Wardrobe', 248, '225', '1', '2011-12-25', '60:00', '11', 84, 0, 0),
(792, 'Asylum of the Daleks', 249, '226', '1', '2012-09-01', '50:00', '8', 89, 0, 0),
(793, 'Dinosaurs on a Spaceship', 250, '227', '1', '2012-09-08', '45:00', '8', 87, 0, 0),
(794, 'A Town Called Mercy', 251, '228', '1', '2012-09-15', '45:00', '8', 85, 0, 0),
(795, 'The Power of Three', 252, '229', '1', '2012-09-22', '45:00', '8', 87, 0, 0),
(796, 'The Angels Take Manhattan', 253, '230', '1', '2012-09-29', '45:00', '8', 88, 0, 0),
(797, 'The Snowmen', 254, '231', '1', '2012-12-25', '60:00', '10', 87, 0, 0),
(798, 'The Bells of Saint John', 255, '232', '1', '2013-03-30', '45:00', '8', 87, 0, 0),
(799, 'The Rings of Akhaten', 256, '233', '1', '2013-04-06', '45:00', '7', 84, 0, 0),
(800, 'Cold War', 257, '234', '1', '2013-04-13', '45:00', '7', 84, 0, 0),
(801, 'Hide', 258, '235', '1', '2013-04-20', '45:00', '7', 85, 0, 0),
(802, 'Journey to the Centre of the TARDIS', 259, '236', '1', '2013-04-27', '45:00', '7', 85, 0, 0),
(803, 'The Crimson Horror', 260, '237', '1', '2013-05-04', '45:00', '6', 85, 0, 0),
(804, 'Nightmare in Silver', 261, '238', '1', '2013-05-11', '45:00', '7', 84, 0, 0),
(805, 'The Name of the Doctor', 262, '239', '1', '2013-05-18', '45:00', '7', 88, 0, 0),
(806, 'The Day of the Doctor', 263, '240', '1', '2013-11-23', '77:00', '13', 88, 0, 0),
(807, 'The Time of the Doctor', 264, '241', '1', '2013-12-25', '60:00', '11', 83, 0, 0),
(808, 'Deep Breath', 265, '242', '1', '2014-08-23', '76:00', '9', 82, 0, 0),
(809, 'Into the Dalek', 266, '243', '1', '2014-08-30', '45:00', '7', 84, 0, 0),
(810, 'Robot of Sherwood', 267, '244', '1', '2014-09-06', '45:00', '7', 82, 0, 0),
(811, 'Listen', 268, '245', '1', '2014-09-13', '45:00', '7', 82, 0, 0),
(812, 'Time Heist', 269, '246', '1', '2014-09-20', '45:00', '7', 84, 0, 0),
(813, 'The Caretaker', 270, '247', '1', '2014-09-27', '45:00', '7', 83, 0, 0),
(814, 'Kill the Moon', 271, '248', '1', '2014-10-04', '45:00', '7', 82, 0, 0),
(815, 'Mummy on the Orient Express', 272, '249', '1', '2014-10-11', '45:00', '7', 85, 0, 0),
(816, 'Flatline', 273, '250', '1', '2014-10-18', '45:00', '7', 85, 0, 0),
(817, 'In the Forest of the Night', 274, '251', '1', '2014-10-25', '45:00', '7', 83, 0, 0),
(818, 'Dark Water', 275, '252a', '1', '2014-11-01', '45:00', '7', 85, 0, 0),
(819, 'Death in Heaven', 276, '252b', '2', '2014-11-08', '60:00', '8', 83, 0, 0),
(820, 'Last Christmas', 277, '253', '1', '2014-12-25', '60:00', '8', 82, 0, 0),
(821, 'The Magician\'s Apprentice', 278, '254a', '1', '2015-09-19', '50:00', '7', 84, 0, 0),
(822, 'The Witch\'s Familiar', 279, '254b', '2', '2015-09-26', '50:00', '6', 83, 0, 0),
(823, 'Under the Lake', 280, '255a', '1', '2015-10-03', '45:00', '6', 84, 0, 0),
(824, 'Before the Flood', 281, '255b', '2', '2015-10-10', '42:00', '6', 83, 0, 0),
(825, 'The Girl Who Died', 282, '256', '1', '2015-10-17', '45:00', '7', 82, 0, 0),
(826, 'The Woman Who Lived', 283, '257', '1', '2015-10-24', '45:00', '6', 81, 0, 0),
(827, 'The Zygon Invasion', 284, '258a', '1', '2015-10-31', '45:00', '6', 82, 0, 0),
(828, 'The Zygon Inversion', 285, '258b', '2', '2015-11-07', '45:00', '6', 84, 0, 0),
(829, 'Sleep No More', 286, '259', '1', '2015-11-14', '45:00', '6', 78, 0, 0),
(830, 'Face the Raven', 287, '260', '1', '2015-11-21', '50:00', '6', 84, 0, 0),
(831, 'Heaven Sent', 288, '261', '1', '2015-11-28', '55:00', '6', 80, 0, 0),
(832, 'Hell Bent', 289, '262', '1', '2015-12-05', '60:00', '6', 82, 0, 0),
(833, 'The Husbands of River Song', 290, '263', '1', '2015-12-25', '60:00', '8', 82, 0, 0),
(834, 'The Return of Doctor Mysterio', 291, '264', '1', '2016-12-25', '60:00', '8', 82, 0, 0),
(835, 'Dr. Who and the Daleks', 292, NULL, '1', '1965-08-23', '82:00', NULL, NULL, 0, 0),
(836, 'Daleks -- Invasion Earth: 2150 A.D.', 293, NULL, '1', '1966-08-05', '84:00', NULL, NULL, 0, 0),
(837, 'The Pilot', 294, '265', '1', '2017-04-15', '50:00', '7', 83, 0, 0),
(838, 'Smile', 295, '266', '1', '2017-04-22', '45:00', '6', 83, 0, 0),
(839, 'Thin Ice', 296, '267', '1', '2017-04-29', '45:00', '6', 84, 0, 0),
(840, 'Knock Knock', 297, '268', '1', '2017-05-06', '44:00', '6', 83, 0, 0),
(841, 'Oxygen', 298, '269', '1', '2017-05-13', '45:00', '5', 83, 0, 0),
(842, 'Extremis', 299, '270', '1', '2017-05-20', '49:00', '6', 82, 0, 0),
(843, 'The Pyramid at the End of the World', 300, '271', '1', '2017-05-27', '46:00', '6', 82, 0, 0),
(844, 'The Lie of the Land', 301, '272', '1', '2017-06-03', '45:00', '5', 82, 0, 0),
(845, 'Empress of Mars', 302, '273', '1', '2017-06-10', '44:00', '5', 83, 0, 0),
(846, 'The Eaters of Light', 303, '274', '1', '2017-06-17', '42:00', '5', 81, 0, 0),
(847, 'World Enough and Time', 304, '275a', '1', '2017-06-24', '45:00', NULL, 85, 0, 0),
(848, 'The Doctor Falls', 305, '275b', '2', '2017-07-01', '60:00', NULL, NULL, 0, 0),
(849, 'Twice Upon a Time', 306, '276', '1', '2017-12-25', '60:00', NULL, NULL, 0, 0),
(850, 'The Woman Who Fell to Earth', 307, '277', '1', '2018-10-07', NULL, NULL, NULL, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `seasons`
--

DROP TABLE IF EXISTS `seasons`;
CREATE TABLE IF NOT EXISTS `seasons` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

--
-- Dumping data for table `seasons`
--

INSERT INTO `seasons` (`id`, `name`) VALUES
(1, 'Season 1'),
(2, 'Season 2'),
(3, 'Season 3'),
(4, 'Season 4'),
(5, 'Season 5'),
(6, 'Season 6'),
(7, 'Season 7'),
(8, 'Season 8'),
(9, 'Season 9'),
(10, 'Season 10'),
(11, 'Season 11'),
(12, 'Season 12'),
(13, 'Season 13'),
(14, 'Season 14'),
(15, 'Season 15'),
(16, 'Season 16'),
(17, 'Season 17'),
(18, 'Season 18'),
(19, 'Season 19'),
(20, 'Season 20'),
(21, 'Season 21'),
(22, 'Season 22'),
(23, 'Season 23'),
(24, 'Season 24'),
(25, 'Season 25'),
(26, 'Season 26'),
(27, 'TV movie'),
(28, 'Series 1'),
(29, 'Series 2'),
(30, 'Series 3'),
(31, 'Series 4'),
(32, 'Specials (2008–2010)'),
(33, 'Series 5'),
(34, 'Series 6'),
(35, 'Series 7'),
(36, 'Specials (2013)'),
(37, 'Series 8'),
(38, 'Series 9'),
(39, 'Series 10'),
(40, 'Films'),
(41, 'Series 11');

-- --------------------------------------------------------

--
-- Table structure for table `serials`
--

DROP TABLE IF EXISTS `serials`;
CREATE TABLE IF NOT EXISTS `serials` (
  `id` int(11) NOT NULL,
  `season_id` int(11) NOT NULL,
  `story` text,
  `serial` int(11) DEFAULT NULL,
  `title` text NOT NULL,
  `production_code` text,
  PRIMARY KEY (`id`),
  KEY `season_id_fk` (`season_id`)
) ENGINE=InnoDB;

--
-- Dumping data for table `serials`
--

INSERT INTO `serials` (`id`, `season_id`, `story`, `serial`, `title`, `production_code`) VALUES
(1, 1, '1', 1, 'An Unearthly Child', 'A'),
(2, 1, '2', 2, 'The Daleks', 'B'),
(3, 1, '3', 3, 'The Edge of Destruction', 'C'),
(4, 1, '4', 4, 'Marco Polo', 'D'),
(5, 1, '5', 5, 'The Keys of Marinus', 'E'),
(6, 1, '6', 6, 'The Aztecs', 'F'),
(7, 1, '7', 7, 'The Sensorites', 'G'),
(8, 1, '8', 8, 'The Reign of Terror', 'H'),
(9, 2, '9', 1, 'Planet of Giants', 'J'),
(10, 2, '10', 2, 'The Dalek Invasion of Earth', 'K'),
(11, 2, '11', 3, 'The Rescue', 'L'),
(12, 2, '12', 4, 'The Romans', 'M'),
(13, 2, '13', 5, 'The Web Planet', 'N'),
(14, 2, '14', 6, 'The Crusade', 'P'),
(15, 2, '15', 7, 'The Space Museum', 'Q'),
(16, 2, '16', 8, 'The Chase', 'R'),
(17, 2, '17', 9, 'The Time Meddler', 'S'),
(18, 3, '18', 1, 'Galaxy 4', 'T'),
(19, 3, '19', 2, 'Mission to the Unknown', 'T/A'),
(20, 3, '20', 3, 'The Myth Makers', 'U'),
(21, 3, '21', 4, 'The Daleks\' Master Plan', 'V'),
(22, 3, '22', 5, 'The Massacre of St. Bartholomew\'s Eve', 'W'),
(23, 3, '23', 6, 'The Ark', 'X'),
(24, 3, '24', 7, 'The Celestial Toymaker', 'Y'),
(25, 3, '25', 8, 'The Gunfighters', 'Z'),
(26, 3, '26', 9, 'The Savages', 'AA'),
(27, 3, '27', 10, 'The War Machines', 'BB'),
(28, 4, '28', 1, 'The Smugglers', 'CC'),
(29, 4, '29', 2, 'The Tenth Planet', 'DD'),
(30, 4, '30', 3, 'The Power of the Daleks', 'EE'),
(31, 4, '31', 4, 'The Highlanders', 'FF'),
(32, 4, '32', 5, 'The Underwater Menace', 'GG'),
(33, 4, '33', 6, 'The Moonbase', 'HH'),
(34, 4, '34', 7, 'The Macra Terror', 'JJ'),
(35, 4, '35', 8, 'The Faceless Ones', 'KK'),
(36, 4, '36', 9, 'The Evil of the Daleks', 'LL'),
(37, 5, '37', 1, 'The Tomb of the Cybermen', 'MM'),
(38, 5, '38', 2, 'The Abominable Snowmen', 'NN'),
(39, 5, '39', 3, 'The Ice Warriors', 'OO'),
(40, 5, '40', 4, 'The Enemy of the World', 'PP'),
(41, 5, '41', 5, 'The Web of Fear', 'QQ'),
(42, 5, '42', 6, 'Fury from the Deep', 'RR'),
(43, 5, '43', 7, 'The Wheel in Space', 'SS'),
(44, 6, '44', 1, 'The Dominators', 'TT'),
(45, 6, '45', 2, 'The Mind Robber', 'UU'),
(46, 6, '46', 3, 'The Invasion', 'VV'),
(47, 6, '47', 4, 'The Krotons', 'WW'),
(48, 6, '48', 5, 'The Seeds of Death', 'XX'),
(49, 6, '49', 6, 'The Space Pirates', 'YY'),
(50, 6, '50', 7, 'The War Games', 'ZZ'),
(51, 7, '51', 1, 'Spearhead from Space', 'AAA'),
(52, 7, '52', 2, 'Doctor Who and the Silurians', 'BBB'),
(53, 7, '53', 3, 'The Ambassadors of Death', 'CCC'),
(54, 7, '54', 4, 'Inferno', 'DDD'),
(55, 8, '55', 1, 'Terror of the Autons', 'EEE'),
(56, 8, '56', 2, 'The Mind of Evil', 'FFF'),
(57, 8, '57', 3, 'The Claws of Axos', 'GGG'),
(58, 8, '58', 4, 'Colony in Space', 'HHH'),
(59, 8, '59', 5, 'The Daemons', 'JJJ'),
(60, 9, '60', 1, 'Day of the Daleks', 'KKK'),
(61, 9, '61', 2, 'The Curse of Peladon', 'MMM'),
(62, 9, '62', 3, 'The Sea Devils', 'LLL'),
(63, 9, '63', 4, 'The Mutants', 'NNN'),
(64, 9, '64', 5, 'The Time Monster', 'OOO'),
(65, 10, '65', 1, 'The Three Doctors', 'RRR'),
(66, 10, '66', 2, 'Carnival of Monsters', 'PPP'),
(67, 10, '67', 3, 'Frontier in Space', 'QQQ'),
(68, 10, '68', 4, 'Planet of the Daleks', 'SSS'),
(69, 10, '69', 5, 'The Green Death', 'TTT'),
(70, 11, '70', 1, 'The Time Warrior', 'UUU'),
(71, 11, '71', 2, 'Invasion of the Dinosaurs', 'WWW'),
(72, 11, '72', 3, 'Death to the Daleks', 'XXX'),
(73, 11, '73', 4, 'The Monster of Peladon', 'YYY'),
(74, 11, '74', 5, 'Planet of the Spiders', 'ZZZ'),
(75, 12, '75', 1, 'Robot', '4A'),
(76, 12, '76', 2, 'The Ark in Space', '4C'),
(77, 12, '77', 3, 'The Sontaran Experiment', '4B'),
(78, 12, '78', 4, 'Genesis of the Daleks', '4E'),
(79, 12, '79', 5, 'Revenge of the Cybermen', '4D'),
(80, 13, '80', 1, 'Terror of the Zygons', '4F'),
(81, 13, '81', 2, 'Planet of Evil', '4H'),
(82, 13, '82', 3, 'Pyramids of Mars', '4G'),
(83, 13, '83', 4, 'The Android Invasion', '4J'),
(84, 13, '84', 5, 'The Brain of Morbius', '4K'),
(85, 13, '85', 6, 'The Seeds of Doom', '4L'),
(86, 14, '86', 1, 'The Masque of Mandragora', '4M'),
(87, 14, '87', 2, 'The Hand of Fear', '4N'),
(88, 14, '88', 3, 'The Deadly Assassin', '4P'),
(89, 14, '89', 4, 'The Face of Evil', '4Q'),
(90, 14, '90', 5, 'The Robots of Death', '4R'),
(91, 14, '91', 6, 'The Talons of Weng-Chiang', '4S'),
(92, 15, '92', 1, 'Horror of Fang Rock', '4V'),
(93, 15, '93', 2, 'The Invisible Enemy', '4T'),
(94, 15, '94', 3, 'Image of the Fendahl', '4X'),
(95, 15, '95', 4, 'The Sun Makers', '4W'),
(96, 15, '96', 5, 'Underworld', '4Y'),
(97, 15, '97', 6, 'The Invasion of Time', '4Z'),
(98, 16, '98', 1, 'The Ribos Operation', '5A'),
(99, 16, '99', 2, 'The Pirate Planet', '5B'),
(100, 16, '100', 3, 'The Stones of Blood', '5C'),
(101, 16, '101', 4, 'The Androids of Tara', '5D'),
(102, 16, '102', 5, 'The Power of Kroll', '5E'),
(103, 16, '103', 6, 'The Armageddon Factor', '5F'),
(104, 17, '104', 1, 'Destiny of the Daleks', '5J'),
(105, 17, '105', 2, 'City of Death', '5H'),
(106, 17, '106', 3, 'The Creature from the Pit', '5G'),
(107, 17, '107', 4, 'Nightmare of Eden', '5K'),
(108, 17, '108', 5, 'The Horns of Nimon', '5L'),
(109, 17, '', 6, 'Shada', '5M'),
(110, 18, '109', 1, 'The Leisure Hive', '5N'),
(111, 18, '110', 2, 'Meglos', '5Q'),
(112, 18, '111', 3, 'Full Circle', '5R'),
(113, 18, '112', 4, 'State of Decay', '5P'),
(114, 18, '113', 5, 'Warriors\' Gate', '5S'),
(115, 18, '114', 6, 'The Keeper of Traken', '5T'),
(116, 18, '115', 7, 'Logopolis', '5V'),
(117, 19, '116', 1, 'Castrovalva', '5Z'),
(118, 19, '117', 2, 'Four to Doomsday', '5W'),
(119, 19, '118', 3, 'Kinda', '5Y'),
(120, 19, '119', 4, 'The Visitation', '5X'),
(121, 19, '120', 5, 'Black Orchid', '6A'),
(122, 19, '121', 6, 'Earthshock', '6B'),
(123, 19, '122', 7, 'Time-Flight', '6C'),
(124, 20, '123', 1, 'Arc of Infinity', '6E'),
(125, 20, '124', 2, 'Snakedance', '6D'),
(126, 20, '125', 3, 'Mawdryn Undead', '6F'),
(127, 20, '126', 4, 'Terminus', '6G'),
(128, 20, '127', 5, 'Enlightenment', '6H'),
(129, 20, '128', 6, 'The King\'s Demons', '6J'),
(130, 20, '129', 0, 'The Five Doctors', '6K'),
(131, 21, '130', 1, 'Warriors of the Deep', '6L'),
(132, 21, '131', 2, 'The Awakening', '6M'),
(133, 21, '132', 3, 'Frontios', '6N'),
(134, 21, '133', 4, 'Resurrection of the Daleks', '6P'),
(135, 21, '134', 5, 'Planet of Fire', '6Q'),
(136, 21, '135', 6, 'The Caves of Androzani', '6R'),
(137, 21, '136', 7, 'The Twin Dilemma', '6S'),
(138, 22, '137', 1, 'Attack of the Cybermen', '6T'),
(139, 22, '138', 2, 'Vengeance on Varos', '6V'),
(140, 22, '139', 3, 'The Mark of the Rani', '6X'),
(141, 22, '140', 4, 'The Two Doctors', '6W'),
(142, 22, '141', 5, 'Timelash', '6Y'),
(143, 22, '142', 6, 'Revelation of the Daleks', '6Z'),
(144, 23, '143a', 1, 'The Mysterious Planet', '7A'),
(145, 23, '143b', 2, 'Mindwarp', '7B'),
(146, 23, '143c', 3, 'Terror of the Vervoids', '7C'),
(147, 23, '143d', 4, 'The Ultimate Foe', '7C'),
(148, 24, '144', 1, 'Time and the Rani', '7D'),
(149, 24, '145', 2, 'Paradise Towers', '7E'),
(150, 24, '146', 3, 'Delta and the Bannermen', '7F'),
(151, 24, '147', 4, 'Dragonfire', '7G'),
(152, 25, '148', 1, 'Remembrance of the Daleks', '7H'),
(153, 25, '149', 2, 'The Happiness Patrol', '7L'),
(154, 25, '150', 3, 'Silver Nemesis', '7K'),
(155, 25, '151', 4, 'The Greatest Show in the Galaxy', '7J'),
(156, 26, '152', 1, 'Battlefield', '7N'),
(157, 26, '153', 2, 'Ghost Light', '7Q'),
(158, 26, '154', 3, 'The Curse of Fenric', '7M'),
(159, 26, '155', 4, 'Survival', '7P'),
(160, 27, '156', 0, 'Doctor Who', 'TVM'),
(161, 28, '157', 1, 'Rose', '1.1'),
(162, 28, '158', 2, 'The End of the World', '1.2'),
(163, 28, '159', 3, 'The Unquiet Dead', '1.3'),
(164, 28, '160a', 4, 'Aliens of London', '1.4'),
(165, 28, '160b', 5, 'World War Three', '1.5'),
(166, 28, '161', 6, 'Dalek', '1.6'),
(167, 28, '162', 7, 'The Long Game', '1.7'),
(168, 28, '163', 8, 'Father\'s Day', '1.8'),
(169, 28, '164a', 9, 'The Empty Child', '1.9'),
(170, 28, '164b', 10, 'The Doctor Dances', '1.10'),
(171, 28, '165', 11, 'Boom Town', '1.11'),
(172, 28, '166a', 12, 'Bad Wolf', '1.12'),
(173, 28, '166b', 13, 'The Parting of the Ways', '1.13'),
(174, 29, '167', 0, 'The Christmas Invasion', '2X'),
(175, 29, '168', 1, 'New Earth', '2.1'),
(176, 29, '169', 2, 'Tooth and Claw', '2.2'),
(177, 29, '170', 3, 'School Reunion', '2.3'),
(178, 29, '171', 4, 'The Girl in the Fireplace', '2.4'),
(179, 29, '172a', 5, 'Rise of the Cybermen', '2.5'),
(180, 29, '172b', 6, 'The Age of Steel', '2.6'),
(181, 29, '173', 7, 'The Idiot\'s Lantern', '2.7'),
(182, 29, '174a', 8, 'The Impossible Planet', '2.8'),
(183, 29, '174b', 9, 'The Satan Pit', '2.9'),
(184, 29, '175', 10, 'Love & Monsters', '2.10'),
(185, 29, '176', 11, 'Fear Her', '2.11'),
(186, 29, '177a', 12, 'Army of Ghosts', '2.12'),
(187, 29, '177b', 13, 'Doomsday', '2.13'),
(188, 30, '178', 0, 'The Runaway Bride', '3X'),
(189, 30, '179', 1, 'Smith and Jones', '3.1'),
(190, 30, '180', 2, 'The Shakespeare Code', '3.2'),
(191, 30, '181', 3, 'Gridlock', '3.3'),
(192, 30, '182a', 4, 'Daleks in Manhattan', '3.4'),
(193, 30, '182b', 5, 'Evolution of the Daleks', '3.5'),
(194, 30, '183', 6, 'The Lazarus Experiment', '3.6'),
(195, 30, '184', 7, '42', '3.7'),
(196, 30, '185a', 8, 'Human Nature', '3.8'),
(197, 30, '185b', 9, 'The Family of Blood', '3.9'),
(198, 30, '186', 10, 'Blink', '3.10'),
(199, 30, '187a', 11, 'Utopia', '3.11'),
(200, 30, '187b', 12, 'The Sound of Drums', '3.12'),
(201, 30, '187c', 13, 'Last of the Time Lords', '3.13'),
(202, 31, '188', 0, 'Voyage of the Damned', '4X'),
(203, 31, '189', 1, 'Partners in Crime', '4.1'),
(204, 31, '190', 2, 'The Fires of Pompeii', '4.3'),
(205, 31, '191', 3, 'Planet of the Ood', '4.2'),
(206, 31, '192a', 4, 'The Sontaran Stratagem', '4.4'),
(207, 31, '192b', 5, 'The Poison Sky', '4.5'),
(208, 31, '193', 6, 'The Doctor\'s Daughter', '4.6'),
(209, 31, '194', 7, 'The Unicorn and the Wasp', '4.7'),
(210, 31, '195a', 8, 'Silence in the Library', '4.9'),
(211, 31, '195b', 9, 'Forest of the Dead', '4.10'),
(212, 31, '196', 10, 'Midnight', '4.8'),
(213, 31, '197', 11, 'Turn Left', '4.11'),
(214, 31, '198a', 12, 'The Stolen Earth', '4.12'),
(215, 31, '198b', 13, 'Journey\'s End', '4.13'),
(216, 32, '199', 1, 'The Next Doctor', '4.14'),
(217, 32, '200', 2, 'Planet of the Dead', '4.15'),
(218, 32, '201', 3, 'The Waters of Mars', '4.16'),
(219, 32, '202', 4, 'The End of Time part 1', '4.17'),
(220, 32, '202', 5, 'The End of Time part 2', '4.18'),
(221, 33, '203', 1, 'The Eleventh Hour', '1.1'),
(222, 33, '204', 2, 'The Beast Below', '1.2'),
(223, 33, '205', 3, 'Victory of the Daleks', '1.3'),
(224, 33, '206a', 4, 'The Time of Angels', '1.4'),
(225, 33, '206b', 5, 'Flesh and Stone', '1.5'),
(226, 33, '207', 6, 'The Vampires of Venice', '1.6'),
(227, 33, '208', 7, 'Amy\'s Choice', '1.7'),
(228, 33, '209a', 8, 'The Hungry Earth', '1.8'),
(229, 33, '209b', 9, 'Cold Blood', '1.9'),
(230, 33, '210', 10, 'Vincent and the Doctor', '1.10'),
(231, 33, '211', 11, 'The Lodger', '1.11'),
(232, 33, '212a', 12, 'The Pandorica Opens', '1.12'),
(233, 33, '212b', 13, 'The Big Bang', '1.13'),
(234, 34, '213', 0, 'A Christmas Carol', '2.X'),
(235, 34, '214a', 1, 'The Impossible Astronaut', '2.1'),
(236, 34, '214b', 2, 'Day of the Moon', '2.2'),
(237, 34, '215', 3, 'The Curse of the Black Spot', '2.9'),
(238, 34, '216', 4, 'The Doctor\'s Wife', '2.3'),
(239, 34, '217a', 5, 'The Rebel Flesh', '2.5'),
(240, 34, '217b', 6, 'The Almost People', '2.6'),
(241, 34, '218', 7, 'A Good Man Goes to War', '2.7'),
(242, 34, '219', 8, 'Let\'s Kill Hitler', '2.8'),
(243, 34, '220', 9, 'Night Terrors', '2.4'),
(244, 34, '221', 10, 'The Girl Who Waited', '2.10'),
(245, 34, '222', 11, 'The God Complex', '2.11'),
(246, 34, '223', 12, 'Closing Time', '2.12'),
(247, 34, '224', 13, 'The Wedding of River Song', '2.13'),
(248, 35, '225', 0, 'The Doctor, the Widow and the Wardrobe', ''),
(249, 35, '226', 1, 'Asylum of the Daleks', ''),
(250, 35, '227', 2, 'Dinosaurs on a Spaceship', ''),
(251, 35, '228', 3, 'A Town Called Mercy', ''),
(252, 35, '229', 4, 'The Power of Three', ''),
(253, 35, '230', 5, 'The Angels Take Manhattan', ''),
(254, 35, '231', 0, 'The Snowmen', ''),
(255, 35, '232', 6, 'The Bells of Saint John', ''),
(256, 35, '233', 7, 'The Rings of Akhaten', ''),
(257, 35, '234', 8, 'Cold War', ''),
(258, 35, '235', 9, 'Hide', ''),
(259, 35, '236', 10, 'Journey to the Centre of the TARDIS', ''),
(260, 35, '237', 11, 'The Crimson Horror', ''),
(261, 35, '238', 12, 'Nightmare in Silver', ''),
(262, 35, '239', 13, 'The Name of the Doctor', ''),
(263, 36, '240', 1, 'The Day of the Doctor', ''),
(264, 36, '241', 2, 'The Time of the Doctor', ''),
(265, 37, '242', 1, 'Deep Breath', ''),
(266, 37, '243', 2, 'Into the Dalek', ''),
(267, 37, '244', 3, 'Robot of Sherwood', ''),
(268, 37, '245', 4, 'Listen', ''),
(269, 37, '246', 5, 'Time Heist', ''),
(270, 37, '247', 6, 'The Caretaker', ''),
(271, 37, '248', 7, 'Kill the Moon', ''),
(272, 37, '249', 8, 'Mummy on the Orient Express', ''),
(273, 37, '250', 9, 'Flatline', ''),
(274, 37, '251', 10, 'In the Forest of the Night', ''),
(275, 37, '252a', 11, 'Dark Water', ''),
(276, 37, '252b', 12, 'Death in Heaven', ''),
(277, 38, '253', 0, 'Last Christmas', ''),
(278, 38, '254a', 1, 'The Magician\'s Apprentice', ''),
(279, 38, '254b', 2, 'The Witch\'s Familiar', ''),
(280, 38, '255a', 3, 'Under the Lake', ''),
(281, 38, '255b', 4, 'Before the Flood', ''),
(282, 38, '256', 5, 'The Girl Who Died', ''),
(283, 38, '257', 6, 'The Woman Who Lived', ''),
(284, 38, '258a', 7, 'The Zygon Invasion', ''),
(285, 38, '258b', 8, 'The Zygon Inversion', ''),
(286, 38, '259', 9, 'Sleep No More', ''),
(287, 38, '260', 10, 'Face the Raven', ''),
(288, 38, '261', 11, 'Heaven Sent', ''),
(289, 38, '262', 12, 'Hell Bent', ''),
(290, 38, '263', 0, 'The Husbands of River Song', ''),
(291, 39, '264', 0, 'The Return of Doctor Mysterio', ''),
(292, 40, '', 0, 'Dr. Who and the Daleks', ''),
(293, 40, '', 0, 'Daleks -- Invasion Earth: 2150 A.D.', ''),
(294, 39, '265', 1, 'The Pilot', NULL),
(295, 39, '266', 2, 'Smile', NULL),
(296, 39, '267', 3, 'Thin Ice', NULL),
(297, 39, '268', 4, 'Knock Knock', NULL),
(298, 39, '269', 5, 'Oxygen', NULL),
(299, 39, '270', 6, 'Extremis', NULL),
(300, 39, '271', 7, 'The Pyramid at the End of the World', NULL),
(301, 39, '272', 8, 'The Lie of the Land', NULL),
(302, 39, '273', 9, 'Empress of Mars', NULL),
(303, 39, '274', 10, 'The Eaters of Light', NULL),
(304, 39, '275a', 11, 'World Enough and Time', NULL),
(305, 39, '275b', 12, 'The Doctor Falls', NULL),
(306, 39, '276', 0, 'Twice Upon a Time', NULL),
(307, 41, '277', 0, 'The Woman Who Fell to Earth', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `serials_doctors`
--

DROP TABLE IF EXISTS `serials_doctors`;
CREATE TABLE IF NOT EXISTS `serials_doctors` (
  `serial_id` int(11) NOT NULL,
  `doctor_id` int(11) NOT NULL,
  PRIMARY KEY (`serial_id`,`doctor_id`),
  KEY `doctor_id` (`doctor_id`)
) ENGINE=InnoDB;

--
-- Dumping data for table `serials_doctors`
--

INSERT INTO `serials_doctors` (`serial_id`, `doctor_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(65, 1),
(130, 1),
(305, 1),
(30, 2),
(31, 2),
(32, 2),
(33, 2),
(34, 2),
(35, 2),
(36, 2),
(37, 2),
(38, 2),
(39, 2),
(40, 2),
(41, 2),
(42, 2),
(43, 2),
(44, 2),
(45, 2),
(46, 2),
(47, 2),
(48, 2),
(49, 2),
(50, 2),
(65, 2),
(130, 2),
(141, 2),
(51, 3),
(52, 3),
(53, 3),
(54, 3),
(55, 3),
(56, 3),
(57, 3),
(58, 3),
(59, 3),
(60, 3),
(61, 3),
(62, 3),
(63, 3),
(64, 3),
(65, 3),
(66, 3),
(67, 3),
(68, 3),
(69, 3),
(70, 3),
(71, 3),
(72, 3),
(73, 3),
(74, 3),
(130, 3),
(75, 4),
(76, 4),
(77, 4),
(78, 4),
(79, 4),
(80, 4),
(81, 4),
(82, 4),
(83, 4),
(84, 4),
(85, 4),
(86, 4),
(87, 4),
(88, 4),
(89, 4),
(90, 4),
(91, 4),
(92, 4),
(93, 4),
(94, 4),
(95, 4),
(96, 4),
(97, 4),
(98, 4),
(99, 4),
(100, 4),
(101, 4),
(102, 4),
(103, 4),
(104, 4),
(105, 4),
(106, 4),
(107, 4),
(108, 4),
(109, 4),
(110, 4),
(111, 4),
(112, 4),
(113, 4),
(114, 4),
(115, 4),
(116, 4),
(130, 4),
(117, 5),
(118, 5),
(119, 5),
(120, 5),
(121, 5),
(122, 5),
(123, 5),
(124, 5),
(125, 5),
(126, 5),
(127, 5),
(128, 5),
(129, 5),
(130, 5),
(131, 5),
(132, 5),
(133, 5),
(134, 5),
(135, 5),
(136, 5),
(137, 6),
(138, 6),
(139, 6),
(140, 6),
(141, 6),
(142, 6),
(143, 6),
(144, 6),
(145, 6),
(146, 6),
(147, 6),
(148, 7),
(149, 7),
(150, 7),
(151, 7),
(152, 7),
(153, 7),
(154, 7),
(155, 7),
(156, 7),
(157, 7),
(158, 7),
(159, 7),
(160, 8),
(263, 9),
(161, 10),
(162, 10),
(163, 10),
(164, 10),
(165, 10),
(166, 10),
(167, 10),
(168, 10),
(169, 10),
(170, 10),
(171, 10),
(172, 10),
(173, 10),
(174, 11),
(175, 11),
(176, 11),
(177, 11),
(178, 11),
(179, 11),
(180, 11),
(181, 11),
(182, 11),
(183, 11),
(184, 11),
(185, 11),
(186, 11),
(187, 11),
(188, 11),
(189, 11),
(190, 11),
(191, 11),
(192, 11),
(193, 11),
(194, 11),
(195, 11),
(196, 11),
(197, 11),
(198, 11),
(199, 11),
(200, 11),
(201, 11),
(202, 11),
(203, 11),
(204, 11),
(205, 11),
(206, 11),
(207, 11),
(208, 11),
(209, 11),
(210, 11),
(211, 11),
(212, 11),
(213, 11),
(214, 11),
(215, 11),
(216, 11),
(217, 11),
(218, 11),
(219, 11),
(220, 11),
(263, 11),
(221, 12),
(222, 12),
(223, 12),
(224, 12),
(225, 12),
(226, 12),
(227, 12),
(228, 12),
(229, 12),
(230, 12),
(231, 12),
(232, 12),
(233, 12),
(234, 12),
(235, 12),
(236, 12),
(237, 12),
(238, 12),
(239, 12),
(240, 12),
(241, 12),
(242, 12),
(243, 12),
(244, 12),
(245, 12),
(246, 12),
(247, 12),
(248, 12),
(249, 12),
(250, 12),
(251, 12),
(252, 12),
(253, 12),
(254, 12),
(255, 12),
(256, 12),
(257, 12),
(258, 12),
(259, 12),
(260, 12),
(261, 12),
(262, 12),
(263, 12),
(264, 12),
(265, 13),
(266, 13),
(267, 13),
(268, 13),
(269, 13),
(270, 13),
(271, 13),
(272, 13),
(273, 13),
(274, 13),
(275, 13),
(276, 13),
(277, 13),
(278, 13),
(279, 13),
(280, 13),
(281, 13),
(282, 13),
(283, 13),
(284, 13),
(285, 13),
(286, 13),
(287, 13),
(288, 13),
(289, 13),
(290, 13),
(291, 13),
(294, 13),
(295, 13),
(296, 13),
(297, 13),
(298, 13),
(299, 13),
(300, 13),
(301, 13),
(302, 13),
(303, 13),
(304, 13),
(305, 13),
(292, 14),
(293, 14),
(306, 15);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `doctors`
--
ALTER TABLE `doctors`
  ADD CONSTRAINT `doctors_ibfk_1` FOREIGN KEY (`primary_actor`) REFERENCES `actors` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `episodes`
--
ALTER TABLE `episodes`
  ADD CONSTRAINT `serial_id_fk` FOREIGN KEY (`serial_id`) REFERENCES `serials` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `serials`
--
ALTER TABLE `serials`
  ADD CONSTRAINT `season_id_fk` FOREIGN KEY (`season_id`) REFERENCES `seasons` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

--
-- Constraints for table `serials_doctors`
--
ALTER TABLE `serials_doctors`
  ADD CONSTRAINT `serials_doctors_ibfk_1` FOREIGN KEY (`doctor_id`) REFERENCES `doctors` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD CONSTRAINT `serials_doctors_ibfk_2` FOREIGN KEY (`serial_id`) REFERENCES `serials` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
SET FOREIGN_KEY_CHECKS=1;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
