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}_fact.fact_raw (
2 `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 `factType` VARCHAR(32) NOT NULL COLLATE utf8_bin,
4 `objectPHID` VARCHAR(64) NOT NULL COLLATE utf8_bin,
5 `objectA` VARCHAR(64) NOT NULL COLLATE utf8_bin,
6 `valueX` BIGINT NOT NULL,
7 `valueY` BIGINT NOT NULL,
8 `epoch` INT UNSIGNED NOT NULL,
9 KEY (objectPHID),
10 KEY (factType, epoch),
11 KEY (factType, objectA, epoch)
12) ENGINE=InnoDB, COLLATE utf8_general_ci;
13
14CREATE TABLE {$NAMESPACE}_fact.fact_aggregate (
15 `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
16 `factType` VARCHAR(32) NOT NULL COLLATE utf8_bin,
17 `objectPHID` VARCHAR(64) NOT NULL COLLATE utf8_bin,
18 `valueX` BIGINT NOT NULL,
19 UNIQUE KEY (factType, objectPHID),
20 KEY (factType, valueX)
21) ENGINE=InnoDB, COLLATE utf8_general_ci;
22
23CREATE TABLE {$NAMESPACE}_fact.fact_cursor (
24 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
25 `name` VARCHAR(64) NOT NULL COLLATE utf8_bin,
26 `position` VARCHAR(64) NOT NULL COLLATE utf8_bin,
27 UNIQUE KEY (name)
28) ENGINE=InnoDB, COLLATE utf8_general_ci;