[FileBackend] Simplified fj_batch_id index

If we want to sort the ops for a batch ID, we can just use a tiny to small filesort.
No need to make the index bigger.

Change-Id: Ibf7592930ec633a26e675e33d42aebe7763547b1

diff --git a/maintenance/archives/patch-filejournal.sql b/maintenance/archives/patch-filejournal.sql
index 8c2f6b9..114297c 100644 (file)
--- a/maintenance/archives/patch-filejournal.sql
+++ b/maintenance/archives/patch-filejournal.sql
@@ -18,5 +18,5 @@ CREATE TABLE /*_*/filejournal (
   fj_timestamp varbinary(14) NOT NULL default ''
 );
 
-CREATE INDEX /*i*/fj_batch_id ON /*_*/filejournal (fj_batch_uuid,fj_id);
+CREATE INDEX /*i*/fj_batch_id ON /*_*/filejournal (fj_batch_uuid);
 CREATE INDEX /*i*/fj_timestamp ON /*_*/filejournal (fj_timestamp);