github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/transactional/20200519101057000003_create_recovery_addresses.sqlite3.up.sql (about)

     1  CREATE TABLE "selfservice_recovery_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  "messages" TEXT,
     7  "active_method" TEXT,
     8  "csrf_token" TEXT NOT NULL,
     9  "state" TEXT NOT NULL,
    10  "recovered_identity_id" char(36),
    11  "created_at" DATETIME NOT NULL,
    12  "updated_at" DATETIME NOT NULL,
    13  FOREIGN KEY (recovered_identity_id) REFERENCES identities (id) ON DELETE cascade
    14  )