Boardies,
I've made some improvements to the music library. Go to
http://acwe.org/library/ to get a sneak preview.
I added the capability to add parts to the instrumentation. This required
remodeling the parts table, but by doing so, it's easier to write reports
like the following, which shows all the pieces with missing original parts:
MariaDB [arbilewca]> SELECT `compositions`.`name` Composition,
`part_types`.`name` Missing_part
-> FROM `compositions`
-> LEFT JOIN `parts` ON `parts`.`catalog_number` =
`compositions`.`catalog_number`
-> LEFT JOIN `part_types` ON `parts`.`id_part_type` =
`part_types`.`id_part_type`
-> WHERE `parts`.`originals_count` = 0
-> ORDER BY `compositions`.`name` ASC, `part_types`.`collation` ASC,
`parts`.`id_part_type` ASC;
+-------------------------+----------------+
| Composition | Missing_part |
+-------------------------+----------------+
| (Yankee Doodle) Missing | Clarinet in Bb |
+-------------------------+----------------+
1 row in set (0.000 sec)
I also added a "search" button to the Compositions entry, where it opens a
search page on WindRep.org with the title.
Anyone can sign up for a username/password (when you click the padlock in
the upper right, you see "Sign up now" on the logon page). Remember, if you
login and go delete everything, it's GONE FOREVER.
Let me know what problems you find. I'm quite sure there are many.
Regards,