class RightOnMigration < ActiveRecord::Migration
  def self.change
    create_table :rights do |t|
      t.string :name, :controller, :action, :limit => 150
      t.timestamps
    end

    change_table :rights do |t|
      t.index :action
      t.index :name
      t.index [:controller, :action]
    end

    create_table :rights_roles, :id => false do |t|
      t.integer :right_id, :role_id
    end

    change_table :rights_roles do |t|
      t.index [:right_id, :role_id]
      t.index [:role_id, :right_id]
    end

    create_table :roles do |t|
      t.string  :title
      t.text    :description
      t.integer :right_id
      t.timestamps
    end

    change_table :roles do |t|
      t.index :right_id
    end
  end
end