@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
1/* This column was previously "uint32?" with these values:
2
3 1: run every time
4 0: run only the first time
5
6*/
7
8UPDATE {$NAMESPACE}_herald.herald_rule
9 SET repetitionPolicy = '1'
10 WHERE repetitionPolicy IS NULL;
11
12ALTER TABLE {$NAMESPACE}_herald.herald_rule
13 CHANGE repetitionPolicy
14 repetitionPolicy VARCHAR(32) NOT NULL COLLATE {$COLLATE_TEXT};
15
16/* If the old value was "0", the new value is "first". */
17
18UPDATE {$NAMESPACE}_herald.herald_rule
19 SET repetitionPolicy = 'first'
20 WHERE repetitionPolicy = '0';
21
22/* If the old value was anything else, the new value is "every". */
23
24UPDATE {$NAMESPACE}_herald.herald_rule
25 SET repetitionPolicy = 'every'
26 WHERE repetitionPolicy NOT IN ('first', '0');