@@ -, +, @@ and add multiple ip only one ip at format xxx.xxx.xxx.xxx or xxx.xxx.* those ip(s) you want seperate by space in any format like xxx.xxx.xxx.xxx or xxx.xxx.xxx.0/24 or xxx.xxx.xxx.* or only one also on the same formats. before and now CIDR notation can regognized also and also you can have more than one ip for restriction. --- installer/data/mysql/atomicupdate/bug_11180.perl | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_11180.perl --- a/installer/data/mysql/atomicupdate/bug_11180.perl +++ a/installer/data/mysql/atomicupdate/bug_11180.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( "ALTER TABLE `branches` MODIFY `branchip` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the IP address(s) for your library or branch'" ); + + NewVersion( $DBversion, 11180, "expand branches.branchip to allow for multiple ip ranges"); +} --