[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