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}_ponder`.`ponder_question` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `title` varchar(255) NOT NULL,
4 `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
5 `voteCount` int(10) NOT NULL,
6 `authorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
7 `content` longtext CHARACTER SET utf8 NOT NULL,
8 `dateCreated` int(10) unsigned NOT NULL,
9 `dateModified` int(10) unsigned NOT NULL,
10 `contentSource` varchar(255) DEFAULT NULL,
11 `heat` float NOT NULL,
12 `answerCount` int(10) unsigned NOT NULL,
13 PRIMARY KEY (`id`),
14 UNIQUE KEY `phid` (`phid`),
15 KEY `authorPHID` (`authorPHID`),
16 KEY `heat` (`heat`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11;
18
19CREATE TABLE `{$NAMESPACE}_ponder`.`ponder_answer` (
20 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
21 `questionID` int(10) unsigned NOT NULL,
22 `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
23 `voteCount` int(10) NOT NULL,
24 `authorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
25 `content` longtext CHARACTER SET utf8 NOT NULL,
26 `dateCreated` int(10) unsigned NOT NULL,
27 `dateModified` int(10) unsigned NOT NULL,
28 `contentSource` varchar(255) DEFAULT NULL,
29 PRIMARY KEY (`id`),
30 UNIQUE KEY `phid` (`phid`),
31 KEY `questionID` (`questionID`),
32 KEY `authorPHID` (`authorPHID`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35CREATE TABLE `{$NAMESPACE}_ponder`.`edge` (
36 `src` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
37 `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
38 `dst` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
39 `dateCreated` int(10) unsigned NOT NULL,
40 `seq` int(10) unsigned NOT NULL,
41 `dataID` int(10) unsigned DEFAULT NULL,
42 PRIMARY KEY (`src`,`type`,`dst`),
43 KEY `src` (`src`,`type`,`dateCreated`,`seq`)
44) ENGINE=InnoDB DEFAULT CHARSET=utf8;
45
46CREATE TABLE `{$NAMESPACE}_ponder`.`edgedata` (
47 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
48 `data` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;