diff options
author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-31 08:16:28 +0300 |
---|---|---|
committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-31 08:16:28 +0300 |
commit | f449df161ad1dc4ac613377108b21e781ffc4cbd (patch) | |
tree | f3543cc4b598d0e9d82c902f00dfef1ba2aea0a3 /sql/mysql.sql | |
parent | Raise bad_node instead of node_down for consistency reason (diff) |
Add SQL as mod_proxy65 RAM backend
Diffstat (limited to '')
-rw-r--r-- | sql/mysql.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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)); |