4 files changed, 34 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);
diff --git a/sql/mssql.sql b/sql/mssql.sql
index 06f73aea..7535da5a 100644
--- a/sql/mssql.sql
+++ b/sql/mssql.sql
@@ -504,3 +504,13 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW
 
 CREATE INDEX [route_domain] ON [route] (domain)
 WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON);
+
+CREATE TABLE [dbo].[bosh] (
+    [sid] [varchar] (255) NOT NULL,
+    [node] [varchar] (255) NOT NULL,
+    [pid] [varchar](100) NOT NULL
+ CONSTRAINT [bosh_PRIMARY] PRIMARY KEY CLUSTERED 
+(
+        [sid] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+) TEXTIMAGE_ON [PRIMARY];
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));
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);