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

     1  create_table("identity_verification_tokens") {
     2  	t.Column("id", "uuid", {primary: true})
     3  
     4    t.Column("token", "string", {"size": 64})
     5    t.Column("used", "bool", {"default": false})
     6    t.Column("used_at", "timestamp", {"null": true})
     7    t.Column("expires_at", "timestamp")
     8    t.Column("issued_at", "timestamp")
     9  
    10    t.Column("identity_verifiable_address_id", "uuid")
    11    t.ForeignKey("identity_verifiable_address_id", {"identity_verifiable_addresses": ["id"]}, {"on_delete": "cascade"})
    12  
    13    t.Column("selfservice_verification_flow_id", "uuid", {"null": true})
    14    t.ForeignKey("selfservice_verification_flow_id", {"selfservice_verification_flows": ["id"]}, {"on_delete": "cascade"})
    15  }
    16  
    17  add_index("identity_verification_tokens", ["token"], { "unique": true, "name": "identity_verification_tokens_token_uq_idx" })
    18  add_index("identity_verification_tokens", ["token"], { "name": "identity_verification_tokens_token_idx" })
    19  
    20  add_index("identity_verification_tokens", ["identity_verifiable_address_id"], { "name": "identity_verification_tokens_verifiable_address_id_idx" })
    21  add_index("identity_verification_tokens", ["selfservice_verification_flow_id"], { "name": "identity_verification_tokens_verification_flow_id_idx" })