ALTER TABLE tankPhotos
    ADD CONSTRAINT fk_tankPhotos_tank
    FOREIGN KEY (tankID)
    REFERENCES tanks(tankID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;

