backend/migrations/2021-12-13-145111_users/up.sql


1
2
3
4
5
6
7
8

CREATE TABLE users(
    id SERIAL PRIMARY KEY,
    username VARCHAR(52) NOT NULL,
    password_salt BYTEA NOT NULL,
    password_hash BYTEA NOT NULL
);

CREATE UNIQUE INDEX users_username_index ON users(username);