9456a4e922
Some checks failed
CI / Run lints and checks (push) Failing after 47s
CI / Run tests (push) Failing after 1s
CI / Run race tests (push) Failing after 5s
CI / Build CLI docs (push) Has been skipped
CI / Run buf actions (push) Failing after 5s
CodeQL / Analyze (go) (push) Failing after 3s
CodeQL / Analyze (javascript) (push) Failing after 2s
Docker Image Scanners / scanners (push) Failing after 3s
Format / format (push) Failing after 3s
Synchronize Issue Labels / Synchronize Issue Labels (push) Has been skipped
CI / Generate release (push) Has been skipped
CI / Draft newsletter (push) Has been skipped
CI / Pending approval Slack notification (push) Has been skipped
CI / Send newsletter (push) Has been skipped
35 lines
1.1 KiB
Plaintext
35 lines
1.1 KiB
Plaintext
create_table("identities") {
|
|
t.Column("id", "uuid", {primary: true})
|
|
t.Column("traits_schema_id", "string", {"size": 2048})
|
|
t.Column("traits", "json")
|
|
}
|
|
|
|
create_table("identity_credential_types") {
|
|
t.Column("id", "uuid", {primary: true})
|
|
t.Column("name", "string", { "size": 32 })
|
|
|
|
t.DisableTimestamps()
|
|
}
|
|
|
|
add_index("identity_credential_types", "name", {"unique": true})
|
|
|
|
create_table("identity_credentials") {
|
|
t.Column("id", "uuid", {primary: true})
|
|
t.Column("config", "json")
|
|
|
|
t.Column("identity_credential_type_id", "uuid")
|
|
t.Column("identity_id", "uuid")
|
|
|
|
t.ForeignKey("identity_id", {"identities": ["id"]}, {"on_delete": "cascade"})
|
|
t.ForeignKey("identity_credential_type_id", {"identity_credential_types": ["id"]}, {"on_delete": "cascade"})
|
|
}
|
|
|
|
create_table("identity_credential_identifiers") {
|
|
t.Column("id", "uuid", {primary: true})
|
|
t.Column("identifier", "string", {"size": 255})
|
|
t.Column("identity_credential_id", "uuid")
|
|
t.ForeignKey("identity_credential_id", {"identity_credentials": ["id"]}, {"on_delete": "cascade"})
|
|
}
|
|
|
|
add_index("identity_credential_identifiers", "identifier", {"unique": true})
|