Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130926.dinkeys.sql
| ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ||||
| DROP KEY `key_draft`; | DROP KEY `key_draft`; | ||||
| ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ||||
| ADD KEY `key_changeset` (changesetID); | ADD KEY `key_changeset` (changesetID); | ||||
| ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ||||
| ADD KEY `key_draft` (authorPHID, transactionPHID); | ADD KEY `key_draft` (authorPHID, transactionPHID); | ||||
| ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ||||
| ADD KEY `key_revision` (revisionPHID); | ADD KEY `key_revision` (revisionPHID); | ||||
| ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ALTER TABLE {$NAMESPACE}_differential.differential_transaction_comment | ||||
| ADD KEY `key_legacy` (legacyCommentID); | ADD KEY `key_legacy` (legacyCommentID); | ||||