recaptime.dev
@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/* Change quality from color to int */
2
3UPDATE {$NAMESPACE}_badges.badges_badge
4 SET quality = 140
5 WHERE quality = 'grey';
6
7UPDATE {$NAMESPACE}_badges.badges_badge
8 SET quality = 120
9 WHERE quality = 'white';
10
11UPDATE {$NAMESPACE}_badges.badges_badge
12 SET quality = 100
13 WHERE quality = 'green';
14
15UPDATE {$NAMESPACE}_badges.badges_badge
16 SET quality = 80
17 WHERE quality = 'blue';
18
19UPDATE {$NAMESPACE}_badges.badges_badge
20 SET quality = 60
21 WHERE quality = 'indigo';
22
23UPDATE {$NAMESPACE}_badges.badges_badge
24 SET quality = 40
25 WHERE quality = 'orange';
26
27UPDATE {$NAMESPACE}_badges.badges_badge
28 SET quality = 20
29 WHERE quality = 'yellow';
30
31ALTER TABLE {$NAMESPACE}_badges.badges_badge
32 MODIFY quality INT UNSIGNED NOT NULL;