From a850d03599e3f90ee16f78814c702eabae4416f2 Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Wed, 25 Dec 2019 17:34:19 -0500 Subject: Insert MOTDs into the database --- database.h | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'database.h') diff --git a/database.h b/database.h index 3d88757..fa0dc10 100644 --- a/database.h +++ b/database.h @@ -210,6 +210,13 @@ static inline int dbVersion(void) { static const char *InitSQL = SQL( BEGIN TRANSACTION; + CREATE TABLE motds ( + time DATETIME NOT NULL, + network TEXT NOT NULL, + motd TEXT NOT NULL, + UNIQUE (network, motd) + ); + CREATE TABLE contexts ( context INTEGER PRIMARY KEY, network TEXT NOT NULL, -- cgit 1.4.1