diff options
| author | June McEnroe <june@causal.agency> | 2019-12-02 21:01:57 -0500 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2019-12-02 21:01:57 -0500 |
| commit | 1c0c1523c22407de05ba125d43bd3a588fd4a00f (patch) | |
| tree | 710e72a7f2301097bda66b88ba237700feb57282 | |
| parent | Enable foreign key enforcement (diff) | |
| download | litterbox-1c0c1523c22407de05ba125d43bd3a588fd4a00f.tar.gz litterbox-1c0c1523c22407de05ba125d43bd3a588fd4a00f.zip | |
Make user and host NOT NULL as well
Since involving NULLs in comparisons is awkward, I think I'll just use "*" for unknowns.
| -rw-r--r-- | database.h | 4 |
1 files 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 (" |