diff options
Diffstat (limited to 'sql/pg.sql')
-rw-r--r-- | sql/pg.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql index 8a8b77b1f..6c099fc6b 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -293,6 +293,27 @@ CREATE TABLE muc_registered ( CREATE INDEX i_muc_registered_nick ON muc_registered USING btree (nick); CREATE UNIQUE INDEX i_muc_registered_jid_host ON muc_registered USING btree (jid, host); +CREATE TABLE muc_online_room ( + name text NOT NULL, + host text NOT NULL, + node text NOT NULL, + pid text NOT NULL +); + +CREATE UNIQUE INDEX i_muc_online_room_name_host ON muc_online_room USING btree (name, host); + +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 +); + +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 irc_custom ( jid text NOT NULL, host text NOT NULL, |