[mythtv-users] Remove program listings from database

[Nick]

On 25/08/06, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 08/24/2006 04:53 PM, Nick wrote:
>
> >On 24/08/06, OJ <ole at legaard.net> wrote:
> >
> >
> >>I'm running 0.19.
> >>
> >>Is it possible to delete all program listings from the database?
> >>
> >>
> ...
>
> >If you want to keep your video sources but delete all program listing
> >information, the only way to achieve this is to edit the database
> >directly - remember this is more risky, and you really need to remove
> >the information from all the associated program listing tables
> >(program, credits, programrating, programgenres, etc).
> >
>
> You can skip this and they'll eventually get "expired".
>
> DELETE FROM program;
>
> or
>
> TRUNCATE TABLE program;
>
> should be good enough.

Mike,

Just so I understand this - if you delete just the contents of the
program table, does MFDB automatically determine the newly orphaned
information in the associated credits/rating/genre tables and delete
it as soon as it can't find the keyed information in the program
table?

Cheers,
Nick

-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users