Closed gjf2a closed 1 year ago
This is part of implementing #20.
Redo the database schema as follows:
melodies
row
melody_id
melody_indices
info
row_id
info_index
Not worth the trouble. I got #20 working without doing this.
This is part of implementing #20.
Redo the database schema as follows:
melodies
table as is, but index therow
column. Rename it tomelody_id
. It will be a reference to the index in themelody_indices
table.info
table that contains:melody_indices
row_id
values - one for the melody, one for the variation.melody_indices
table that contains one column - theinfo
tablerow_id
, which we'll callinfo_index
.info
.info
table size, double for the melody, double + 1 for the variation.