@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
1UPDATE {$NAMESPACE}_slowvote.slowvote_transaction
2 SET transactionType = 'vote:status'
3 WHERE transactionType = 'vote:close';
4
5UPDATE {$NAMESPACE}_slowvote.slowvote_transaction
6 SET oldValue = '"open"' WHERE
7 transactionType = 'vote:status' AND oldValue IN ('0', '"0"', 'false');
8
9UPDATE {$NAMESPACE}_slowvote.slowvote_transaction
10 SET newValue = '"open"' WHERE
11 transactionType = 'vote:status' AND newValue IN ('0', '"0"', 'false');
12
13UPDATE {$NAMESPACE}_slowvote.slowvote_transaction
14 SET oldValue = '"closed"' WHERE
15 transactionType = 'vote:status' AND oldValue IN ('1', '"1"', 'true');
16
17UPDATE {$NAMESPACE}_slowvote.slowvote_transaction
18 SET newValue = '"closed"' WHERE
19 transactionType = 'vote:status' AND newValue IN ('1', '"1"', 'true');