ALTER TABLE `lh_chat_archive_range` CHANGE `range_from` `range_from` bigint(20) unsigned NOT NULL, CHANGE `range_to` `range_to` bigint(20) unsigned NOT NULL, CHANGE `last_id` `last_id` bigint(20) NOT NULL, CHANGE `first_id` `first_id` bigint(20) NOT NULL;
ALTER TABLE `lh_departament` ADD `max_ac_dep_mails` int(11) NOT NULL, COMMENT='';
ALTER TABLE `lh_departament` ADD `delay_before_assign_mail` int(11) NOT NULL, COMMENT='';
ALTER TABLE `lh_departament` ADD `max_active_mails` int(11) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_departament` ADD `max_timeout_seconds_mail` int(11) NOT NULL, COMMENT='';
ALTER TABLE `lh_departament` ADD `active_mail_balancing` tinyint(1) NOT NULL, COMMENT='';
ALTER TABLE `lh_transfer` ADD `transfer_scope` int(11) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_userdep` ADD `exclude_autoasign_mails` tinyint(1) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_userdep` ADD `last_accepted_mail` int(11) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_userdep` ADD `active_mails` int(11) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_userdep` ADD `pending_mails` int(11) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_userdep` ADD `max_mails` int(11) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_users` ADD `exclude_autoasign_mails` tinyint(1) NOT NULL DEFAULT '0', COMMENT='';
ALTER TABLE `lh_users` ADD `max_active_mails` int(11) NOT NULL DEFAULT '0', COMMENT='';
CREATE TABLE `lhc_mailconv_msg_open` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `opened_at` bigint(20) unsigned NOT NULL, `hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `hash` (`hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_mailing_list_recipient` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `mailing_list_id` bigint(20) unsigned NOT NULL, `mailing_recipient_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `mailing_list_id` (`mailing_list_id`), KEY `mailing_recipient_id` (`mailing_recipient_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_recipient` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `data` text COLLATE utf8mb4_unicode_ci NOT NULL, `disabled` tinyint(1) NOT NULL DEFAULT 0, `mailbox` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_1` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_2` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_3` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_4` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_5` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_6` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `email` (`email`), KEY `disabled` (`disabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_mailing_list` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_mailing_campaign_recipient` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `campaign_id` bigint(20) unsigned NOT NULL, `recipient_id` bigint(20) unsigned NOT NULL, `type` tinyint(1) NOT NULL DEFAULT 0, `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `mailbox` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 0, `opened_at` bigint(20) unsigned NOT NULL DEFAULT 0, `send_at` bigint(20) unsigned NOT NULL, `message_id` bigint(20) unsigned NOT NULL DEFAULT 0, `conversation_id` bigint(20) unsigned NOT NULL DEFAULT 0, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_1` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_2` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_3` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_4` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_5` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `attr_str_6` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `log` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `message_id` (`message_id`), KEY `campaign_id_status` (`campaign_id`,`status`), KEY `campaign_id_email` (`campaign_id`, `email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_mailing_campaign` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 0, `starts_at` bigint(20) unsigned NOT NULL, `enabled` tinyint(1) unsigned NOT NULL DEFAULT 0, `mailbox_id` bigint(20) unsigned NOT NULL, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `body_alt` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `subject` text COLLATE utf8mb4_unicode_ci NOT NULL, `as_active` tinyint(1) unsigned NOT NULL DEFAULT 0, `reply_email` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `reply_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,`owner_logic` tinyint(1) unsigned NOT NULL DEFAULT 0, `owner_user_id` bigint(20) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `status_enabled_starts_at` (`status`,`enabled`,`starts_at`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_personal_mailbox_group` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `mails` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `active` (`active`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lh_mail_archive_range` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `range_from` bigint(20) unsigned NOT NULL, `range_to` bigint(20) unsigned NOT NULL, `older_than` int(11) NOT NULL, `last_id` bigint(20) NOT NULL, `first_id` bigint(20) NOT NULL, `year_month` int(11) NOT NULL, `type` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_response_template_subject` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `template_id` bigint(20) unsigned NOT NULL, `subject_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `template_id` (`template_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_response_template_dep` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `template_id` bigint(20) NOT NULL, `dep_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `template_id` (`template_id`), KEY `dep_id` (`dep_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_oauth_ms` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `mailbox_id` bigint(20) unsigned NOT NULL, `oauth_uid` varchar(50) NOT NULL, `name` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `surname` varchar(200) NOT NULL, `display_name` varchar(200) NOT NULL, `txtSessionKey` varchar(255) NOT NULL, `txtCodeVerifier` varchar(255) NOT NULL, `dtExpires` bigint(20) unsigned NOT NULL, `txtRefreshToken` text NOT NULL, `txtToken` text NOT NULL, `txtIDToken` text NOT NULL, `completed` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `oauth_uid` (`oauth_uid`), KEY `user_id_completed` (`mailbox_id`,`completed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;
CREATE TABLE `lhc_mailconv_conversation` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `dep_id` int(11) unsigned NOT NULL, `user_id` int(11) unsigned NOT NULL, `status` int(11) unsigned NOT NULL, `subject` text COLLATE utf8mb4_unicode_ci NOT NULL, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `ctime` int(11) unsigned NOT NULL, `priority` int(11) NOT NULL DEFAULT 0, `priority_asc` int(11) NOT NULL DEFAULT 0, `from_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `from_address` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `lang` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, `last_message_id` bigint(20) unsigned NOT NULL, `message_id` bigint(20) unsigned NOT NULL, `udate` bigint(20) unsigned NOT NULL, `date` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `mailbox_id` bigint(20) unsigned NOT NULL, `opened_at` bigint(20) unsigned NOT NULL DEFAULT 0, `total_messages` int(11) unsigned NOT NULL, `match_rule_id` int(11) unsigned NOT NULL, `cls_time` int(11) unsigned NOT NULL, `pnd_time` int(11) unsigned NOT NULL, `wait_time` int(11) unsigned NOT NULL, `accept_time` int(11) unsigned NOT NULL, `response_time` int(11) NOT NULL, `interaction_time` int(11) NOT NULL, `lr_time` int(11) unsigned NOT NULL, `tslasign` int(11) unsigned NOT NULL, `start_type` tinyint(1) unsigned NOT NULL DEFAULT 0, `transfer_uid` int(11) unsigned NOT NULL, `remarks` text COLLATE utf8mb4_unicode_ci NOT NULL, `conv_duration` int(11) NOT NULL DEFAULT 0, `mail_variables` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `has_attachment` tinyint(1) unsigned NOT NULL DEFAULT 0, `pending_sync` tinyint(1) unsigned NOT NULL DEFAULT 0, `follow_up_id` bigint(20) unsigned NOT NULL DEFAULT 0, `undelivered` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `lang` (`lang`), KEY `from_address` (`from_address`), KEY `mailbox_id` (`mailbox_id`), KEY `dep_id` (`dep_id`), KEY `mailbox_id_status_udate` (`mailbox_id`,`status`,`udate`), KEY `status_priority` (`status`,`priority`), KEY `status_priority_asc` (`status`,`priority_asc`), KEY `has_attachment` (`has_attachment`), KEY `udate` (`udate`), KEY `user_id_status` (`user_id`,`status`), KEY `status_dep_id` (`status`,`dep_id`), KEY `undelivered` (`undelivered`), KEY `phone` (`phone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_file` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `message_id` bigint(20) unsigned NOT NULL, `size` int(11) unsigned NOT NULL, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `extension` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `attachment_id` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `file_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `file_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `content_id` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `disposition` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `conversation_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `message_id` (`message_id`), KEY `conversation_id` (`conversation_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_remarks` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(250) NOT NULL, `remarks` longtext NOT NULL, PRIMARY KEY (`id`), KEY `email` (`email`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_msg` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `priority` int(11) NOT NULL DEFAULT 0, `is_external` tinyint(1) unsigned NOT NULL DEFAULT 0, `message_hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, `status` int(11) unsigned NOT NULL,`opened_at` bigint(20) unsigned NOT NULL DEFAULT 0, `conversation_id_old` bigint(20) unsigned NOT NULL DEFAULT 0, `conversation_id` bigint(20) unsigned NOT NULL,`lang` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `message_id` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `in_reply_to` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` text COLLATE utf8mb4_unicode_ci NOT NULL, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `alt_body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `references` text COLLATE utf8mb4_unicode_ci NOT NULL, `ctime` int(11) unsigned NOT NULL, `udate` int(11) unsigned NOT NULL, `date` text COLLATE utf8mb4_unicode_ci NOT NULL, `flagged` int(11) unsigned NOT NULL, `recent` int(11) unsigned NOT NULL, `msgno` bigint(20) unsigned NOT NULL, `uid` bigint(20) unsigned NOT NULL, `size` int(11) unsigned NOT NULL, `from_host` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `from_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `from_address` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `sender_host` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `sender_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `sender_address` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `to_data` text COLLATE utf8mb4_unicode_ci NOT NULL, `reply_to_data` text COLLATE utf8mb4_unicode_ci NOT NULL, `mailbox_id` bigint(20) unsigned NOT NULL, `response_time` bigint(20) unsigned NOT NULL, `cls_time` bigint(20) unsigned NOT NULL, `wait_time` bigint(20) unsigned NOT NULL, `accept_time` bigint(20) unsigned NOT NULL, `interaction_time` bigint(20) NOT NULL, `conv_user_id` bigint(20) unsigned NOT NULL DEFAULT 0, `user_id` bigint(20) unsigned NOT NULL, `lr_time` bigint(20) unsigned NOT NULL, `response_type` int(11) unsigned NOT NULL, `bcc_data` text COLLATE utf8mb4_unicode_ci NOT NULL, `cc_data` text COLLATE utf8mb4_unicode_ci NOT NULL, `dep_id` int(11) unsigned NOT NULL, `mb_folder` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `conv_duration` int(11) NOT NULL DEFAULT 0, `has_attachment` tinyint(1) unsigned NOT NULL DEFAULT 0, `undelivered` tinyint(1) unsigned NOT NULL DEFAULT 0, `rfc822_body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `delivery_status` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `message_id` (`message_id`), KEY `response_type` (`response_type`), KEY `user_id` (`user_id`), KEY `conversation_id_old` (`conversation_id_old`), KEY `conversation_id` (`conversation_id`), KEY `mailbox_id` (`mailbox_id`), KEY `dep_id` (`dep_id`), KEY `message_hash` (`message_hash`), KEY `lang` (`lang`), KEY `has_attachment` (`has_attachment`), KEY `udate` (`udate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_msg_subject` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subject_id` int(11) unsigned NOT NULL, `message_id` bigint(20) unsigned NOT NULL, `conversation_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `message_id` (`message_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_mailbox` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `mail` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `host` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT 1, `port` int(11) unsigned NOT NULL, `workflow_options` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `imap` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `last_sync_log` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `sync_started` bigint(20) unsigned NOT NULL, `last_sync_time` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL DEFAULT 0, `mailbox_sync` text COLLATE utf8mb4_unicode_ci NOT NULL, `sync_status` int(11) unsigned NOT NULL, `sync_interval` int(11) unsigned NOT NULL, `signature` text COLLATE utf8mb4_unicode_ci NOT NULL, `signature_under` tinyint(1) unsigned NOT NULL DEFAULT 0, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `import_since` int(11) unsigned NOT NULL DEFAULT 0, `dep_id` int(11) unsigned NOT NULL DEFAULT 0, `delete_mode` tinyint(1) unsigned NOT NULL DEFAULT 0, `reopen_timeout` int(11) unsigned NOT NULL DEFAULT 4, `failed` tinyint(1) unsigned NOT NULL DEFAULT 0, `uuid_status` text COLLATE utf8mb4_unicode_ci NOT NULL, `create_a_copy` tinyint(1) unsigned NOT NULL DEFAULT 0, `import_priority` int(11) unsigned NOT NULL DEFAULT 0, `assign_parent_user` tinyint(1) unsigned NOT NULL DEFAULT 0, `mail_smtp` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name_smtp` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `username_smtp` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password_smtp` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `no_pswd_smtp` tinyint(1) unsigned NOT NULL DEFAULT 0, `auth_method` tinyint(1) unsigned NOT NULL DEFAULT '0', `reopen_reset` tinyint(1) unsigned NOT NULL DEFAULT 0, `last_process_time` bigint(20) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `active` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_response_template` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `template` text COLLATE utf8mb4_unicode_ci NOT NULL, `dep_id` int(11) NOT NULL DEFAULT 0, `template_plain` text COLLATE utf8mb4_unicode_ci NOT NULL, `unique_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `disabled` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `unique_id` (`unique_id`), KEY `disabled` (`disabled`), KEY `dep_id` (`dep_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_msg_internal` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `time` bigint(20) unsigned NOT NULL, `chat_id` bigint(20) unsigned NOT NULL DEFAULT 0, `user_id` bigint(20) NOT NULL DEFAULT 0, `name_support` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `meta_msg` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `chat_id_id` (`chat_id`,`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `lhc_mailconv_match_rule` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dep_id` int(11) unsigned NOT NULL, `conditions` text COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT 1, `mailbox_id` text COLLATE utf8mb4_unicode_ci NOT NULL, `from_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `from_mail` text COLLATE utf8mb4_unicode_ci NOT NULL, `subject_contains` text COLLATE utf8mb4_unicode_ci NOT NULL, `priority` int(11) NOT NULL, `priority_rule` int(11) NOT NULL, `options` text COLLATE utf8mb4_unicode_ci NOT NULL,`name` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `active_priority` (`active`,`priority`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;