diff options
| author | badlop <badlop@process-one.net> | 2021-08-16 12:47:45 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-08-16 12:47:45 +0200 |
| commit | 545a2f0097830c2732d5432eeb8d1d97cfdb8ccb (patch) | |
| tree | 620c0e6f3b2655fbd722a057d2d73de1f74fe048 /sql | |
| parent | mod_mam_sql: Remove duplicated functions (diff) | |
| parent | Add missing SQL migration for table push_session (diff) | |
Merge pull request #3656 from pitchum/master
Add missing pgsql migration for table push_session
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/pg.new.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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, |