-- Migration to support Advanced KOT & Billing Workflow

ALTER TABLE table_cart_items
ADD COLUMN status ENUM('pending', 'sent_to_kitchen', 'served', 'cancelled') DEFAULT 'pending',
ADD COLUMN kot_id VARCHAR(50) DEFAULT NULL,
ADD COLUMN cancel_reason VARCHAR(255) DEFAULT NULL,
ADD COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

-- Optional: Add index for performance
CREATE INDEX idx_table_cart_items_status ON table_cart_items(status);
CREATE INDEX idx_table_cart_items_kot_id ON table_cart_items(kot_id);

-- Mirror status and kot_id in order_items for KDS display
ALTER TABLE order_items
ADD COLUMN status ENUM('pending', 'sent_to_kitchen', 'served', 'cancelled') DEFAULT 'pending',
ADD COLUMN kot_id VARCHAR(50) DEFAULT NULL;

