From 783453129bec1966636b63226e04aff97cc8e082 Mon Sep 17 00:00:00 2001
From: defacer <defacer>
Date: Tue, 8 Feb 2005 20:29:17 +0000
Subject: [PATCH] Fix for bug 2488:

Extending mdl_log column module to varchar(20).
It was already 20 chars in Postgres, so no changes there.
---
 lib/db/mysql.php  | 5 +++++
 lib/db/mysql.sql  | 2 +-
 lib/db/oci8po.sql | 2 +-
 version.php       | 2 +-
 4 files changed, 8 insertions(+), 3 deletions(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index bb9cb72940..45fbf74138 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -1180,6 +1180,11 @@ function main_upgrade($oldversion=0) {
         }
     }
 
+    if ($oldversion < 2005020800) {
+        // Expand module column to max 20 chars
+        table_column('log','module','module','varchar','20','','','not null');
+    }
+
     return $result;
 }
 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 85609e1399..76b610dae0 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -277,7 +277,7 @@ CREATE TABLE `prefix_log` (
   `userid` int(10) unsigned NOT NULL default '0',
   `ip` varchar(15) NOT NULL default '',
   `course` int(10) unsigned NOT NULL default '0',
-  `module` varchar(10) NOT NULL default '',
+  `module` varchar(20) NOT NULL default '',
   `cmid` int(10) unsigned NOT NULL default '0',
   `action` varchar(15) NOT NULL default '',
   `url` varchar(100) NOT NULL default '',
diff --git a/lib/db/oci8po.sql b/lib/db/oci8po.sql
index 68121f26df..a94a7099d4 100755
--- a/lib/db/oci8po.sql
+++ b/lib/db/oci8po.sql
@@ -260,7 +260,7 @@ CREATE TABLE prefix_log (
   userid number(10) default '0' not null,
   ip varchar2(15) default '' not null,
   course number(10) default '0' not null,
-  module varchar2(10) default '' not null,
+  module varchar2(20) default '' not null,
   action varchar2(15) default '' not null,
   url varchar2(100) default '' not null,
   info varchar2(255) default '' not null
diff --git a/version.php b/version.php
index 2136dac442..f6328f9751 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 = 2005020101;  // YYYYMMDD = date of first major branch release 1.4
+   $version = 2005020800;  // YYYYMMDD = date of first major branch release 1.4
                            //       XY = increments within a single day
 
    $release = '1.5 UNSTABLE DEVELOPMENT';    // Human-friendly version name
-- 
2.39.5