MDL-36941 core_message: improved performance of helper::get_messages()

[moodle.git] / lib / db / install.xml

diff --git a/lib/db/install.xml b/lib/db/install.xml
index eacc4c1..abd5c93 100644 (file)
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -608,6 +608,9 @@
         <KEY NAME="useridfrom" TYPE="foreign" FIELDS="useridfrom" REFTABLE="user" REFFIELDS="id"/>
         <KEY NAME="conversationid" TYPE="foreign" FIELDS="conversationid" REFTABLE="message_conversations" REFFIELDS="id"/>
       </KEYS>
+      <INDEXES>
+        <INDEX NAME="conversationid_timecreated" UNIQUE="false" FIELDS="conversationid, timecreated"/>
+      </INDEXES>
     </TABLE>
     <TABLE NAME="message_conversations" COMMENT="Stores all message conversations">
       <FIELDS>