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