From fd73fa95fcba81312481546aee188e4733a8f45b Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 23 May 2017 16:16:17 -0300 Subject: [PATCH] Bug 18663: Add pref ExportRemoveFields if missing Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice Signed-off-by: Mason James --- installer/data/mysql/atomicupdate/bug_18663.sql | 2 ++ installer/data/mysql/updatedatabase.pl | 9 +++++++++ 2 files changed, 11 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_18663.sql diff --git a/installer/data/mysql/atomicupdate/bug_18663.sql b/installer/data/mysql/atomicupdate/bug_18663.sql new file mode 100644 index 0000000000..b8f246847f --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_18663.sql @@ -0,0 +1,2 @@ +INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES +('ExportRemoveFields','',NULL,'List of fields for non export in circulation.pl (separated by a space)','Free'); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 8660802609..9de0510e27 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12988,6 +12988,15 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } +$DBversion = "16.05.14.001"; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{ + INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES ('ExportRemoveFields','',NULL,'List of fields for non export in circulation.pl (separated by a space)','Free'); + }); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 18663 - Missing db update for ExportRemoveFields)\n"; +} + # DEVELOPER PROCESS, search for anything to execute in the db_update directory # SEE bug sss # if there is anything in the atomicupdate, read and execute it. -- 2.39.5