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

     1  {{ if or .IsPostgreSQL .IsMySQL .IsMariaDB }}
     2    add_column("selfservice_profile_management_requests", "form", "json", { "null": true })
     3    sql("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);")
     4    change_column("selfservice_profile_management_requests", "form", "json", { "null": false })
     5  {{ end }}
     6  
     7  {{ if .IsCockroach }}
     8    add_column("selfservice_profile_management_requests", "form", "json", { "default": "{}" })
     9  {{ end }}
    10  
    11  drop_table("selfservice_profile_management_request_methods")
    12  drop_column("selfservice_profile_management_requests", "active_method")