[mythtv] Recorded Programs table schema

[Stuart Morgan]

On Sunday 27 Nov 2005 13:08, Torbjörn Jansson wrote:
> > What I noticed was that the 'recorded' table doesn't have a unique id
> > column, instead relying on a combination of start/end time and
> > program name. Was this a conscious decision? If so why?
> >
> > I ask because the future proof solution to the mythweb deletion issue
> > would be to use a static format unique id instead of changing the
> > input filter to match possible filenames.
>
> There is a way to uniquely identify a row in the recorded table, thats what
> the primary keys are for.
> The combination of chanid and starttime must be unique.

Good point. Although for that reason I can't understand why for deletion etc 
Myth Protocol appears to require the filename, title etc.

Anyway using the chanid and starttime should be better than using the filename 
in the mythweb delete function. So I'm now off to create the patch.
-- 
Stuart Morgan