diff options
author | Christophe Romain <christophe.romain@process-one.net> | 2017-10-31 14:00:41 +0100 |
---|---|---|
committer | Christophe Romain <christophe.romain@process-one.net> | 2017-10-31 14:00:41 +0100 |
commit | 0452ffc1dfa613397aab0968f46f5f5b235a42c5 (patch) | |
tree | e9c72ee77ed142f40de4b44c3ec8fb620d151c33 /sql/pg.sql | |
parent | Enforce module_name/1 (diff) |
Optimize muc subscriptions handling
Diffstat (limited to '')
-rw-r--r-- | sql/pg.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql index db46111f5..fd56ba39d 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -308,6 +308,18 @@ CREATE TABLE muc_online_users ( CREATE UNIQUE INDEX i_muc_online_users ON muc_online_users USING btree (username, server, resource, name, host); CREATE INDEX i_muc_online_users_us ON muc_online_users USING btree (username, server); +CREATE TABLE muc_room_subscribers ( + room text NOT NULL, + host text NOT NULL, + jid text NOT NULL, + nick text NOT NULL, + nodes text NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT now() +); + +CREATE INDEX i_muc_room_subscribers_host_jid ON muc_room_subscribers USING btree (host, jid); +CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid ON muc_room_subscribers USING btree (host, room, jid); + CREATE TABLE irc_custom ( jid text NOT NULL, host text NOT NULL, |