From 85c7bd5bcdd7593f7a925961a05a17890de0400e Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Fri, 13 Jul 2007 05:01:32 +0000
Subject: [PATCH] adding feedback to grade import temp table and rename
 rawgrade to finalgrade

---
 lib/db/install.xml |  9 +++++----
 lib/db/upgrade.php | 18 +++++++++++++++++-
 version.php        |  2 +-
 3 files changed, 23 insertions(+), 6 deletions(-)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index d416b93b94..9e1bc9c9e5 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="lib/db" VERSION="20070710" COMMENT="XMLDB file for core Moodle tables"
+<XMLDB PATH="lib/db" VERSION="20070713" COMMENT="XMLDB file for core Moodle tables"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd"
 >
@@ -1543,9 +1543,10 @@
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" COMMENT="id of the table, please edit me" NEXT="itemid"/>
         <FIELD NAME="itemid" TYPE="int" LENGTH="10" NOTNULL="false" UNSIGNED="true" SEQUENCE="false" ENUM="false" COMMENT="if set, this points to existing grade_items id" PREVIOUS="id" NEXT="newgradeitem"/>
         <FIELD NAME="newgradeitem" TYPE="int" LENGTH="10" NOTNULL="false" UNSIGNED="true" SEQUENCE="false" ENUM="false" COMMENT="if set, points to the id of grade_import_newitem" PREVIOUS="itemid" NEXT="userid"/>
-        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="false" ENUM="false" PREVIOUS="newgradeitem" NEXT="rawgrade"/>
-        <FIELD NAME="rawgrade" TYPE="number" LENGTH="10" NOTNULL="true" UNSIGNED="false" DEFAULT="0.0" SEQUENCE="false" ENUM="false" DECIMALS="5" COMMENT="raw grade value" PREVIOUS="userid" NEXT="import_code"/>
-        <FIELD NAME="import_code" TYPE="int" LENGTH="12" NOTNULL="true" UNSIGNED="true" SEQUENCE="false" ENUM="false" COMMENT="similar to backup_code, a unique batch code for identifying one batch of imports" PREVIOUS="rawgrade"/>
+        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="false" ENUM="false" PREVIOUS="newgradeitem" NEXT="finalgrade"/>
+        <FIELD NAME="finalgrade" TYPE="number" LENGTH="10" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" DECIMALS="5" COMMENT="raw grade value" PREVIOUS="userid" NEXT="feedback"/>
+        <FIELD NAME="feedback" TYPE="text" LENGTH="medium" NOTNULL="false" SEQUENCE="false" ENUM="false" PREVIOUS="finalgrade" NEXT="import_code"/>
+        <FIELD NAME="import_code" TYPE="int" LENGTH="12" NOTNULL="true" UNSIGNED="true" SEQUENCE="false" ENUM="false" COMMENT="similar to backup_code, a unique batch code for identifying one batch of imports" PREVIOUS="feedback"/>
       </FIELDS>
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="primary key of the table, please edit me" NEXT="itemid"/>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 635b78fe98..037674748a 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -1427,8 +1427,24 @@ function xmldb_main_upgrade($oldversion=0) {
         }
 
     }
+    
+    if ($result && $oldversion < 2007071300) {
+    /// Define field feedback to be added to grade_import_values
+        $table = new XMLDBTable('grade_import_values');
+        $field = new XMLDBField('feedback');
+        $field->setAttributes(XMLDB_TYPE_TEXT, 'medium', null, null, null, null, null, null, 'rawgrade');
+
+    /// Launch add field feedback
+        $result = $result && add_field($table, $field);
+    
+    /// Rename field rawgrade on table grade_import_values to NEWNAMEGOESHERE
+        $table = new XMLDBTable('grade_import_values');
+        $field = new XMLDBField('rawgrade');
+        $field->setAttributes(XMLDB_TYPE_NUMBER, '10, 5', null, XMLDB_NOTNULL, null, null, null, '0.0', 'userid');
 
+    /// Launch rename field rawgrade
+        $result = $result && rename_field($table, $field, 'finalgrade');
+    }
     return $result;
 }
-
 ?>
diff --git a/version.php b/version.php
index 4222d3ad31..6c6224fa08 100644
--- a/version.php
+++ b/version.php
@@ -6,7 +6,7 @@
 // This is compared against the values stored in the database to determine
 // whether upgrades should be performed (see lib/db/*.php)
 
-   $version = 2007071000;  // YYYYMMDD = date
+   $version = 2007071300;  // YYYYMMDD = date
                            //       XY = increments within a single day
 
    $release = '1.9 dev';    // Human-friendly version name
-- 
2.39.5