@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}_phame.phame_blog (
2 `id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3 `phid` VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 `name` VARCHAR(64) NOT NULL COLLATE utf8_bin,
5 `description` LONGTEXT NOT NULL COLLATE utf8_bin,
6 `configData` LONGTEXT NOT NULL COLLATE utf8_bin,
7 `creatorPHID` VARCHAR(64) NOT NULL COLLATE utf8_bin,
8 `dateCreated` INT UNSIGNED NOT NULL,
9 `dateModified` INT UNSIGNED NOT NULL,
10 UNIQUE KEY (`phid`)
11) ENGINE=InnoDB, COLLATE utf8_general_ci;
12
13CREATE TABLE {$NAMESPACE}_phame.edge (
14 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
15 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
16 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
17 dateCreated INT UNSIGNED NOT NULL,
18 seq INT UNSIGNED NOT NULL,
19 dataID INT UNSIGNED,
20 PRIMARY KEY (src, type, dst),
21 KEY (src, type, dateCreated, seq)
22) ENGINE=InnoDB, COLLATE utf8_general_ci;
23
24CREATE TABLE {$NAMESPACE}_phame.edgedata (
25 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
26 data LONGTEXT NOT NULL COLLATE utf8_bin
27) ENGINE=InnoDB, COLLATE utf8_general_ci;
28
29ALTER TABLE {$NAMESPACE}_phame.phame_post
30 ADD KEY `instancePosts` (`visibility`, `datePublished`, `id`);