@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}_auth.auth_sshkey
2 SET name = '' WHERE name IS NULL;
3
4ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
5 CHANGE name name VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;
6
7UPDATE {$NAMESPACE}_auth.auth_sshkey
8 SET keyType = '' WHERE keyType IS NULL;
9
10ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
11 CHANGE keyType keyType VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;
12
13UPDATE {$NAMESPACE}_auth.auth_sshkey
14 SET keyBody = '' WHERE keyBody IS NULL;
15
16ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
17 CHANGE keyBody keyBody LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL;
18
19UPDATE {$NAMESPACE}_auth.auth_sshkey
20 SET keyComment = '' WHERE keyComment IS NULL;
21
22ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
23 CHANGE keyComment keyComment VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;