Differential D8344 Diff 19854 resources/sql/patches/058.missingkeys.sql

Changeset View

Standalone View

	ALTER TABLE {$NAMESPACE}_file.file			ALTER TABLE {$NAMESPACE}_file.file
	ADD UNIQUE KEY (phid);			ADD UNIQUE KEY (phid);

	ALTER TABLE {$NAMESPACE}_project.project			ALTER TABLE {$NAMESPACE}_project.project
	ADD UNIQUE KEY (phid);			ADD UNIQUE KEY (phid);

	ALTER TABLE {$NAMESPACE}_herald.herald_condition			ALTER TABLE {$NAMESPACE}_herald.herald_condition
	ADD KEY (ruleID);			ADD KEY (ruleID);

	ALTER TABLE {$NAMESPACE}_herald.herald_action			ALTER TABLE {$NAMESPACE}_herald.herald_action
	ADD KEY (ruleID);			ADD KEY (ruleID);
	No newline at end of file