[mythtv] [PATCH] Save program guide data with recordings

[Colin Cross]

This patch adds support for saving the guide data for recordings, 
including the credits.  It modifies the following files:
dbcheck.cpp:
Changes dbver to 1073, adds recordedprogram, recordedcredits, and 
recordedrating tables with the same columns as the program, credits, and 
programrating tables.
programinfo.cpp:
ProgramInfo::StartedRecording copies data into the recorded* tables
ProgramInfo::showDetails gets data from the program tables if 
filesize=0, or from the recorded* tables if filesize>0
mainserver.cpp:
Delete thread removes data from recorded* tables

This patch assumes that the recordedprogram table has the exact same 
column format as the program table, and the same for credits and 
recordedcredits and programrating and recordedrating.  This restriction 
can be lifted by putting a list of all the columns in the data copying 
code in ProgramInfo::StartedRecording, but then any time a new column is 
created it would have to be added to the list.  Also, I used the INSERT 
INTO ... SELECT command for the data copying, which could be sped up by 
the use of separate INSERT and SELECT commands for the single row queries.
Some data is duplicated between the recorded and recordedprogram table.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mythtv-record-program-data.diff
Type: text/x-patch
Size: 9619 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20050220/4c43f462/mythtv-record-program-data.bin