1DROP TABLE "selfservice_verification_flow_methods";
2CREATE TABLE "_selfservice_verification_flows_tmp" (
3"id" TEXT PRIMARY KEY,
4"request_url" TEXT NOT NULL,
5"issued_at" DATETIME NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
6"expires_at" DATETIME NOT NULL,
7"csrf_token" TEXT NOT NULL,
8"created_at" DATETIME NOT NULL,
9"updated_at" DATETIME NOT NULL,
10"messages" TEXT,
11"type" TEXT NOT NULL DEFAULT 'browser',
12"state" TEXT NOT NULL DEFAULT 'show_form'
13);
14INSERT INTO "_selfservice_verification_flows_tmp" (id, request_url, issued_at, expires_at, csrf_token, created_at, updated_at, messages, type, state) SELECT id, request_url, issued_at, expires_at, csrf_token, created_at, updated_at, messages, type, state FROM "selfservice_verification_flows";
15
16DROP TABLE "selfservice_verification_flows";
17ALTER TABLE "_selfservice_verification_flows_tmp" RENAME TO "selfservice_verification_flows";
18CREATE TABLE "_selfservice_verification_flows_tmp" (
19"id" TEXT PRIMARY KEY,
20"request_url" TEXT NOT NULL,
21"issued_at" DATETIME NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
22"expires_at" DATETIME NOT NULL,
23"csrf_token" TEXT NOT NULL,
24"created_at" DATETIME NOT NULL,
25"updated_at" DATETIME NOT NULL,
26"messages" TEXT,
27"type" TEXT NOT NULL DEFAULT 'browser'
28);
29INSERT INTO "_selfservice_verification_flows_tmp" (id, request_url, issued_at, expires_at, csrf_token, created_at, updated_at, messages, type) SELECT id, request_url, issued_at, expires_at, csrf_token, created_at, updated_at, messages, type FROM "selfservice_verification_flows";
30
31DROP TABLE "selfservice_verification_flows";
32ALTER TABLE "_selfservice_verification_flows_tmp" RENAME TO "selfservice_verification_flows";
33ALTER TABLE "selfservice_verification_flows" ADD COLUMN "via" TEXT NOT NULL DEFAULT 'email';
34ALTER TABLE "selfservice_verification_flows" ADD COLUMN "success" bool NOT NULL DEFAULT FALSE;View as plain text