db/migrate/20120308144859_create_permissions.rb

	20120308144859_create_permissions.rb revision 8c1be7aa00ddeb367fac5d3e8574429a301dbeb7
class CreatePermissions < ActiveRecord::Migration
  def change
    create_table :permissions do |t|
      t.references :subject, :polymorphic => true, :null => false
      t.references :item,    :polymorphic => true, :null => false
      t.string :role, :null => false, :default => 'editor'
      t.timestamps :null => false
    end

    change_table :permissions do |t|
      t.index [:item_id, :item_type, :subject_id, :subject_type],
        :name => 'index_permissions_on_item_and_subject',
        :unique => true
      t.index [:subject_id, :subject_type]
    end
  end
end