Differential D8344 Diff 19854 resources/sql/patches/20130926.dinkeys.sql

Changeset View

Standalone View

	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);