START TRANSACTION;

CREATE TABLE `tblleads_email_integration_static` (
  `id` bigint(20) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `active` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(100) NOT NULL,
  `imap_server` varchar(100) NOT NULL,
  `password` mediumtext NOT NULL,
  `check_every` bigint(20) UNSIGNED NOT NULL DEFAULT '5',
  `responsible` bigint(20) UNSIGNED NOT NULL,
  `lead_source` bigint(20) UNSIGNED NOT NULL,
  `lead_status` bigint(20) UNSIGNED NOT NULL,
  `encryption` varchar(3) DEFAULT NULL,
  `folder` varchar(100) NOT NULL,
  `last_run` varchar(50) DEFAULT NULL,
  `notify_lead_imported` tinyint(1) NOT NULL DEFAULT '1',
  `notify_lead_contact_more_times` tinyint(1) NOT NULL DEFAULT '1',
  `notify_type` varchar(20) DEFAULT NULL,
  `notify_ids` mediumtext,
  `mark_public` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `only_loop_on_unseen_emails` tinyint(1) NOT NULL DEFAULT '1',
  `delete_after_import` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `create_task_if_customer` bigint(20) UNSIGNED NOT NULL DEFAULT '0'
);

INSERT INTO `tblleads_email_integration_static` (`id`, `active`, `email`, `imap_server`, `password`, `check_every`, `responsible`, `lead_source`, `lead_status`, `encryption`, `folder`, `last_run`, `notify_lead_imported`, `notify_lead_contact_more_times`, `notify_type`, `notify_ids`, `mark_public`, `only_loop_on_unseen_emails`, `delete_after_import`, `create_task_if_customer`) VALUES
(1, 0, '', '', '', 10, 0, 0, 0, 'tls', 'inbox', '', 1, 1, 'assigned', '', 0, 1, 0, 1);

COMMIT;