@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}_owners.owners_customfieldstorage (
2 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3 objectPHID VARBINARY(64) NOT NULL,
4 fieldIndex BINARY(12) NOT NULL,
5 fieldValue LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
6 UNIQUE KEY (objectPHID, fieldIndex)
7) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};
8
9CREATE TABLE {$NAMESPACE}_owners.owners_customfieldstringindex (
10 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
11 objectPHID VARBINARY(64) NOT NULL,
12 indexKey BINARY(12) NOT NULL,
13 indexValue LONGTEXT NOT NULL COLLATE {$COLLATE_SORT},
14 KEY `key_join` (objectPHID, indexKey, indexValue(64)),
15 KEY `key_find` (indexKey, indexValue(64))
16) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};
17
18CREATE TABLE {$NAMESPACE}_owners.owners_customfieldnumericindex (
19 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
20 objectPHID VARBINARY(64) NOT NULL,
21 indexKey BINARY(12) NOT NULL,
22 indexValue BIGINT NOT NULL,
23 KEY `key_join` (objectPHID, indexKey, indexValue),
24 KEY `key_find` (indexKey, indexValue)
25) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};