new.rb

  describe "database" do

    it "should have an unique index on confirmation_token" do
      must have_db_index(:confirmation_token).unique(true)
    end

    it "should have an unique index on email" do
      must have_db_index(:email).unique(true)
    end

    it "should have an unique index on reset_password_token" do
      must have_db_index(:reset_password_token).unique(true)
    end

    it "should have an index on validated and application_id" do
      must have_db_index([:validated, :application_id])
    end

  end

old.rb

  describe "database" do

    it { must have_db_index(:confirmation_token).unique(true) }
    it { must have_db_index(:email).unique(true) }
    it { must have_db_index(:reset_password_token).unique(true) }
    it { must have_db_index([:validated, :application_id]) }

  end