-- phpMyAdmin SQL Dump
-- version 2.8.0.3-Debian-1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 19, 2006 at 05:40 PM
-- Server version: 4.1.15
-- PHP Version: 4.4.2-1build1
-- 
-- Database: `mythtv`
-- 

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

-- 
-- Table structure for table `recordedprogram`
-- 

DROP TABLE IF EXISTS `recordedprogram`;
CREATE TABLE IF NOT EXISTS `recordedprogram` (
  `chanid` int(10) unsigned NOT NULL default '0',
  `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `endtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(128) NOT NULL default '',
  `subtitle` varchar(128) NOT NULL default '',
  `description` text NOT NULL,
  `category` varchar(64) NOT NULL default '',
  `category_type` varchar(64) NOT NULL default '',
  `airdate` year(4) NOT NULL default '0000',
  `stars` float unsigned NOT NULL default '0',
  `previouslyshown` tinyint(4) NOT NULL default '0',
  `title_pronounce` varchar(128) NOT NULL default '',
  `stereo` tinyint(1) NOT NULL default '0',
  `subtitled` tinyint(1) NOT NULL default '0',
  `hdtv` tinyint(1) NOT NULL default '0',
  `closecaptioned` tinyint(1) NOT NULL default '0',
  `partnumber` int(11) NOT NULL default '0',
  `parttotal` int(11) NOT NULL default '0',
  `seriesid` varchar(12) NOT NULL default '',
  `originalairdate` date default NULL,
  `showtype` varchar(30) NOT NULL default '',
  `colorcode` varchar(20) NOT NULL default '',
  `syndicatedepisodenumber` varchar(20) NOT NULL default '',
  `programid` varchar(20) NOT NULL default '',
  `manualid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`chanid`,`starttime`,`manualid`),
  KEY `endtime` (`endtime`),
  KEY `title` (`title`),
  KEY `title_pronounce` (`title_pronounce`),
  KEY `seriesid` (`seriesid`),
  KEY `programid` (`programid`),
  KEY `id_start_end` (`chanid`,`starttime`,`endtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `recordedprogram`
-- 

INSERT DELAYED IGNORE INTO `recordedprogram` (`chanid`, `starttime`, `endtime`, `title`, `subtitle`, `description`, `category`, `category_type`, `airdate`, `stars`, `previouslyshown`, `title_pronounce`, `stereo`, `subtitled`, `hdtv`, `closecaptioned`, `partnumber`, `parttotal`, `seriesid`, `originalairdate`, `showtype`, `colorcode`, `syndicatedepisodenumber`, `programid`, `manualid`) VALUES (1136, '2006-07-18 04:00:00', '2006-07-18 04:30:00', 'Rugrats', 'Under Chuckie''s Bed; Chuckie is Rich', 'Chuckie gets a big-boy''s bed; Chaz wins $10 million.', 'Children', 'series', 0000, 0, 0, '', 1, 0, 0, 1, 0, 0, 'SH019781', NULL, 'Series', '', '55AB', 'EP0197810021', 0),
(1136, '2006-07-18 09:30:00', '2006-07-18 10:00:00', 'Rugrats', 'Toy Palace; Sand Ho!', 'Chuckie and Tommy are locked in a toy store; the Rugrats pretend to be pirates.', 'Children', 'series', 0000, 0, 0, '', 1, 0, 0, 1, 0, 0, 'SH019781', NULL, 'Series', '', '14AB', 'EP0197810045', 0);