# - #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 = "3.22.20.000";
+$VERSION = "3.22.20.001";
sub version {
return $VERSION;
+++ /dev/null
-$DBversion = 'XXX';
-if( CheckVersion( $DBversion ) ) {
- unless( column_exists( 'branches', 'geolocation' ) ) {
- $dbh->do(q|
- ALTER TABLE branches ADD COLUMN geolocation VARCHAR(255) DEFAULT NULL after opac_info
- |);
- }
-
- $dbh->do(q|
- INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES ('UsageStatsGeolocation', '', NULL, 'Geolocation of the main library', 'Free');
- |);
- $dbh->do(q|
- INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES ('UsageStatsLibrariesInfo', '', NULL, 'Share libraries information', 'YesNo');
- |);
- $dbh->do(q|
- INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES ('UsageStatsPublicID', '', NULL, 'Public ID for Hea website', 'Free');
- |);
-
- SetVersion( $DBversion );
- print "Upgrade to $DBversion done (Bug 18066 - Hea version 2)\n";
-}
SetVersion($DBversion);
}
+$DBversion = "3.22.20.001";
+if ( CheckVersion($DBversion) ) {
+ unless( column_exists( 'branches', 'geolocation' ) ) {
+ $dbh->do(q|
+ ALTER TABLE branches
+ ADD COLUMN geolocation VARCHAR(255) DEFAULT NULL after opac_info
+ |);
+ }
+
+ $dbh->do(q|
+ INSERT IGNORE INTO systempreferences
+ (variable, value, options, explanation, type)
+ VALUES
+ ('UsageStatsGeolocation', '', NULL, 'Geolocation of the main library', 'Free')
+ |);
+ $dbh->do(q|
+ INSERT IGNORE INTO systempreferences
+ (variable, value, options, explanation, type)
+ VALUES
+ ('UsageStatsLibrariesInfo', '', NULL, 'Share libraries information', 'YesNo')
+ |);
+ $dbh->do(q|
+ INSERT IGNORE INTO systempreferences
+ (variable, value, options, explanation, type)
+ VALUES
+ ('UsageStatsPublicID', '', NULL, 'Public ID for Hea website', 'Free')
+ |);
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 18066 - Hea version 2)\n";
+}
+
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.