-- 1. Updates to zones table
ALTER TABLE zones 
CHANGE COLUMN name zone_name VARCHAR(100) NOT NULL,
DROP COLUMN description,
ADD COLUMN color_code VARCHAR(7) DEFAULT '#00a6ce';

-- 2. Updates to restaurant_tables table
ALTER TABLE restaurant_tables
DROP COLUMN zone,
DROP COLUMN shape,
DROP COLUMN capacity,
DROP COLUMN grid_span_width,
DROP COLUMN session_id,
DROP COLUMN seated_at,
MODIFY COLUMN status ENUM('Blank', 'Running', 'Printed', 'Paid', 'RunningKOT') DEFAULT 'Blank',
ADD COLUMN zone_id INT NOT NULL AFTER table_number,
ADD COLUMN is_virtual_split BOOLEAN DEFAULT FALSE,
ADD COLUMN split_divisor INT DEFAULT 1,
ADD COLUMN customer_name VARCHAR(255) DEFAULT NULL,
ADD COLUMN customer_phone VARCHAR(20) DEFAULT NULL,
ADD COLUMN waiter_id VARCHAR(50) DEFAULT NULL,
ADD COLUMN pax INT DEFAULT NULL,
ADD COLUMN comments TEXT DEFAULT NULL;

-- 3. Create table_carts
CREATE TABLE IF NOT EXISTS table_carts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    table_id INT NOT NULL,
    global_discount_type ENUM('flat', 'percent', 'coupon') DEFAULT NULL,
    global_discount_value DECIMAL(10,2) DEFAULT 0.00,
    global_coupon_code VARCHAR(50) DEFAULT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (table_id) REFERENCES restaurant_tables(id) ON DELETE CASCADE
);

-- 4. Create table_cart_items
CREATE TABLE IF NOT EXISTS table_cart_items (
    cart_item_id VARCHAR(36) PRIMARY KEY, -- Used to store UUIDs
    table_id INT NOT NULL,
    menu_id INT NOT NULL,
    name VARCHAR(255) NOT NULL,
    quantity INT DEFAULT 1,
    base_price DECIMAL(10,2) NOT NULL,
    selected_modifiers JSON DEFAULT NULL,
    is_complimentary BOOLEAN DEFAULT FALSE,
    item_discount DECIMAL(10,2) DEFAULT 0.00,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (table_id) REFERENCES restaurant_tables(id) ON DELETE CASCADE
);
