aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20140804120601_add_display_order_to_categories_and_headings.rb16
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