recaptime.dev / phorge
@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge
phorge phabricator
fork atom
phorge / resources / sql / patches / 135.datecommitted.sql
at recaptime-dev/main 7 lines 283 B view raw
epriestley SQL Patch Management: SQL Changes
68b597ff
1UPDATE {$NAMESPACE}_differential.differential_revision SET 2 dateCommitted = ( 3 SELECT MIN(dateCreated) 4 FROM {$NAMESPACE}_differential.differential_comment 5 WHERE revisionID = differential_revision.id AND action = 'commit' 6 ) 7 WHERE status = 3 AND dateCommitted IS NULL;