recaptime.dev / phorge
@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge
phorge phabricator
1
fork

Configure Feed

Select the types of activity you want to include in your feed.

phorge / resources / sql / autopatches / 20181213.auth.06.challenge.sql
at recaptime-dev/main 12 lines 516 B view raw
epriestley Track MFA "challenges" so we can bind challenges to sessions and support SMS and other push MFA
b8cbfda0
1CREATE TABLE {$NAMESPACE}_auth.auth_challenge ( 2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 3 phid VARBINARY(64) NOT NULL, 4 userPHID VARBINARY(64) NOT NULL, 5 factorPHID VARBINARY(64) NOT NULL, 6 sessionPHID VARBINARY(64) NOT NULL, 7 challengeKey VARCHAR(255) NOT NULL COLLATE {$COLLATE_TEXT}, 8 challengeTTL INT UNSIGNED NOT NULL, 9 properties LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT}, 10 dateCreated INT UNSIGNED NOT NULL, 11 dateModified INT UNSIGNED NOT NULL 12) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};