class AddMoreIndexes < ActiveRecord::Migration
  def change
    add_index :events, :created_at
    add_index :events, :target_id

    add_index :issues, :closed
    add_index :issues, :created_at
    add_index :issues, :title

    add_index :keys, :identifier
    # FIXME: MySQL can't index text columns
    #add_index :keys, :key
    add_index :keys, :project_id

    add_index :merge_requests, :closed
    add_index :merge_requests, :created_at
    add_index :merge_requests, :source_branch
    add_index :merge_requests, :target_branch
    add_index :merge_requests, :title

    add_index :milestones, :due_date
    add_index :milestones, :project_id

    add_index :namespaces, :name
    add_index :namespaces, :path
    add_index :namespaces, :type

    add_index :notes, :created_at

    add_index :snippets, :created_at
    add_index :snippets, :expires_at

    add_index :users, :admin
    add_index :users, :blocked
    add_index :users, :name
    add_index :users, :username

    add_index :users_projects, :project_access
    add_index :users_projects, :user_id

    add_index :wikis, :project_id
    add_index :wikis, :slug
  end
end