1create_table("identity_verifiable_addresses") {
2 t.Column("id", "uuid", {primary: true})
3
4 t.Column("code", "string", {"size": 32})
5 t.Column("status", "string", {"size": 16})
6 t.Column("via", "string", {"size": 16})
7 t.Column("verified", "bool")
8
9 t.Column("value", "string", {"size": 400})
10
11 t.Column("verified_at", "timestamp", {"null": true})
12 t.Column("expires_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
13
14 t.Column("identity_id", "uuid")
15 t.ForeignKey("identity_id", {"identities": ["id"]}, {"on_delete": "cascade"})
16}
17
18add_index("identity_verifiable_addresses", ["code"], { "unique": true, "name": "identity_verifiable_addresses_code_uq_idx" })
19add_index("identity_verifiable_addresses", ["code"], { "name": "identity_verifiable_addresses_code_idx" })
20
21add_index("identity_verifiable_addresses", ["via", "value"], { "unique": true, "name": "identity_verifiable_addresses_status_via_uq_idx" })
22add_index("identity_verifiable_addresses", ["via", "value"], { "name": "identity_verifiable_addresses_status_via_idx" })
23
24create_table("selfservice_verification_requests") {
25 t.Column("id", "uuid", {primary: true})
26
27 t.Column("request_url", "string", {"size": 2048})
28 t.Column("issued_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
29 t.Column("expires_at", "timestamp")
30
31 t.Column("form", "json")
32 t.Column("via", "string", {"size": 16})
33 t.Column("csrf_token", "string")
34 t.Column("success", "bool")
35}
View as plain text