update itemlost = 0 on seen items

diff --git a/update.sql b/update.sql
index ec84634..8164516 100644 (file)
--- 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 ;