Viewing File: /home/ubuntu/code-backup/code_review/phabricator/resources/sql/patches/023.dxkeys.sql

ALTER TABLE {$NAMESPACE}_differential.differential_changeset
  ADD KEY (diffID);

ALTER TABLE {$NAMESPACE}_differential.differential_comment
  ADD KEY (revisionID);

ALTER TABLE {$NAMESPACE}_differential.differential_diff
  ADD KEY (revisionID);

ALTER TABLE {$NAMESPACE}_differential.differential_inlinecomment
  ADD KEY (changesetID);

ALTER TABLE {$NAMESPACE}_differential.differential_inlinecomment
  ADD KEY (commentID);

ALTER TABLE {$NAMESPACE}_differential.differential_hunk
  ADD KEY (changesetID);

ALTER TABLE {$NAMESPACE}_herald.herald_transcript
  ADD KEY (objectPHID);

ALTER TABLE {$NAMESPACE}_differential.differential_revision
  ADD KEY (authorPHID, status);

ALTER TABLE {$NAMESPACE}_differential.differential_revision
  ADD UNIQUE KEY (phid);

ALTER TABLE {$NAMESPACE}_metamta.metamta_mailinglist
  ADD UNIQUE KEY (phid);