[mythtv] [PATCH] Split program.{start, end}time into separate date and time columns

Matt Zimmerman mdz at debian.org
Fri Mar 19 12:38:42 EST 2004


On Fri, Mar 19, 2004 at 08:43:45AM -0800, Matt Zimmerman wrote:

> On Fri, Mar 19, 2004 at 10:12:06AM -0600, David Engel wrote:
> > 2. In a few DB queries, you replaced something like "WHERE
> >    ... starttime >= xyz" with "WHERE ...  startdate >= xyzdate AND
> >    starttime >= xyztime".  This should be like "WHERE ... startdate >
> >    xyzdate OR (startdate = xyzdate AND starttime >= xyztime)".

I've also wondered for a while if it wouldn't make sense to assign a unique
ID to each program we know about (auto_increment or such) which would be
preserved by mythfilldatabase if the program is determined to be a match.
Then we could use that to map various tables to the program table
efficiently, and it would also have the positive side effect of dissociating
them if the program was replaced by a different one due to a scheduling
change.

Thoughts?

-- 
 - mdz


More information about the mythtv-dev mailing list