Thanks. So it looks like records are only created in the settings table for files where the user has adjusted something for a given file. I can see how Kodi is incorrectly setting a flag for subtitles where I’ve adjusted something else. Having browsed the settings, tvshow and episode tables, it looks like I would have to do the following (beyond my SQL coding skills!)
select c00 and idShow from tvshow where c00=name of show I want to apply deinterlacing update to
select idFile and idShow from episode, only for those records selected from tvshow with the correct show title
we now have a list of idFile values that we want to insert into settings, with Deinterlace set to 0, and all other columns in settings equal to default values, while ensureing there is only one record per idFile value
Are there any SQL coders who can advise? I am using phpMyAdmin to play with queries to get the hang of this.