@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_buildable (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 buildablePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
5 containerPHID VARCHAR(64) COLLATE utf8_bin,
6 buildStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
7 buildableStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
8 dateCreated INT UNSIGNED NOT NULL,
9 dateModified INT UNSIGNED NOT NULL,
10 KEY `key_buildable` (buildablePHID),
11 KEY `key_container` (containerPHID),
12 UNIQUE KEY `key_phid` (phid)
13) ENGINE=InnoDB, COLLATE utf8_general_ci;
14
15CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact (
16 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
17 buildablePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
18 artifactType VARCHAR(32) NOT NULL COLLATE utf8_bin,
19 artifactIndex VARCHAR(12) NOT NULL COLLATE utf8_bin,
20 artifactKey VARCHAR(255) NOT NULL COLLATE utf8_bin,
21 artifactData LONGTEXT NOT NULL COLLATE utf8_bin,
22 dateCreated INT UNSIGNED NOT NULL,
23 dateModified INT UNSIGNED NOT NULL,
24 UNIQUE KEY `key_artifact` (buildablePHID, artifactType, artifactIndex),
25 UNIQUE KEY `key_artifact_type` (artifactType, artifactIndex),
26 KEY `key_garbagecollect` (artifactType, dateCreated)
27) ENGINE=InnoDB, COLLATE utf8_general_ci;
28
29CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildplan (
30 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
31 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
32 name VARCHAR(255) NOT NULL,
33 planStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
34 dateCreated INT UNSIGNED NOT NULL,
35 dateModified INT UNSIGNED NOT NULL,
36 UNIQUE KEY `key_phid` (phid),
37 KEY `key_status` (planStatus)
38) ENGINE=InnoDB, COLLATE utf8_general_ci;
39
40CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildplantransaction (
41 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
42 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
43 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
44 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
45 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
46 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
47 commentPHID VARCHAR(64) COLLATE utf8_bin,
48 commentVersion INT UNSIGNED NOT NULL,
49 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
50 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
51 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
52 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
53 metadata LONGTEXT NOT NULL COLLATE utf8_bin,
54 dateCreated INT UNSIGNED NOT NULL,
55 dateModified INT UNSIGNED NOT NULL,
56
57 UNIQUE KEY `key_phid` (phid),
58 KEY `key_object` (objectPHID)
59
60) ENGINE=InnoDB, COLLATE utf8_general_ci;
61
62CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_build (
63 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
64 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
65 buildablePHID varchar(64) NOT NULL COLLATE utf8_bin,
66 buildPlanPHID varchar(64) NOT NULL COLLATE utf8_bin,
67 buildStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
68 dateCreated INT UNSIGNED NOT NULL,
69 dateModified INT UNSIGNED NOT NULL,
70 UNIQUE KEY `key_phid` (phid),
71 KEY `key_buildable` (buildablePHID),
72 KEY `key_plan` (buildPlanPHID),
73 KEY `key_status` (buildStatus)
74) ENGINE=InnoDB, COLLATE utf8_general_ci;