Contents

class AddMoreIndexesToAlchemyCrmTables < ActiveRecord::Migration
  def change
    add_index :alchemy_crm_recipients, :message_id
    add_index :alchemy_crm_recipients, :email
    add_index :alchemy_crm_recipients, :contact_id
    add_index :alchemy_crm_recipients, :delivery_id
    add_index :alchemy_crm_contacts, :email
    add_index :alchemy_crm_reactions, :recipient_id
    add_index :alchemy_contact_groups_newsletters, [:contact_group_id, :newsletter_id], :name => 'contact_group_newsletter_index', :unique => true
    add_index :alchemy_crm_subscriptions, [:contact_id, :newsletter_id], :name => 'contact_newsletter_index', :unique => true
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
alchemy_crm-2.0.5	db/migrate/20120327174301_add_more_indexes_to_alchemy_crm_tables.rb
alchemy_crm-2.0.4.1	db/migrate/20120327174301_add_more_indexes_to_alchemy_crm_tables.rb
alchemy_crm-2.1.0a	db/migrate/20120327174301_add_more_indexes_to_alchemy_crm_tables.rb
alchemy_crm-2.0.3	db/migrate/20120327174301_add_more_indexes_to_alchemy_crm_tables.rb
alchemy_crm-2.0.2	db/migrate/20120327174301_add_more_indexes_to_alchemy_crm_tables.rb