Migration

CREATE TABLE IF NOT EXISTS products
(
    id    SERIAL PRIMARY KEY AUTO_INCREMENT,
    name  CHARACTER VARYING(30) NOT NULL,
    price NUMERIC               NOT NULL,
    quantity INTEGER
);


CREATE TABLE IF NOT EXISTS orders
(
    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
    user_id    INTEGER REFERENCES users (id) NOT NULL,
    created_at date                          NOT NULL
);


CREATE TABLE IF NOT EXISTS order_entries
(
    product_id INTEGER REFERENCES products(id) NOT NULL,
    order_id INTEGER REFERENCES orders(id) NOT NULL,
    quantity INTEGER,
    price NUMERIC NOT NULL,
    total NUMERIC
);
CREATE TABLE IF NOT EXISTS cart
(
    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
    product_id INTEGER REFERENCES products (id) NOT NULL,
    products_quantity      INTEGER,
    total     NUMERIC                          NOT NULL

);
CREATE TABLE IF NOT EXISTS categories
(
    id         SERIAL PRIMARY KEY KEY AUTO_INCREMENT,
    name       CHARACTER VARYING(30)            NOT NULL,
    product_id INTEGER REFERENCES products (id) NOT NULL
);

CREATE TABLE IF NOT EXISTS users
(
    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
    username   CHARACTER VARYING(30) NOT NULL,
    first_name CHARACTER VARYING(30) NOT NULL,
    last_name  CHARACTER VARYING(30) NOT NULL,
    password   CHARACTER VARYING(50) NOT NULL,
    email      CHARACTER VARYING(50) NOT NULL,
    role       CHARACTER VARYING(10) NOT NULL,
    created_at date                  NOT NULL
);