20 lines
583 B
SQL
20 lines
583 B
SQL
-- +migrate Up
|
|
CREATE TABLE users (
|
|
id uuid NOT NULL DEFAULT uuid_generate_v4 (),
|
|
username varchar(255),
|
|
"password" text,
|
|
is_active bool NOT NULL,
|
|
-- TODO: use user_scope enum as "scopes user_scope[]" when supported
|
|
-- https://github.com/volatiletech/sqlboiler/issues/739
|
|
scopes text[] NOT NULL,
|
|
last_authenticated_at timestamptz,
|
|
created_at timestamptz NOT NULL,
|
|
updated_at timestamptz NOT NULL,
|
|
CONSTRAINT users_pkey PRIMARY KEY (id),
|
|
CONSTRAINT users_username_key UNIQUE (username)
|
|
);
|
|
|
|
-- +migrate Down
|
|
DROP TABLE IF EXISTS users;
|
|
|