summaryrefslogtreecommitdiff
path: root/sql/pg.new.sql
diff options
context:
space:
mode:
authorEvgeny Khramtsov <ekhramtsov@process-one.net>2018-12-01 13:33:44 +0300
committerEvgeny Khramtsov <ekhramtsov@process-one.net>2018-12-01 13:33:44 +0300
commit109ed8f2f666a6a0911e8222db529e2d377aec2b (patch)
tree0aa8a15915513ac666ecca2b079a0ff897271555 /sql/pg.new.sql
parentejabberd_s2s_in: Check for subdomain configuration (diff)
Keep info about carbons inside session table
Accordingly, Mnesia/SQL/Riak table 'carboncopy' is not used anymore and can be safely removed. As a consequence, the commit deprecates the following options of mod_carboncopy: - ram_db_type - use_cache - cache_size - cache_missed - cache_life_time Fixes #2663
Diffstat (limited to 'sql/pg.new.sql')
-rw-r--r--sql/pg.new.sql18
1 files changed, 0 insertions, 18 deletions
diff --git a/sql/pg.new.sql b/sql/pg.new.sql
index 928d74db..6244eeea 100644
--- a/sql/pg.new.sql
+++ b/sql/pg.new.sql
@@ -156,13 +156,6 @@
-- CREATE INDEX i_sm_sh_username ON sm USING btree (server_host, username);
-- ALTER TABLE sm ALTER COLUMN server_host DROP DEFAULT;
--- ALTER TABLE carboncopy ADD COLUMN server_host text NOT NULL DEFAULT '<HOST>';
--- DROP INDEX i_carboncopy_ur;
--- DROP INDEX i_carboncopy_user;
--- ALTER TABLE carboncopy ADD PRIMARY KEY (server_host, username, resource);
--- CREATE INDEX i_carboncopy_sh_user ON carboncopy USING btree (server_host, username);
--- ALTER TABLE carboncopy ALTER COLUMN server_host DROP DEFAULT;
-
CREATE TABLE users (
username text NOT NULL,
@@ -555,17 +548,6 @@ CREATE TABLE bosh (
CREATE UNIQUE INDEX i_bosh_sid ON bosh USING btree (sid);
-CREATE TABLE carboncopy (
- username text NOT NULL,
- server_host text NOT NULL,
- resource text NOT NULL,
- namespace text NOT NULL,
- node text NOT NULL,
- PRIMARY KEY (server_host, username, resource)
-);
-
-CREATE INDEX i_carboncopy_sh_user ON carboncopy USING btree (server_host, username);
-
CREATE TABLE proxy65 (
sid text NOT NULL,
pid_t text NOT NULL,