Add SQL as mod_bosh RAM backend

1 files changed, 8 insertions, 0 deletions

diff --git a/sql/pg.sql b/sql/pg.sql
index fac806e8..8a8b77b1 100644
--- a/sql/pg.sql
+++ b/sql/pg.sql
@@ -350,3 +350,11 @@ CREATE TABLE route (
 
 CREATE UNIQUE INDEX i_route ON route USING btree (domain, server_host, node, pid);
 CREATE INDEX i_route_domain ON route USING btree (domain);
+
+CREATE TABLE bosh (
+    sid text NOT NULL,
+    node text NOT NULL,
+    pid text NOT NULL
+);
+
+CREATE UNIQUE INDEX i_bosh_sid ON bosh USING btree (sid);