@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
1CREATE TABLE {$NAMESPACE}_conduit.conduit_certificatetoken (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 userPHID VARCHAR(64) BINARY NOT NULL,
4 token VARCHAR(64),
5 dateCreated INT UNSIGNED NOT NULL,
6 dateModified INT UNSIGNED NOT NULL
7);
8
9ALTER TABLE {$NAMESPACE}_conduit.conduit_certificatetoken
10 ADD UNIQUE KEY (userPHID);
11ALTER TABLE {$NAMESPACE}_conduit.conduit_certificatetoken
12 ADD UNIQUE KEY (token);