# - #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 = "16.06.00.001";
+$VERSION = "16.06.00.002";
sub version {
return $VERSION;
+++ /dev/null
-ALTER TABLE borrowers
- ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
- ON UPDATE CURRENT_TIMESTAMP
- AFTER privacy_guarantor_checkouts;
-ALTER TABLE deletedborrowers
- ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
- ON UPDATE CURRENT_TIMESTAMP
- AFTER privacy_guarantor_checkouts;
$DBversion = "16.06.00.000";
if ( CheckVersion($DBversion) ) {
- print "Upgrade to $DBversion done (Koha 16.06 - starting a new dev line at KohaCon16 in Thessaloniki, Greece! Koha is great!)\n";
- SetVersion($DBversion);
+ print "Upgrade to $DBversion done (Koha 16.06 - starting a new dev line at KohaCon16 in Thessaloniki, Greece! Koha is great!)\n";
+ SetVersion($DBversion);
}
$DBversion = "16.06.00.001";
if ( CheckVersion($DBversion) ) {
- $dbh->do(q{
- UPDATE accountlines SET accounttype='HE', description=itemnumber WHERE (description REGEXP '^Hold waiting too long [0-9]+') AND accounttype='F';
+ $dbh->do(q{
+ UPDATE accountlines SET accounttype='HE', description=itemnumber WHERE (description REGEXP '^Hold waiting too long [0-9]+') AND accounttype='F';
});
- print "Upgrade to $DBversion done (Bug 16200 - 'Hold waiting too long' fee has a translation problem)\n";
- SetVersion($DBversion);
+
+ print "Upgrade to $DBversion done (Bug 16200 - 'Hold waiting too long' fee has a translation problem)\n";
+ SetVersion($DBversion);
+}
+
+$DBversion = "16.06.00.002";
+if ( CheckVersion($DBversion) ) {
+ $dbh->do(q{
+ ALTER TABLE borrowers
+ ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
+ ON UPDATE CURRENT_TIMESTAMP
+ AFTER privacy_guarantor_checkouts;
+ });
+ $dbh->do(q{
+ ALTER TABLE deletedborrowers
+ ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
+ ON UPDATE CURRENT_TIMESTAMP
+ AFTER privacy_guarantor_checkouts;
+ });
+
+ print "Upgrade to $DBversion done (Bug 10459 - borrowers should have a timestamp)\n";
+ SetVersion($DBversion);
}