...
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