Manual Schema changes for legacy App version update failure

// ALL Databases
ALTER TABLE scm_activity DROP CONSTRAINT scm_issuekey_changeid_type;
ALTER TABLE scm_activity DROP CONSTRAINT fk_scm_files_activity;
ALTER TABLE scm_activity DROP CONSTRAINT FK_scm_files_activity;

// MYSQL
ALTER TABLE scm_activity DROP FOREIGN KEY scm_issuekey_changeid_type;
ALTER TABLE scm_activity DROP INDEX scm_issuekey_changeid_type;
ALTER TABLE scm_activity DROP FOREIGN KEY FK_scm_files_activity;
ALTER TABLE scm_activity DROP INDEX FK_scm_files_activity;

// ALL Databases
ALTER TABLE scm_message DROP CONSTRAINT scm_activity_id;
ALTER TABLE scm_message DROP CONSTRAINT fk_scm_message_activity;
ALTER TABLE scm_message DROP CONSTRAINT FK_scm_message_activity;

// MYSQL
ALTER TABLE scm_message DROP FOREIGN KEY scm_activity_id;
ALTER TABLE scm_message DROP INDEX scm_activity_id;
ALTER TABLE scm_message DROP FOREIGN KEY FK_scm_message_activity;
ALTER TABLE scm_message DROP INDEX FK_scm_message_activity;

// ALL Databases
ALTER TABLE scm_files DROP CONSTRAINT fk_scm_files_activity;
ALTER TABLE scm_files DROP CONSTRAINT FK_scm_files_activity;

// MYSQL
ALTER TABLE scm_files DROP FOREIGN KEY FK_scm_files_activity;
ALTER TABLE scm_files DROP INDEX FK_scm_files_activity;

// ALL Databases
ALTER TABLE scm_job DROP CONSTRAINT scm_activity_id_jobname;
ALTER TABLE scm_job DROP CONSTRAINT fk_scm_job_activity;
ALTER TABLE scm_job DROP CONSTRAINT FK_scm_job_activity;

// MYSQL
ALTER TABLE scm_job DROP FOREIGN KEY scm_activity_id_jobname;
ALTER TABLE scm_job DROP INDEX scm_activity_id_jobname;
ALTER TABLE scm_job DROP FOREIGN KEY FK_scm_job_activity;
ALTER TABLE scm_job DROP INDEX FK_scm_job_activity;