Text file src/github.com/ory/x/popx/stub/migrations/source/20200830130642_add_verification_methods.down.fizz

Documentation: github.com/ory/x/popx/stub/migrations/source

     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
    11drop_table("selfservice_verification_flow_methods")
    12drop_column("selfservice_verification_flows", "active_method")
    13drop_column("selfservice_verification_flows", "state")
    14
    15add_column("selfservice_verification_flows", "via", "string", {"size": 16, "default": "email"})
    16add_column("selfservice_verification_flows", "success", "bool", {"default_raw": "FALSE"})

View as plain text