From cfa7cdb958f849e12930d061c8ac335cae651540 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Thu, 5 Oct 2006 06:05:02 +0000
Subject: [PATCH] droppinf utf8 support for user_* tables

---
 lib/db/migrate2utf8.xml | 24 ------------------------
 1 file changed, 24 deletions(-)

diff --git a/lib/db/migrate2utf8.xml b/lib/db/migrate2utf8.xml
index 5971f21f58..ee08b15d21 100755
--- a/lib/db/migrate2utf8.xml
+++ b/lib/db/migrate2utf8.xml
@@ -349,28 +349,6 @@
         <FIELD name="std_time" method="NO_CONV" type="varchar" length="5" />
       </FIELDS>
     </TABLE>
-    <TABLE name="user_students">
-      <FIELDS>
-        <FIELD name="enrol" method="NO_CONV" type="varchar" length="20" dropindex="enrol" addindex="enrol(enrol(20))"/>
-      </FIELDS>
-    </TABLE>
-    <TABLE name="user_teachers">
-      <FIELDS>
-        <FIELD name="role" method="PLAIN_SQL_UPDATE" type="varchar" length="40">
-          <SQL_DETECT_USER>
-            SELECT ut.userid
-            FROM {$CFG->prefix}user_teachers ut
-            WHERE ut.id = RECORDID
-          </SQL_DETECT_USER>
-          <SQL_DETECT_COURSE>
-            SELECT ut.course
-            FROM {$CFG->prefix}user_teachers ut
-            WHERE ut.id = RECORDID
-          </SQL_DETECT_COURSE>
-        </FIELD>
-        <FIELD name="enrol" method="NO_CONV" type="varchar" length="20" dropindex="enrol" addindex="enrol(enrol(20))"/>
-      </FIELDS>
-    </TABLE>
     <TABLE name="stats_daily" />
     <TABLE name="stats_weekly" />
     <TABLE name="stats_monthly" />
@@ -395,8 +373,6 @@
         <FIELD name="value" method="NO_CONV" type="varchar" length="255" />
       </FIELDS>
     </TABLE>
-    <TABLE name="user_admins" />
-    <TABLE name="user_coursecreators" />
     <TABLE name="course">
       <FIELDS>
         <FIELD name="currency" method="NO_CONV" type="char" length="3" />
-- 
2.39.5