crm-server/migrations/00006_users_table.sql

-- +goose Up
CREATE TABLE users (
  id          TEXT PRIMARY KEY,
  login       VARCHAR(50) NOT NULL UNIQUE,
  password    VARCHAR(255) NOT NULL,
  phone       VARCHAR(20) NOT NULL,
  email       VARCHAR(100) UNIQUE,
  full_name   VARCHAR(150) NOT NULL,
  role        VARCHAR(20) NOT NULL,
  reg_date    TIMESTAMPTZ DEFAULT NOW()
);

-- +goose Down
DROP TABLE users;