Files
rss-feed/sql/schema/002_users_apikey.sql

5 lines
179 B
SQL

-- +goose Up
ALTER TABLE users ADD api_key VARCHAR(64) NOT NULL DEFAULT encode(sha256(random()::text::bytea), 'hex') UNIQUE;
-- +goose Down
ALTER TABLE users DROP COLUMN api_key;