From a4232e9500f0e368f6b5c36f57a679429a04c9ab Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Mon, 27 Aug 2007 04:21:59 +0000
Subject: [PATCH] adding timemodified to tag_instance table (to get blog blocks
 working)

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

diff --git a/lib/db/install.xml b/lib/db/install.xml
index d1d10a032f..e5f5066be0 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="20070823" COMMENT="XMLDB file for core Moodle tables"
+<XMLDB PATH="lib/db" VERSION="20070827" COMMENT="XMLDB file for core Moodle tables"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd"
 >
@@ -1653,7 +1653,8 @@
         <FIELD NAME="tagid" TYPE="int" LENGTH="11" NOTNULL="true" UNSIGNED="false" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="itemtype"/>
         <FIELD NAME="itemtype" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="tagid" NEXT="itemid"/>
         <FIELD NAME="itemid" TYPE="int" LENGTH="11" NOTNULL="true" UNSIGNED="false" SEQUENCE="false" ENUM="false" PREVIOUS="itemtype" NEXT="ordering"/>
-        <FIELD NAME="ordering" TYPE="int" LENGTH="10" NOTNULL="false" UNSIGNED="false" SEQUENCE="false" ENUM="false" COMMENT="Maintains the order of the tag instances of an item" PREVIOUS="itemid"/>
+        <FIELD NAME="ordering" TYPE="int" LENGTH="10" NOTNULL="false" UNSIGNED="false" SEQUENCE="false" ENUM="false" COMMENT="Maintains the order of the tag instances of an item" PREVIOUS="itemid" NEXT="timemodified"/>
+        <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" COMMENT="timemodified" PREVIOUS="ordering"/>
       </FIELDS>
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for tag_instance"/>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 7723e5c192..98ace3166a 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -1779,6 +1779,17 @@ function xmldb_main_upgrade($oldversion=0) {
     }
 */
 
+    if ($result && $oldversion < 2007082700) {
+
+    /// Define field timemodified to be added to tag_instance
+        $table = new XMLDBTable('tag_instance');
+        $field = new XMLDBField('timemodified');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'ordering');
+
+    /// Launch add field timemodified
+        $result = $result && add_field($table, $field);
+    }
+
     return $result;
 }
 
diff --git a/version.php b/version.php
index 6b72890567..3bd8b3d405 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 = 2007082400;  // YYYYMMDD = date
+    $version = 2007082700;  // YYYYMMDD = date
                             //       XY = increments within a single day
 
     $release = '1.9 Beta +';   // Human-friendly version name
-- 
2.39.5