DROP SCHEMA IF EXISTS hello_schema CASCADE;

CREATE SCHEMA IF NOT EXISTS hello_schema;

CREATE TABLE IF NOT EXISTS hello_schema.couriers(
    courier_id SERIAL PRIMARY KEY,
    courier_type TEXT,
    regions INTEGER[],
    working_hours TEXT[][]
);

CREATE TABLE IF NOT EXISTS hello_schema.users (
    name TEXT PRIMARY KEY,
    count INTEGER DEFAULT(1)
);



CREATE TABLE IF NOT EXISTS hello_schema.orders(
    order_id SERIAL PRIMARY KEY,
    region INTEGER,
    weight FLOAT,
    price INTEGER,
    delivery_time TEXT[]
)