@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
1TRUNCATE {$NAMESPACE}_user.user_externalaccount;
2
3ALTER TABLE {$NAMESPACE}_user.user_externalaccount
4 CHANGE accountDomain accountDomain varchar(64) NOT NULL COLLATE utf8_bin;
5
6ALTER TABLE {$NAMESPACE}_user.user_externalaccount
7 CHANGE displayName displayName varchar(255) COLLATE utf8_bin;
8
9ALTER TABLE {$NAMESPACE}_user.user_externalaccount
10 ADD username VARCHAR(255) COLLATE utf8_bin;
11
12ALTER TABLE {$NAMESPACE}_user.user_externalaccount
13 ADD realName VARCHAR(255) COLLATE utf8_bin;
14
15ALTER TABLE {$NAMESPACE}_user.user_externalaccount
16 ADD email VARCHAR(255) COLLATE utf8_bin;
17
18ALTER TABLE {$NAMESPACE}_user.user_externalaccount
19 ADD emailVerified BOOL NOT NULL COLLATE utf8_bin;
20
21ALTER TABLE {$NAMESPACE}_user.user_externalaccount
22 ADD accountURI VARCHAR(255) COLLATE utf8_bin;
23
24ALTER TABLE {$NAMESPACE}_user.user_externalaccount
25 ADD profileImagePHID VARCHAR(64) COLLATE utf8_bin;
26
27ALTER TABLE {$NAMESPACE}_user.user_externalaccount
28 ADD properties LONGTEXT NOT NULL COLLATE utf8_bin;
29
30ALTER TABLE {$NAMESPACE}_user.user_externalaccount
31 ADD KEY `key_userAccounts` (userPHID);