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 ADD subprojectPHIDs longblob NOT NULL;
3UPDATE {$NAMESPACE}_project.project
4 SET subprojectPHIDs = '[]';
5
6CREATE TABLE {$NAMESPACE}_project.project_subproject (
7 projectPHID varchar(64) BINARY NOT NULL,
8 subprojectPHID varchar(64) BINARY NOT NULL,
9 PRIMARY KEY (subprojectPHID, projectPHID),
10 UNIQUE KEY (projectPHID, subprojectPHID)
11) ENGINE=InnoDB;