Contents

class AddNestedToProductCategories < ActiveRecord::Migration
  def up
    add_column :kkt_shoppe_product_categories, :parent_id, :integer
    add_column :kkt_shoppe_product_categories, :lft, :integer
    add_column :kkt_shoppe_product_categories, :rgt, :integer
    add_column :kkt_shoppe_product_categories, :depth, :integer

    add_index :kkt_shoppe_product_categories, :lft
    add_index :kkt_shoppe_product_categories, :rgt
    
    add_column :kkt_shoppe_product_categories, :ancestral_permalink, :string
    add_column :kkt_shoppe_product_categories, :permalink_includes_ancestors, :boolean, default: false

    KktShoppe::ProductCategory.reset_column_information
    KktShoppe::ProductCategory.rebuild!
  end

  def down
    remove_column :kkt_shoppe_product_categories, :ancestral_permalink
    remove_column :kkt_shoppe_product_categories, :permalink_includes_ancestors

    remove_index :kkt_shoppe_product_categories, :lft
    remove_index :kkt_shoppe_product_categories, :rgt

    remove_column :kkt_shoppe_product_categories, :parent_id
    remove_column :kkt_shoppe_product_categories, :lft
    remove_column :kkt_shoppe_product_categories, :rgt
    remove_column :kkt_shoppe_product_categories, :depth
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
kkt_shoppe-2.0.2	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-2.0.1	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-2.0.0	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-1.3.0	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-1.2.1	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-1.2.0	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-1.1.2	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-1.1.1	db/migrate/20141026181718_add_nested_to_product_categories.rb
kkt_shoppe-1.1.0	db/migrate/20141026181718_add_nested_to_product_categories.rb