diff --git a/db/migrate/20161205095623_removing_intermediary_tables.rb b/db/migrate/20161205095623_removing_intermediary_tables.rb
new file mode 100644
index 0000000..769b881
--- /dev/null
+++ b/db/migrate/20161205095623_removing_intermediary_tables.rb
@@ -0,0 +1,62 @@
+class RemovingIntermediaryTables < ActiveRecord::Migration
+  def change
+    # removing intermediary structures
+
+    drop_table :dmptemplates
+
+    change_table :new_phases do |t|
+      remove_column :vid
+    end
+    drop_table :phases
+    rename_table :new_phases, :phases
+
+    change_table :new_sections do |t|
+      rename_column :new_phase_id, :phase_id
+
+    end
+    drop_table :sections
+    rename_table :new_sections, :sections
+
+    change_table :new_questions do |t|
+      rename_column :new_section_id, :section_id
+      remove_column :question_id
+    end
+    drop_table :questions
+    rename_table :new_questions, :questions
+
+    change_table :new_questions_themes do |t|
+    end
+    drop_table :questions_themes
+    rename_table :new_questions_themes, :questions_themes
+
+    change_table :new_answers do |t|
+      rename_column :new_plan_id, :plan_id
+      rename_column :new_question_id, :question_id
+    end
+    drop_table :answers
+    rename_table :new_answers, :answers
+
+    change_table :question_options do |t|
+      rename_column :new_question_id, :question_id
+      remove_column :option_id
+    end
+    drop_table :options
+
+    drop_table :answers_options
+    rename_table :new_answers_question_options, :answers_question_options
+
+    change_table :notes do |t|
+      rename_column :new_answer_id, :answer_id
+    end
+    drop_table :comments
+
+    change_table :new_plans do |t|
+    end
+    drop_table :plans
+    rename_table :new_plans, :plans
+
+    change_table :roles do |t|
+      rename_column :new_plan_id, :plan_id
+    end
+  end
+end