@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_transaction_comment
2 DROP KEY `key_draft`;
3
4ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment
5 ADD KEY `key_changeset` (changesetID);
6
7ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment
8 ADD KEY `key_draft` (authorPHID, transactionPHID);
9
10ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment
11 ADD KEY `key_revision` (revisionPHID);
12
13ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment
14 ADD KEY `key_legacy` (legacyCommentID);