diff --git a/resources/sql/patches/113.lastreviewer.sql b/resources/sql/patches/113.lastreviewer.sql index 592464781..e2b0c597d 100644 --- a/resources/sql/patches/113.lastreviewer.sql +++ b/resources/sql/patches/113.lastreviewer.sql @@ -1,12 +1,12 @@ ALTER TABLE `phabricator_differential`.`differential_revision` ADD `lastReviewerPHID` varchar(64) BINARY AFTER `authorPHID`; UPDATE `phabricator_differential`.`differential_revision` SET `lastReviewerPHID` = ( SELECT `authorPHID` - FROM `differential_comment` + FROM `phabricator_differential`.`differential_comment` WHERE `revisionID` = `differential_revision`.`id` AND `action` IN ('accept', 'reject') ORDER BY `id` DESC LIMIT 1 );