aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorbadlop <badlop@process-one.net>2021-08-16 12:47:45 +0200
committerGitHub <noreply@github.com>2021-08-16 12:47:45 +0200
commit545a2f0097830c2732d5432eeb8d1d97cfdb8ccb (patch)
tree620c0e6f3b2655fbd722a057d2d73de1f74fe048
parentmod_mam_sql: Remove duplicated functions (diff)
parentAdd missing SQL migration for table push_session (diff)
Merge pull request #3656 from pitchum/master
Add missing pgsql migration for table push_session
-rw-r--r--sql/pg.new.sql6
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,