ALTER TABLE lights
    ADD CONSTRAINT fk_lights_manufacturer
    FOREIGN KEY (manufacturerID)
    REFERENCES manufacturers(manufacturerID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;

