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@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Thank you very much...
/kbn
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
