From 65070e3c0317d37d6ea6971d9659d93900a056ca Mon Sep 17 00:00:00 2001 From: mjollnir_ Date: Sun, 12 Mar 2006 23:19:17 +0000 Subject: [PATCH] Adding new mdl_log indexes to the .sql files as well as just the pg ones (bug #4112) --- lib/db/mysql.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql index 2ac4784f19..131b84ddf2 100644 --- a/lib/db/mysql.sql +++ b/lib/db/mysql.sql @@ -420,7 +420,9 @@ CREATE TABLE `prefix_log` ( PRIMARY KEY (`id`), KEY `timecoursemoduleaction` (time,course,module,action), KEY `coursemoduleaction` (course,module,action), - KEY `courseuserid` (course,userid) + KEY `courseuserid` (course,userid), + KEY `userid` (userid), + KEY `info` (info) ) TYPE=MyISAM COMMENT='Every action is logged as far as possible.'; # -------------------------------------------------------- -- 2.39.5