For APS they would also like to specify the priority of the samples queued for mail-in / autocollect, so i would like to add:
ALTER TABLE `DiffractionPlan`
ADD `priority` INT(4) NULL COMMENT 'The priority of this sample relative to others in the container';