• 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
www.johanvromans.nlwww.howsagoin.nlwww.hetgeluidvanseptember.nl
Samsung Galaxy Note S4 (T830) 10.5", Android 9.0, AirTurn Duo & Digit.
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS) (backup).
Samsung A3 (A320FL), Android 8.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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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