Reply to thread

lol - no, I can't do a re-import as it takes hours and downloads several gigs of data.  I'm doing this at a mate's house and he as a very very small monthly limit on his ISP plan.

 

I found that I can resolve the previous issue via:

sqlite> update season

....> set EpisodesUnwatched = EpisodeCount;

 

And voila, that sets all EpisodesUnwatched to be the same as EpisodeCount.

 

Now on to the series table.