@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_10300.perl | 12 ++++++++++++ installer/data/mysql/atomicupdate/bug_10300.sql | 3 --- 2 files changed, 12 insertions(+), 3 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_10300.perl delete mode 100644 installer/data/mysql/atomicupdate/bug_10300.sql --- a/installer/data/mysql/atomicupdate/bug_10300.perl +++ a/installer/data/mysql/atomicupdate/bug_10300.perl @@ -0,0 +1,12 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( q{ + INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) + SELECT 'IndependentBranchesTransfers', value, NULL, 'Allow non-superlibrarians to transfer items between libraries','YesNo' + FROM systempreferences WHERE variable = 'IndependentBranches' + }); + + # Always end with this (adjust the bug info) + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 10300 - Allow transferring of items to be have separate IndependentBranches syspref)\n"; +} --- a/installer/data/mysql/atomicupdate/bug_10300.sql +++ a/installer/data/mysql/atomicupdate/bug_10300.sql @@ -1,3 +0,0 @@ -INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) -SELECT 'IndependentBranchesTransfers', value, NULL, 'Allow non-superlibrarians to transfer items between libraries','YesNo' -FROM systempreferences WHERE variable = 'IndependentBranches'; --