class AddAuditTrailsTable < ActiveRecord::Migration
  def self.up
    create_table :audit_trails do |t|
      t.column :record_id, :integer
      t.column :record_type, :string
      t.column :event, :string
      t.column :user_id, :integer
      t.column :created_at, :datetime
    end
end

  def self.down
    drop_table :audit_trails
  end
end

class AuditSweeper < ActionController::Caching::Sweeper    
  observe Person      
  def after_destroy(record)      
    log(record, "DESTROY")      
  end      
  def after_update(record)          
    log(record, "UPDATE")      
  end      
  def after_create(record)      
    log(record, "CREATE")      
  end      
  def log(record, event, user = controller.session[:user])          
    AuditTrail.create(:record_id => record.id,
                             :record_type => record.type.name,
                             :event => event,
                             :user_id => user)
  end
end

cache_sweeper :audit_sweeper