[mythtv-users] Re: Help needed on oldrecordings table...
Boleslaw Ciesielski
bolek-mythtv at curl.com
Wed Dec 28 19:08:05 EST 2005
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;
More information about the mythtv-users
mailing list