-- added_location_id_to_sales_deliveries_table --
ALTER TABLE `phppos_sales_deliveries` ADD COLUMN `location_id` INT NULL AFTER `duration`, ADD FOREIGN KEY (`location_id`) REFERENCES `phppos_locations`(`location_id`);