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

[David Engel]

On Fri, Mar 19, 2004 at 09:38:42AM -0800, Matt Zimmerman wrote:
> 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.

>From what Bruce and I have been able to figure out, that's exactly how
the Tribune company stores their data.  They appear to have a program
table and a channel table and then use a schedule table which place a
program on a channel at specified time.  If anyone's looked at the
labs.zap2it.com data, it even includes the unique program and channel
IDs.

I keep hoping somebody will pick up the ball on the labs.zap2it.com
data and run with it.  Their data includes lots of useful information
like episode numbers (ideal duplicate detecion) and credits (actor and
director searches).

David
-- 
David Engel
gigem at comcast.net