
CREATE TABLE IF NOT EXISTS `imap_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc` varchar(300) NOT NULL,
  `status` int(1) NOT NULL,
  `time` int(11) NOT NULL,
  `newLetters` int(11) NOT NULL,
  `matchesLetters` int(11) NOT NULL,
  `err` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `acc` (`acc`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2313 ;


CREATE TABLE IF NOT EXISTS `imap_letter` (
  `time` int(11) NOT NULL,
  `eml` longtext NOT NULL,
  `account` varchar(300) NOT NULL,
  `emlOld` text NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;


CREATE TABLE IF NOT EXISTS `imap_setting` (
  `DeliveryTimeout` int(11) NOT NULL,
  `urlsocks` varchar(250) NOT NULL,
  `word1` varchar(500) NOT NULL,
  `word2` varchar(300) NOT NULL,
  `word3` varchar(300) NOT NULL,
  `attach` varchar(300) NOT NULL,
  `or` int(1) NOT NULL,
  `status` int(1) NOT NULL,
  `demon` int(1) NOT NULL,
  `maxcount` int(11) NOT NULL,
  `sid` int(11) NOT NULL,
  `str` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `imap_setting` (`DeliveryTimeout`, `word1`, `word2`, `word3`, `or`, `status`, `demon`, `str`) VALUES
(10, 'blockchain\r\npassword\r\npayment', 'bitcoin', 'payment', 1, 1, 2, 1544381036);


