From f449df161ad1dc4ac613377108b21e781ffc4cbd Mon Sep 17 00:00:00 2001 From: Evgeniy Khramtsov Date: Fri, 31 Mar 2017 08:16:28 +0300 Subject: Add SQL as mod_proxy65 RAM backend --- sql/lite.sql | 12 ++++++++++++ sql/mysql.sql | 12 ++++++++++++ sql/pg.sql | 12 ++++++++++++ 3 files changed, 36 insertions(+) (limited to 'sql') diff --git a/sql/lite.sql b/sql/lite.sql index ddfb91ff0..1d057407f 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -369,3 +369,15 @@ CREATE TABLE carboncopy ( CREATE UNIQUE INDEX i_carboncopy_ur ON carboncopy (username, resource); CREATE INDEX i_carboncopy_user ON carboncopy (username); + +CREATE TABLE proxy65 ( + sid text NOT NULL, + pid_t text NOT NULL, + pid_i text NOT NULL, + node_t text NOT NULL, + node_i text NOT NULL, + jid_i text NOT NULL +); + +CREATE UNIQUE INDEX i_proxy65_sid ON proxy65 (sid); +CREATE INDEX i_proxy65_jid ON proxy65 (jid_i); diff --git a/sql/mysql.sql b/sql/mysql.sql index e09c39be5..c591cb761 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -385,3 +385,15 @@ CREATE TABLE carboncopy ( CREATE UNIQUE INDEX i_carboncopy_ur ON carboncopy (username(75), resource(75)); CREATE INDEX i_carboncopy_user ON carboncopy (username(75)); + +CREATE TABLE proxy65 ( + sid text NOT NULL, + pid_t text NOT NULL, + pid_i text NOT NULL, + node_t text NOT NULL, + node_i text NOT NULL, + jid_i text NOT NULL +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +CREATE UNIQUE INDEX i_proxy65_sid ON proxy65 (sid(191)); +CREATE INDEX i_proxy65_jid ON proxy65 (jid_i(191)); diff --git a/sql/pg.sql b/sql/pg.sql index 796391c74..539c1263a 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -389,3 +389,15 @@ CREATE TABLE carboncopy ( CREATE UNIQUE INDEX i_carboncopy_ur ON carboncopy USING btree (username, resource); CREATE INDEX i_carboncopy_user ON carboncopy USING btree (username); + +CREATE TABLE proxy65 ( + sid text NOT NULL, + pid_t text NOT NULL, + pid_i text NOT NULL, + node_t text NOT NULL, + node_i text NOT NULL, + jid_i text NOT NULL +); + +CREATE UNIQUE INDEX i_proxy65_sid ON proxy65 USING btree (sid); +CREATE INDEX i_proxy65_jid ON proxy65 USING btree (jid_i); -- cgit v1.2.3