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