@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
1ALTER TABLE {$NAMESPACE}_differential.differential_changeset
2 ADD KEY (diffID);
3
4ALTER TABLE {$NAMESPACE}_differential.differential_comment
5 ADD KEY (revisionID);
6
7ALTER TABLE {$NAMESPACE}_differential.differential_diff
8 ADD KEY (revisionID);
9
10ALTER TABLE {$NAMESPACE}_differential.differential_inlinecomment
11 ADD KEY (changesetID);
12
13ALTER TABLE {$NAMESPACE}_differential.differential_inlinecomment
14 ADD KEY (commentID);
15
16ALTER TABLE {$NAMESPACE}_differential.differential_hunk
17 ADD KEY (changesetID);
18
19ALTER TABLE {$NAMESPACE}_herald.herald_transcript
20 ADD KEY (objectPHID);
21
22ALTER TABLE {$NAMESPACE}_differential.differential_revision
23 ADD KEY (authorPHID, status);
24
25ALTER TABLE {$NAMESPACE}_differential.differential_revision
26 ADD UNIQUE KEY (phid);
27
28ALTER TABLE {$NAMESPACE}_metamta.metamta_mailinglist
29 ADD UNIQUE KEY (phid);