From d1b5e18b3cd0bcba7f1aa6cb8144b912751597f7 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Wed, 10 Apr 2013 11:13:10 -0300 Subject: [PATCH] Bug 9819 - Make updatedatabase.pl remove the 'stopwords' table MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit To test: - Apply the patch - Will be prompted to run the updater - The 'stopwords' database should be removed ( test on a mysql prompt with > SHOW TABLES LIKE 'stopwords'; and should get no results) Sponsored-by: Universidad Nacional de Córdoba Signed-off-by: Kyle M Hall --- installer/data/mysql/updatedatabase.pl | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 7c97a51..d24889a 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -6771,6 +6771,14 @@ if ( CheckVersion($DBversion) ) { SetVersion ($DBversion); } +$DBversion = "XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(q{ + DROP TABLE IF EXISTS `stopwords`; + }); + print "Upgrade to $DBversion done (Removed obsolete 'stopwords' table)\n"; + SetVersion($DBversion); +} =head1 FUNCTIONS -- 1.7.2.5