Changes for automatic shipment creation about ispyb-database-modeling HOT 5 OPEN

ALTER TABLE CourierTermsAccepted
  DROP FOREIGN KEY CourierTermsAccepted_ibfk_3,
  DROP shippingId;

ALTER TABLE Shipping
  DROP deliveryAgent_flightCodeTimestamp,
  DROP deliveryAgent_label,
  DROP readyByTime,
  DROP closeTime,
  DROP physicalLocation,
  DROP deliveryAgent_pickupConfirmationTimestamp,
  DROP deliveryAgent_pickupConfirmation,
  DROP deliveryAgent_readyByTime,
  DROP deliveryAgent_callinTime,
  DROP deliveryAgent_productcode,
  DROP FOREIGN KEY Shipping_ibfk_4,
  DROP deliveryAgent_flightCodePersonId;
  
ALTER TABLE Dewar
  DROP weight, 
  DROP deliveryAgent_barcode;
  
ALTER TABLE Laboratory
  DROP postcode;

ALTER TABLE CourierTermsAccepted
  ADD shippingId int(11) unsigned,
  ADD CONSTRAINT CourierTermsAccepted_ibfk_3
      FOREIGN KEY (shippingId) REFERENCES Shipping(shippingId) ON DELETE CASCADE ON UPDATE CASCADE;
      
ALTER TABLE Shipping 
  ADD deliveryAgent_flightCodeTimestamp timestamp NULL DEFAULT NULL COMMENT 'Date flight code created, if automatic',
  ADD deliveryAgent_label text COMMENT 'Base64 encoded pdf of airway label',
  ADD readyByTime time COMMENT 'Time shipment will be ready',
  ADD closeTime time COMMENT 'Time after which shipment cannot be picked up',
  ADD physicalLocation varchar(50) COMMENT 'Where shipment can be picked up from: i.e. Stores',
  ADD deliveryAgent_pickupConfirmationTimestamp timestamp NULL DEFAULT NULL COMMENT 'Date picked confirmed',
  ADD deliveryAgent_pickupConfirmation varchar(10) COMMENT 'Confirmation number of requested pickup',
  ADD deliveryAgent_readyByTime time COMMENT 'Confirmed ready-by time',
  ADD deliveryAgent_callinTime time COMMENT 'Confirmed courier call-in time',
  ADD deliveryAgent_productCode varchar(10) COMMENT 'A code that identifies which shipment service was used',
  ADD deliveryAgent_flightCodePersonId int(10) unsigned COMMENT 'The person who created the AWB (for auditing)',
  ADD CONSTRAINT Shipping_ibfk_4
      FOREIGN KEY (deliveryAgent_flightCodePersonId) REFERENCES Person(personId);

ALTER TABLE Dewar
  ADD weight float COMMENT 'Dewar weight in kg',
  ADD deliveryAgent_barcode varchar(30) COMMENT 'Courier piece barcode (not the airway bill)';

ALTER TABLE Laboratory
  ADD postcode varchar(15);