github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/legacy/20191100000002_requests.sqlite3.up.sql (about)

     1  CREATE 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  );
    11  CREATE 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,
    18  FOREIGN KEY (selfservice_login_request_id) REFERENCES selfservice_login_requests (id) ON DELETE cascade
    19  );
    20  CREATE 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  );
    30  CREATE 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,
    37  FOREIGN KEY (selfservice_registration_request_id) REFERENCES selfservice_registration_requests (id) ON DELETE cascade
    38  );
    39  CREATE 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,
    49  FOREIGN KEY (identity_id) REFERENCES identities (id) ON DELETE cascade
    50  );