[Summary view] [Print] [Text view]

   1  ALTER TABLE `{$NAMESPACE}_differential`.`differential_revision`
   2    ADD `lastReviewerPHID` varchar(64) BINARY AFTER `authorPHID`;
   3  
   4  UPDATE `{$NAMESPACE}_differential`.`differential_revision`
   5  SET `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  );