recaptime.dev
@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}_harbormaster.harbormaster_object (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 name VARCHAR(255) COLLATE utf8_general_ci,
5 dateCreated INT UNSIGNED NOT NULL,
6 dateModified INT UNSIGNED NOT NULL
7) ENGINE=InnoDB, COLLATE utf8_general_ci;
8
9CREATE TABLE {$NAMESPACE}_harbormaster.edge (
10 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
11 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
12 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
13 dateCreated INT UNSIGNED NOT NULL,
14 seq INT UNSIGNED NOT NULL,
15 dataID INT UNSIGNED,
16 PRIMARY KEY (src, type, dst),
17 KEY (src, type, dateCreated, seq)
18) ENGINE=InnoDB, COLLATE utf8_general_ci;
19
20CREATE TABLE {$NAMESPACE}_harbormaster.edgedata (
21 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
22 data LONGTEXT NOT NULL COLLATE utf8_bin
23) ENGINE=InnoDB, COLLATE utf8_general_ci;