From 2c48aeab95cdc1b864b337cf31fbd601627b52a0 Mon Sep 17 00:00:00 2001
From: mjollnir_ <mjollnir_>
Date: Fri, 29 Aug 2008 18:30:01 +0000
Subject: [PATCH] MDL-16180 - change field precision of parent_type to 20 in
 mnet rpc function table to fit 'portfolio'

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

diff --git a/lib/db/install.xml b/lib/db/install.xml
index dda246b284..516b751bb6 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -1179,7 +1179,7 @@
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" COMMENT="Unique Function ID" NEXT="function_name"/>
         <FIELD NAME="function_name" TYPE="char" LENGTH="40" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="xmlrpc_path"/>
         <FIELD NAME="xmlrpc_path" TYPE="char" LENGTH="80" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="function_name" NEXT="parent_type"/>
-        <FIELD NAME="parent_type" TYPE="char" LENGTH="6" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="xmlrpc_path" NEXT="parent"/>
+        <FIELD NAME="parent_type" TYPE="char" LENGTH="20" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="xmlrpc_path" NEXT="parent"/>
         <FIELD NAME="parent" TYPE="char" LENGTH="20" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="parent_type" NEXT="enabled"/>
         <FIELD NAME="enabled" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="parent" NEXT="help"/>
         <FIELD NAME="help" TYPE="text" LENGTH="medium" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="enabled" NEXT="profile"/>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 00f20b31d3..ad6cddcfd4 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -738,6 +738,19 @@ function xmldb_main_upgrade($oldversion) {
         upgrade_main_savepoint($result, 2008082700);
     }
 
+    if ($result && $oldversion < 2008082900) {
+
+    /// Changing precision of field parent_type on table mnet_rpc to (20)
+        $table = new xmldb_table('mnet_rpc');
+        $field = new xmldb_field('parent_type', XMLDB_TYPE_CHAR, '20', null, XMLDB_NOTNULL, null, null, null, null, 'xmlrpc_path');
+
+    /// Launch change of precision for field parent_type
+        $dbman->change_field_precision($table, $field);
+
+    /// Main savepoint reached
+        upgrade_main_savepoint($result, 2008082900);
+    }
+
     return $result;
 }
 
diff --git a/version.php b/version.php
index 581230faaa..7745ab7c5c 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 = 2008082702;  // YYYYMMDD   = date of the last version bump
+    $version = 2008082900;  // YYYYMMDD   = date of the last version bump
                             //         XX = daily increments
 
     $release = '2.0 dev (Build: 20080829)';  // Human-friendly version name
-- 
2.39.5