lemmy/migrations/2021-09-20-112945_jwt-secret/up.sql

10 lines
214 B
SQL

-- generate a jwt secret
CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE TABLE secret (
id serial PRIMARY KEY,
jwt_secret varchar NOT NULL DEFAULT gen_random_uuid ()
);
INSERT INTO secret DEFAULT VALUES;