class RemovingIntermediaryTables < ActiveRecord::Migration
  def up
    # removing intermediary structures

    drop_table :dmptemplates

    change_table :new_phases do |t|
      t.remove :vid
    end
    drop_table :phases
    rename_table :new_phases, :phases

    change_table :new_sections do |t|
      t.rename :new_phase_id, :phase_id

    end
    drop_table :sections
    rename_table :new_sections, :sections

    change_table :new_questions do |t|
      t.rename :new_section_id, :section_id
      t.remove :question_id
    end
    drop_table :questions
    rename_table :new_questions, :questions

    change_table :new_questions_themes do |t|
      t.rename :new_question_id, :question_id
    end
    drop_table :questions_themes
    rename_table :new_questions_themes, :questions_themes

    change_table :new_answers do |t|
      t.rename :new_plan_id, :plan_id
      t.rename :new_question_id, :question_id
    end
    drop_table :answers
    rename_table :new_answers, :answers

    change_table :question_options do |t|
      t.rename :new_question_id, :question_id
      t.remove :option_id
    end
    drop_table :options

    change_table :new_answers_question_options do |t|
      t.rename :new_answer_id, :answer_id
    end
    drop_table :answers_options
    rename_table :new_answers_question_options, :answers_question_options

    change_table :notes do |t|
      t.rename :new_answer_id, :answer_id
    end
    drop_table :comments

    change_table :new_plans do |t|
      #t.remove :project_id
    end
    drop_table :plans
    rename_table :new_plans, :plans

    change_table :roles do |t|
      t.rename :new_plan_id, :plan_id
    end

    change_table :new_suggested_answers do |t|
      t.rename :new_question_id, :question_id
    end
    drop_table :suggested_answers
    rename_table :new_suggested_answers, :suggested_answers

    #drop_table :projects

    rename_table :organisations, :orgs
    rename_column :guidance_groups, :organisation_id, :org_id
    rename_column :suggested_answers, :organisation_id, :org_id
    rename_column :org_token_permissions, :organisation_id, :org_id
    rename_column :projects, :organisation_id, :org_id
    rename_column :templates, :organisation_id, :org_id
    rename_column :users, :organisation_id, :org_id

    drop_table :projects
    
    drop_table :project_groups
    drop_table :project_guidance
    drop_table :versions
    drop_table :dmptemplates_guidance_groups
    drop_table :plan_sections

  end

  def down
    create_table :dmptemplates
    change_table :phases do |t|
      t.integer :vid
    end
    rename_table :phases, :new_phases
    create_table :phases


    change_table :sections do |t|
      t.rename :phase_id, :new_phase_id
    end
    rename_table :sections, :new_sections
    create_table :sections


    change_table :questions do |t|
      t.rename :section_id, :new_section_id
      t.integer :question_id
    end
    rename_table :questions, :new_questions
    create_table :questions

    change_table :questions_themes do |t|
      t.rename :question_id, :new_question_id
    end
    rename_table :questions_themes, :new_questions_themes
    create_table :questions_themes

    change_table :answers do |t|
      t.rename :plan_id, :new_plan_id
      t.rename :question_id, :new_question_id
    end
    rename_table :answers, :new_answers
    create_table :answers

    change_table :question_options do |t|
      t.rename :question_id, :new_question_id
      t.integer :option_id
    end
    create_table :options

    change_table :answers_question_options do |t|
      t.rename :answer_id, :new_answer_id
    end
    rename_table :answers_question_options, :new_answers_question_options
    create_table :answers_options

    change_table :notes do |t|
      t.rename :answer_id, :new_answer_id
    end
    create_table :comments

    change_table :plans do |t|
    end
    rename_table :plans, :new_plans
    create_table :plans

    change_table :roles do |t|
      t.rename :plan_id, :new_plan_id
    end

    rename_table  :suggested_answers, :new_suggested_answers
    create_table :suggested_answers
    change_table :new_suggested_answers do |t|
      t.rename :question_id, :new_question_id
    end
  end
end