1UPDATE selfservice_errors SET seen_at = '1980-01-01 00:00:00' WHERE seen_at = NULL;
2CREATE 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);
11INSERT 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";
12DROP TABLE "selfservice_errors";
13ALTER TABLE "_selfservice_errors_tmp" RENAME TO "selfservice_errors";View as plain text