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}_user.user_customfieldstringindex (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 indexKey VARCHAR(12) NOT NULL COLLATE utf8_bin,
5 indexValue LONGTEXT NOT NULL COLLATE utf8_general_ci,
6
7 KEY `key_join` (objectPHID, indexKey, indexValue(64)),
8 KEY `key_find` (indexKey, indexValue(64))
9
10) ENGINE=InnoDB, COLLATE utf8_general_ci;
11
12CREATE TABLE {$NAMESPACE}_user.user_customfieldnumericindex (
13 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
14 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
15 indexKey VARCHAR(12) NOT NULL COLLATE utf8_bin,
16 indexValue BIGINT NOT NULL,
17
18 KEY `key_join` (objectPHID, indexKey, indexValue),
19 KEY `key_find` (indexKey, indexValue)
20
21) ENGINE=InnoDB, COLLATE utf8_general_ci;