# HG changeset patch
# User Vincent Tondellier <tonton+hg@team1664.org>
# Date 1442013164 -7200
# Node ID 25df7947e5da06d7a244bdfcf7b2801ef619c17c
# Parent  ec517ae81b3956d7074ec0745f87b84187ecc2ee
Add index on crash_time (it is used to sort the index page)

diff -r ec517ae81b39 -r 25df7947e5da lib/CrashTest/Storage/Sql/Schema/Result/CrashReport.pm
--- 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;