@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.diviner_livebook (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 name VARCHAR(64) NOT NULL COLLATE utf8_bin,
5 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
6 dateCreated INT UNSIGNED NOT NULL,
7 dateModified INT UNSIGNED NOT NULL,
8 UNIQUE KEY (name),
9 UNIQUE KEY (phid)
10) ENGINE=InnoDB, DEFAULT CHARSET = utf8;
11
12
13CREATE TABLE {$NAMESPACE}_diviner.diviner_livesymbol (
14 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
15 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
16 bookPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
17 context VARCHAR(255) COLLATE utf8_bin,
18 type VARCHAR (32) NOT NULL COLLATE utf8_bin,
19 name VARCHAR (255) NOT NULL COLLATE utf8_bin,
20 atomIndex INT UNSIGNED NOT NULL,
21 identityHash VARCHAR(12) NOT NULL COLLATE utf8_bin,
22 graphHash VARCHAR(33) COLLATE utf8_bin,
23 KEY (bookPHID, type, name(64), context(64), atomIndex),
24 KEY (name),
25 UNIQUE KEY (graphHash),
26 UNIQUE KEY (identityHash),
27 UNIQUE KEY (phid)
28) ENGINE=InnoDB, DEFAULT CHARSET = utf8;
29
30CREATE TABLE {$NAMESPACE}_diviner.diviner_liveatom (
31 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
32 symbolPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
33 content LONGTEXT NOT NULL COLLATE utf8_bin,
34 atomData LONGTEXT NOT NULL COLLATE utf8_bin,
35 UNIQUE KEY (symbolPHID)
36) ENGINE=InnoDB, DEFAULT CHARSET = utf8;