Sha256: df436286330ce1c0ec34f5977e78105e689f1d70d674cbda2bb245a8670aa4a5

Contents?: true

Size: 603 Bytes

Versions: 13

Compression:

Stored size: 603 Bytes

Contents

class CreateCategories < ActiveRecord::Migration
  def self.up
    create_table :categories, :force=>true do |t|
      t.string  :name
      t.string  :url
      t.integer :lft
      t.integer :rgt
      t.integer :depth
      t.integer :parent_id
      t.boolean :is_visible
      t.timestamps
    end

    add_index :categories, [:lft,:rgt,:parent_id]
    add_index :categories, :lft # for sorting
    add_index :categories, :rgt
    add_index :categories, :depth
    add_index :categories, :parent_id
    add_index :categories, :is_visible
  end

  def self.down
    drop_table :categories
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version Path
lolita-menu-0.4.2 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.4.1 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.4.0 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.3.6 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.3.5 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.3.4 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.3.2 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.3.1 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.3.0 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.2.2 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.2.1 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.2.0 test_orm/db/migrate/03_create_categories.rb
lolita-menu-0.1.7 test_orm/db/migrate/03_create_categories.rb