# - #4 : the developer version. The 4th number is the database subversion.
# used by developers when the database changes. updatedatabase take care of the changes itself
# and is automatically called by Auth.pm when needed.
-$VERSION = "19.12.00.066";
+$VERSION = "19.12.00.067";
sub version {
return $VERSION;
+++ /dev/null
-$DBversion = 'XXX'; # will be replaced by the RM
-if( CheckVersion( $DBversion ) ) {
- # From: https://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql
- $dbh->do(q|
-DELETE a
-FROM virtualshelfshares as a, virtualshelfshares as b
-WHERE a.id < b.id AND a.borrowernumber IS NOT NULL AND a.borrowernumber=b.borrowernumber AND a.shelfnumber=b.shelfnumber
- |);
- SetVersion( $DBversion );
- print "Upgrade to $DBversion done (Bug 20754: Remove double accepted list shares)\n";
-}
);
}
+$DBversion = '19.12.00.067';
+if( CheckVersion( $DBversion ) ) {
+ # From: https://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql
+ $dbh->do(q|
+ DELETE a
+ FROM virtualshelfshares as a, virtualshelfshares as b
+ WHERE
+ a.id < b.id
+ AND
+ a.borrowernumber IS NOT NULL
+ AND
+ a.borrowernumber=b.borrowernumber
+ AND
+ a.shelfnumber=b.shelfnumber
+ |);
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 20754: Remove double accepted list shares)\n";
+}
+
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.
my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/';