From 5e227395d4df6ae1042b7c9602c74aa2f88449fe Mon Sep 17 00:00:00 2001 From: martinlanghoff Date: Wed, 28 Feb 2007 00:29:24 +0000 Subject: [PATCH] hotpot: Fixing db upgrade script Note MySQL upgrade (earlier on by version) Author: Andrew Walbran --- mod/hotpot/db/update_to_v2.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/mod/hotpot/db/update_to_v2.php b/mod/hotpot/db/update_to_v2.php index 4b8441eb21..df66623623 100644 --- a/mod/hotpot/db/update_to_v2.php +++ b/mod/hotpot/db/update_to_v2.php @@ -61,6 +61,7 @@ function hotpot_update_to_v2_1_21() { // ensure setting of default values on certain fields // this was originally done in postgres7.php, but was found to be incompatible with PG7 :-( $table="hotpot"; + execute_sql("UPDATE {$CFG->prefix}$table SET studentfeedbackurl = '' WHERE studentfeedbackurl IS NULL"); $ok = $ok && hotpot_db_update_field_type($table, '', 'studentfeedbackurl', 'VARCHAR', 255, '', 'NOT NULL', ''); $ok = $ok && hotpot_db_update_field_type($table, '', 'studentfeedback', 'INTEGER', 4, 'UNSIGNED', 'NOT NULL', 0); $ok = $ok && hotpot_db_update_field_type($table, '', 'clickreporting', 'INTEGER', 4, 'UNSIGNED', 'NOT NULL', 0); @@ -77,7 +78,9 @@ function hotpot_update_to_v2_1_21() { $ok = $ok && hotpot_db_update_field_type($table, '', 'score', 'INTEGER', 4, 'UNSIGNED', 'NOT NULL', 0); $ok = $ok && hotpot_db_update_field_type($table, '', 'weighting', 'INTEGER', 4, 'UNSIGNED', 'NOT NULL', 0); $ok = $ok && hotpot_db_update_field_type($table, '', 'correct', 'VARCHAR', 255, '', 'NOT NULL', ''); + execute_sql("UPDATE {$CFG->prefix}$table SET wrong = '' WHERE wrong IS NULL"); $ok = $ok && hotpot_db_update_field_type($table, '', 'wrong', 'VARCHAR', 255, '', 'NOT NULL', ''); + execute_sql("UPDATE {$CFG->prefix}$table SET ignored = '' WHERE ignored IS NULL"); $ok = $ok && hotpot_db_update_field_type($table, '', 'ignored', 'VARCHAR', 255, '', 'NOT NULL', ''); $ok = $ok && hotpot_db_update_field_type($table, '', 'hints', 'INTEGER', 4, 'UNSIGNED', 'NOT NULL', 0); $ok = $ok && hotpot_db_update_field_type($table, '', 'clues', 'INTEGER', 4, 'UNSIGNED', 'NOT NULL', 0); -- 2.39.5