34968-vm/migrations/20251015_add_menu_item_id_to_cart.sql
Flatlogic Bot 2c8c9bfe04 V7
2025-10-15 01:01:54 +00:00

4 lines
254 B
SQL

ALTER TABLE cart DROP CONSTRAINT IF EXISTS fk_menu_item;
ALTER TABLE cart DROP COLUMN IF EXISTS menu_item_id;
ALTER TABLE cart ADD COLUMN menu_item_id INT;
ALTER TABLE cart ADD CONSTRAINT fk_menu_item FOREIGN KEY (menu_item_id) REFERENCES menu_items(id);