renumber supermotifs
we don't have 15 and 18
so we want to renumber supermotifs.
usually
move 16 to 15
move 17 to 16
move 19 to 17
move 20 to 18
move 21 to 19
move 22 to 20
move 23 to 21
move 24 to 22
move 25 to 23
move 26 to 24
move 27 to 25
move 28 to 26
and all the motifs in them.
so I decide take a short cut
move 28 to 15
move 27 to 18
move 28a to 15a
move 27a to 18a
so, sql as follow:
update sandwich set supermotif=15 where supermotif=28;
update sandwich set supermotif=18 where supermotif=27;
update sandwich set motif='15A' where motif='28A';
update sandwich set motif='18A' where motif='27A';
done on http://sssdb.no-ip.info:81/demoFrameset.html
so we want to renumber supermotifs.
usually
move 16 to 15
move 17 to 16
move 19 to 17
move 20 to 18
move 21 to 19
move 22 to 20
move 23 to 21
move 24 to 22
move 25 to 23
move 26 to 24
move 27 to 25
move 28 to 26
and all the motifs in them.
so I decide take a short cut
move 28 to 15
move 27 to 18
move 28a to 15a
move 27a to 18a
so, sql as follow:
update sandwich set supermotif=15 where supermotif=28;
update sandwich set supermotif=18 where supermotif=27;
update sandwich set motif='15A' where motif='28A';
update sandwich set motif='18A' where motif='27A';
done on http://sssdb.no-ip.info:81/demoFrameset.html