Add display order to public body categories and headings

1 files changed, 16 insertions, 0 deletions

diff --git a/db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb b/db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb
new file mode 100644
index 000000000..60ac5ec5e
--- /dev/null
+++ b/db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb
@@ -0,0 +1,16 @@
+class AddDisplayOrderToCategoriesAndHeadings < ActiveRecord::Migration
+  def up
+      add_column :public_body_categories_public_body_headings, :category_display_order, :integer
+
+      rename_table :public_body_categories_public_body_headings, :public_body_category_links
+      add_column :public_body_category_links, :id, :primary_key
+      add_index :public_body_category_links, [:public_body_category_id, :public_body_heading_id], :name => "index_public_body_category_links_on_join_ids", :primary => true
+  end
+
+  def down
+      remove_index :public_body_category_links, :name => "index_public_body_category_links_on_join_ids"
+      remove_column :public_body_category_links, :category_display_order
+      remove_column :public_body_category_links, :id
+      rename_table :public_body_category_links, :public_body_categories_public_body_headings
+  end
+end