Contents

class AddNestedSetToPostCategories < ActiveRecord::Migration
  def up
    change_table :spud_post_categories do |t|
      t.integer :lft
      t.integer :rgt
      t.integer :depth
    end

    # Populates lft, rgt, and depth values for nested set
    SpudPostCategory.where(:parent_id => 0).update_all({:parent_id => nil})
    SpudPostCategory.rebuild!
  end

  def down
    change_table :spud_post_categories do |t|
      t.remove :ltf
      t.remove :rgt
      t.remove :depth
    end
  end
end

Version data entries

27 entries across 27 versions & 2 rubygems

Version	Path
tb_blog-1.2.1	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.2.0	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-1.0.2	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-1.0.1	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-1.0.0	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.1.3	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.1.2	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.1.1	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.1.0	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-1.0.0.rc1.1	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-1.0.0.rc1	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.0.4	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.0.3	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-0.9.11	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.0.2	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.0.1	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
tb_blog-1.0	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-0.9.10	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-0.9.9	db/migrate/20121113135812_add_nested_set_to_post_categories.rb
spud_blog-0.9.8	db/migrate/20121113135812_add_nested_set_to_post_categories.rb