github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/transactional/20191100000008000005_selfservice_verification.cockroach.up.sql (about) 1 CREATE TABLE "selfservice_verification_requests" ( 2 "id" UUID NOT NULL, 3 PRIMARY KEY("id"), 4 "request_url" VARCHAR (2048) NOT NULL, 5 "issued_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 6 "expires_at" timestamp NOT NULL, 7 "form" json NOT NULL, 8 "via" VARCHAR (16) NOT NULL, 9 "csrf_token" VARCHAR (255) NOT NULL, 10 "success" bool NOT NULL, 11 "created_at" timestamp NOT NULL, 12 "updated_at" timestamp NOT NULL 13 );