From 5352ceba679db649adf80773dcc7306b1c0fe455 Mon Sep 17 00:00:00 2001 From: paca70 Date: Sun, 27 Apr 2003 15:33:31 +0000 Subject: [PATCH] quiz_match was missing... --- mod/quiz/db/postgres7.php | 11 +++++++++-- mod/quiz/version.php | 2 +- 2 files changed, 10 insertions(+), 3 deletions(-) diff --git a/mod/quiz/db/postgres7.php b/mod/quiz/db/postgres7.php index 39a9970f4b..28cfa041d2 100644 --- a/mod/quiz/db/postgres7.php +++ b/mod/quiz/db/postgres7.php @@ -48,10 +48,17 @@ function quiz_upgrade($oldversion) { } if ($oldversion < 2003040901) { - table_column("quiz", "", "shufflequestions", "INTEGER", "4", "UNSIGNED", "0", "NOT NULL", "review"); + table_column("quiz", "", "shufflequestions", "INTEGER", "5", "UNSIGNED", "0", "NOT NULL", "review"); table_column("quiz", "", "shuffleanswers", "INTEGER", "4", "UNSIGNED", "0", "NOT NULL", "shufflequestions"); } - + if ($oldversion < 2003042702) { + modify_database ("", "CREATE TABLE prefix_quiz_match ( + id SERIAL PRIMARY KEY, + question integer NOT NULL default '0', + subquestions varchar(255) NOT NULL default '' + );"); + modify_database ("", "CREATE INDEX question ON prefix_quiz_match (question);"); + } return true; } diff --git a/mod/quiz/version.php b/mod/quiz/version.php index 9283b57bd6..50d0821f0e 100644 --- a/mod/quiz/version.php +++ b/mod/quiz/version.php @@ -5,7 +5,7 @@ // This fragment is called by moodle_needs_upgrading() and /admin/index.php //////////////////////////////////////////////////////////////////////////////// -$module->version = 2003040901; // The (date) version of this module +$module->version = 2003042702; // The (date) version of this module $module->cron = 0; // How often should cron check this module (seconds)? ?> -- 2.39.5