class DeleteOldTables < ActiveRecord::Migration[6.1]
  def change
    drop_table :tips
    drop_table :tickets
    drop_table :answers
    
    remove_column :programs, :training_id
    remove_column :routines, :training_id
    
    remove_column :meals, :diet_id
    remove_column :diets, :training_id
    drop_table :diets
    
    drop_table :measurements
    
    remove_index :users, column: [:identity_id], name: "index_users_on_identity_id"
    remove_column :users, :identity_id
    
    remove_index :trainings, column: [:identity_id], name: "index_trainings_on_identity_id"
    remove_column :trainings, :identity_id

    remove_index :identities, column: [:recommender_id], name: "index_identities_on_recommender_id"
    remove_index :identities, column: [:trainer_id], name: "index_identities_on_trainer_id"
    drop_table :identities

    drop_table :trainings
    drop_table :details
    drop_table :exercises

    # antiguos cuestionarios
    remove_index :choices, column: [:question_id], name: "index_choices_on_question_id"
    remove_column :choices, :question_id
    
    remove_index :questions, column: [:section_id], name: "index_questions_on_section_id"
    remove_column :questions, :section_id
    
    drop_table :questions
    drop_table :choices
    drop_table :sections
  end
end