~/projects/rails/app/ (setup_test_environment *%) ruby-1.8.7@rails2 $ rake spec
(in /Users/guest/projects/rails/app)
"SQL: CREATE UNIQUE INDEX `index_catalogs_on_url` ON catalogs (`url`)"
"SQL: CREATE  INDEX `index_districts_on_province_id` ON districts (`province_id`)"
"SQL: CREATE  INDEX `index_geolocalizations_on_property_id` ON geolocalizations (`property_id`)"
"SQL: CREATE  INDEX `index_images_on_property_id` ON images (`property_id`)"
"SQL: CREATE  INDEX `idx_messages` ON messages (`owner_id`, `owner_type`, `checked`)"
"SQL: CREATE  INDEX `index_messages_on_property_id` ON messages (`property_id`)"
"SQL: CREATE  INDEX `index_messages_on_reverse_created_at` ON messages (`reverse_created_at`)"
"SQL: CREATE  INDEX `index_messages_on_reverse_updated_at` ON messages (`reverse_updated_at`)"
"SQL: CREATE  INDEX `index_panoramics_on_property_id` ON panoramics (`property_id`)"
"SQL: CREATE  INDEX `index_photos_on_property_id` ON photos (`property_id`)"
"SQL: CREATE  INDEX `index_price_alerts_on_property_id` ON price_alerts (`property_id`)"
"SQL: CREATE  INDEX `index_projects_on_permalink` ON projects (`permalink`)"
"SQL: CREATE  INDEX `index_projects_properties_on_project_id_and_property_id` ON projects_properties (`project_id`, `property_id`)"
"SQL: CREATE  INDEX `idx_outstanding` ON properties (`active`, `outstanding`, `reverse_updated_at`)"
"SQL: CREATE  INDEX `idx_last_properties` ON properties (`active`, `reverse_created_at`)"
"SQL: CREATE  INDEX `idx_search` ON properties (`operation`, `type`)"
"SQL: CREATE  INDEX `idx_basic_search` ON properties (`owner_id`, `owner_type`)"
"SQL: CREATE  INDEX `index_properties_on_reverse_created_at` ON properties (`reverse_created_at`)"
"SQL: CREATE  INDEX `index_properties_on_reverse_updated_at` ON properties (`reverse_updated_at`)"
"SQL: CREATE UNIQUE INDEX `index_property_addresses_on_property_id` ON property_addresses (`property_id`)"
"SQL: CREATE UNIQUE INDEX `index_property_details_on_property_id` ON property_details (`property_id`)"
"SQL: CREATE UNIQUE INDEX `index_property_statistics_on_property_id` ON property_statistics (`property_id`)"
"SQL: CREATE  INDEX `index_real_states_on_reverse_created_at` ON real_states (`reverse_created_at`)"
"SQL: CREATE  INDEX `index_real_states_on_reverse_updated_at` ON real_states (`reverse_updated_at`)"
"SQL: CREATE  INDEX `index_service_list_on_url_name` ON service_list (`url_name`)"
"SQL: CREATE  INDEX `index_services_on_reverse_created_at` ON services (`reverse_created_at`)"
"SQL: CREATE  INDEX `index_services_on_reverse_updated_at` ON services (`reverse_updated_at`)"
"SQL: CREATE  INDEX `index_users_on_reverse_created_at` ON users (`reverse_created_at`)"
"SQL: CREATE  INDEX `index_users_on_reverse_updated_at` ON users (`reverse_updated_at`)"
"SQL: CREATE  INDEX `index_videos_on_property_id` ON videos (`property_id`)"
"SQL: CREATE  INDEX `index_vip_grants_on_real_state_id_and_vip_id` ON vip_grants (`real_state_id`, `vip_id`)"
"SQL: CREATE  INDEX `index_zones_on_district_id` ON zones (`district_id`)"
"SQL: CREATE UNIQUE INDEX `unique_schema_migrations` ON schema_migrations (`version`)"