@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}_phriction.edge (
2 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
3 type INT UNSIGNED NOT NULL COLLATE utf8_bin,
4 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
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, type, dateCreated, seq)
10) ENGINE=InnoDB, COLLATE utf8_general_ci;
11
12CREATE TABLE {$NAMESPACE}_phriction.edgedata (
13 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
14 data LONGTEXT NOT NULL COLLATE utf8_bin
15) ENGINE=InnoDB, COLLATE utf8_general_ci;