8 lines
224 B
SQL
8 lines
224 B
SQL
CREATE TABLE users (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
username TEXT NOT NULL UNIQUE,
|
|
role TEXT,
|
|
permissions TEXT[] DEFAULT '{}'::TEXT[] NOT NULL,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|