summaryrefslogtreecommitdiff
path: root/server/migrations/20220822142548_add-users-table.sql
blob: c9571eca644eaa932c2afcc09b6c93c06b846a90 (plain)
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
);