diff options
Diffstat (limited to 'sql/lite.new.sql')
| -rw-r--r-- | sql/lite.new.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/lite.new.sql b/sql/lite.new.sql index be971c8d8..96c880358 100644 --- a/sql/lite.new.sql +++ b/sql/lite.new.sql @@ -73,6 +73,8 @@ CREATE TABLE sr_group ( PRIMARY KEY (server_host, name) ); +CREATE UNIQUE INDEX i_sr_group_sh_name ON sr_group (server_host, name); + CREATE TABLE sr_user ( jid text NOT NULL, server_host text NOT NULL, @@ -81,6 +83,7 @@ CREATE TABLE sr_user ( PRIMARY KEY (server_host, jid, grp) ); +CREATE UNIQUE INDEX i_sr_user_sh_jid_grp ON sr_user (server_host, jid, grp); CREATE INDEX i_sr_user_sh_jid ON sr_user (server_host, jid); CREATE INDEX i_sr_user_sh_grp ON sr_user (server_host, grp); |