14 lines
402 B
SQL
14 lines
402 B
SQL
CREATE TABLE IF NOT EXISTS user_token (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
"user" UUID NOT NULL,
|
|
name VARCHAR(255) NOT NULL,
|
|
token_hash VARCHAR(255) NOT NULL,
|
|
scopes JSONB NOT NULL,
|
|
expires_at TIMESTAMPTZ,
|
|
is_revoked BOOLEAN NOT NULL DEFAULT false,
|
|
created_at TIMESTAMPTZ NOT NULL,
|
|
updated_at TIMESTAMPTZ NOT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_user_token_user ON user_token ("user");
|