1create_table("selfservice_login_requests") {
2 t.Column("id", "uuid", {primary: true})
3 t.Column("request_url", "string", {"size": 2048})
4 t.Column("issued_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
5 t.Column("expires_at", "timestamp")
6 t.Column("active_method", "string", {"size": 32})
7 t.Column("csrf_token", "string")
8}
9
10create_table("selfservice_login_request_methods") {
11 t.Column("id", "uuid", {primary: true})
12 t.Column("method", "string", {"size": 32})
13 t.Column("selfservice_login_request_id", "uuid")
14 t.Column("config", "json")
15
16 t.ForeignKey("selfservice_login_request_id", {"selfservice_login_requests": ["id"]}, {"on_delete": "cascade"})
17}
18
19create_table("selfservice_registration_requests") {
20 t.Column("id", "uuid", {primary: true})
21 t.Column("request_url", "string", {"size": 2048})
22 t.Column("issued_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
23 t.Column("expires_at", "timestamp")
24 t.Column("active_method", "string", {"size": 32})
25 t.Column("csrf_token", "string")
26}
27
28create_table("selfservice_registration_request_methods") {
29 t.Column("id", "uuid", {primary: true})
30 t.Column("method", "string", {"size": 32})
31 t.Column("selfservice_registration_request_id", "uuid")
32 t.Column("config", "json")
33
34 t.ForeignKey("selfservice_registration_request_id", {"selfservice_registration_requests": ["id"]}, {"on_delete": "cascade"})
35}
36
37create_table("selfservice_profile_management_requests") {
38 t.Column("id", "uuid", {primary: true})
39 t.Column("request_url", "string", {"size": 2048})
40 t.Column("issued_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
41 t.Column("expires_at", "timestamp")
42 t.Column("form", "json")
43 t.Column("update_successful", "bool")
44 t.Column("identity_id", "uuid")
45
46 t.ForeignKey("identity_id", {"identities": ["id"]}, {"on_delete": "cascade"})
47}
View as plain text