@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
1/* For `grep`: */
2
3/* PhabricatorObjectHasSubscriberEdgeType::EDGECONST = 21 */
4
5INSERT IGNORE INTO {$NAMESPACE}_differential.edge (src, type, dst, seq)
6 SELECT rev.phid, 21, rel.objectPHID, rel.sequence
7 FROM {$NAMESPACE}_differential.differential_revision rev
8 JOIN {$NAMESPACE}_differential.differential_relationship rel
9 ON rev.id = rel.revisionID
10 WHERE relation = 'subd';