...

Text file src/github.com/ory/x/popx/stub/migrations/legacy/20200605111551_messages.sqlite3.down.sql

Documentation: github.com/ory/x/popx/stub/migrations/legacy

     1CREATE TABLE "_selfservice_verification_requests_tmp" (
     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"csrf_token" TEXT NOT NULL,
     7"created_at" DATETIME NOT NULL,
     8"updated_at" DATETIME NOT NULL,
     9"via" TEXT NOT NULL DEFAULT 'email',
    10"success" bool NOT NULL DEFAULT 'FALSE'
    11);
    12INSERT INTO "_selfservice_verification_requests_tmp" (id, request_url, issued_at, expires_at, csrf_token, created_at, updated_at, via, success) SELECT id, request_url, issued_at, expires_at, csrf_token, created_at, updated_at, via, success FROM "selfservice_verification_requests";
    13
    14DROP TABLE "selfservice_verification_requests";
    15ALTER TABLE "_selfservice_verification_requests_tmp" RENAME TO "selfservice_verification_requests";
    16CREATE TABLE "_selfservice_login_requests_tmp" (
    17"id" TEXT PRIMARY KEY,
    18"request_url" TEXT NOT NULL,
    19"issued_at" DATETIME NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
    20"expires_at" DATETIME NOT NULL,
    21"active_method" TEXT NOT NULL,
    22"csrf_token" TEXT NOT NULL,
    23"created_at" DATETIME NOT NULL,
    24"updated_at" DATETIME NOT NULL,
    25"forced" bool NOT NULL DEFAULT 'false'
    26);
    27INSERT INTO "_selfservice_login_requests_tmp" (id, request_url, issued_at, expires_at, active_method, csrf_token, created_at, updated_at, forced) SELECT id, request_url, issued_at, expires_at, active_method, csrf_token, created_at, updated_at, forced FROM "selfservice_login_requests";
    28
    29DROP TABLE "selfservice_login_requests";
    30ALTER TABLE "_selfservice_login_requests_tmp" RENAME TO "selfservice_login_requests";
    31CREATE TABLE "_selfservice_registration_requests_tmp" (
    32"id" TEXT PRIMARY KEY,
    33"request_url" TEXT NOT NULL,
    34"issued_at" DATETIME NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
    35"expires_at" DATETIME NOT NULL,
    36"active_method" TEXT NOT NULL,
    37"csrf_token" TEXT NOT NULL,
    38"created_at" DATETIME NOT NULL,
    39"updated_at" DATETIME NOT NULL
    40);
    41INSERT INTO "_selfservice_registration_requests_tmp" (id, request_url, issued_at, expires_at, active_method, csrf_token, created_at, updated_at) SELECT id, request_url, issued_at, expires_at, active_method, csrf_token, created_at, updated_at FROM "selfservice_registration_requests";
    42
    43DROP TABLE "selfservice_registration_requests";
    44ALTER TABLE "_selfservice_registration_requests_tmp" RENAME TO "selfservice_registration_requests";

View as plain text