From 3a5d2dbed8f089b112eba7998e2ad0d2508f01cb Mon Sep 17 00:00:00 2001 From: Evgeniy Khramtsov Date: Wed, 20 Jun 2018 12:27:44 +0300 Subject: Move mod_irc to ejabberd-contrib --- sql/lite.new.sql | 10 ---------- sql/lite.sql | 9 --------- sql/mssql.sql | 10 ---------- sql/mysql.new.sql | 10 ---------- sql/mysql.sql | 9 --------- sql/pg.new.sql | 13 ------------- sql/pg.sql | 9 --------- 7 files changed, 70 deletions(-) (limited to 'sql') diff --git a/sql/lite.new.sql b/sql/lite.new.sql index b1ff14fd1..d58d04c77 100644 --- a/sql/lite.new.sql +++ b/sql/lite.new.sql @@ -329,16 +329,6 @@ CREATE TABLE muc_room_subscribers ( CREATE INDEX i_muc_room_subscribers_host_jid ON muc_room_subscribers(host, jid); CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid ON muc_room_subscribers(host, room, jid); -CREATE TABLE irc_custom ( - jid text NOT NULL, - host text NOT NULL, - server_host text NOT NULL, - data text NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP -); - -CREATE UNIQUE INDEX i_irc_custom_jid_host ON irc_custom (jid, host); - CREATE TABLE motd ( username text NOT NULL, server_host text NOT NULL, diff --git a/sql/lite.sql b/sql/lite.sql index eb6b2ab4c..abb25d5b4 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -302,15 +302,6 @@ CREATE TABLE muc_room_subscribers ( CREATE INDEX i_muc_room_subscribers_host_jid ON muc_room_subscribers(host, jid); CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid ON muc_room_subscribers(host, room, jid); -CREATE TABLE irc_custom ( - jid text NOT NULL, - host text NOT NULL, - data text NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP -); - -CREATE UNIQUE INDEX i_irc_custom_jid_host ON irc_custom (jid, host); - CREATE TABLE motd ( username text PRIMARY KEY, xml text, diff --git a/sql/mssql.sql b/sql/mssql.sql index 648dfb9ed..c6a89311f 100644 --- a/sql/mssql.sql +++ b/sql/mssql.sql @@ -72,16 +72,6 @@ CREATE TABLE [dbo].[caps_features] ( CREATE CLUSTERED INDEX [caps_features_node_subnode] ON [caps_features] (node, subnode) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON); -CREATE TABLE [dbo].[irc_custom] ( - [jid] [varchar] (255) NOT NULL, - [host] [varchar] (255) NOT NULL, - [data] [text] NOT NULL, - [created_at] [datetime] NOT NULL DEFAULT GETDATE() -) TEXTIMAGE_ON [PRIMARY]; - -CREATE UNIQUE CLUSTERED INDEX [irc_custom_jid_host] ON [irc_custom] (jid, host) -WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON); - CREATE TABLE [dbo].[last] ( [username] [varchar] (250) NOT NULL, [seconds] [text] NOT NULL, diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index 395a8aa64..544135e82 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -345,16 +345,6 @@ CREATE TABLE muc_room_subscribers ( CREATE INDEX i_muc_room_subscribers_host_jid USING BTREE ON muc_room_subscribers(host, jid); -CREATE TABLE irc_custom ( - jid text NOT NULL, - host text NOT NULL, - server_host text NOT NULL, - data text NOT NULL, - created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP -) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - -CREATE UNIQUE INDEX i_irc_custom_jid_host USING BTREE ON irc_custom(jid(75), host(75)); - CREATE TABLE motd ( username varchar(191) NOT NULL, server_host text NOT NULL, diff --git a/sql/mysql.sql b/sql/mysql.sql index 1d7e4c4e7..7894fa5b7 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -318,15 +318,6 @@ CREATE TABLE muc_room_subscribers ( CREATE INDEX i_muc_room_subscribers_host_jid USING BTREE ON muc_room_subscribers(host, jid); -CREATE TABLE irc_custom ( - jid text NOT NULL, - host text NOT NULL, - data text NOT NULL, - created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP -) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - -CREATE UNIQUE INDEX i_irc_custom_jid_host USING BTREE ON irc_custom(jid(75), host(75)); - CREATE TABLE motd ( username varchar(191) PRIMARY KEY, xml text, diff --git a/sql/pg.new.sql b/sql/pg.new.sql index 82fafa64c..928d74db0 100644 --- a/sql/pg.new.sql +++ b/sql/pg.new.sql @@ -144,9 +144,6 @@ -- ALTER TABLE muc_online_users ADD COLUMN server_host text NOT NULL DEFAULT ''; -- ALTER TABLE muc_online_users ALTER COLUMN server_host DROP DEFAULT; --- ALTER TABLE irc_custom ADD COLUMN server_host text NOT NULL DEFAULT ''; --- ALTER TABLE irc_custom ALTER COLUMN server_host DROP DEFAULT; - -- ALTER TABLE motd ADD COLUMN server_host text NOT NULL DEFAULT ''; -- ALTER TABLE motd DROP CONSTRAINT motd_pkey; -- ALTER TABLE motd ADD PRIMARY KEY (server_host, username); @@ -498,16 +495,6 @@ CREATE TABLE muc_room_subscribers ( CREATE INDEX i_muc_room_subscribers_host_jid ON muc_room_subscribers USING btree (host, jid); CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid ON muc_room_subscribers USING btree (host, room, jid); -CREATE TABLE irc_custom ( - jid text NOT NULL, - host text NOT NULL, - server_host text NOT NULL, - data text NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT now() -); - -CREATE UNIQUE INDEX i_irc_custom_jid_host ON irc_custom USING btree (jid, host); - CREATE TABLE motd ( username text NOT NULL, server_host text NOT NULL, diff --git a/sql/pg.sql b/sql/pg.sql index 4863cb721..a0cfe0ea6 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -320,15 +320,6 @@ CREATE TABLE muc_room_subscribers ( CREATE INDEX i_muc_room_subscribers_host_jid ON muc_room_subscribers USING btree (host, jid); CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid ON muc_room_subscribers USING btree (host, room, jid); -CREATE TABLE irc_custom ( - jid text NOT NULL, - host text NOT NULL, - data text NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT now() -); - -CREATE UNIQUE INDEX i_irc_custom_jid_host ON irc_custom USING btree (jid, host); - CREATE TABLE motd ( username text PRIMARY KEY, xml text, -- cgit v1.2.3