1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
<?php // $Id: mysql.php,v 1.7 2006/04/24 08:28:21 vyshane Exp $
function label_upgrade($oldversion) {
/// This function does anything necessary to upgrade
/// older versions to match current functionality
global $CFG;
if ($oldversion < 2003091400) {
table_column("label", "", "course", "integer", "10", "unsigned", "0", "not null", "id");
}
if ($oldversion < 2004021900) {
modify_database("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('label', 'add', 'quiz', 'name');");
modify_database("", "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('label', 'update', 'quiz', 'name');");
}
if ($oldversion < 2004111200) { //DROP first
execute_sql("ALTER TABLE {$CFG->prefix}label DROP INDEX course;",false);
modify_database('','ALTER TABLE prefix_label ADD INDEX course (course);');
}
return true;
}
?>
|
