[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