Change the index to be stream_ordering, highlight

1 files changed, 1 insertions, 1 deletions

diff --git a/synapse/storage/event_push_actions.py b/synapse/storage/event_push_actions.py

index e02afdb1df..51b13e9498 100644
--- a/synapse/storage/event_push_actions.py
+++ b/synapse/storage/event_push_actions.py
@@ -36,7 +36,7 @@ class EventPushActionsStore(SQLBaseStore):
             self.EPA_HIGHLIGHT_INDEX,
             index_name="event_push_actions_u_highlight",
             table="event_push_actions",
-            columns=["user_id", "highlight", "stream_ordering"],
+            columns=["user_id", "stream_ordering", "highlight"],
         )
 
     def _set_push_actions_for_event_and_users_txn(self, txn, event, tuples):