github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/legacy/20191100000008_selfservice_verification.postgres.up.sql (about)

     1  CREATE TABLE "identity_verifiable_addresses" (
     2  "id" UUID NOT NULL,
     3  PRIMARY KEY("id"),
     4  "code" VARCHAR (32) NOT NULL,
     5  "status" VARCHAR (16) NOT NULL,
     6  "via" VARCHAR (16) NOT NULL,
     7  "verified" bool NOT NULL,
     8  "value" VARCHAR (400) NOT NULL,
     9  "verified_at" timestamp,
    10  "expires_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    11  "identity_id" UUID NOT NULL,
    12  "created_at" timestamp NOT NULL,
    13  "updated_at" timestamp NOT NULL,
    14  FOREIGN KEY ("identity_id") REFERENCES "identities" ("id") ON DELETE cascade
    15  );
    16  CREATE UNIQUE INDEX "identity_verifiable_addresses_code_uq_idx" ON "identity_verifiable_addresses" (code);
    17  CREATE INDEX "identity_verifiable_addresses_code_idx" ON "identity_verifiable_addresses" (code);
    18  CREATE UNIQUE INDEX "identity_verifiable_addresses_status_via_uq_idx" ON "identity_verifiable_addresses" (via, value);
    19  CREATE INDEX "identity_verifiable_addresses_status_via_idx" ON "identity_verifiable_addresses" (via, value);
    20  CREATE TABLE "selfservice_verification_requests" (
    21  "id" UUID NOT NULL,
    22  PRIMARY KEY("id"),
    23  "request_url" VARCHAR (2048) NOT NULL,
    24  "issued_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    25  "expires_at" timestamp NOT NULL,
    26  "form" jsonb NOT NULL,
    27  "via" VARCHAR (16) NOT NULL,
    28  "csrf_token" VARCHAR (255) NOT NULL,
    29  "success" bool NOT NULL,
    30  "created_at" timestamp NOT NULL,
    31  "updated_at" timestamp NOT NULL
    32  );