github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/legacy/20191100000010_errors.sqlite3.down.sql (about)

     1  UPDATE selfservice_errors SET seen_at = '1980-01-01 00:00:00' WHERE seen_at = NULL;
     2  CREATE TABLE "_selfservice_errors_tmp" (
     3  "id" TEXT PRIMARY KEY,
     4  "errors" TEXT NOT NULL,
     5  "seen_at" DATETIME,
     6  "was_seen" bool NOT NULL,
     7  "created_at" DATETIME NOT NULL,
     8  "updated_at" DATETIME NOT NULL,
     9  "csrf_token" TEXT NOT NULL DEFAULT ''
    10  );
    11  INSERT INTO "_selfservice_errors_tmp" (id, errors, seen_at, was_seen, created_at, updated_at, csrf_token) SELECT id, errors, seen_at, was_seen, created_at, updated_at, csrf_token FROM "selfservice_errors";
    12  DROP TABLE "selfservice_errors";
    13  ALTER TABLE "_selfservice_errors_tmp" RENAME TO "selfservice_errors";