From f3367b57e75b20fc981722fee8ebf4d16915a548 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Sun, 19 Jun 2011 13:23:09 +0200 Subject: [PATCH] datelastseen --- ferlib2koha.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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 }); -- 2.20.1