Class: CreateDirtyHistoryRecords

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/dirty_history/migration/templates/active_record/migration.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



30
31
32
 
# File 'lib/generators/dirty_history/migration/templates/active_record/migration.rb', line 30

def self.down
  drop_table :dirty_history_records
end

.up ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
# 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