[Summary view] [Print] [Text view]

   1  CREATE 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  
  12  CREATE 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;