ppbbww

commit 897dc2fb4dcc80db65ef52a2b88b23f242f32031
parent 53fe4cadb08339d37771c9b17fcc5405cf974d64
Author: david cochran <about.trout@gmail.com>
Date:   Thu, 27 Mar 2025 21:05:54 -0700

stop clobbering matches in the archive

Diffstat:
M
ppboatwatch/archive.py
 | 
4
++--

1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/ppboatwatch/archive.py b/ppboatwatch/archive.py
@@ -6,7 +6,7 @@ from contextlib import closing
 
 INIT_TABLES_SQL = """
 CREATE TABLE IF NOT EXISTS matches (
-    ts INTEGER PRIMARY KEY,
+    ts,
     filename,
     label,
     score,
@@ -15,7 +15,7 @@ CREATE TABLE IF NOT EXISTS matches (
 )"""
 
 ADD_MATCH_SQL = """
-INSERT OR IGNORE INTO matches (ts, filename, label, score, x0, y0, x1, y1)
+INSERT INTO matches (ts, filename, label, score, x0, y0, x1, y1)
 VALUES (?, ?, ?, ?, ?, ?, ?, ?)"""
 
 LIST_MATCHES_SQL = """