Rename some columns and indexes in the bug tables

[rails.git] / db / migrate / 20110508145337_cleanup_bug_tables.rb

diff --git a/db/migrate/20110508145337_cleanup_bug_tables.rb b/db/migrate/20110508145337_cleanup_bug_tables.rb
new file mode 100644 (file)
index 0000000..a5563ce
--- /dev/null
+++ b/db/migrate/20110508145337_cleanup_bug_tables.rb
@@ -0,0 +1,37 @@
+class CleanupBugTables < ActiveRecord::Migration
+  def self.up
+    rename_column :map_bugs, :date_created, :created_at
+    rename_column :map_bugs, :last_changed, :updated_at
+    rename_column :map_bugs, :date_closed, :closed_at
+
+    rename_index :map_bugs, :map_bugs_tile_idx, :map_bugs_tile_staus_idx
+    rename_index :map_bugs, :map_bugs_changed_idx, :map_bugs_updated_at_idx
+    rename_index :map_bugs, :map_bugs_created_idx, :map_bugs_created_at_idx
+
+    rename_column :map_bug_comment, :date_created, :created_at
+    rename_column :map_bug_comment, :commenter_name, :author_name
+    rename_column :map_bug_comment, :commenter_ip, :author_ip
+    rename_column :map_bug_comment, :commenter_id, :author_id
+    rename_column :map_bug_comment, :comment, :body
+
+    rename_index :map_bug_comment, :map_bug_comment_id_idx, :map_bug_comment_bug_id_idx
+  end
+
+  def self.down
+    rename_index :map_bug_comment, :map_bug_comment_bug_id_idx, :map_bug_comment_id_idx
+
+    rename_column :map_bug_comment, :body, :comment
+    rename_column :map_bug_comment, :author_id, :commenter_id
+    rename_column :map_bug_comment, :author_ip, :commenter_ip
+    rename_column :map_bug_comment, :author_name, :commenter_name
+    rename_column :map_bug_comment, :created_at, :date_created
+
+    rename_index :map_bugs, :map_bugs_created_at_idx, :map_bugs_created_idx
+    rename_index :map_bugs, :map_bugs_updated_at_idx, :map_bugs_changed_idx
+    rename_index :map_bugs, :map_bugs_tile_staus_idx, :map_bugs_tile_idx
+
+    rename_column :map_bugs, :closed_at, :date_closed
+    rename_column :map_bugs, :updated_at, :last_changed
+    rename_column :map_bugs, :created_at, :date_created
+  end
+end