From 14151769028a8d5304de0e18e81cc43ae9164344 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 8 Nov 2017 14:34:13 -0300 Subject: [PATCH] Bug 18882: (follow-up) DBRev 17.06.000.027 No idea how I did that... Signed-off-by: Jonathan Druart --- installer/data/mysql/updatedatabase.pl | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index dbe30fa199..948b036bbc 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -14948,19 +14948,19 @@ if( CheckVersion( $DBversion ) ) { print "Upgrade to $DBversion done (Bug 13178 - Increase cardnumber fields to VARCHAR(32))\n"; } -$dbversion = '17.06.00.026'; -if( checkversion( $dbversion ) ) { +$DBversion = '17.06.00.026'; +if( CheckVersion( $DBversion ) ) { $dbh->do(q{ - insert ignore into systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) values - ('blockreturnoflostitems','0','0','if enabled, items that are marked as lost cannot be returned.','yesno'); + INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES + ('BlockReturnOfLostItems','0','0','If enabled, items that are marked as lost cannot be returned.','YesNo'); }); - setversion( $dbversion ); - print "upgrade to $dbversion done (bug 10748 - add system preference blockreturnoflostitems)\n"; + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 10748 - Add system preference BlockReturnOfLostItems)\n"; } -$dbversion = '17.06.00.027'; -if( checkversion( $dbversion ) ) { +$DBversion = '17.06.00.027'; +if( CheckVersion( $DBversion ) ) { if ( !column_exists( 'statistics', 'location' ) ) { $dbh->do('ALTER TABLE statistics ADD COLUMN location VARCHAR(80) default NULL AFTER itemtype'); } -- 2.39.5