github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/legacy/20200830172221_recovery_token_expires.postgres.down.sql (about)

     1  DELETE FROM identity_recovery_tokens WHERE selfservice_recovery_flow_id IS NULL;
     2  ALTER TABLE "identity_recovery_tokens" ALTER COLUMN "selfservice_recovery_flow_id" TYPE UUID, ALTER COLUMN "selfservice_recovery_flow_id" SET NOT NULL;
     3  ALTER TABLE "identity_recovery_tokens" DROP COLUMN "expires_at";
     4  ALTER TABLE "identity_recovery_tokens" DROP COLUMN "issued_at";