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}_phame`.`phame_post` (
2 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 `phid` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
4 `bloggerPHID` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
5 `title` VARCHAR(255) NOT NULL,
6 `phameTitle` VARCHAR(64) NOT NULL,
7 `body` LONGTEXT COLLATE utf8_general_ci,
8 `visibility` INT UNSIGNED NOT NULL DEFAULT 0,
9 `configData` LONGTEXT COLLATE utf8_general_ci,
10 `datePublished` INT UNSIGNED NOT NULL,
11 `dateCreated` INT UNSIGNED NOT NULL,
12 `dateModified` INT UNSIGNED NOT NULL,
13 KEY `bloggerPosts` (`bloggerPHID`, `visibility`, `datePublished`, `id`),
14 UNIQUE KEY `phid` (`phid`),
15 UNIQUE KEY `phameTitle` (`bloggerPHID`, `phameTitle`)
16) ENGINE=InnoDB;