From 54f03faba2543502c82d5a8aa1a248d391f1869d Mon Sep 17 00:00:00 2001 From: Mike Churchward Date: Wed, 17 Apr 2013 10:18:55 -0400 Subject: [PATCH] MDL-34933 core_message: Adding index to improve database access on message_working table. --- lib/db/install.xml | 3 +++ lib/db/upgrade.php | 14 ++++++++++++++ version.php | 2 +- 3 files changed, 18 insertions(+), 1 deletion(-) diff --git a/lib/db/install.xml b/lib/db/install.xml index 22835b232a0..1fc7e86280e 100644 --- a/lib/db/install.xml +++ b/lib/db/install.xml @@ -2328,6 +2328,9 @@ + + + diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php index 6233a521b82..48bf758e1dc 100644 --- a/lib/db/upgrade.php +++ b/lib/db/upgrade.php @@ -1142,5 +1142,19 @@ function xmldb_main_upgrade($oldversion) { upgrade_main_savepoint(true, 2012062506.02); } + if ($oldversion < 2012062506.06) { + // Adding index to unreadmessageid field of message_working table (MDL-34933) + $table = new xmldb_table('message_working'); + $index = new xmldb_index('unreadmessageid_idx', XMLDB_INDEX_NOTUNIQUE, array('unreadmessageid')); + + // Conditionally launch add index unreadmessageid + if (!$dbman->index_exists($table, $index)) { + $dbman->add_index($table, $index); + } + + // Main savepoint reached. + upgrade_main_savepoint(true, 2012062506.06); + } + return true; } diff --git a/version.php b/version.php index 9f8242f86d5..7a312466ea4 100644 --- a/version.php +++ b/version.php @@ -30,7 +30,7 @@ defined('MOODLE_INTERNAL') || die(); -$version = 2012062506.05; // YYYYMMDD = weekly release date of this DEV branch +$version = 2012062506.06; // YYYYMMDD = weekly release date of this DEV branch // RR = release increments - 00 in DEV branches // .XX = incremental changes -- 2.43.0