@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}_repository.repository_branch (
2 id int unsigned NOT NULL AUTO_INCREMENT,
3 repositoryID int unsigned NOT NULL,
4 name varchar(255) NOT NULL,
5 lintCommit varchar(40),
6 dateCreated int unsigned NOT NULL,
7 dateModified int unsigned NOT NULL,
8 UNIQUE (repositoryID, name),
9 PRIMARY KEY (id)
10);
11
12CREATE TABLE {$NAMESPACE}_repository.repository_lintmessage (
13 id int unsigned NOT NULL AUTO_INCREMENT,
14 branchID int unsigned NOT NULL,
15 path varchar(512) NOT NULL,
16 line int unsigned NOT NULL,
17 code varchar(32) NOT NULL,
18 severity varchar(16) NOT NULL,
19 name varchar(255) NOT NULL,
20 description text NOT NULL,
21 INDEX (branchID, path(64)),
22 INDEX (branchID, code, path(64)),
23 PRIMARY KEY (id)
24);