@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}_doorkeeper.doorkeeper_externalobject (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 objectKey CHAR(12) NOT NULL COLLATE utf8_bin,
5 applicationType VARCHAR(32) NOT NULL COLLATE utf8_bin,
6 applicationDomain VARCHAR(32) NOT NULL COLLATE utf8_bin,
7 objectType VARCHAR(32) NOT NULL COLLATE utf8_bin,
8 objectID VARCHAR(64) NOT NULL COLLATE utf8_bin,
9 objectURI VARCHAR(128) COLLATE utf8_bin,
10 importerPHID VARCHAR(64) COLLATE utf8_bin,
11 properties LONGTEXT NOT NULL COLLATE utf8_bin,
12 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
13 dateCreated INT UNSIGNED NOT NULL,
14 dateModified INT UNSIGNED NOT NULL,
15 UNIQUE KEY `key_phid` (phid),
16 UNIQUE KEY `key_object` (objectKey),
17 KEY `key_full` (applicationType, applicationDomain, objectType, objectID)
18) ENGINE=InnoDB, COLLATE utf8_general_ci;
19
20CREATE TABLE {$NAMESPACE}_doorkeeper.edge (
21 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
22 type INT UNSIGNED NOT NULL COLLATE utf8_bin,
23 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
24 dateCreated INT UNSIGNED NOT NULL,
25 seq INT UNSIGNED NOT NULL,
26 dataID INT UNSIGNED,
27 PRIMARY KEY (src, type, dst),
28 KEY (src, type, dateCreated, seq)
29) ENGINE=InnoDB, COLLATE utf8_general_ci;
30
31CREATE TABLE {$NAMESPACE}_doorkeeper.edgedata (
32 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
33 data LONGTEXT NOT NULL COLLATE utf8_bin
34) ENGINE=InnoDB, COLLATE utf8_general_ci;