From d93cde7d668c31605a3682606f83dea5a53ea4bc Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 21 Feb 2014 18:14:05 +0000 Subject: [PATCH] [SIGNED-OFF] Bug 10012: remove last traces of NoZebra This patch removes the last traces of NoZebra: [1] The DBIC schema class for the nozebra table [2] References to the NoZebra and NoZebraIndexes sysprefs in the Italian SQL scripts. [3] Deleting the NoZebraIndexes syspref if it's still present. To test: [1] Verify that after applying the patch and running the DB upgrade, that "NoZebraIndexes" is no longer to be found in the systempreferences table. [2] Verify that "nozebra" is not referenced anywhere in the source code except for the database update scripts. Signed-off-by: Galen Charlton Signed-off-by: wajasu --- Koha/Schema/Result/Nozebra.pm | 64 ---------------------- .../mysql/it-IT/necessari/system_preferences.sql | 2 - installer/data/mysql/updatedatabase.pl | 9 +++ 3 files changed, 9 insertions(+), 66 deletions(-) delete mode 100644 Koha/Schema/Result/Nozebra.pm diff --git a/Koha/Schema/Result/Nozebra.pm b/Koha/Schema/Result/Nozebra.pm deleted file mode 100644 index b7a24b0..0000000 --- a/Koha/Schema/Result/Nozebra.pm +++ /dev/null @@ -1,64 +0,0 @@ -package Koha::Schema::Result::Nozebra; - -# Created by DBIx::Class::Schema::Loader -# DO NOT MODIFY THE FIRST PART OF THIS FILE - -use strict; -use warnings; - -use base 'DBIx::Class::Core'; - - -=head1 NAME - -Koha::Schema::Result::Nozebra - -=cut - -__PACKAGE__->table("nozebra"); - -=head1 ACCESSORS - -=head2 server - - data_type: 'varchar' - is_nullable: 0 - size: 20 - -=head2 indexname - - data_type: 'varchar' - is_nullable: 0 - size: 40 - -=head2 value - - data_type: 'varchar' - is_nullable: 0 - size: 250 - -=head2 biblionumbers - - data_type: 'longtext' - is_nullable: 0 - -=cut - -__PACKAGE__->add_columns( - "server", - { data_type => "varchar", is_nullable => 0, size => 20 }, - "indexname", - { data_type => "varchar", is_nullable => 0, size => 40 }, - "value", - { data_type => "varchar", is_nullable => 0, size => 250 }, - "biblionumbers", - { data_type => "longtext", is_nullable => 0 }, -); - - -# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HEbJLtO1Tpyvy9/w8dnS2w - - -# You can replace this text with custom content, and it will be preserved on regeneration -1; diff --git a/installer/data/mysql/it-IT/necessari/system_preferences.sql b/installer/data/mysql/it-IT/necessari/system_preferences.sql index b4ddfa0..df446bc 100644 --- a/installer/data/mysql/it-IT/necessari/system_preferences.sql +++ b/installer/data/mysql/it-IT/necessari/system_preferences.sql @@ -41,7 +41,6 @@ UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'language'; UPDATE systempreferences SET value = '0' WHERE variable = 'LetterLog'; UPDATE systempreferences SET value = '0' WHERE variable = 'MARCOrgCode'; UPDATE systempreferences SET value = '2' WHERE variable = 'maxreserves'; -UPDATE systempreferences SET value = '0' WHERE variable = 'NoZebra'; UPDATE systempreferences SET value = '0' WHERE variable = 'OpacAuthorities'; UPDATE systempreferences SET value = 'relevance' WHERE variable = 'OPACdefaultSortField'; UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder'; @@ -67,4 +66,3 @@ UPDATE systempreferences SET value = '1' WHERE variable = 'XISBN'; UPDATE systempreferences SET value = '#200||{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}|\r\n#210|. – |{210a}{ : 210c}{, 210d}|\r\n#215|. – |{215a}{ ; 215d}|\r\n#225|. – |{(225a}{ ; 225v)}|\r\n#010|. – |{ISBN 010a}|' WHERE variable = 'ISBD'; -UPDATE systempreferences SET value = '\'title\' => \'200a,200c,200d,200e,225a,225d,225e,225f,225h,225i,225v,500*,501*,503*,510*,512*,513*,514*,515*,516*,517*,518*,519*,520*,530*,531*,532*,540*,541*,545*,604t,610t,605a\',\r\n\'author\' => \'200f,600a,601a,604a,700a,700b,700c,700d,700a,701b,701c,701d,702a,702b,702c,702d,710a,710b,710c,710d,711a,711b,711c,711d,712a,712b,712c,712d\',\r\n\'isbn\' => \'010a\',\r\n\'issn\' => \'011a\',\r\n\'biblionumber => \'0909\',\r\n\'itemtype\' => \'200b\',\r\n\'language\' => \'101a\',\r\n\'publisher\' => \'210c\',\r\n\'date\' => \'210d\',\r\n\'note\' => \r\n\'300a,301a,302a,303a,304a,305a,306az,307a,308a,309a,310a,311a,312a,313a,314a,315a,316a,317a,318a,319a,320a,321a,322a,323a,324a,325a,326a,327a,328a,330a,332a,333a,336a,337a,345a\',\r\n\'Koha-Auth-Number\' => \'6009,6019,6029,6039,6049,6059,6069,6109,7009,7019,7029,7109,7119,7129\',\r\n \'subject\' => \'600*,601*,606*,610*\',\r\n \'dewey\' => \'676a\',\r\n \'homebranch\' => \'995a,995b\',\r\n \'lcn\' => \'995k\'' WHERE variable = 'NoZebraIndexes'; diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index c8e883f..4529938 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8012,6 +8012,15 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.15.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(q{ + DELETE FROM systempreferences WHERE variable = 'NoZebraIndexes' + }); + print "Upgrade to $DBversion done (Bug 10012 - remove last vestiges of NoZebra)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 1.8.5.3