[mythtv-users] modifying recorded program descriptions

mielikki-ivtv mielikki-ivtv at westbrook.com
Sun Dec 12 23:47:57 UTC 2004


If I want to change the title, subtitle, or description of a recorded 
show using MySQL commands, are there any caveats I should be aware of?

The basic command I would use is something like this (I haven't syntax 
checked this, so just use it to get the idea):

UPDATE recorded SET starttime=starttime, endtime=endtime, title='new 
title' WHERE chanid=@ChanId AND starttime=@StartTime;

I'm assuming that, since the starttime and endtime are of type 
TIMESTAMP, it is a good idea to make sure they don't get reset (probably 
only need to specify it for the first TIMESTAMP in the table, but 
doesn't hurt to do both).

Any other tables that might be affected?

One caveat might be that I might mess up the stuff that tries to 
determine if I have already recorded this episode of a series.


More information about the mythtv-users mailing list