github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/source/20191100000008_selfservice_verification.up.fizz (about)

     1  create_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  
    18  add_index("identity_verifiable_addresses", ["code"], { "unique": true, "name": "identity_verifiable_addresses_code_uq_idx" })
    19  add_index("identity_verifiable_addresses", ["code"], { "name": "identity_verifiable_addresses_code_idx" })
    20  
    21  add_index("identity_verifiable_addresses", ["via", "value"], { "unique": true, "name": "identity_verifiable_addresses_status_via_uq_idx" })
    22  add_index("identity_verifiable_addresses", ["via", "value"], { "name": "identity_verifiable_addresses_status_via_idx" })
    23  
    24  create_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  }