github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/transactional/20191100000008000005_selfservice_verification.mysql.up.sql (about) 1 CREATE TABLE `selfservice_verification_requests` ( 2 `id` char(36) NOT NULL, 3 PRIMARY KEY(`id`), 4 `request_url` VARCHAR (2048) NOT NULL, 5 `issued_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 6 `expires_at` DATETIME 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` DATETIME NOT NULL, 12 `updated_at` DATETIME NOT NULL 13 ) ENGINE=InnoDB;