@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
1CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildtarget (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 buildPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
5 buildStepPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
6 className VARCHAR(255) NOT NULL COLLATE utf8_bin,
7 details LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
8 variables LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
9 dateCreated INT UNSIGNED NOT NULL,
10 dateModified INT UNSIGNED NOT NULL,
11 KEY `key_build` (buildPHID, buildStepPHID),
12 UNIQUE KEY `key_phid` (phid)
13) ENGINE=InnoDB, COLLATE utf8_general_ci;
14
15TRUNCATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog;
16TRUNCATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlogchunk;
17TRUNCATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact;
18
19ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog
20DROP COLUMN buildPHID;
21
22ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog
23DROP COLUMN buildStepPHID;
24
25ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact
26DROP COLUMN buildablePHID;
27
28ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog
29ADD COLUMN buildTargetPHID VARCHAR(64) NOT NULL COLLATE utf8_bin;
30
31ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact
32ADD COLUMN buildTargetPHID VARCHAR(64) NOT NULL COLLATE utf8_bin;