From f3c9e7f9c347d64eb928b6d7922d446cfa28eba0 Mon Sep 17 00:00:00 2001 From: mjollnir_ Date: Wed, 24 Nov 2004 19:00:24 +0000 Subject: [PATCH] Merged from MOODLE_14_STABLE: Fixing typo in mysql.sql for unique key for user_teachers on course userid --- lib/db/mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql index b511c12d98..f0cefade03 100644 --- a/lib/db/mysql.sql +++ b/lib/db/mysql.sql @@ -455,7 +455,7 @@ CREATE TABLE `prefix_user_teachers` ( `timeaccess` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), - KEY UNIQUE `courseuserid` (course,userid), + UNIQUE KEY `courseuserid` (course,userid), KEY `userid` (userid) ) TYPE=MyISAM COMMENT='One record per teacher per course'; -- 2.39.5