lemmy/migrations/2021-11-22-143904_add_requi.../up.sql

15 lines
274 B
SQL

-- Delete the empty public keys
DELETE FROM community
WHERE public_key IS NULL;
DELETE FROM person
WHERE public_key IS NULL;
-- Make it required
ALTER TABLE community
ALTER COLUMN public_key SET NOT NULL;
ALTER TABLE person
ALTER COLUMN public_key SET NOT NULL;