Text file src/github.com/ory/x/popx/stub/migrations/transactional/20191100000001000004_identities.postgres.up.sql

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

     1CREATE TABLE "identity_credential_identifiers" (
     2"id" UUID NOT NULL,
     3PRIMARY KEY("id"),
     4"identifier" VARCHAR (255) NOT NULL,
     5"identity_credential_id" UUID NOT NULL,
     6"created_at" timestamp NOT NULL,
     7"updated_at" timestamp NOT NULL,
     8FOREIGN KEY ("identity_credential_id") REFERENCES "identity_credentials" ("id") ON DELETE cascade
     9)

View as plain text