ALTER TABLE `pumps` ADD COLUMN `tank_id` INT NULL, ADD FOREIGN KEY (`tank_id`) REFERENCES `tanks`(`id`);