113.lastreviewer.sql
6aa729b1c974stable

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
			);