[mythtv-users] modifying recorded program descriptions
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