From 7db989230f5d18aa8b0d9f349d9bc1623e8d68f0 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 14 Aug 2007 04:13:58 +0000
Subject: [PATCH] Added "notification" field, currently unused, to allow
 MDL-8377

---
 mod/data/db/install.xml |  5 +++--
 mod/data/db/upgrade.php | 11 +++++++++++
 mod/data/version.php    |  2 +-
 3 files changed, 15 insertions(+), 3 deletions(-)

diff --git a/mod/data/db/install.xml b/mod/data/db/install.xml
index 02e428a994..3bfc2526f1 100644
--- a/mod/data/db/install.xml
+++ b/mod/data/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="mod/data/db" VERSION="20060923" COMMENT="XMLDB file for Moodle mod/data"
+<XMLDB PATH="mod/data/db" VERSION="20070814" COMMENT="XMLDB file for Moodle mod/data"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"
 >
@@ -34,7 +34,8 @@
         <FIELD NAME="assessed" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="scale" NEXT="defaultsort"/>
         <FIELD NAME="defaultsort" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="assessed" NEXT="defaultsortdir"/>
         <FIELD NAME="defaultsortdir" TYPE="int" LENGTH="4" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="defaultsort" NEXT="editany"/>
-        <FIELD NAME="editany" TYPE="int" LENGTH="4" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="defaultsortdir"/>
+        <FIELD NAME="editany" TYPE="int" LENGTH="4" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="defaultsortdir" NEXT="notification"/>
+        <FIELD NAME="notification" TYPE="int" LENGTH="10" NOTNULL="false" UNSIGNED="false" SEQUENCE="false" ENUM="false" COMMENT="Notify people when things change" PREVIOUS="editany"/>
       </FIELDS>
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for data"/>
diff --git a/mod/data/db/upgrade.php b/mod/data/db/upgrade.php
index e027f183d2..a7b6a316cd 100644
--- a/mod/data/db/upgrade.php
+++ b/mod/data/db/upgrade.php
@@ -63,6 +63,17 @@ function xmldb_data_upgrade($oldversion=0) {
         $db->debug = true;
     }  
 
+    if ($result && $oldversion < 2007081400) {
+
+    /// Define field notification to be added to data
+        $table = new XMLDBTable('data');
+        $field = new XMLDBField('notification');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, '10', null, null, null, null, null, null, 'editany');
+
+    /// Launch add field notification
+        $result = $result && add_field($table, $field);
+    }
+
 
     return $result;
 }
diff --git a/mod/data/version.php b/mod/data/version.php
index e54cd9ef60..d3e4e0cf05 100644
--- a/mod/data/version.php
+++ b/mod/data/version.php
@@ -5,7 +5,7 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->version  = 2007072200;
+$module->version  = 2007081400;
 $module->requires = 2007072200;  // Requires this Moodle version
 $module->cron     = 60;
 
-- 
2.39.5