@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}_owners.owners_package (
2 id int unsigned not null auto_increment primary key,
3 phid varchar(64) binary not null,
4 unique key(phid),
5 name varchar(255) COLLATE `binary` not null,
6 unique key(name),
7 description text not null,
8 primaryOwnerPHID varchar(64) binary
9);
10
11CREATE TABLE {$NAMESPACE}_owners.owners_owner (
12 id int unsigned not null auto_increment primary key,
13 packageID int unsigned not null,
14 userPHID varchar(64) binary not null,
15 UNIQUE KEY(packageID, userPHID),
16 KEY(userPHID)
17);
18
19CREATE TABLE {$NAMESPACE}_owners.owners_path (
20 id int unsigned not null auto_increment primary key,
21 packageID int unsigned not null,
22 key(packageID),
23 repositoryPHID varchar(64) binary not null,
24 path varchar(255) not null
25);