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

-- Create the "fruit" table
CREATE TABLE fruit (
    name VARCHAR(255) PRIMARY KEY NOT NULL,
    price_per_kilogram DECIMAL(10, 2) NOT NULL,
    origin VARCHAR(255) NOT NULL
);

-- Insert sample data into the "fruit" table
INSERT INTO fruit (name, price_per_kilogram, origin)
VALUES
    ('Apple', 2.99, 'Germany'),
    ('Banana', 1.49, 'Costa Rica'),
    ('Strawberry', 4.50, 'Spain'),
    ('Grape', 3.75, 'Italy'),
    ('Cherry', 5.20, 'Germany');

-- Create the "vegetable" table
CREATE TABLE vegetable (
    name VARCHAR(255) PRIMARY KEY NOT NULL,
    price_per_kilogram DECIMAL(10, 2) NOT NULL,
    origin VARCHAR(255) NOT NULL
);

-- Insert sample data into the "vegetable" table
INSERT INTO vegetable (name, price_per_kilogram, origin)
VALUES
    ('Tomato', 1.99, 'Netherlands'),
    ('Cucumber', 1.25, 'Spain'),
    ('Carrot', 1.75, 'Germany'),
    ('Courgette', 2.20, 'France'),
    ('Broccoli', 2.99, 'Germany');