From 03faab9e34cb2de043f6f63442a06da36e3aeaa7 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Wed, 10 Oct 2018 15:17:24 +0200 Subject: [PATCH] update itemlost = 0 on seen items --- update.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/update.sql b/update.sql index ec84634..8164516 100644 --- a/update.sql +++ b/update.sql @@ -7,5 +7,5 @@ inner join ( having datelastseen < max(date_scanned) ) as b on a.barcode = b.barcode -set a.datelastseen = b.date_scanned ; +set a.datelastseen = b.date_scanned, a.itemlost = 0 ; -- 2.20.1