1 files changed, 8 insertions, 0 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql
index c4f3d1f0..982df7ff 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -346,3 +346,11 @@ CREATE TABLE route (
 
 CREATE UNIQUE INDEX i_route ON route(domain(75), server_host(75), node(75), pid(75));
 CREATE INDEX i_route_domain ON route(domain(75));
+
+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));