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

     1  ALTER TABLE `selfservice_profile_management_requests` ADD COLUMN `form` JSON;
     2  UPDATE selfservice_profile_management_requests SET form=(SELECT * FROM (SELECT m.config FROM selfservice_profile_management_requests AS r INNER JOIN selfservice_profile_management_request_methods AS m ON r.id=m.selfservice_profile_management_request_id) as t);
     3  ALTER TABLE `selfservice_profile_management_requests` MODIFY `form` JSON;
     4  DROP TABLE `selfservice_profile_management_request_methods`;
     5  ALTER TABLE `selfservice_profile_management_requests` DROP COLUMN `active_method`;