1 files changed, 7 insertions, 0 deletions
diff --git a/sql/pgsql/mod_announce.sql b/sql/pgsql/mod_announce.sql
new file mode 100644
index 000000000..16b2148e1
--- /dev/null
+++ b/sql/pgsql/mod_announce.sql
@@ -0,0 +1,7 @@
+CREATE TABLE motd (
+    username text NOT NULL,
+    server_host text NOT NULL,
+    xml text,
+    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY (server_host, username)
+);