From 109ed8f2f666a6a0911e8222db529e2d377aec2b Mon Sep 17 00:00:00 2001 From: Evgeny Khramtsov Date: Sat, 1 Dec 2018 13:33:44 +0300 Subject: 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 --- sql/mssql.sql | 13 ------------- 1 file changed, 13 deletions(-) (limited to 'sql/mssql.sql') diff --git a/sql/mssql.sql b/sql/mssql.sql index 04798ee51..9393a19c1 100644 --- a/sql/mssql.sql +++ b/sql/mssql.sql @@ -531,19 +531,6 @@ CREATE TABLE [dbo].[bosh] ( )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ); -CREATE TABLE [dbo].[carboncopy] ( - [username] [varchar] (255) NOT NULL, - [resource] [varchar] (255) NOT NULL, - [namespace] [varchar] (255) NOT NULL, - [node] [varchar] (255) NOT NULL -); - -CREATE UNIQUE CLUSTERED INDEX [carboncopy_ur] ON [carboncopy] (username, resource) -WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON); - -CREATE INDEX [carboncopy_user] ON [carboncopy] (username) -WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON); - CREATE TABLE [dbo].[push_session] ( [username] [varchar] (255) NOT NULL, [timestamp] [bigint] NOT NULL, -- cgit v1.2.3