<DBMIGRATION type="mod/data" VERSION="2005120100">
  <TABLES>
    <TABLE name="data_ratings" />
    <TABLE name="data_records" />
    <TABLE name="data_comments">
      <FIELDS>
        <FIELD name="content" method="NO_CONV" type="text" length="0" />
      </FIELDS>
    </TABLE>
    <TABLE name="data_content">
      <FIELDS>
        <FIELD name="content" 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="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">
      <FIELDS>
        <FIELD name="type" method="NO_CONV" type="varchar" length="255" />
        <FIELD name="name" method="PHP_FUNCTION" type="varchar" length="255">
          <PHP_FUNCTION>
            migrate2utf_data_fields_name(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="description" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
            migrate2utf_data_fields_description(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="param1" method="NO_CONV" type="text" length="0" />
        <FIELD name="param2" method="NO_CONV" type="text" length="0" />
        <FIELD name="param3" method="NO_CONV" type="text" length="0" />
        <FIELD name="param4" method="NO_CONV" type="text" length="0" />
        <FIELD name="param5" method="NO_CONV" type="text" length="0" />
        <FIELD name="param6" method="NO_CONV" type="text" length="0" />
        <FIELD name="param7" method="NO_CONV" type="text" length="0" />
        <FIELD name="param8" method="NO_CONV" type="text" length="0" />
        <FIELD name="param9" method="NO_CONV" type="text" length="0" />
        <FIELD name="param10" method="NO_CONV" type="text" length="0" />
      </FIELDS>
    </TABLE>
    <TABLE name="data">
      <FIELDS>
        <FIELD name="name" method="PHP_FUNCTION" type="varchar" length="255">
          <PHP_FUNCTION>
           migrate2utf_data_name(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="intro" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_intro(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="singletemplate" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_singletemplate(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="listtemplate" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_listtemplate(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="csstemplate" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_csstemplate(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="addtemplate" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_addtemplate(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="rsstemplate" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_rsstemplate(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="rsstitletemplate" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_rsstitletemplate(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="listtemplateheader" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_listtemplateheader(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
        <FIELD name="listtemplatefooter" method="PHP_FUNCTION" type="text" length="0">
          <PHP_FUNCTION>
           migrate2utf_data_listtemplatefooter(RECORDID)
          </PHP_FUNCTION>
        </FIELD>
      </FIELDS>
    </TABLE>
  </TABLES>
</DBMIGRATION>
