[mythtv-users] Re: Help needed on oldrecordings table...

[Boleslaw Ciesielski]

Kim B. Nielsen wrote:
> Any chance that I can get one to log into their sql server and make an 
> 'describe oldrecorded'?
> 
> Or better yet, point me to the sql expression that creates the table, 
> because i can't seem to find it...
> 
> The version of myth is 0.18.1

CREATE TABLE `oldrecorded` (
   `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 '',
   `seriesid` varchar(12) NOT NULL default '',
   `programid` varchar(20) NOT NULL default '',
   `findid` int(11) NOT NULL default '0',
   `recordid` int(11) NOT NULL default '0',
   PRIMARY KEY  (`chanid`,`starttime`),
   KEY `endtime` (`endtime`),
   KEY `title` (`title`),
   KEY `seriesid` (`seriesid`),
   KEY `programid` (`programid`),
   KEY `recordid` (`recordid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;