[sciurius]

Don't want to give you any extra work either .

Results for the current database (on device as well as in the cloud):

sqlite> select count(*) from Songs;
1607
sqlite> select count(*) from Songs,TextDisplaySettings where Songs.id = TextDisplaySettings.SongId and TransposeKey < 0;
554

It seems that all songs that were added but never involved in a transpose have TransposeKey = -1. Isn't this just the default value?

But I also noticed that I have 373 entries in TextDisplaySettings for existing songs that refer to non-existent files. Sometimes even multiple, e.g.

   

(File 1930 exists, but 14410 does not.)

Must I be afraid I have a serious database corruption, or has there been a time where removing files did not remove the corresponding TextDisplaySettings entry?

I have manually added foreign keys to the tables and enabled foreign key checking, and it only seems to be so for the TextDisplaySettings. All other tables check ok.