DROP INDEX IF EXISTS ix_qna_task_state_deleted_rater_ds_manager;

ALTER TABLE IF EXISTS qna_table DROP COLUMN IF EXISTS last_assigned_rater;
ALTER TABLE IF EXISTS qna_table DROP COLUMN IF EXISTS last_assigned_manager;
ALTER TABLE IF EXISTS qna_table DROP COLUMN IF EXISTS last_answered_ds;

ALTER TABLE IF EXISTS qna_version_table DROP COLUMN IF EXISTS last_assigned_rater;
ALTER TABLE IF EXISTS qna_version_table DROP COLUMN IF EXISTS last_assigned_manager;
ALTER TABLE IF EXISTS qna_version_table DROP COLUMN IF EXISTS last_answered_ds;
