--- a/lib/CrashTest/Storage/Sql/Schema/Result/CrashReport.pm	Sat Sep 12 00:00:43 2015 +0200
+++ b/lib/CrashTest/Storage/Sql/Schema/Result/CrashReport.pm	Sat Sep 12 01:12:44 2015 +0200
@@ -54,10 +54,14 @@
 sub sqlt_deploy_hook {
     my ($self, $sqlt_table) = @_;
     $sqlt_table->add_index(
-        name => 'crash_reports_idx_uuid',
+        name => 'crash_reports_uuid_idx',
         fields => [ 'uuid' ],
         type   => 'unique',
     );
+    $sqlt_table->add_index(
+        name => 'crash_reports_crash_time_idx',
+        fields => [ 'crash_time' ]
+    );
 }
 
 1;