[mythtv-users] Re: Help needed on oldrecordings table...
Kim B. Nielsen
kbn at daimi.au.dk
Wed Dec 28 19:20:04 EST 2005
Boleslaw Ciesielski wrote:
> 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;
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Thank you very much...
/kbn
More information about the mythtv-users
mailing list