Ok, looks like a migration taking shape. That was to be another question, but I had not yet got that far wondering if it may go the "brute-force" route.
There are 4 other columns in the `pickreq` table, one of which is `loccode` as a foreign key, but I may be able to derive this info as part of item #3 below.
So, the "general idea" as it seems at the moment, is to:
- Leave the 2 original trunk tables as-is (or in-place) for now...
- Create the 3 new tables relative to Andrew's handling...
- Migrate the existing data from the existing tables (which will become unused), based on the similar columns... (I can handle this SQL, no problem)
- Then see how the overall handling goes from there.
If that is correct, that sounds good, I hope that some of the un-populated columns don't cause issues, such as script filtering uses when output, but we'll see.
Other than that, I might still need to see what your copy of the PDFPickingList.php might contain -- if it differs much from the trunk copy that I have.