From 90ccfd190fd9b7a77b2166313296b570ea178a15 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Sun, 30 Jan 2005 10:05:36 +0000
Subject: [PATCH] Added one missing key too.

---
 lib/db/mysql.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index c42ff5d3fd..85609e1399 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -536,7 +536,8 @@ CREATE TABLE `prefix_user_teachers` (
   PRIMARY KEY  (`id`),
   UNIQUE KEY `id` (`id`),
   UNIQUE KEY `courseuserid` (course,userid),
-  KEY `userid` (userid)
+  KEY `userid` (userid),
+  KEY `enrol` (enrol)
 ) TYPE=MyISAM COMMENT='One record per teacher per course';
 
 #
-- 
2.39.5