# This patch file was generated by NetBeans IDE
# This patch can be applied using context Tools: Apply Diff Patch action on respective folder.
# It uses platform neutral UTF-8 encoding.
# Above lines and this line are ignored by the patching process.
Index: moodle/lib/db/upgrade.php
--- moodle/lib/db/upgrade.php Base (1.154.2.67)
+++ moodle/lib/db/upgrade.php Locally Modified (Based On 1.154.2.67)
@@ -3291,6 +3291,32 @@
         upgrade_main_savepoint($result, 2007101563.03);
     }
 
+    if ($result && $oldversion < 2007101571.01) {
+        // bring down course sort orders away from maximum values
+        // MDL-21011
+        $sql = "SELECT * from {$CFG->prefix}course
+                ORDER BY sortorder ASC;";
+        if ($courses = get_records_sql($sql)) {
+            $i=1000;
+            $old_category = 0;
+            foreach ($courses as $course) {
+                if($course->category!=$old_category) {
+                    $i += 1000; //put a gap between courses in different categories
+                    $old_category = $course->category;
+                }
+                $course->sortorder = $i++;
+
+                //this sets every field and not just the modified ones so its a bit slow.
+                //$result = $result && update_record('course', $course);
+                //Just set the one field.
+                execute_sql("UPDATE {$CFG->prefix}course SET sortorder=$i WHERE id={$course->id}");
+            }
+        }
+        unset($courses);
+
+        upgrade_main_savepoint($result, 2007101571.01);
+    }
+
     return $result;
 }