From 842079426ac0b36ed6187faed231ecba15132b41 Mon Sep 17 00:00:00 2001 From: Jeffrey Armstrong Date: Tue, 14 Sep 2021 14:02:14 -0400 Subject: Additional fixes to checkin sql --- captain/db.f90 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/captain/db.f90 b/captain/db.f90 index 42f1bfc..b9d1e61 100644 --- a/captain/db.f90 +++ b/captain/db.f90 @@ -1210,7 +1210,7 @@ contains call date_and_time(values=right_now) if(stmt%prepare(db, & - "INSERT OR UPDATE INTO checkin(player, year, month, day, hour, minute, second, platform)" & + "INSERT OR REPLACE INTO checkin(player, year, month, day, hour, minute, second, os)" & //" VALUES(?, ?, ?, ?, ?, ?, ?, ?)") & == SQLITE_OK) & then -- cgit v1.2.3