113.lastreviewer.sql
No OneTemporary
Actions

Size

417 B

Referenced Files

None

Subscribers

None

113.lastreviewer.sql
View Options

	ALTER TABLE `phabricator_differential`.`differential_revision`
	ADD `lastReviewerPHID` varchar(64) BINARY AFTER `authorPHID`;

	UPDATE `phabricator_differential`.`differential_revision`
	SET `lastReviewerPHID` = (
	SELECT `authorPHID`
	FROM `phabricator_differential`.`differential_comment`
	WHERE `revisionID` = `differential_revision`.`id`
	AND `action` IN ('accept', 'reject')
	ORDER BY `id` DESC
	LIMIT 1
	);