projects / moodle.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f61ee4e) | patch
MDL-62621 comments: Add missing indexes on comments table
authorDavid Mudrák <david@moodle.com>
Mon, 18 Jun 2018 14:53:03 +0000 (16:53 +0200)
committerDavid Mudrák <david@moodle.com>
Mon, 2 Jul 2018 08:04:26 +0000 (10:04 +0200)
commit82b7ad70b1772e3f57d25ca6db3810794b6bc455
tree131749790fa569a732125a310c6adf435d31ee4dtree | snapshot
parentf61ee4e857a894a5b8b69516b00be88ae499964bcommit | diff
MDL-62621 comments: Add missing indexes on comments table

The composite index over the fields contextid, commentarea and itemid
helps the comments API to load all comments for the given area
effectively.

The index over the userid field helps the privacy API to load all
comments by the given user.
lib/db/install.xml diff | blob | blame | history
lib/db/upgrade.php diff | blob | blame | history
version.php diff | blob | blame | history
Moodle official production repository