• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database internals: FileId in TextDisplaySettings table
#1
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
Johan
johanvromans.nl — hetgeluidvanseptember.nl — mojore.nl -- howsagoin.nl
Samsung Galaxy Note S7FE (T733) 12.4", Android 13.0, AirTurn Duo & Digit (Gigs).
Samsung Galaxy Note S4 (T830) 10.5", Android 10.0 (maintenance and backup).
Samsung A3 (A320FL), Android 8.0.0 (emergency).
Reply
#2
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
Reply




Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.