[mythtv] Recorded Programs table schema

[Torbjörn Jansson]

mythtv-dev-bounces at mythtv.org <> wrote:
> I'm looking at a bug in mythweb which prevents it from deleting
> renamed recordings. The bug occurs simply because the input is
> checked against an expected pattern to prevent an nasty individual
> deleting system  files etc. 
> 
> 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.