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.2.3	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.2.2	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.2.1	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.2.0	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.1.2	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.1.1	spec/dummy/db/migrate/20130207224516_create_catalogues.rb
ab_admin-0.1.0	spec/dummy/db/migrate/20130207224516_create_catalogues.rb