xbmc/xbmc — pull request #943 by jmarshallnz (2012-05-08 09:42:27+00:00)
Title: add idShow to the episode table and drop the unneeded tvshowlinkepisode

Mostly cleanup.

A couple of questions about this one though:

1. I've taken the easy route by appending idShow to the episodes table. This means it can't easily be expanded in the future (using the silly c## stuff). IMO this is not a bad thing - perhaps it will encourage us to redo the db.

2. Because of this, it's meant I needed to shuffle the order in the episodeview, which meant bring some stuff out of GetCommonDetails. IMO this is nicer than stuffing idShow into one of the c## columns.