...

Text file src/github.com/ory/x/popx/stub/migrations/source/20200830154602_add_verification_token.up.fizz

Documentation: github.com/ory/x/popx/stub/migrations/source

     1create_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
    17add_index("identity_verification_tokens", ["token"], { "unique": true, "name": "identity_verification_tokens_token_uq_idx" })
    18add_index("identity_verification_tokens", ["token"], { "name": "identity_verification_tokens_token_idx" })
    19
    20add_index("identity_verification_tokens", ["identity_verifiable_address_id"], { "name": "identity_verification_tokens_verifiable_address_id_idx" })
    21add_index("identity_verification_tokens", ["selfservice_verification_flow_id"], { "name": "identity_verification_tokens_verification_flow_id_idx" })

View as plain text