From 362d9c0e7e1152e9cee62877599c7298e0fc9938 Mon Sep 17 00:00:00 2001 From: mjollnir_ Date: Thu, 18 Nov 2004 02:35:42 +0000 Subject: [PATCH] Replaced prefix_ with CFG->prefix for DROP of indexes before creation because of being inside execute_sql rather than modify_database - attendance module --- mod/attendance/db/mysql.php | 6 +++--- mod/attendance/db/postgres7.php | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/mod/attendance/db/mysql.php b/mod/attendance/db/mysql.php index 1feaea73e6..78426223f5 100644 --- a/mod/attendance/db/mysql.php +++ b/mod/attendance/db/mysql.php @@ -41,9 +41,9 @@ function attendance_upgrade($oldversion) { } if ($oldversion < 2004111200) { - execute_sql('ALTER TABLE prefix_attendance DROP INDEX course;',false); - execute_sql('ALTER TABLE prefix_attendance_roll DROP INDEX dayid;',false); - execute_sql('ALTER TABLE prefix_attendance_roll DROP INDEX userid;',false); + execute_sql("ALTER TABLE {$CFG->prefix}attendance DROP INDEX course;",false); + execute_sql("ALTER TABLE {$CFG->prefix}attendance_roll DROP INDEX dayid;",false); + execute_sql("ALTER TABLE {$CFG->prefix}attendance_roll DROP INDEX userid;",false); modify_database('','ALTER TABLE prefix_attendance ADD INDEX course (course);'); modify_database('','ALTER TABLE prefix_attendance_roll ADD INDEX dayid (dayid);'); diff --git a/mod/attendance/db/postgres7.php b/mod/attendance/db/postgres7.php index dcecd28cea..b518d872c2 100644 --- a/mod/attendance/db/postgres7.php +++ b/mod/attendance/db/postgres7.php @@ -31,9 +31,9 @@ function attendance_upgrade($oldversion) { if ($oldversion < 2004111200) { - execute_sql('DROP INDEX prefix_attendance_course_idx;',false); - execute_sql('DROP INDEX prefix_attendance_roll_dayid_idx;',false); - execute_sql('DROP INDEX prefix_attendance_roll_userid_idx;',false); + execute_sql("DROP INDEX {$CFG->prefix}attendance_course_idx;",false); + execute_sql("DROP INDEX {$CFG->prefix}attendance_roll_dayid_idx;",false); + execute_sql("DROP INDEX {$CFG->prefix}attendance_roll_userid_idx;",false); modify_database('','CREATE INDEX prefix_attendance_course_idx ON prefix_attendance (course);'); modify_database('','CREATE INDEX prefix_attendance_roll_dayid_idx ON prefix_attendance_roll (dayid);'); -- 2.39.5