From 7ea53a1fb1dff526c52e5e2b5f80ce14d0d7932d Mon Sep 17 00:00:00 2001
From: martin <martin>
Date: Fri, 2 Aug 2002 17:42:59 +0000
Subject: [PATCH] Removed fullname and search fields from modules table. 
 Fullname is now derived from the string 'modulename' in the lang files for
 each module.

---
 lib/db/mysql.sql           | 1 -
 mod/assignment/version.php | 2 --
 mod/choice/version.php     | 2 --
 mod/forum/version.php      | 2 --
 mod/journal/version.php    | 2 --
 mod/survey/version.php     | 2 --
 version.php                | 7 ++++++-
 7 files changed, 6 insertions(+), 12 deletions(-)

diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index ce8cf35e91..c8728dc693 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -129,7 +129,6 @@ CREATE TABLE `log_display` (
 CREATE TABLE `modules` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `name` varchar(20) NOT NULL default '',
-  `fullname` varchar(255) NOT NULL default '',
   `version` int(10) NOT NULL default '0',
   `cron` int(10) unsigned NOT NULL default '0',
   `lastcron` int(10) unsigned NOT NULL default '0',
diff --git a/mod/assignment/version.php b/mod/assignment/version.php
index afa4c246c1..31d8d73e86 100644
--- a/mod/assignment/version.php
+++ b/mod/assignment/version.php
@@ -5,10 +5,8 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->fullname = "Assignment";
 $module->version  = 20020801;
 $module->cron     = 60;
-$module->search   = "";
 
 function assignment_upgrade($oldversion) {
 // This function does anything necessary to upgrade
diff --git a/mod/choice/version.php b/mod/choice/version.php
index 31e1f4fa56..956260e42c 100644
--- a/mod/choice/version.php
+++ b/mod/choice/version.php
@@ -5,10 +5,8 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->fullname = "Choice";
 $module->version  = 20011110;
 $module->cron     = 0;
-$module->search   = "";
 
 function choice_upgrade($oldversion) {
 // This function does anything necessary to upgrade
diff --git a/mod/forum/version.php b/mod/forum/version.php
index d71ff35ef1..e9604b8bf4 100644
--- a/mod/forum/version.php
+++ b/mod/forum/version.php
@@ -5,10 +5,8 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->fullname = "Forum";
 $module->version  = 2002080100;
 $module->cron     = 60;
-$module->search   = "";
 
 function forum_upgrade($oldversion) {
 // This function does anything necessary to upgrade
diff --git a/mod/journal/version.php b/mod/journal/version.php
index 10bcf6e01f..77fc315041 100644
--- a/mod/journal/version.php
+++ b/mod/journal/version.php
@@ -5,10 +5,8 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->fullname = "Journal";
 $module->version  = 200208010;
 $module->cron     = 60;
-$module->search   = "";
 
 function journal_upgrade($oldversion) {
 // This function does anything necessary to upgrade
diff --git a/mod/survey/version.php b/mod/survey/version.php
index 8369de8515..2ad81cbec6 100644
--- a/mod/survey/version.php
+++ b/mod/survey/version.php
@@ -5,10 +5,8 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->fullname = "Survey";
 $module->version  = 20020727;
 $module->cron     = 0;
-$module->search   = "";
 
 function survey_upgrade($oldversion) {
 // This function does anything necessary to upgrade
diff --git a/version.php b/version.php
index 69c86ff58e..5fadb361ec 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 = 2002073100;
+$version = 2002080200;
 
 function upgrade_moodle($oldversion=0) {
 
@@ -37,6 +37,11 @@ function upgrade_moodle($oldversion=0) {
         execute_sql("DELETE FROM `modules` WHERE `name` = 'chat' ");
     }
 
+    if ($oldversion < 2002080200) {
+        execute_sql(" ALTER TABLE `modules` DROP `fullname`  ");
+        execute_sql(" ALTER TABLE `modules` DROP `search`  ");
+    }
+
     return true;
 }
 
-- 
2.39.5