github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/legacy/20200317160354_create_profile_request_forms.cockroach.up.sql (about)

     1  CREATE TABLE "selfservice_profile_management_request_methods" (
     2  "id" UUID NOT NULL,
     3  PRIMARY KEY("id"),
     4  "method" VARCHAR (32) NOT NULL,
     5  "selfservice_profile_management_request_id" UUID NOT NULL,
     6  "config" json NOT NULL,
     7  "created_at" timestamp NOT NULL,
     8  "updated_at" timestamp NOT NULL
     9  );COMMIT TRANSACTION;BEGIN TRANSACTION;
    10  ALTER TABLE "selfservice_profile_management_requests" ADD COLUMN "active_method" VARCHAR (32);COMMIT TRANSACTION;BEGIN TRANSACTION;
    11  INSERT INTO selfservice_profile_management_request_methods (id, method, selfservice_profile_management_request_id, config) SELECT id, 'traits', id, form FROM selfservice_profile_management_requests;
    12  ALTER TABLE "selfservice_profile_management_requests" DROP COLUMN "form";COMMIT TRANSACTION;BEGIN TRANSACTION;