1 INSERT INTO {$NAMESPACE}_auth.auth_password
2 (objectPHID, phid, passwordType, passwordHash, isRevoked,
3 dateCreated, dateModified)
4 SELECT userPHID, CONCAT('XVCS', id), 'vcs', passwordHash, 0,
5 dateCreated, dateModified
6 FROM {$NAMESPACE}_repository.repository_vcspassword;