Contents

class CreateCatalogues < ActiveRecord::Migration
  def change
    create_table :catalogues do |t|
      t.string :name
      t.integer :parent_id
      t.integer :lft, default: 0
      t.integer :rgt, default: 0
      t.integer :depth, default: 0

      t.timestamps
    end

    add_index :catalogues, :parent_id
    add_index :catalogues, [:lft, :rgt]
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
ab_admin-0.3.6	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.3.5	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.3.4	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.3.3	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.3.2	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.3.1	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.3.0	spec/dummy/db/migrate/20130207224516_create_catalogues.rb