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

ALTER TABLE tankLights
    ADD CONSTRAINT fk_tankLights_light
    FOREIGN KEY (lightID)
    REFERENCES lights(lightID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;
