mod/label/db/postgres7.php

   1 <?php
   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 label_upgrade($oldversion) {
   9
  10 /// This function does anything necessary to upgrade
  11
  12 /// older versions to match current functionality
  13
  14
  15
  16     global $CFG;
  17
  18
  19
  20     if ($oldversion < 2003091400) {
  21
  22         table_column("label", "", "course", "integer", "10", "unsigned", "0", "not null", "id");
  23
  24     }
  25
  26
  27
  28     if ($oldversion < 2004021900) {
  29
  30         modify_database("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('label', 'add', 'quiz', 'name');");
  31
  32         modify_database("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('label', 'update', 'quiz', 'name');");
  33
  34     }
  35
  36     if ($oldversion < 2004111200) { //DROP first
  37         execute_sql("DROP INDEX {$CFG->prefix}label_course_idx;",false);
  38
  39         modify_database('','CREATE INDEX prefix_label_course_idx ON prefix_label (course);');
  40     }
  41
  42     //////  DO NOT ADD NEW THINGS HERE!!  USE upgrade.php and the lib/ddllib.php functions.
  43
  44     return true;
  45
  46 }
  47
  48
  49 ?>