-- 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'),
    ('Pear', 3.20, 'Germany'),
    ('Orange', 2.49, 'Spain'),
    ('Lemon', 2.89, 'Italy'),
    ('Peach', 3.99, 'Spain'),
    ('Plum', 3.49, 'Germany'),
    ('Raspberry', 8.90, 'Germany'),
    ('Blueberry', 7.50, 'Poland'),
    ('Mango', 4.20, 'Peru'),
    ('Pineapple', 2.80, 'Costa Rica'),
    ('Kiwi', 3.60, 'New Zealand'),
    ('Watermelon', 1.79, 'Spain'),
    ('Apricot', 4.75, 'France'),
    ('Pomegranate', 5.90, 'Turkey'),
    ('Mandarin', 2.69, 'Spain'),
    ('Redcurrant', 6.80, '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'),
    ('Bell Pepper', 3.49, 'Spain'),
    ('Potato', 1.29, 'Germany'),
    ('Onion', 1.19, 'Germany'),
    ('Garlic', 5.50, 'Spain'),
    ('Cauliflower', 2.79, 'Germany'),
    ('Spinach', 3.20, 'Italy'),
    ('Leek', 2.40, 'Germany'),
    ('Aubergine', 2.89, 'Netherlands'),
    ('Pumpkin', 1.99, 'Germany'),
    ('Celery', 2.10, 'Germany'),
    ('Radish', 3.60, 'Germany'),
    ('Kohlrabi', 2.30, 'Germany'),
    ('Pea', 4.40, 'France'),
    ('Asparagus', 9.90, 'Germany'),
    ('Beetroot', 1.89, 'Germany');