From 5712bf7b91964e6dbbd2afdead94bb3dd8c0030a Mon Sep 17 00:00:00 2001
From: Jean-Michel Vedrine <vedrine@vedrine.org>
Date: Fri, 4 Jan 2013 14:24:55 +0100
Subject: Ability to use Mathjax for TeX rendering

---
 db/install.xml |  8 +++---
 db/upgrade.php | 79 ++++++++++++++++++++++++++++++++++------------------------
 2 files changed, 51 insertions(+), 36 deletions(-)

(limited to 'db')

diff --git a/db/install.xml b/db/install.xml
index 8bcfd32..1927ae2 100644
--- a/db/install.xml
+++ b/db/install.xml
@@ -1,7 +1,9 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="question/type/symbollic/db" VERSION="20080516" COMMENT="XMLDB file for Moodle question/type/algebra">
+<XMLDB PATH="question/type/algebra/db" VERSION="20080516" COMMENT="XMLDB file for Moodle question/type/algebra question type"
+    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xsi:noNamespaceSchemaLocation="../../../../lib/xmldb/xmldb.xsd"
   <TABLES>
-    <TABLE NAME="question_algebra" COMMENT="Options for algebra questions" NEXT="question_algebra_variables">
+    <TABLE NAME="qtype_algebra" COMMENT="Options for algebra questions" NEXT="qtype_algebra_variables">
       <FIELDS>
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true" NEXT="questionid"/>
         <FIELD NAME="questionid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="id" NEXT="compareby"/>
@@ -17,7 +19,7 @@
         <KEY NAME="questionid" TYPE="foreign" FIELDS="questionid" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
       </KEYS>
     </TABLE>
-    <TABLE NAME="question_algebra_variables" COMMENT="Variables for algebra questions" PREVIOUS="question_algebra">
+    <TABLE NAME="qtype_algebra_variables" COMMENT="Variables for algebra questions" PREVIOUS="qtype_algebra">
       <FIELDS>
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true" NEXT="question"/>
         <FIELD NAME="question" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" PREVIOUS="id" NEXT="name"/>
diff --git a/db/upgrade.php b/db/upgrade.php
index 371150b..ed8c060 100644
--- a/db/upgrade.php
+++ b/db/upgrade.php
@@ -1,59 +1,72 @@
-<?php  // $Id: upgrade.php,v 1.1 2008/07/24 01:48:12 arborrow Exp $
-
-// This file keeps track of upgrades to 
-// the algebra qtype plugin
-//
-// Sometimes, changes between versions involve
-// alterations to database structures and other
-// major things that may break installations.
+<?php
+// This file is part of Moodle - http://moodle.org/
 //
-// The upgrade function in this file will attempt
-// to perform all the necessary actions to upgrade
-// your older installtion to the current version.
+// Moodle is free software: you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation, either version 3 of the License, or
+// (at your option) any later version.
 //
-// If there's something it cannot do itself, it
-// will tell you what you need to do.
+// Moodle is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+// GNU General Public License for more details.
 //
-// The commands in here will all be database-neutral,
-// using the functions defined in lib/ddllib.php
+// You should have received a copy of the GNU General Public License
+// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
 
+/**
+ * Algebra question type upgrade code.
+ *
+ * @package    qtype_algebra
+ * @copyright  Roger Moore
+ * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
+ */
 function xmldb_qtype_algebra_upgrade($oldversion=0) {
 
     global $CFG, $THEME, $DB;
-	
-	$dbman = $DB->get_manager();
 
-/// And upgrade begins here. For each one, you'll need one 
-/// block of code similar to the next one. Please, delete 
-/// this comment lines once this file start handling proper
-/// upgrade code.
+    $dbman = $DB->get_manager();
 
     // Add the field to store the string which is placed in front of the answer
-    // box when the question is displayed
+    // box when the question is displayed.
     if ($oldversion < 2008061500) {
         $table = new xmldb_table('question_algebra');
         $field = new xmldb_field('answerprefix', XMLDB_TYPE_TEXT, 'small', null, XMLDB_NOTNULL, null, '', 'allowedfuncs');
-		if (!$dbman->field_exists($table, $field)) {
-			$dbman->add_field($table, $field);
-		}
-		upgrade_plugin_savepoint(true, 2008061500, 'qtype', 'algebra');
+        if (!$dbman->field_exists($table, $field)) {
+            $dbman->add_field($table, $field);
+        }
+        upgrade_plugin_savepoint(true, 2008061500, 'qtype', 'algebra');
     }
 
-    // Drop the answers and variables fields wich are totaly redundants	
-	if ($oldversion < 2011072800) {
-	    $table = new xmldb_table('question_algebra');
+    // Drop the answers and variables fields wich are totaly redundants.
+    if ($oldversion < 2011072800) {
+        $table = new xmldb_table('question_algebra');
         $field = new xmldb_field('answers');
 
         if ($dbman->field_exists($table, $field)) {
             $dbman->drop_field($table, $field);
         }
-		$field = new xmldb_field('variables');
+        $field = new xmldb_field('variables');
 
         if ($dbman->field_exists($table, $field)) {
             $dbman->drop_field($table, $field);
         }
-		upgrade_plugin_savepoint(true, 2011072800, 'qtype', 'algebra');
-	}
-    return true;
+        upgrade_plugin_savepoint(true, 2011072800, 'qtype', 'algebra');
+    }
+
+    // Change tables names according to new standards for plugins.
+    if ($oldversion < 2012061701) {
+        // Renaming old tables.
+        $table = new xmldb_table('question_algebra');
+        if ($dbman->table_exists($table)) {
+            $dbman->rename_table($table, 'qtype_algebra');
+        }
+        $table = new xmldb_table('question_algebra_variables');
+        if ($dbman->table_exists($table)) {
+            $dbman->rename_table($table, 'qtype_algebra_variables');
+        }
+        upgrade_plugin_savepoint(true, 2012061701, 'qtype', 'algebra');
+    }
+    return true;   
 }
 
-- 
cgit v1.2.3