...

Text file src/github.com/ory/x/popx/stub/migrations/source/20191100000001_identities.up.fizz

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

     1create_table("identities") {
     2	t.Column("id", "uuid", {primary: true})
     3  t.Column("traits_schema_id", "string", {"size": 2048})
     4  t.Column("traits", "json")
     5}
     6
     7create_table("identity_credential_types") {
     8 	t.Column("id", "uuid", {primary: true})
     9  t.Column("name", "string", { "size": 32 })
    10
    11  t.DisableTimestamps()
    12}
    13
    14add_index("identity_credential_types", "name", {"unique": true})
    15
    16create_table("identity_credentials") {
    17 	t.Column("id", "uuid", {primary: true})
    18  t.Column("config", "json")
    19
    20  t.Column("identity_credential_type_id", "uuid")
    21  t.Column("identity_id", "uuid")
    22
    23  t.ForeignKey("identity_id", {"identities": ["id"]}, {"on_delete": "cascade"})
    24  t.ForeignKey("identity_credential_type_id", {"identity_credential_types": ["id"]}, {"on_delete": "cascade"})
    25}
    26
    27create_table("identity_credential_identifiers") {
    28 	t.Column("id", "uuid", {primary: true})
    29  t.Column("identifier", "string", {"size": 255})
    30  t.Column("identity_credential_id", "uuid")
    31  t.ForeignKey("identity_credential_id", {"identity_credentials": ["id"]}, {"on_delete": "cascade"})
    32}
    33
    34add_index("identity_credential_identifiers", "identifier", {"unique": true})

View as plain text