timekeeper

commit 67cd991b0865b05f9e33e5172d1d6dc5b07164de
parent 59aad7bea1837109ab85a9256a4ccf7d463e2629
Author: Jacob R. Edwards <jacob@jacobedwards.org>
Date:   Wed,  3 Apr 2024 18:54:58 -0700

Fix times table userid definition

The userid should not be null, so use NOTNULL.

Diffstat:
M
stmt.c
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/stmt.c b/stmt.c
@@ -19,7 +19,7 @@ struct sqlbox_pstmt pstmts[] = {
 	},
 	[StmtInit2] = { .stmt =
 		"CREATE TABLE IF NOT EXISTS times (\n"
-		"	userid TEXT REFERENCES auth (hash),\n"
+		"	userid TEXT REFERENCES auth (hash) NOT NULL,\n"
 		"	period INTEGER,\n"
 		"	entry INTEGER DEFAULT 0 NOT NULL,\n"
 		"	start INTEGER,\n"