MobileSheets Forums

Full Version: Database internals: FileId in TextDisplaySettings table
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
AFAIK, the TextDisplaySettings only applies to ChordPro/text songs.

Since ChordPro/text songs can have only one file associated, the SongId uniquely identifies the song and the FileId column can be removed from the table.

https://johan.vromans.org/seasons_greetings.html
It's true that I only support one file at the moment. There is no guarantee that I won't try to support multiple files in the future though.  Doing so would require some redesign so I guess I could wait until then to add the FileId back...  I'm just trying to decide if it's worth the effort to remove that field right now when there are so many higher priority things I'm working on. I might table it for future cleanup.

Thanks,
Mike