From 1b63e57388839946172cb225273d4e4b49248f5b Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Tue, 5 Jun 2007 05:40:10 +0000
Subject: [PATCH] adding a usermodified field to post table

---
 lib/db/install.xml |  8 +++++---
 lib/db/upgrade.php | 19 +++++++++++++++++++
 version.php        |  2 +-
 3 files changed, 25 insertions(+), 4 deletions(-)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index 34ae950126..e946e85282 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="20070601" COMMENT="XMLDB file for core Moodle tables"
+<XMLDB PATH="lib/db" VERSION="20070605" COMMENT="XMLDB file for core Moodle tables"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd"
 >
@@ -756,10 +756,12 @@
         <FIELD NAME="attachment" TYPE="char" LENGTH="100" NOTNULL="false" SEQUENCE="false" ENUM="false" COMMENT="attachment" PREVIOUS="format" NEXT="publishstate"/>
         <FIELD NAME="publishstate" TYPE="char" LENGTH="20" NOTNULL="true" DEFAULT="draft" SEQUENCE="false" ENUM="true" ENUMVALUES="'draft', 'site', 'public'" PREVIOUS="attachment" NEXT="lastmodified"/>
         <FIELD NAME="lastmodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="publishstate" NEXT="created"/>
-        <FIELD NAME="created" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="lastmodified"/>
+        <FIELD NAME="created" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="lastmodified" NEXT="usermodified"/>
+        <FIELD NAME="usermodified" TYPE="int" LENGTH="10" NOTNULL="false" UNSIGNED="true" SEQUENCE="false" ENUM="false" PREVIOUS="created"/>
       </FIELDS>
       <KEYS>
-        <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for post"/>
+        <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for post" NEXT="usermodified"/>
+        <KEY NAME="usermodified" TYPE="foreign" FIELDS="usermodified" REFTABLE="user" REFFIELDS="id" COMMENT="Default comment for the key, please edit me" PREVIOUS="primary"/>
       </KEYS>
       <INDEXES>
         <INDEX NAME="id-userid" UNIQUE="true" FIELDS="id, userid" NEXT="lastmodified"/>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 57c9d10634..5a97b266ef 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -1324,6 +1324,25 @@ function xmldb_main_upgrade($oldversion=0) {
         // Launch add field deleted
         $result = $result && add_field($table, $field); 
     }
+    
+    if ($result && $oldversion < 2007060500) {
+
+    /// Define field usermodified to be added to post
+        $table = new XMLDBTable('post');
+        $field = new XMLDBField('usermodified');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, null, null, 'created');
+
+    /// Launch add field usermodified
+        $result = $result && add_field($table, $field);
+        
+    /// Define key usermodified (foreign) to be added to post
+        $table = new XMLDBTable('post');
+        $key = new XMLDBKey('usermodified');
+        $key->setAttributes(XMLDB_KEY_FOREIGN, array('usermodified'), 'user', array('id'));
+
+    /// Launch add key usermodified
+        $result = $result && add_key($table, $key);
+    }
 
     return $result; 
 }
diff --git a/version.php b/version.php
index 12d276dd1e..0e88b375d4 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 = 2007060100;  // YYYYMMDD = date
+   $version = 2007060500;  // YYYYMMDD = date
                            //       XY = increments within a single day
 
    $release = '1.9 dev';    // Human-friendly version name
-- 
2.39.5