[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