From b7943731efbedfc713f455ad9ce503650d5a67db Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Wed, 20 Feb 2008 09:53:45 +0000
Subject: [PATCH] MDL-4667, MDL-4112 switching order of columns in
 course-userid log table index in order to please mysql; merged from
 MOODLE_19_STABLE

---
 lib/db/install.xml | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index 87cc0353c9..e8c58bff70 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="lib/db" VERSION="20080202" COMMENT="XMLDB file for core Moodle tables"
+<XMLDB PATH="lib/db" VERSION="20080220" COMMENT="XMLDB file for core Moodle tables"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd"
 >
@@ -285,10 +285,10 @@
         <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
       </KEYS>
       <INDEXES>
-        <INDEX NAME="course-module-action" UNIQUE="false" FIELDS="course, module, action" NEXT="course-userid"/>
-        <INDEX NAME="course-userid" UNIQUE="false" FIELDS="course, userid" PREVIOUS="course-module-action" NEXT="time"/>
-        <INDEX NAME="time" UNIQUE="false" FIELDS="time" PREVIOUS="course-userid" NEXT="action"/>
-        <INDEX NAME="action" UNIQUE="false" FIELDS="action" PREVIOUS="time"/>
+        <INDEX NAME="course-module-action" UNIQUE="false" FIELDS="course, module, action" NEXT="time"/>
+        <INDEX NAME="time" UNIQUE="false" FIELDS="time" PREVIOUS="course-module-action" NEXT="action"/>
+        <INDEX NAME="action" UNIQUE="false" FIELDS="action" PREVIOUS="time" NEXT="userid-course"/>
+        <INDEX NAME="userid-course" UNIQUE="false" FIELDS="userid, course" PREVIOUS="action"/>
       </INDEXES>
     </TABLE>
     <TABLE NAME="log_display" COMMENT="For a particular module/action, specifies a moodle table/field" PREVIOUS="log" NEXT="message">
-- 
2.39.5