From 8bcd295c3da959770652edbbbd40ea618b4c6d03 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Wed, 19 Apr 2006 08:18:35 +0000
Subject: [PATCH] bumping up version, chaing user->firstname, user->lastname,
 course->shortname to varchar(100)

---
 lib/db/migrate2utf8.xml | 6 +++---
 lib/db/mysql.php        | 8 ++++++++
 lib/db/mysql.sql        | 6 +++---
 lib/moodlelib.php       | 4 ++--
 version.php             | 2 +-
 5 files changed, 17 insertions(+), 9 deletions(-)

diff --git a/lib/db/migrate2utf8.xml b/lib/db/migrate2utf8.xml
index 5ab4164775..7e4733f05a 100755
--- a/lib/db/migrate2utf8.xml
+++ b/lib/db/migrate2utf8.xml
@@ -362,7 +362,7 @@
             migrate2utf8_course_fullname(RECORDID)
           </PHP_FUNCTION>
         </FIELD>
-        <FIELD name="shortname" method="PHP_FUNCTION" type="varchar" length="15" dropindex="shortname" addindex="shortname(shortname(15))">
+        <FIELD name="shortname" method="PHP_FUNCTION" type="varchar" length="100" dropindex="shortname" addindex="shortname(shortname(15))">
           <PHP_FUNCTION>
             migrate2utf8_course_shortname(RECORDID)
           </PHP_FUNCTION>
@@ -426,12 +426,12 @@
             migrate2utf8_user_idnumber(RECORDID)
           </PHP_FUNCTION>
         </FIELD>
-        <FIELD name="firstname" method="PHP_FUNCTION" type="varchar" length="20" dropindex="user_firstname" addindex="user_firstname(firstname(20))">
+        <FIELD name="firstname" method="PHP_FUNCTION" type="varchar" length="100" dropindex="user_firstname" addindex="user_firstname(firstname(20))">
           <PHP_FUNCTION>
             migrate2utf8_user_firstname(RECORDID)
           </PHP_FUNCTION>
         </FIELD>
-        <FIELD name="lastname" method="PHP_FUNCTION" type="varchar" length="20" dropindex="user_lastname" addindex="user_lastname(lastname(20))">
+        <FIELD name="lastname" method="PHP_FUNCTION" type="varchar" length="100" dropindex="user_lastname" addindex="user_lastname(lastname(20))">
           <PHP_FUNCTION>
             migrate2utf8_user_lastname(RECORDID)
           </PHP_FUNCTION>
diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index 799db2b5ba..847ae403c8 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -1786,6 +1786,14 @@ function main_upgrade($oldversion=0) {
         modify_database('',"ALTER TABLE prefix_blog_tag_instance CHANGE id id INT UNSIGNED NOT NULL AUTO_INCREMENT");
     }
     
+    // changed user->firstname, user->lastname, course->shortname to varchar(100)
+    
+    if ($oldversion < 2006041900) {
+        table_column('course','shortname','shortname','varchar','100','','','not null');
+        table_column('user','firstname','firstname','varchar','100','','','not null');
+        table_column('user','lastname','lastname','varchar','100','','','not null');
+    }
+    
     return $result;
 }
 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index fe04ed9828..92cb9a9d0e 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -48,7 +48,7 @@ CREATE TABLE `prefix_course` (
   `sortorder` int(10) unsigned NOT NULL default '0',
   `password` varchar(50) NOT NULL default '',
   `fullname` varchar(254) NOT NULL default '',
-  `shortname` varchar(15) NOT NULL default '',
+  `shortname` varchar(100) NOT NULL default '',
   `idnumber` varchar(100) NOT NULL default '',
   `summary` text NOT NULL default '',
   `format` varchar(10) NOT NULL default 'topics',
@@ -583,8 +583,8 @@ CREATE TABLE `prefix_user` (
   `username` varchar(100) NOT NULL default '',
   `password` varchar(32) NOT NULL default '',
   `idnumber` varchar(64) default NULL,
-  `firstname` varchar(20) NOT NULL default '',
-  `lastname` varchar(20) NOT NULL default '',
+  `firstname` varchar(100) NOT NULL default '',
+  `lastname` varchar(100) NOT NULL default '',
   `email` varchar(100) NOT NULL default '',
   `emailstop` tinyint(1) unsigned NOT NULL default '0',
   `icq` varchar(15) default NULL,
diff --git a/lib/moodlelib.php b/lib/moodlelib.php
index 9b7a86d418..73d9c9a806 100644
--- a/lib/moodlelib.php
+++ b/lib/moodlelib.php
@@ -2480,8 +2480,8 @@ function truncate_userinfo($info) {
     $limit = array(
                     'username'    => 100,
                     'idnumber'    =>  64,
-                    'firstname'   =>  20,
-                    'lastname'    =>  20,
+                    'firstname'   => 100,
+                    'lastname'    => 100,
                     'email'       => 100,
                     'icq'         =>  15,
                     'phone1'      =>  20,
diff --git a/version.php b/version.php
index ef5e6859a0..b0bbe665c4 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 = 2006041801;  // YYYYMMDD = date
+   $version = 2006041900;  // YYYYMMDD = date
                            //       XY = increments within a single day
 
    $release = '1.6 Beta 3';    // Human-friendly version name
-- 
2.39.5