summary refs log tree commit diff
path: root/database.h
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--database.h7
1 files changed, 7 insertions, 0 deletions
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,