From 745c0ee508cc8448b4cb4052bf7958e733841dd1 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sun, 7 Dec 2008 22:13:39 +0000
Subject: [PATCH] MDL-17537 course request: shortname in course_request is now
the same length as in course table - 100 chars
---
lib/db/install.xml | 2 +-
lib/db/upgrade.php | 15 ++++++++++++++-
version.php | 2 +-
3 files changed, 16 insertions(+), 3 deletions(-)
diff --git a/lib/db/install.xml b/lib/db/install.xml
index 35890b92d0..10bcb190d3 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -225,7 +225,7 @@
<FIELDS>
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="fullname"/>
<FIELD NAME="fullname" TYPE="char" LENGTH="254" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="shortname"/>
- <FIELD NAME="shortname" TYPE="char" LENGTH="15" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="fullname" NEXT="summary"/>
+ <FIELD NAME="shortname" TYPE="char" LENGTH="100" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="fullname" NEXT="summary"/>
<FIELD NAME="summary" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="shortname" NEXT="reason"/>
<FIELD NAME="reason" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="summary" NEXT="requester"/>
<FIELD NAME="requester" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="reason" NEXT="password"/>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 46225c09ea..1463351fbf 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -1109,7 +1109,20 @@ function xmldb_main_upgrade($oldversion) {
/// Main savepoint reached
upgrade_main_savepoint($result, 2008112400);
}
-
+
+ if ($result && $oldversion < 2008120700) {
+
+ /// Changing precision of field shortname on table course_request to (100)
+ $table = new xmldb_table('course_request');
+ $field = new xmldb_field('shortname', XMLDB_TYPE_CHAR, '100', null, XMLDB_NOTNULL, null, null, null, null, 'fullname');
+
+ /// Launch change of precision for field shortname
+ $dbman->change_field_precision($table, $field);
+
+ /// Main savepoint reached
+ upgrade_main_savepoint($result, 2008120700);
+ }
+
return $result;
}
diff --git a/version.php b/version.php
index 35dfa1f691..8bdd242304 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 = 2008120400; // YYYYMMDD = date of the last version bump
+ $version = 2008120700; // YYYYMMDD = date of the last version bump
// XX = daily increments
$release = '2.0 dev (Build: 20081207)'; // Human-friendly version name
--
2.39.5