question/type/multichoice/db/upgrade.php

   1 <?php  //$Id$
   2
   3 // This file keeps track of upgrades to
   4 // the multichoice qtype plugin
   5 //
   6 // Sometimes, changes between versions involve
   7 // alterations to database structures and other
   8 // major things that may break installations.
   9 //
  10 // The upgrade function in this file will attempt
  11 // to perform all the necessary actions to upgrade
  12 // your older installtion to the current version.
  13 //
  14 // If there's something it cannot do itself, it
  15 // will tell you what you need to do.
  16 //
  17 // The commands in here will all be database-neutral,
  18 // using the functions defined in lib/ddllib.php
  19
  20 function xmldb_qtype_multichoice_upgrade($oldversion=0) {
  21
  22     global $CFG, $THEME, $db;
  23
  24     $result = true;
  25
  26     // This upgrade actually belongs to the description question type,
  27     // but that does not have a DB upgrade script. Therefore, multichoice
  28     // is doing it.
  29     // The need for this is that for a while, descriptions were being created
  30     // with a defaultgrade of 1, when it shoud be 0. We need to reset them all to 0.
  31     // See MDL-7925.
  32     if ($result && $oldversion < 2006121500) {
  33         $result = $result && set_field('question', 'defaultgrade', 0,
  34                 'qtype', DESCRIPTION, 'defaultgrade', 1);
  35     }
  36
  37     // Add a field so that question authors can choose whether and how the Choices are numbered.
  38     // Subsequently changed to not create an enum constraint, because it was causing problems -
  39     // See 2007081700 update.
  40     if ($result && $oldversion < 2007041300) {
  41         $table = new XMLDBTable('question_multichoice');
  42         $field = new XMLDBField('answernumbering');
  43         $field->setAttributes(XMLDB_TYPE_CHAR, '10', null, XMLDB_NOTNULL, null, null, null, 'abc', 'incorrectfeedback');
  44         $result = $result && add_field($table, $field);
  45     }
  46
  47     // This upgrade actually belongs to the description question type,
  48     // but that does not have a DB upgrade script. Therefore, multichoice
  49     // is doing it.
  50     // The need for this is that for a while, descriptions were being created
  51     // with a defaultgrade of 1, when it shoud be 0. We need to reset them all to 0.
  52     // This is re-occurrence of MDL-7925, so we need to do it again.
  53     if ($result && $oldversion < 2007072000) {
  54         $result = $result && set_field('question', 'defaultgrade', 0,
  55                 'qtype', DESCRIPTION, 'defaultgrade', 1);
  56     }
  57
  58     // Drop enum constraint on 'answernumbering' column, and change ABC to ABCD becuase MySQL
  59     // sometimes can't cope with things that differ only by case.
  60     if ($result && $oldversion < 2007081700) {
  61         if ($result && $oldversion >= 2007041300) {
  62             $table = new XMLDBTable('question_multichoice');
  63             $field = new XMLDBField('answernumbering');
  64             $field->setAttributes(XMLDB_TYPE_CHAR, '10', null, XMLDB_NOTNULL, null, null, null, 'abc', 'incorrectfeedback');
  65             $result = $result && change_field_enum($table, $field);
  66         }
  67         $result = $result && set_field('question_multichoice', 'answernumbering', 'ABCD', 'answernumbering', 'ABC');
  68     }
  69
  70     return $result;
  71 }
  72
  73 ?>