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

     1  {{ if or .IsPostgreSQL .IsMySQL .IsMariaDB }}
     2    add_column("selfservice_verification_flows", "form", "json", { "null": true })
     3    sql("UPDATE selfservice_verification_flows SET form=(SELECT * FROM (SELECT m.config FROM selfservice_verification_flows AS r INNER JOIN selfservice_verification_flow_methods AS m ON r.id=m.selfservice_verification_flow_id) as t);")
     4    change_column("selfservice_verification_flows", "form", "json", { "null": false })
     5  {{ end }}
     6  
     7  {{ if .IsCockroach }}
     8    add_column("selfservice_verification_flows", "form", "json", { "default": "{}" })
     9  {{ end }}
    10  
    11  drop_table("selfservice_verification_flow_methods")
    12  drop_column("selfservice_verification_flows", "active_method")
    13  drop_column("selfservice_verification_flows", "state")
    14  
    15  add_column("selfservice_verification_flows", "via", "string", {"size": 16, "default": "email"})
    16  add_column("selfservice_verification_flows", "success", "bool", {"default_raw": "FALSE"})