Contents

class CreateEcmStaffPositions < ActiveRecord::Migration
  def change
    create_table :ecm_staff_positions do |t|
      t.string :name
      t.text :description

      # acts as markup
      t.string :markup_language

      # awesome nested set
      t.references :parent
      t.integer :lft
      t.integer :rgt
      t.integer :depth

      # friendly id
      t.string :slug

      t.timestamps
    end
    add_index :ecm_staff_positions, :parent_id
  end
end

Version data entries

7 entries across 7 versions & 2 rubygems

Version	Path
ecm_staff2-2.0.0	db/migrate/003_create_ecm_staff_positions.rb
ecm_staff2-1.0.0	db/migrate/003_create_ecm_staff_positions.rb
ecm_staff2-0.0.3	db/migrate/003_create_ecm_staff_positions.rb
ecm_staff2-0.0.2	db/migrate/003_create_ecm_staff_positions.rb
ecm_staff2-0.0.1	db/migrate/003_create_ecm_staff_positions.rb
ecm_staff-0.0.2.pre	db/migrate/003_create_ecm_staff_positions.rb
ecm_staff-0.0.1.pre	db/migrate/003_create_ecm_staff_positions.rb