chatrpg-api/sql/users.sql

CREATE TABLE IF NOT EXISTS users(
    id UUID PRIMARY KEY,
    session_token UUID NOT NULL,
    name TEXT NOT NULL,
    email TEXT NOT NULL UNIQUE,
    pass_hash TEXT NOT NULL,
    tokens INTEGER NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);