-- 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),
    ('Latte Macchiato', 3.80, 350),
    ('Americano', 3.00, 250),
    ('Filter Coffee', 2.20, 300),
    ('Chai Latte', 3.70, 300),
    ('Matcha Latte', 4.20, 300),
    ('Orange Juice', 3.20, 250),
    ('Apple Spritzer', 2.80, 330),
    ('Mineral Water', 2.20, 500);

-- 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),
    ('Marble Cake', 3.80, FALSE),
    ('Strawberry Cake', 4.80, FALSE),
    ('Plum Cake', 4.20, TRUE),
    ('Nut Cake', 4.30, TRUE),
    ('Poppy Seed Cake', 4.40, FALSE),
    ('Cherry Cake', 4.50, TRUE),
    ('Banana Cake', 4.10, TRUE),
    ('Crumb Cake', 3.90, FALSE);