[mythtv] db schema, metadata and season/episode numbering

[Stuart Morgan]

On Monday 30 Apr 2012 16:34:06 Raymond Wagner wrote:
> On 4/30/2012 16:27, Torbjörn Jansson wrote:
> > I didn’t find anywhere that inserts the season and episode data in the
> > recorded table unless you do it manually.
> 
> It doesn't, as there is no season/episode number stored for guide data
> for it to be inserted into recordings. It must be inserted afterwards,
> either manually by the user, or automatically by mythmetadatalookup.

There is season/episode information for some guide sources, which is I believe 
what's being discussed here. When I last raised the subject of inserting 
season/episode information from guide data into the database it was shot down 
by Robert M because he believed that it couldn't be trusted and would 
interfere with his metadata lookup stuff.

Since he's no longer here to block it I'd be interested in pushing forward, at 
least in the UK it's pretty decent information. There's no reason to simply 
ignore it, especially when the current metadata lookup is so hit and miss (tv 
espiodes frequently given film metadata and vice-versa), having season/episode 
information would either make it more reliable or as reliable, but certainly  
not less. Even if the air order differs from the order at tvdb.com (subtitle 
etc) can always take precedence over episode number.

If nothing else it could be inserted as airepisode/airseason - let those of us 
who get this data use it in the UI and for sorting.
-- 
Stuart Morgan