mod/choice/db/mysql.php

   1 <?php // $Id$
   2
   3 // THIS FILE IS DEPRECATED!  PLEASE DO NOT MAKE CHANGES TO IT!
   4 //
   5 // IT IS USED ONLY FOR UPGRADES FROM BEFORE MOODLE 1.7, ALL
   6 // LATER CHANGES SHOULD USE upgrade.php IN THIS DIRECTORY.
   7
   8 function choice_upgrade($oldversion) {
   9
  10     global $CFG;
  11
  12 // This function does anything necessary to upgrade
  13 // older versions to match current functionality
  14
  15     if ($oldversion < 2002090800) {
  16         execute_sql(" ALTER TABLE `choice` CHANGE `answer1` `answer1` VARCHAR( 255 )");
  17         execute_sql(" ALTER TABLE `choice` CHANGE `answer2` `answer2` VARCHAR( 255 )");
  18     }
  19     if ($oldversion < 2002102400) {
  20         execute_sql(" ALTER TABLE `choice` ADD `answer3` varchar(255) NOT NULL AFTER `answer2`");
  21         execute_sql(" ALTER TABLE `choice` ADD `answer4` varchar(255) NOT NULL AFTER `answer3`");
  22         execute_sql(" ALTER TABLE `choice` ADD `answer5` varchar(255) NOT NULL AFTER `answer4`");
  23         execute_sql(" ALTER TABLE `choice` ADD `answer6` varchar(255) NOT NULL AFTER `answer5`");
  24     }
  25     if ($oldversion < 2002122300) {
  26         execute_sql("ALTER TABLE `choice_answers` CHANGE `user` `userid` INT(10) UNSIGNED DEFAULT '0' NOT NULL ");
  27     }
  28     if ($oldversion < 2003010100) {
  29         execute_sql(" ALTER TABLE `choice` ADD `format` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `text` ");
  30         execute_sql(" ALTER TABLE `choice` ADD `publish` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `answer6` ");
  31     }
  32
  33     if ($oldversion < 2004010100) {
  34         table_column("choice", "", "showunanswered", "integer", "4", "unsigned", "0", "", "publish");
  35     }
  36     if ($oldversion < 2004021700) {
  37         modify_database("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('choice', 'choose', 'choice', 'name');");
  38         modify_database("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('choice', 'choose again', 'choice', 'name');");
  39     }
  40     if ($oldversion < 2004070100) {
  41         table_column("choice", "", "timeclose", "integer", "10", "unsigned", "0", "", "showunanswered");
  42         table_column("choice", "", "timeopen", "integer", "10", "unsigned", "0", "", "showunanswered");
  43     }
  44     if ($oldversion < 2004070101) {
  45         table_column("choice", "", "release", "integer", "2", "unsigned", "0", "", "publish");
  46         table_column("choice", "", "allowupdate", "integer", "2", "unsigned", "0", "", "release");
  47     }
  48     if ($oldversion < 2004070102) {
  49         modify_database("", "UPDATE prefix_choice SET allowupdate = '1' WHERE publish = 0;");
  50         modify_database("", "UPDATE prefix_choice SET release = '1' WHERE publish > 0;");
  51         modify_database("", "UPDATE prefix_choice SET publish = publish - 1 WHERE publish > 0;");
  52     }
  53
  54     if ($oldversion < 2004111200){  // drop first to avoid conflicts when upgrading from 1.4+
  55         execute_sql("ALTER TABLE {$CFG->prefix}choice DROP INDEX course;",false);
  56         execute_sql("ALTER TABLE {$CFG->prefix}choice_answers DROP INDEX choice;",false);
  57         execute_sql("ALTER TABLE {$CFG->prefix}choice_answers DROP INDEX userid;",false);
  58
  59         modify_database('','ALTER TABLE prefix_choice ADD INDEX course (course);');
  60         modify_database('','ALTER TABLE prefix_choice_answers ADD INDEX choice (choice);');
  61         modify_database('','ALTER TABLE prefix_choice_answers ADD INDEX userid (userid);');
  62     }
  63
  64     if ($oldversion < 2005033001){
  65         if (execute_sql("CREATE TABLE {$CFG->prefix}choice_options (
  66                              `id` int(10) unsigned NOT NULL auto_increment,
  67                              `choiceid` int(10) unsigned NOT NULL default '0',
  68                              `text` TEXT,
  69                              `timemodified` int(10) NOT NULL default '0',
  70                              PRIMARY KEY  (id),
  71                              UNIQUE KEY id (id),
  72                              KEY choiceid (choiceid)
  73                          ) TYPE=MyISAM;")) {
  74
  75             table_column('choice_answers', 'choice', 'choiceid', 'integer', '10', 'unsigned', 0, 'not null');
  76             table_column('choice_answers', 'answer', 'optionid', 'integer', '10', 'unsigned', 0, 'not null');
  77
  78             table_column('choice', '', 'display', 'integer', '4', 'unsigned', 0, 'not null', 'release');
  79
  80
  81             /// move old answers from choice to choice_options
  82
  83             if ($choices = get_records('choice')) {
  84                 foreach ($choices as $choice) {
  85                     for ($i=1; $i<=6; $i++) {      // We used to have six columns
  86                         $option = new stdClass;
  87                         $option->text         = addslashes($choice->{'answer'.$i});
  88                         if ($option->text) {   /// Don't bother with blank options
  89                             $option->choiceid     = $choice->id;
  90                             $option->timemodified = $choice->timemodified;
  91                             if ($option->id = insert_record('choice_options', $option)) {
  92                                 /// Update all the user answers to fit the new value
  93                                 execute_sql("UPDATE {$CFG->prefix}choice_answers
  94                                                 SET optionid='$option->id'
  95                                               WHERE choiceid='$choice->id'
  96                                                 AND optionid='$i'");
  97                             }
  98                         }
  99                     }
 100                 }
 101             }
 102
 103             //drop old fields
 104
 105             modify_database('','ALTER TABLE prefix_choice DROP `answer1`;');
 106             modify_database('','ALTER TABLE prefix_choice DROP `answer2`;');
 107             modify_database('','ALTER TABLE prefix_choice DROP `answer3`;');
 108             modify_database('','ALTER TABLE prefix_choice DROP `answer4`;');
 109             modify_database('','ALTER TABLE prefix_choice DROP `answer5`;');
 110             modify_database('','ALTER TABLE prefix_choice DROP `answer6`;');
 111
 112         } else {
 113             notify('SERIOUS PROBLEM OCCURRED WHILE UPGRADING A TABLE - you may have to manually upgrade your tables ... see mod/choice/db/mysql.php');
 114             return false;
 115         }
 116     }
 117
 118     if ($oldversion < 2005041100) { // replace wiki-like with markdown
 119         include_once( "$CFG->dirroot/lib/wiki_to_markdown.php" );
 120         $wtm = new WikiToMarkdown();
 121         $wtm->update( 'choice','text','format' );
 122     }
 123     if ($oldversion < 2005041500) { //new limit feature
 124         table_column('choice', '', 'limitanswers', 'TINYINT', '2', 'unsigned', 0, 'not null', 'showunanswered');
 125         table_column('choice_options', '', 'maxanswers', 'INTEGER', '10', 'unsigned', 0, 'null', 'text');
 126     }
 127     if ($oldversion < 2006020900) { //rename release column to showanswers - Release is now reserved word in mySql
 128         table_column('choice', '`release`', 'showresults', 'TINYINT', '2', 'unsigned', 0, 'not null');
 129     }
 130
 131     //////  DO NOT ADD NEW THINGS HERE!!  USE upgrade.php and the lib/ddllib.php functions.
 132
 133     return true;
 134 }
 135
 136
 137 ?>