[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_maniphest.maniphest_customfieldstorage (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    fieldIndex CHAR(12) NOT NULL COLLATE utf8_bin,
   5    fieldValue LONGTEXT NOT NULL,
   6    UNIQUE KEY (objectPHID, fieldIndex)
   7  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
   8  
   9  CREATE TABLE {$NAMESPACE}_maniphest.maniphest_customfieldstringindex (
  10    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  11    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  12    indexKey VARCHAR(12) NOT NULL COLLATE utf8_bin,
  13    indexValue LONGTEXT NOT NULL COLLATE utf8_general_ci,
  14  
  15    KEY `key_join` (objectPHID, indexKey, indexValue(64)),
  16    KEY `key_find` (indexKey, indexValue(64))
  17  
  18  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  19  
  20  CREATE TABLE {$NAMESPACE}_maniphest.maniphest_customfieldnumericindex (
  21    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  22    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  23    indexKey VARCHAR(12) NOT NULL COLLATE utf8_bin,
  24    indexValue BIGINT NOT NULL,
  25  
  26    KEY `key_join` (objectPHID, indexKey, indexValue),
  27    KEY `key_find` (indexKey, indexValue)
  28  
  29  ) ENGINE=InnoDB, COLLATE utf8_general_ci;