From 812e3294be7a0cf0edd687d6640e6a7d0734ddd8 Mon Sep 17 00:00:00 2001 From: Petr Skoda Date: Sun, 21 Aug 2011 16:41:58 +0200 Subject: [PATCH] MDL-27248 remove forgotten unique sortorder index from the course table --- lib/db/upgrade.php | 12 ++++++++++++ version.php | 2 +- 2 files changed, 13 insertions(+), 1 deletion(-) diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php index 198d35301ce..b4d57f86c84 100644 --- a/lib/db/upgrade.php +++ b/lib/db/upgrade.php @@ -6639,6 +6639,18 @@ FROM // Moodle v2.1.0 release upgrade line // Put any upgrade step following this + if ($oldversion < 2011070101.04) { + // Remove category_sortorder index that was supposed to be removed long time ago + $table = new xmldb_table('course'); + $index = new xmldb_index('category_sortorder', XMLDB_INDEX_UNIQUE, array('category', 'sortorder')); + + if ($dbman->index_exists($table, $index)) { + $dbman->drop_index($table, $index); + } + upgrade_main_savepoint(true, 2011070101.04); + } + + return true; } diff --git a/version.php b/version.php index b49b374b518..99b4434bc9a 100644 --- a/version.php +++ b/version.php @@ -31,7 +31,7 @@ defined('MOODLE_INTERNAL') || die(); -$version = 2011070101.03; // 20110701 = branching date YYYYMMDD - do not modify! +$version = 2011070101.04; // 20110701 = branching date YYYYMMDD - do not modify! // RR = release version - do not change in weeklies // .XX = incremental changes -- 2.11.4.GIT