ALTER TABLE menu_items
ADD COLUMN promotion_id INT,
ADD CONSTRAINT fk_promotion
  FOREIGN KEY(promotion_id)
  REFERENCES special_promotions(id)
  ON DELETE SET NULL;