@@ -, +, @@ ReservesControlBranch has null then update the table to insert a ItemHomeLibrary as value +-----------------------+-----------------+-------------------------------+-------------------------------------------------+--------+ +-----------------------+-----------------+-------------------------------+-------------------------------------------------+--------+ +-----------------------+-----------------+-------------------------------+-------------------------------------------------+--------+ --- installer/data/mysql/updatedatabase.pl | 10 ++++++++++ 1 file changed, 10 insertions(+) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -5239,6 +5239,16 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.09.00.XXX"; +if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { + unless(C4::Context->preference('ReservesControlBranch')){ + $dbh->do("INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES ('ReservesControlBranch','ItemHomeLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights.','Choice')"); + } + print "Upgrade to $DBversion done (Insert ReservesControlBranch systempreference into systempreferences table )\n"; + SetVersion($DBversion); +} + + =head1 FUNCTIONS =head2 TableExists($table) --