From: Dobrica Pavlinusic Date: Sun, 19 Jun 2011 11:23:09 +0000 (+0200) Subject: datelastseen X-Git-Url: http://git.rot13.org/?p=ferlib2koha.git;a=commitdiff_plain;h=f3367b57e75b20fc981722fee8ebf4d16915a548 datelastseen --- diff --git a/ferlib2koha.pl b/ferlib2koha.pl index aa6ef62..fdff596 100755 --- a/ferlib2koha.pl +++ b/ferlib2koha.pl @@ -255,7 +255,8 @@ update items set datelastseen = datelastborrowed ; update items join old_issues on items.itemnumber=old_issues.itemnumber -set datelastseen = returndate where returndate > datelastseen +set datelastseen = returndate +where returndate > datelastseen or datelastseen is null ; update old_issues set timestamp = returndate });