GoScrobble/migrations/7_resettoken.up.sql

8 lines
194 B
SQL

CREATE TABLE IF NOT EXISTS resettoken (
"user" uuid PRIMARY KEY,
token VARCHAR(64) NOT NULL,
expiry timestamptz NOT NULL
);
CREATE INDEX resettokenTokenLookup ON resettoken (token)