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

-- Create the "container" table
CREATE TABLE IF NOT EXISTS container (
    name TEXT PRIMARY KEY,
    price INTEGER NOT NULL
);

-- Insert data into the "container" table
INSERT INTO container (name, price)
VALUES
    ('Cone', 50),
    ('Premium Cone', 70),
    ('Cup', 10);

-- Create the "flavour" table
CREATE TABLE IF NOT EXISTS flavour (
    name TEXT PRIMARY KEY,
    price INTEGER NOT NULL
);

-- Insert data into the "flavour" table
INSERT INTO flavour (name, price)
VALUES
    ('Cookie Dough', 110),
    ('Chocolate', 100),
    ('Vanilla', 90);