ory-am/hydra

View on GitHub
persistence/sql/migrations/20230908104443000000_change_client_pk.down.sql

Summary

Maintainability
Test Coverage
UPDATE hydra_client SET pk = gen_random_uuid() WHERE pk IS NULL;

ALTER TABLE hydra_client ALTER COLUMN pk SET NOT NULL;

ALTER TABLE hydra_client DROP CONSTRAINT hydra_client_pkey;

ALTER TABLE hydra_client ADD PRIMARY KEY (pk);