diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-29 12:58:01 +0300 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-29 12:58:01 +0300 |
| commit | 12e01a51196a656955d79869a05ec3db1fc2f9bb (patch) | |
| tree | fa10a2a65f65f1ec51faae466cdec594bb68375f /sql/mysql.sql | |
| parent | Add Redis as mod_bosh RAM backend (diff) | |
Add SQL as mod_muc RAM backend
Diffstat (limited to '')
| -rw-r--r-- | sql/mysql.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index 982df7ff5..edd205f0d 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -291,6 +291,27 @@ CREATE TABLE muc_registered ( CREATE INDEX i_muc_registered_nick USING BTREE ON muc_registered(nick(75)); CREATE UNIQUE INDEX i_muc_registered_jid_host USING BTREE ON muc_registered(jid(75), host(75)); +CREATE TABLE muc_online_room ( + name text NOT NULL, + host text NOT NULL, + node text NOT NULL, + pid text NOT NULL +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +CREATE UNIQUE INDEX i_muc_online_room_name_host USING BTREE ON muc_online_room(name(75), host(75)); + +CREATE TABLE muc_online_users ( + username text NOT NULL, + server text NOT NULL, + resource text NOT NULL, + name text NOT NULL, + host text NOT NULL, + node text NOT NULL +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +CREATE UNIQUE INDEX i_muc_online_users USING BTREE ON muc_online_users(username(75), server(75), resource(75), name(75), host(75)); +CREATE INDEX i_muc_online_users_us USING BTREE ON muc_online_users(username(75), server(75)); + CREATE TABLE irc_custom ( jid text NOT NULL, host text NOT NULL, |