class CreateDirtyHistoryRecords

# File lib/generators/dirty_history/migration/templates/active_record/migration.rb, line 30
def self.down
  drop_table :dirty_history_records
end

# File lib/generators/dirty_history/migration/templates/active_record/migration.rb, line 2
def self.up
  create_table :dirty_history_records do |t|                                           
    t.integer    :creator_id
    t.string     :creator_type, :limit => 64
    t.integer    :object_id
    t.string     :object_type,  :limit => 64
    t.string     :column_name,  :limit => 64
    t.string     :column_type,  :limit => 16 # :string, :text, :integer, :decimal, :float, :datetime, :boolean
    t.string     :old_value,    :limit => 128
    t.string     :new_value,    :limit => 128
  
    t.datetime   :created_at
    t.datetime   :revised_created_at
    t.datetime   :updated_at
    t.datetime   :deleted_at
  end
  add_index :dirty_history_records, [:creator_id, :creator_type]
  add_index :dirty_history_records, [:object_id,  :object_type]
  add_index :dirty_history_records, [:created_at,  :revised_created_at], :name => "index_created_at"
  add_index :dirty_history_records, [:deleted_at, :created_at,  :revised_created_at], :name => "index_deleted_at_created_at"
  add_index :dirty_history_records, [:object_type, :column_name, :deleted_at], :name => "index_obj_type_column_deleted_at"
  add_index :dirty_history_records, [:object_type, :column_name, :deleted_at, :created_at, :revised_created_at], :name => "index_obj_type_column_deleted_at_created_at"

  add_index :dirty_history_records, :old_value, :name => "index_old_value"
  add_index :dirty_history_records, :new_value, :name => "index_new_value"
  add_index :dirty_history_records, [:old_value, :new_value], :name => "index_old_value_new_value"
end