diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql.new.sql | 2 | ||||
| -rw-r--r-- | sql/pg.new.sql | 6 |
2 files changed, 7 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); diff --git a/sql/pg.new.sql b/sql/pg.new.sql index 8a35ec6c9..b3473a1a0 100644 --- a/sql/pg.new.sql +++ b/sql/pg.new.sql @@ -156,6 +156,12 @@ -- CREATE INDEX i_sm_sh_username ON sm USING btree (server_host, username); -- ALTER TABLE sm ALTER COLUMN server_host DROP DEFAULT; +-- ALTER TABLE push_session ADD COLUMN server_host text NOT NULL DEFAULT '<HOST>'; +-- DROP INDEX i_push_usn; +-- DROP INDEX i_push_ut; +-- ALTER TABLE push_session ADD PRIMARY KEY (server_host, username, timestamp); +-- CREATE UNIQUE INDEX i_push_session_susn ON push_session USING btree (server_host, username, service, node); + CREATE TABLE users ( username text NOT NULL, |