1CREATE TABLE "identity_verifiable_addresses" (
2"id" UUID NOT NULL,
3PRIMARY 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,
14CONSTRAINT "identity_verifiable_addresses_identities_id_fk" FOREIGN KEY ("identity_id") REFERENCES "identities" ("id") ON DELETE cascade
15);COMMIT TRANSACTION;BEGIN TRANSACTION;
16CREATE UNIQUE INDEX "identity_verifiable_addresses_code_uq_idx" ON "identity_verifiable_addresses" (code);COMMIT TRANSACTION;BEGIN TRANSACTION;
17CREATE INDEX "identity_verifiable_addresses_code_idx" ON "identity_verifiable_addresses" (code);COMMIT TRANSACTION;BEGIN TRANSACTION;
18CREATE UNIQUE INDEX "identity_verifiable_addresses_status_via_uq_idx" ON "identity_verifiable_addresses" (via, value);COMMIT TRANSACTION;BEGIN TRANSACTION;
19CREATE INDEX "identity_verifiable_addresses_status_via_idx" ON "identity_verifiable_addresses" (via, value);COMMIT TRANSACTION;BEGIN TRANSACTION;
20CREATE TABLE "selfservice_verification_requests" (
21"id" UUID NOT NULL,
22PRIMARY 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" json 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);COMMIT TRANSACTION;BEGIN TRANSACTION;View as plain text