1 files changed, 8 insertions, 0 deletions
diff --git a/sql/lite.sql b/sql/lite.sql
index bc6a6e70..c17d80ec 100644
--- a/sql/lite.sql
+++ b/sql/lite.sql
@@ -330,3 +330,11 @@ CREATE TABLE route (
 
 CREATE UNIQUE INDEX i_route ON route(domain, server_host, node, pid);
 CREATE INDEX i_route_domain ON route(domain);
+
+CREATE TABLE bosh (
+    sid text NOT NULL,
+    node text NOT NULL,
+    pid text NOT NULL
+);
+
+CREATE UNIQUE INDEX i_bosh_sid ON bosh(sid);