From 795301860f3a2a36e66396f2c57552f16d5c170b Mon Sep 17 00:00:00 2001 From: louie Date: Sun, 2 Jul 2023 17:16:59 -0700 Subject: Use 'struct tm' for date in entries --- src/db/sqlite3/db.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/db/sqlite3') diff --git a/src/db/sqlite3/db.c b/src/db/sqlite3/db.c index dd46071..36981d4 100644 --- a/src/db/sqlite3/db.c +++ b/src/db/sqlite3/db.c @@ -52,7 +52,7 @@ int create_tables(const char *path) { "CREATE TABLE IF NOT EXISTS 'Entry' (" "'ID' int NOT NULL PRIMARY KEY, " "'Group_ID' int NOT NULL, " // FIXME might want foreign key constraint - // TODO add due_date here once it's figure out + "'Due_date' date DEFAULT NULL, " "'Alt_due_date' varchar(%d) DEFAULT NULL, " "'Title' varchar(%d) NOT NULL, " "'Color' varchar(%d) DEFAULT NULL, " -- cgit