From e94eb1af0cbbb1c89332b87e6ee35ca1f4658535 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Fri, 2 Jul 2021 16:13:48 +0200 Subject: remove mail and conv tables from install SQL schemas --- install/schema_mysql.sql | 59 ------------------------------------------------ 1 file changed, 59 deletions(-) (limited to 'install/schema_mysql.sql') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 17ad1767e..8267d17f7 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -366,20 +366,6 @@ CREATE TABLE IF NOT EXISTS `config` ( UNIQUE KEY `access` (`cat`,`k`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -CREATE TABLE IF NOT EXISTS `conv` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `guid` char(191) NOT NULL DEFAULT '', - `recips` mediumtext NOT NULL, - `uid` int(11) NOT NULL DEFAULT 0 , - `creator` char(191) NOT NULL DEFAULT '', - `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `subject` mediumtext NOT NULL, - PRIMARY KEY (`id`), - KEY `created` (`created`), - KEY `updated` (`updated`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - CREATE TABLE IF NOT EXISTS `dreport` ( `dreport_id` int(11) NOT NULL AUTO_INCREMENT, `dreport_channel` int(11) NOT NULL DEFAULT 0 , @@ -730,51 +716,6 @@ CREATE TABLE IF NOT EXISTS listeners ( KEY ltype (ltype) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -CREATE TABLE IF NOT EXISTS `mail` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `convid` int(10) unsigned NOT NULL DEFAULT 0 , - `conv_guid` char(191) NOT NULL DEFAULT '', - `mail_flags` int(10) unsigned NOT NULL DEFAULT 0 , - `from_xchan` char(191) NOT NULL DEFAULT '', - `to_xchan` char(191) NOT NULL DEFAULT '', - `account_id` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_id` int(10) unsigned NOT NULL DEFAULT 0 , - `mail_mimetype` char(64) NOT NULL DEFAULT 'text/bbcode', - `title` text NOT NULL, - `body` mediumtext NOT NULL, - `sig` text NOT NULL, - `attach` mediumtext NOT NULL, - `mid` char(191) NOT NULL DEFAULT '', - `parent_mid` char(191) NOT NULL DEFAULT '', - `mail_deleted` tinyint(4) NOT NULL DEFAULT 0 , - `mail_replied` tinyint(4) NOT NULL DEFAULT 0 , - `mail_isreply` tinyint(4) NOT NULL DEFAULT 0 , - `mail_seen` tinyint(4) NOT NULL DEFAULT 0 , - `mail_recalled` tinyint(4) NOT NULL DEFAULT 0 , - `mail_obscured` smallint(6) NOT NULL DEFAULT 0 , - `mail_raw` tinyint(4) NOT NULL DEFAULT 0 , - `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - PRIMARY KEY (`id`), - KEY `created` (`created`), - KEY `mail_flags` (`mail_flags`), - KEY `account_id` (`account_id`), - KEY `channel_id` (`channel_id`), - KEY `from_xchan` (`from_xchan`), - KEY `to_xchan` (`to_xchan`), - KEY `mid` (`mid`), - KEY `parent_mid` (`parent_mid`), - KEY `expires` (`expires`), - KEY `convid` (`convid`), - KEY `conv_guid` (`conv_guid`), - KEY `mail_deleted` (`mail_deleted`), - KEY `mail_replied` (`mail_replied`), - KEY `mail_isreply` (`mail_isreply`), - KEY `mail_seen` (`mail_seen`), - KEY `mail_recalled` (`mail_recalled`), - KEY `mail_obscured` (`mail_obscured`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - CREATE TABLE IF NOT EXISTS `menu` ( `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `menu_channel_id` int(10) unsigned NOT NULL DEFAULT 0 , -- cgit v1.2.3