[mythtv-users] sql query to identify duplicates
Karl Dietz
dekarl at spaetfruehstuecken.org
Thu May 1 09:46:09 UTC 2014
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.
Regards,
Karl
More information about the mythtv-users
mailing list