recaptime.dev / phorge
@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
fork

Configure Feed

Select the types of activity you want to include in your feed.

phorge / resources / sql / patches / 113.lastreviewer.sql
at recaptime-dev/main 12 lines 420 B view raw
epriestley SQL Patch Management: SQL Changes
68b597ff
1ALTER TABLE `{$NAMESPACE}_differential`.`differential_revision` 2 ADD `lastReviewerPHID` varchar(64) BINARY AFTER `authorPHID`; 3 4UPDATE `{$NAMESPACE}_differential`.`differential_revision` 5SET `lastReviewerPHID` = ( 6 SELECT `authorPHID` 7 FROM `{$NAMESPACE}_differential`.`differential_comment` 8 WHERE `revisionID` = `differential_revision`.`id` 9 AND `action` IN ('accept', 'reject') 10 ORDER BY `id` DESC 11 LIMIT 1 12);