[mythtv] Database layout

Eric Andresen ruler111 at cox.net
Mon Mar 31 14:33:38 EST 2003

On Mon, 2003-03-31 at 14:13, Calvin Harrigan wrote:
> Greetings all,
> I've been perusing the mythtv database trying to determine where all the
> programs 'to be' recorded are stored.  Previously it has been in several
> tables.
> singlerecord
> timeslotrecord
> allrecord
> record
> Record has since taken on a different task, purpose.  All the recordings
> of all types all seem to be in this table now.  
> 1) Is this a correct statement?  
> 2) If so, how is this table updated with the timeslot record, weekly
> record, any channel, anytime on this channel?  
> 3) How are these programs flagged in the database?  
> 4) Is the extended 'to be recorded' information generated on the fly in
> the epg using just the type flag in the record table as a marker to do
> further querying?
> 5) Are the aforementioned tables obsolete?
> I know it seems like a lot of questions. I've try to figure out as much
> as I could without getting into the code. I'm working on a little applet
> for mythtv that requires the record info.  I just need to know what/how
> to query.
> Thanks for the help.
> Calvin

The easiest would be to look at how MythWeb gets/stores the info.
single.php and functions.php contain all of that functionality.

--Eric Andresen
  ndiin at asu.edu

More information about the mythtv-dev mailing list