diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-28 20:33:57 +0300 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-28 20:33:57 +0300 |
| commit | e5815553cbaa0a2ca829a6b7fdb799ee820fa967 (patch) | |
| tree | 7ff3b0408ba05f9c14cd842578aa81f27b1de8cf /sql | |
| parent | Add Redis as router RAM backend (diff) | |
Add SQL as mod_bosh RAM backend
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/lite.sql | 8 | ||||
| -rw-r--r-- | sql/mssql.sql | 10 | ||||
| -rw-r--r-- | sql/mysql.sql | 8 | ||||
| -rw-r--r-- | sql/pg.sql | 8 |
4 files changed, 34 insertions, 0 deletions
diff --git a/sql/lite.sql b/sql/lite.sql index bc6a6e706..c17d80ec5 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 06f73aea9..7535da5ac 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 c4f3d1f02..982df7ff5 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 fac806e8a..8a8b77b1f 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); |