-- eskuel:system=sqlite
-- eskuel:systemMinVersion=3.37.0

-- Create the "beverage" table
CREATE TABLE beverage (
    name VARCHAR(255) PRIMARY KEY NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    volume INT NOT NULL -- Volume in millilitres (ml)
);

-- Insert sample data into the "beverage" table
INSERT INTO beverage (name, price, volume) VALUES
    ('Coffee', 2.50, 250),
    ('Tea', 2.00, 240),
    ('Cappuccino', 3.00, 300),
    ('Espresso', 2.50, 50),
    ('Hot Chocolate', 3.50, 300);

-- Create the "cake" table
CREATE TABLE cake (
    name VARCHAR(255) PRIMARY KEY NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    is_vegan BOOLEAN NOT NULL
);

-- Insert sample data into the "cake" table
INSERT INTO cake (name, price, is_vegan) VALUES
    ('Chocolate Cake', 4.50, FALSE),
    ('Apple Cake', 3.50, TRUE),
    ('Carrot Cake', 4.00, TRUE),
    ('Cheesecake', 4.50, FALSE),
    ('Lemon Cake', 4.00, TRUE);