[mythtv-users] sql query to identify duplicates

[Leo Butler]

Hi Karl,

>   Hi Leo,
>
>   On 30.04.2014 17:48, Leo Butler wrote:
>   >>    From: Raymond Wagner<raymond at wagnerrp.com>
>   >>    On 4/30/2014 9:47 AM, Leo Butler wrote:
>   >>    >
>   >>    >  I would like to write an sql query to identify duplicate recordings,
>   >>    >  in order to delete the older recording. I am no sql guru, and my first
>   >>    >  thought was to query the recorded.duplicate field--but this is set to
>   >>    >  1 for all recordings, so the name belies its purpose.
>   >>
>   >>    That field (along with the one in oldrecorded) indicates that the record
>   >>    is participating in duplicate matching.  If you set it to zero, the
>   >>    scheduler will allow that show to be re-recorded, independent of any
>   >>    duplicate filters you may have on the recording rule.  This is how the
>   >>    "forget recording" mechanism operates.
>   >
>   > Raymond, thanks, that clarifies that matter. The wiki page does not
>   > have this information. Should this be added?
>   >
>   > http://www.mythtv.org/wiki/Recorded_table
>
>   it is a wiki, so please feel free to update / extend as you encounter 
>   outdated / incomplete information.

A second question: from Raymond's description, the duplicate field
sounds like it should be a boolean. Is that correct? If so, I take it
that the database has no boolean datatype and the tinyint is used in
place?

Leo