1CREATE TABLE "selfservice_login_requests" (
2"id" TEXT PRIMARY KEY,
3"request_url" TEXT NOT NULL,
4"issued_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
5"expires_at" DATETIME NOT NULL,
6"active_method" TEXT NOT NULL,
7"csrf_token" TEXT NOT NULL,
8"created_at" DATETIME NOT NULL,
9"updated_at" DATETIME NOT NULL
10);
11CREATE TABLE "selfservice_login_request_methods" (
12"id" TEXT PRIMARY KEY,
13"method" TEXT NOT NULL,
14"selfservice_login_request_id" char(36) NOT NULL,
15"config" TEXT NOT NULL,
16"created_at" DATETIME NOT NULL,
17"updated_at" DATETIME NOT NULL,
18FOREIGN KEY (selfservice_login_request_id) REFERENCES selfservice_login_requests (id) ON DELETE cascade
19);
20CREATE TABLE "selfservice_registration_requests" (
21"id" TEXT PRIMARY KEY,
22"request_url" TEXT NOT NULL,
23"issued_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
24"expires_at" DATETIME NOT NULL,
25"active_method" TEXT NOT NULL,
26"csrf_token" TEXT NOT NULL,
27"created_at" DATETIME NOT NULL,
28"updated_at" DATETIME NOT NULL
29);
30CREATE TABLE "selfservice_registration_request_methods" (
31"id" TEXT PRIMARY KEY,
32"method" TEXT NOT NULL,
33"selfservice_registration_request_id" char(36) NOT NULL,
34"config" TEXT NOT NULL,
35"created_at" DATETIME NOT NULL,
36"updated_at" DATETIME NOT NULL,
37FOREIGN KEY (selfservice_registration_request_id) REFERENCES selfservice_registration_requests (id) ON DELETE cascade
38);
39CREATE TABLE "selfservice_profile_management_requests" (
40"id" TEXT PRIMARY KEY,
41"request_url" TEXT NOT NULL,
42"issued_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
43"expires_at" DATETIME NOT NULL,
44"form" TEXT NOT NULL,
45"update_successful" bool NOT NULL,
46"identity_id" char(36) NOT NULL,
47"created_at" DATETIME NOT NULL,
48"updated_at" DATETIME NOT NULL,
49FOREIGN KEY (identity_id) REFERENCES identities (id) ON DELETE cascade
50);View as plain text