Contents

class AddNestedToPandaCmsMenuItems < ActiveRecord::Migration[7.1]
  def change
    add_column :panda_cms_menu_items, :parent_id, :uuid
    add_column :panda_cms_menu_items, :lft, :integer
    add_column :panda_cms_menu_items, :rgt, :integer
    add_column :panda_cms_menu_items, :depth, :integer
    add_column :panda_cms_menu_items, :children_count, :integer, null: false, default: 0

    add_index :panda_cms_menu_items, :lft
    add_index :panda_cms_menu_items, :rgt

    PandaCms::MenuItem.reset_column_information
    PandaCms::MenuItem.rebuild!

    # Update pages whilst we're at it
    add_column :panda_cms_pages, :depth, :integer
    add_column :panda_cms_pages, :children_count, :integer, null: false, default: 0
    add_index :panda_cms_pages, :lft
    add_index :panda_cms_pages, :rgt

    PandaCms::Page.reset_column_information
    PandaCms::Page.rebuild!
  end
end

Version data entries

39 entries across 39 versions & 1 rubygems

Version	Path
panda_cms-0.6.3	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.6.2	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.6.1	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.6.0	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.10	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.9	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.8	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.7	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.6	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.5	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.4	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.3	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.2	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.1	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.5.0	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.3.15	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.3.14	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.3.13	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.3.12	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb
panda_cms-0.3.11	db/migrate/20240316230706_add_nested_to_panda_cms_menu_items.rb