1 files changed, 6 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql
index d67ca6c88..104b44481 100644
--- a/src/odbc/mysql.sql
+++ b/src/odbc/mysql.sql
@@ -238,3 +238,9 @@ CREATE TABLE muc_registered (
 
 CREATE INDEX i_muc_registered_nick USING BTREE ON muc_registered(nick(75));
 CREATE UNIQUE INDEX i_muc_registered_jid_host USING BTREE ON muc_registered(jid(75), host(75));
+
+CREATE TABLE motd (
+    username varchar(250) PRIMARY KEY,
+    xml text,
+    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+) CHARACTER SET utf8;