From 7b1c0ce35c898b602560e21e1f080c0a3790c56c Mon Sep 17 00:00:00 2001 From: martin Date: Sun, 1 Sep 2002 14:24:16 +0000 Subject: [PATCH] Increased size of section summaries from 255 chars to 65000 chars. --- lib/db/mysql.sql | 2 +- version.php | 7 +++++-- 2 files changed, 6 insertions(+), 3 deletions(-) diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql index 9b8255151e..20d8602a8a 100644 --- a/lib/db/mysql.sql +++ b/lib/db/mysql.sql @@ -86,7 +86,7 @@ CREATE TABLE `course_sections` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `section` int(10) unsigned NOT NULL default '0', - `summary` varchar(255) NOT NULL default '', + `summary` text NOT NULL, `sequence` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; diff --git a/version.php b/version.php index 7fdf07b8c4..67be050a63 100644 --- a/version.php +++ b/version.php @@ -17,7 +17,7 @@ // If there's something it cannot do itself, it // will tell you what you need to do. -$version = 2002082600; +$version = 2002090100; function upgrade_moodle($oldversion=0) { @@ -52,7 +52,10 @@ function upgrade_moodle($oldversion=0) { } if ($oldversion < 2002082101) { - execute_sql(" ALTER TABLE `user` ADD `maildisplay` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL AFTER `mailformat` "); + execute_sql(" ALTER TABLE `user` ADD `maildisplay` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL AFTER `mailformat` "); + } + if ($oldversion < 2002090100) { + execute_sql(" ALTER TABLE `course_sections` CHANGE `summary` `summary` TEXT NOT NULL "); } return true; -- 2.39.5