@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}_application.edge (
2 src VARBINARY(64) NOT NULL,
3 type INT UNSIGNED NOT NULL,
4 dst VARBINARY(64) NOT NULL,
5 dateCreated INT UNSIGNED NOT NULL,
6 seq INT UNSIGNED NOT NULL,
7 dataID INT UNSIGNED,
8 PRIMARY KEY (src, type, dst),
9 KEY `src` (src, type, dateCreated, seq),
10 UNIQUE KEY `key_dst` (dst, type, src)
11) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};
12
13CREATE TABLE {$NAMESPACE}_application.edgedata (
14 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
15 data LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT}
16) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};