No OneTemporary
Actions

Size

713 B

Referenced Files

None

Subscribers

None

View Options

	diff --git a/resources/sql/patches/113.lastreviewer.sql b/resources/sql/patches/113.lastreviewer.sql
	index 5924647815..e2b0c597d6 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
	);

File Metadata

Mime Type: text/x-diff
Expires: Wed, Jul 2, 9:18 AM (1 d, 17 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 164821
Default Alt Text: (713 B)

Event Timeline