class CreateDirtyHistoryRecords
Public Class Methods
down()
click to toggle source
# File lib/generators/dirty_history/migration/templates/active_record/migration.rb, line 30 def self.down drop_table :dirty_history_records end
up()
click to toggle source
# 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