@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}_passphrase.passphrase_credential (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 name VARCHAR(255) NOT NULL,
5 credentialType VARCHAR(64) NOT NULL COLLATE utf8_bin,
6 providesType VARCHAR(64) NOT NULL COLLATE utf8_bin,
7 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
8 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
9 description LONGTEXT NOT NULL COLLATE utf8_bin,
10 username VARCHAR(255) NOT NULL,
11 secretID INT UNSIGNED,
12 isDestroyed BOOL NOT NULL,
13 dateCreated INT UNSIGNED NOT NULL,
14 dateModified INT UNSIGNED NOT NULL,
15
16 UNIQUE KEY `key_phid` (phid),
17 KEY `key_type` (credentialType),
18 KEY `key_provides` (providesType),
19 UNIQUE KEY `key_secret` (secretID)
20) ENGINE=InnoDB, COLLATE utf8_general_ci;
21
22CREATE TABLE {$NAMESPACE}_passphrase.passphrase_secret (
23 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
24 secretData LONGBLOB NOT NULL
25) ENGINE=InnoDB, COLLATE utf8_general_ci;
26
27CREATE TABLE {$NAMESPACE}_passphrase.passphrase_credentialtransaction (
28 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
29 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
30 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
31 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
32 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
33 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
34 commentPHID VARCHAR(64) COLLATE utf8_bin,
35 commentVersion INT UNSIGNED NOT NULL,
36 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
37 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
38 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
39 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
40 metadata LONGTEXT NOT NULL COLLATE utf8_bin,
41 dateCreated INT UNSIGNED NOT NULL,
42 dateModified INT UNSIGNED NOT NULL,
43
44 UNIQUE KEY `key_phid` (phid),
45 KEY `key_object` (objectPHID)
46) ENGINE=InnoDB, COLLATE utf8_general_ci;