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
1ALTER TABLE `{$NAMESPACE}_project`.`project`
2 MODIFY `phrictionSlug` varchar(128) binary;
3
4ALTER TABLE {$NAMESPACE}_repository.repository_path
5 ADD COLUMN pathHash varchar(32) binary AFTER path;
6UPDATE {$NAMESPACE}_repository.repository_path SET pathHash = MD5(path);
7ALTER TABLE {$NAMESPACE}_repository.repository_path
8 MODIFY pathHash varchar(32) binary not null,
9 DROP KEY path,
10 ADD UNIQUE KEY (pathHash);
11
12ALTER TABLE {$NAMESPACE}_user.user_sshkey
13 ADD COLUMN keyHash varchar(32) binary AFTER keyBody;
14UPDATE {$NAMESPACE}_user.user_sshkey SET keyHash = MD5(keyBody);
15ALTER TABLE {$NAMESPACE}_user.user_sshkey
16 MODIFY keyHash varchar(32) binary not null,
17 DROP KEY keyBody,
18 ADD UNIQUE KEY (keyHash);