diff options
author | Paweł Chmielowski <pchmielowski@process-one.net> | 2021-05-18 18:29:32 +0200 |
---|---|---|
committer | Paweł Chmielowski <pchmielowski@process-one.net> | 2021-05-18 18:29:32 +0200 |
commit | 95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a (patch) | |
tree | 67b20230cac30258296cd4dc8bb1a08816c0d49a /sql/pg.new.sql | |
parent | New simple webadmin pages to view mnesia tables information and content (diff) |
Add missing indexes to sql sr_group tables
Diffstat (limited to 'sql/pg.new.sql')
-rw-r--r-- | sql/pg.new.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/pg.new.sql b/sql/pg.new.sql index d5b1f16bf..8a35ec6c9 100644 --- a/sql/pg.new.sql +++ b/sql/pg.new.sql @@ -218,6 +218,8 @@ CREATE TABLE sr_group ( PRIMARY KEY (server_host, name) ); +CREATE UNIQUE INDEX i_sr_group_sh_name ON sr_group USING btree (server_host, name); + CREATE TABLE sr_user ( jid text NOT NULL, server_host text NOT NULL, @@ -226,6 +228,7 @@ CREATE TABLE sr_user ( PRIMARY KEY (server_host, jid, grp) ); +CREATE UNIQUE INDEX i_sr_user_sh_jid_grp ON sr_user USING btree (server_host, jid, grp); CREATE INDEX i_sr_user_sh_jid ON sr_user USING btree (server_host, jid); CREATE INDEX i_sr_user_sh_grp ON sr_user USING btree (server_host, grp); |