@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
1INSERT INTO {$NAMESPACE}_auth.auth_password
2 (objectPHID, phid, passwordType, passwordHash, passwordSalt, isRevoked,
3 dateCreated, dateModified)
4 SELECT phid, CONCAT('XACCOUNT', id), 'account', passwordHash, passwordSalt, 0,
5 dateCreated, dateModified
6 FROM {$NAMESPACE}_user.user
7 WHERE passwordHash != '';