From 1c0c1523c22407de05ba125d43bd3a588fd4a00f Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Mon, 2 Dec 2019 21:01:57 -0500 Subject: Make user and host NOT NULL as well Since involving NULLs in comparisons is awkward, I think I'll just use "*" for unknowns. --- database.h | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/database.h b/database.h index b98721b..ef62dde 100644 --- a/database.h +++ b/database.h @@ -120,8 +120,8 @@ static const char *InitSQL = { "CREATE TABLE names (" "id INTEGER PRIMARY KEY," "nick TEXT NOT NULL," - "user TEXT," - "host TEXT," + "user TEXT NOT NULL," + "host TEXT NOT NULL," "UNIQUE (nick, user, host)" ");" "CREATE TABLE events (" -- cgit 1.4.1