migrations/00001_users.sql - main - pyo/auth

-- +goose Up
-- +goose StatementBegin
CREATE TABLE users 
(
    id         BIGSERIAL PRIMARY KEY,
    email      TEXT,
    login      TEXT,
    name       TEXT,
    password   TEXT,
    patronymic TEXT,
    surname    TEXT,
    role       INTEGER
);
-- +goose StatementEnd

-- +goose Down
-- +goose StatementBegin
DELETE TABLE users;
-- +goose StatementEnd