@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}_pholio.pholio_image
2 ADD `isObsolete` TINYINT(1) NOT NULL DEFAULT '0';
3
4ALTER TABLE {$NAMESPACE}_pholio.pholio_image
5 DROP KEY `mockID`;
6
7ALTER TABLE {$NAMESPACE}_pholio.pholio_image
8 ADD KEY `mockID` (`mockID`, `isObsolete`, `sequence`);
9
10ALTER TABLE {$NAMESPACE}_pholio.pholio_image
11 ADD `phid` VARCHAR(64) NOT NULL COLLATE utf8_bin AFTER `id`;
12
13ALTER TABLE {$NAMESPACE}_pholio.pholio_image
14 CHANGE `mockID` `mockID` INT(10) UNSIGNED;