1 files changed, 7 insertions, 0 deletions
diff --git a/sql/mysql/mod_bosh.sql b/sql/mysql/mod_bosh.sql
new file mode 100644
index 000000000..03aa33bc0
--- /dev/null
+++ b/sql/mysql/mod_bosh.sql
@@ -0,0 +1,7 @@
+CREATE TABLE bosh (
+    sid text NOT NULL,
+    node text NOT NULL,
+    pid text NOT NULL
+) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+
+CREATE UNIQUE INDEX i_bosh_sid ON bosh(sid(75));