selene-backend/db/mycroft/skill_schema/tables/oauth_token.sql

9 lines
426 B
SQL

CREATE TABLE skill.oauth_token (
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
oauth_credential_id uuid NOT NULL REFERENCES skill.oauth_credential,
account_id uuid NOT NULL REFERENCES account.account,
token json NOT NULL,
insert_ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE (oauth_credential_id, account_id)
)