[mythtv-users] Removed program table from mysql

[Ian Trider]

> I'm not that good at SQL, so using webmin I tried to empty the
> mythconverg.program table. Unfortunatly, I'm not that good at webmin
> either, so I ended up delating the table. Running mythfilldatabase
> again just complains about the missing table.

Whoops!  I've asked phpMyAdmin to give me a dump of the table
structure.. you should be able to insert this, and the table will be
created properly. Here you go:


-- 
-- Table structure for table `program`
-- 

CREATE TABLE `program` (
  `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) default NULL,
  `subtitled` tinyint(1) default NULL,
  `hdtv` tinyint(1) default NULL,
  `closecaptioned` tinyint(1) default NULL,
  `partnumber` int(11) default NULL,
  `parttotal` int(11) default NULL,
  `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(12) NOT NULL default '',
  PRIMARY KEY  (`chanid`,`starttime`),
  KEY `endtime` (`endtime`),
  KEY `title` (`title`),
  KEY `title_pronounce` (`title_pronounce`),
  KEY `seriesid` (`seriesid`),
  KEY `programid` (`programid`),
  KEY `id_start_end` (`chanid`,`starttime`,`endtime`)
) TYPE=MyISAM;
        
---

-- 
Ian Trider
iantri at gmail.com