diff options
| author | Badlop <badlop@process-one.net> | 2021-08-05 13:52:38 +0200 |
|---|---|---|
| committer | Badlop <badlop@process-one.net> | 2021-08-05 13:52:38 +0200 |
| commit | aefc374317860aa1e7fd1ed305cbf71b3ce132a8 (patch) | |
| tree | cb87d3929fc22dcbcbb692564541d1d32fb2a701 | |
| parent | Update tests after last commit (diff) | |
Fix typo when creating index (thanks to Millesimus)
Reference: https://github.com/processone/ejabberd/commit/95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a#r54157330
| -rw-r--r-- | sql/mysql.new.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index c6d74bb91..01aeffbc5 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -86,7 +86,7 @@ CREATE TABLE sr_user ( PRIMARY KEY (server_host(191), jid, grp) ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -CREATE UNIQUE INDEX i_sr_user_sh_jid_group ON sr_group(server_host(191), jid, grp); +CREATE UNIQUE INDEX i_sr_user_sh_jid_group ON sr_user(server_host(191), jid, grp); CREATE INDEX i_sr_user_sh_jid ON sr_user(server_host(191), jid); CREATE INDEX i_sr_user_sh_grp ON sr_user(server_host(191), grp); |