@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}_diviner.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
9 PRIMARY KEY (src, type, dst),
10 KEY src (src, type, dateCreated, seq),
11 UNIQUE KEY key_dst (dst, type, src)
12) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};
13
14CREATE TABLE {$NAMESPACE}_diviner.edgedata (
15 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
16 data LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT}
17) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};