<INDEX NAME="uuid" UNIQUE="false" FIELDS="uuid"/>
<INDEX NAME="type-timesort" UNIQUE="false" FIELDS="type, timesort"/>
<INDEX NAME="groupid-courseid-categoryid-visible-userid" UNIQUE="false" FIELDS="groupid, courseid, categoryid, visible, userid" COMMENT="used for calendar view"/>
+ <INDEX NAME="eventtype" UNIQUE="false" FIELDS="eventtype"/>
+ <INDEX NAME="modulename-instance" UNIQUE="false" FIELDS="modulename, instance"/>
</INDEXES>
</TABLE>
<TABLE NAME="cache_filters" COMMENT="For keeping information about cached data">
upgrade_main_savepoint(true, 2019122000.01);
}
+ if ($oldversion < 2020010900.02) {
+ $table = new xmldb_table('event');
+
+ // This index will improve the performance when the Events API retrieves category and group events.
+ $index = new xmldb_index('eventtype', XMLDB_INDEX_NOTUNIQUE, ['eventtype']);
+ if (!$dbman->index_exists($table, $index)) {
+ $dbman->add_index($table, $index);
+ }
+
+ // This index improves the performance of backups, deletion and visibilty changes on activities.
+ $index = new xmldb_index('modulename-instance', XMLDB_INDEX_NOTUNIQUE, ['modulename', 'instance']);
+ if (!$dbman->index_exists($table, $index)) {
+ $dbman->add_index($table, $index);
+ }
+
+ upgrade_main_savepoint(true, 2020010900.02);
+ }
return true;
}
defined('MOODLE_INTERNAL') || die();
-$version = 2020010900.00; // YYYYMMDD = weekly release date of this DEV branch.
+$version = 2020010900.01; // YYYYMMDD = weekly release date of this DEV branch.
// RR = release increments - 00 in DEV branches.
// .XX = incremental changes.
$release = '3.9dev (Build: 20200109)'; // Human-friendly version name