From 25dbd2ff6475a190313996922f52c67213161017 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Mon, 10 Apr 2006 05:03:38 +0000
Subject: [PATCH] convertion to unicode data_content -> content(1 to 4)

---
 mod/data/db/migrate2utf8.xml | 72 ++++++++++++++++++++++++++++++++++++
 1 file changed, 72 insertions(+)

diff --git a/mod/data/db/migrate2utf8.xml b/mod/data/db/migrate2utf8.xml
index 24d7134274..832b40837a 100755
--- a/mod/data/db/migrate2utf8.xml
+++ b/mod/data/db/migrate2utf8.xml
@@ -27,6 +27,78 @@
                  AND dc.id = RECORDID
           </SQL_DETECT_COURSE>
         </FIELD>
+        <FIELD name="content1" method="PLAIN_SQL_UPDATE" type="longtext" length="0">
+          <SQL_DETECT_USER>
+           SELECT dr.userid
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data_content dc
+           WHERE dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_USER>
+          <SQL_DETECT_COURSE>
+           SELECT d.course
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data d,
+                {$CFG->prefix}data_content dc
+           WHERE d.id = dr.dataid
+                 AND dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_COURSE>
+        </FIELD>
+        <FIELD name="content2" method="PLAIN_SQL_UPDATE" type="longtext" length="0">
+          <SQL_DETECT_USER>
+           SELECT dr.userid
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data_content dc
+           WHERE dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_USER>
+          <SQL_DETECT_COURSE>
+           SELECT d.course
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data d,
+                {$CFG->prefix}data_content dc
+           WHERE d.id = dr.dataid
+                 AND dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_COURSE>
+        </FIELD>
+        <FIELD name="content3" method="PLAIN_SQL_UPDATE" type="longtext" length="0">
+          <SQL_DETECT_USER>
+           SELECT dr.userid
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data_content dc
+           WHERE dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_USER>
+          <SQL_DETECT_COURSE>
+           SELECT d.course
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data d,
+                {$CFG->prefix}data_content dc
+           WHERE d.id = dr.dataid
+                 AND dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_COURSE>
+        </FIELD>
+        <FIELD name="content4" method="PLAIN_SQL_UPDATE" type="longtext" length="0">
+          <SQL_DETECT_USER>
+           SELECT dr.userid
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data_content dc
+           WHERE dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_USER>
+          <SQL_DETECT_COURSE>
+           SELECT d.course
+           FROM {$CFG->prefix}data_records dr,
+                {$CFG->prefix}data d,
+                {$CFG->prefix}data_content dc
+           WHERE d.id = dr.dataid
+                 AND dr.id = dc.recordid
+                 AND dc.id = RECORDID
+          </SQL_DETECT_COURSE>
+        </FIELD>
       </FIELDS>
     </TABLE>
     <TABLE name="data_fields">
-- 
2.39.5