taskcafe/migrations/20220221173356_create_access_token_table.sql

10 lines
271 B
MySQL
Raw Permalink Normal View History

2022-05-06 23:41:52 +02:00
-- +goose Up
-- +goose StatementBegin
CREATE TABLE access_token (
token text PRIMARY KEY,
user_id uuid NOT NULL REFERENCES user_account(user_id) ON DELETE CASCADE,
expires_at timestamptz NOT NULL,
created_at timestamptz NOT NULL
);
-- +goose StatementEnd