server/migrations/20220822142548_add-users-table.sql


1
2
3
4
5
6
7
8
9

create table users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100) UNIQUE NOT NULL,
    username VARCHAR(100) UNIQUE NOT NULL,
    password VARCHAR(100) NOT NULL,
    avatar VARCHAR,
    is_staff BOOLEAN DEFAULT false
);