--
-- Host: localhost    Database: rcmail
-- ------------------------------------------------------


--
-- Table structure for table `attachments`
--

CREATE TABLE `attachments` (
  `attachment_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(11) unsigned NOT NULL DEFAULT '0',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `mimetype` varchar(255) NOT NULL DEFAULT '',
  `size` int(11) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  PRIMARY KEY (`attachment_id`),
  KEY `fk_attachments_event_id` (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `attachments`
--


--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `cache_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cache_key` varchar(128) CHARACTER SET ascii NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `data` longtext NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`cache_id`),
  KEY `created_index` (`created`),
  KEY `user_cache_index` (`user_id`,`cache_key`),
  CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache`
--


--
-- Table structure for table `cache_index`
--

CREATE TABLE `cache_index` (
  `user_id` int(10) unsigned NOT NULL,
  `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `valid` tinyint(1) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  PRIMARY KEY (`user_id`,`mailbox`),
  KEY `changed_index` (`changed`),
  CONSTRAINT `user_id_fk_cache_index` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_index`
--


--
-- Table structure for table `cache_messages`
--

CREATE TABLE `cache_messages` (
  `user_id` int(10) unsigned NOT NULL,
  `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `data` longtext NOT NULL,
  `flags` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`mailbox`,`uid`),
  KEY `changed_index` (`changed`),
  CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_messages`
--


--
-- Table structure for table `cache_thread`
--

CREATE TABLE `cache_thread` (
  `user_id` int(10) unsigned NOT NULL,
  `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `data` longtext NOT NULL,
  PRIMARY KEY (`user_id`,`mailbox`),
  KEY `changed_index` (`changed`),
  CONSTRAINT `user_id_fk_cache_thread` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_thread`
--


--
-- Table structure for table `calendars`
--

CREATE TABLE `calendars` (
  `calendar_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `color` varchar(8) NOT NULL,
  `showalarms` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`calendar_id`),
  KEY `fk_calendars_user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `calendars`
--

INSERT INTO `calendars` VALUES (1,1,'Default','cc0000',0);

--
-- Table structure for table `contactgroupmembers`
--

CREATE TABLE `contactgroupmembers` (
  `contactgroup_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  PRIMARY KEY (`contactgroup_id`,`contact_id`),
  KEY `contactgroupmembers_contact_index` (`contact_id`),
  CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) REFERENCES `contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contactgroupmembers`
--


--
-- Table structure for table `contactgroups`
--

CREATE TABLE `contactgroups` (
  `contactgroup_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `del` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`contactgroup_id`),
  KEY `contactgroups_user_index` (`user_id`,`del`),
  CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contactgroups`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `del` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL DEFAULT '',
  `email` text NOT NULL,
  `firstname` varchar(128) NOT NULL DEFAULT '',
  `surname` varchar(128) NOT NULL DEFAULT '',
  `vcard` longtext,
  `words` text,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`contact_id`),
  KEY `user_contacts_index` (`user_id`,`del`),
  CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES (1,'2012-06-22 22:44:44',0,'Uranov Uran','Uranxp@yandex.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Uranov Uran\r\nEMAIL;type=INTERNET:Uranxp@yandex.ru\r\nEND:VCARD',' uranxp@yandex.ru uranov uran',1),(2,'2012-06-24 11:17:37',0,'Демьян','pressvs@bk.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Демьян\r\nEMAIL;type=INTERNET:pressvs@bk.ru\r\nEND:VCARD',' pressvs@bk.ru демьян',1),(3,'2015-06-14 12:42:10',0,'Наташа','tatka1313@mail.ru,tatka1313@gmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Наташа\r\nEMAIL;TYPE=INTERNET;TYPE=OTHER:tatka1313@mail.ru\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:tatka1313@gmail.com\r\nEND:VCARD',' наташа tatka1313@mail.ru tatka1313@gmail.com',1),(4,'2012-07-05 10:39:00',0,'Pochta','pochta@rdm-print.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Pochta\r\nEMAIL;type=INTERNET:pochta@rdm-print.ru\r\nEND:VCARD',' pochta@rdm print.ru pochta',1),(5,'2012-07-22 00:50:33',0,'Сергей Шилин','snape@liceum8.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Сергей Шилин\r\nEMAIL;type=INTERNET:snape@liceum8.ru\r\nEND:VCARD',' snape@liceum8.ru сергей шилин',1),(6,'2012-07-22 00:55:50',0,'Ира Шклярская','upuwa@inbox.ru','Ира Шклярская','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Ира Шклярская;;;\r\nFN:Ира Шклярская\r\nEMAIL;type=INTERNET;type=HOME:upuwa@inbox.ru\r\nEND:VCARD',' ира шклярская upuwa@inbox.ru',1),(7,'2013-03-12 02:13:27',0,'Aleksandr Mukhin','thorn@flex.ru,mukhin.alx@gmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Aleksandr Mukhin\r\nEMAIL;type=INTERNET;type=WORK:thorn@flex.ru\r\nEMAIL;type=INTERNET;type=OTHER:mukhin.alx@gmail.com\r\nEND:VCARD',' aleksandr mukhin thorn@flex.ru mukhin.alx@gmail.com',1),(8,'2014-02-28 18:49:47',0,'Миша Шрек','Kma_f@mail.ru','Миша','Шрек','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Шрек;Миша;;;\r\nFN:Миша Шрек\r\nEMAIL;type=INTERNET;type=WORK:Kma_f@mail.ru\r\nEND:VCARD',' миша шрек kma_f@mail.ru',1),(9,'2012-12-01 11:38:26',0,'Папа','2565230@mail.ru','Папа','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Папа;;;\r\nFN:Папа\r\nEMAIL;type=INTERNET;type=HOME:2565230@mail.ru\r\nEND:VCARD',' папа 2565230@mail.ru',1),(10,'2013-06-21 17:37:14',0,'tombraider@flex.ru','tombraider@flex.ru','tombraider@flex.ru','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;tombraider@flex.ru;;;\r\nFN:tombraider@flex.ru\r\nEMAIL;type=INTERNET;type=WORK:tombraider@flex.ru\r\nEND:VCARD',' tombraider@flex.ru',1),(11,'2013-12-23 13:48:49',0,'','jul181815@mail.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nEMAIL;type=INTERNET;type=HOME:jul181815@mail.ru\r\nEND:VCARD',' jul181815@mail.ru',1),(12,'2013-12-27 17:20:24',0,'Лёха Полянский','iomin@ro.ru','Лёха Полянский','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Лёха Полянский;;;\r\nFN:Лёха Полянский\r\nEMAIL;type=INTERNET;type=HOME:iomin@ro.ru\r\nEND:VCARD',' лёха полянский iomin@ro.ru',1),(13,'2014-01-28 13:54:02',0,'Дима','dmitry@flex.ru','Дима','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Дима;;;\r\nFN:Дима\r\nEMAIL;type=INTERNET;type=WORK:dmitry@flex.ru\r\nEND:VCARD',' дима dmitry@flex.ru',1),(14,'2014-02-09 08:21:36',0,'Басюга','Slapkin@li.ru','Басюга','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Басюга;;;\r\nFN:Басюга\r\nEMAIL;type=INTERNET;type=HOME:Slapkin@li.ru\r\nEND:VCARD',' басюга slapkin@li.ru',1),(15,'2014-02-10 03:48:33',0,'Александр Eвгеньевич','aep79@yandex.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Александр Eвгеньевич\r\nEMAIL;type=INTERNET:aep79@yandex.ru\r\nEND:VCARD',' ap79@yandex.ru александр eвгеньевич',1),(16,'2014-11-01 00:46:06',0,'Дмитрий Х','dmitriix1@mail.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Дмитрий Х\r\nEMAIL;TYPE=INTERNET:dmitriix1@mail.ru\r\nEND:VCARD',' dmitriix1@mail.ru дмитрий х',1),(17,'2014-11-09 00:36:53',0,'','lightonline@mail.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:lightonline@mail.ru\r\nEND:VCARD',' lightonline@mail.ru',1),(18,'2015-01-03 19:39:09',0,'Артём','artem@ventel.ru,bender2993741547@gmail.com','Артём','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Артём;;;\r\nFN:Артём\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:artem@ventel.ru\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:bender2993741547@gmail.com\r\nEND:VCARD',' артём artem@ventel.ru bender2993741547@gmail.com',1),(19,'2015-01-21 21:13:37',0,'Рябова Светлана Михайловна','sryabova@maxus.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Рябова Светлана Михайловна\r\nEMAIL;TYPE=INTERNET:sryabova@maxus.ru\r\nEND:VCARD',' sryabova@maxus.ru рябова светлана михайловна',1),(20,'2016-05-14 13:04:56',0,'Дима Царёв','dimok_cool@mail.ru','Дима','Царёв','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Царёв;Дима;;;\r\nFN:Дима Царёв\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:dimok_cool@mail.ru\r\nEND:VCARD',' дима царёв dimok_cool@mail.ru',1),(21,'2017-05-24 08:21:08',0,'Геннадий Сажин','chp-saghin@yandex.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Геннадий Сажин\r\nEMAIL;TYPE=INTERNET:chp-saghin@yandex.ru\r\nEND:VCARD',' chp saghin@yandex.ru геннадий сажин',1),(22,'2017-05-29 08:27:27',0,'Склад','larisa@flex.ru','Склад','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Склад;;;\r\nFN:Склад\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:larisa@flex.ru\r\nEND:VCARD',' склад larisa@flex.ru',1),(23,'2017-09-23 01:40:55',0,'Новости недели ЭЛЕКТРОСТАЛЬ','elweek@mail.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Новости недели ЭЛЕКТРОСТАЛЬ\r\nEMAIL;TYPE=INTERNET:elweek@mail.ru\r\nEND:VCARD',' elweek@mail.ru новости недели электросталь',1),(24,'2020-02-06 18:35:05',0,'КБ Панорама','panorama@gisinfo.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:КБ Панорама\r\nEMAIL;TYPE=INTERNET:panorama@gisinfo.ru\r\nEND:VCARD',' panorama@gisinfo.ru кб панорама',1),(25,'2020-03-02 19:47:25',0,'АЛЕКСАНДР КАЛЬЯНОВ','kalianov2005@mail.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:АЛЕКСАНДР КАЛЬЯНОВ\r\nEMAIL;TYPE=INTERNET:kalianov2005@mail.ru\r\nEND:VCARD',' kalianov2005@mail.ru александр кальянов',1),(26,'2020-11-29 00:10:20',0,'Fafnirmerlin','Fafnirmerlin@mail.ru','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Fafnirmerlin\r\nEMAIL;TYPE=INTERNET:Fafnirmerlin@mail.ru\r\nEND:VCARD',' fafnirmerlin@mail.ru fafnirmerlin',1);

--
-- Table structure for table `dictionary`
--

CREATE TABLE `dictionary` (
  `user_id` int(10) unsigned DEFAULT NULL,
  `language` varchar(5) NOT NULL,
  `data` longtext NOT NULL,
  UNIQUE KEY `uniqueness` (`user_id`,`language`),
  CONSTRAINT `user_id_fk_dictionary` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dictionary`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `calendar_id` int(11) unsigned NOT NULL DEFAULT '0',
  `recurrence_id` int(11) unsigned NOT NULL DEFAULT '0',
  `uid` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `start` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `end` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `recurrence` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  `free_busy` tinyint(1) NOT NULL DEFAULT '0',
  `priority` tinyint(1) NOT NULL DEFAULT '0',
  `sensitivity` tinyint(1) NOT NULL DEFAULT '0',
  `alarms` varchar(255) DEFAULT NULL,
  `attendees` text,
  `notifyat` datetime DEFAULT NULL,
  PRIMARY KEY (`event_id`),
  KEY `uid_idx` (`uid`,`calendar_id`),
  KEY `recurrence_idx` (`recurrence_id`),
  KEY `fk_events_calendar_id` (`calendar_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events`
--


--
-- Table structure for table `identities`
--

CREATE TABLE `identities` (
  `identity_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `del` tinyint(1) NOT NULL DEFAULT '0',
  `standard` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL,
  `organization` varchar(128) NOT NULL DEFAULT '',
  `email` varchar(128) NOT NULL,
  `reply-to` varchar(128) NOT NULL DEFAULT '',
  `bcc` varchar(128) NOT NULL DEFAULT '',
  `signature` text,
  `html_signature` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`identity_id`),
  KEY `user_identities_index` (`user_id`,`del`),
  CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `identities`
--

INSERT INTO `identities` VALUES (1,1,'2012-07-05 22:58:24',0,1,'Руслан','','mar@miranet.ru','','','',0),(2,2,'2012-05-28 18:53:16',0,1,'','','spam@miranet.ru','','',NULL,0),(3,3,'2019-10-31 19:43:38',0,1,'Natalya','','samael@miranet.ru','','','',0),(4,4,'2012-06-03 11:49:38',0,1,'','','admin@yalagina15.ru','','',NULL,0),(5,5,'2012-06-03 11:52:11',0,1,'','','mar@yalagina.ru','','',NULL,0),(6,6,'2012-06-03 22:46:21',0,1,'','','info@miranet.ru','','',NULL,0),(7,7,'2012-06-03 22:47:53',0,1,'','','natasha@miranet.ru','','',NULL,0),(8,8,'2012-06-04 13:59:41',0,1,'','','home@miranet.ru','','',NULL,0),(9,9,'2012-06-09 23:57:12',0,1,'','','admin@miranet.ru','','',NULL,0),(10,10,'2012-06-12 22:39:38',0,1,'','','test@yalagina.ru','','',NULL,0),(11,11,'2012-06-13 00:32:27',0,1,'','','mar@fst-racing.ru','','',NULL,0),(12,12,'2012-06-25 12:35:51',0,1,'samael','','samael@127.0.0.1','','',NULL,0),(13,13,'2012-06-25 17:04:21',0,1,'mar','','mar@127.0.0.1','','',NULL,0),(14,14,'2013-03-24 18:45:47',0,1,'','','jury@miranet.ru','','',NULL,0),(15,15,'2014-04-14 13:07:49',0,1,'','','psy@dmitriy-x.ru','','',NULL,0),(16,16,'2015-05-31 10:38:18',0,1,'','','postmaster@miranet.ru','','',NULL,0),(17,17,'2015-08-23 22:02:29',0,1,'','','admin@yalagina.ru','','',NULL,0),(18,18,'2017-04-13 15:15:19',0,1,'','','uran@miranet.ru','','',NULL,0),(19,19,'2017-04-13 15:52:49',0,1,'','','hostmaster@yalagina.ru','','',NULL,0),(20,20,'2017-08-17 21:58:45',0,1,'','','dasha@miranet.ru','','',NULL,0),(21,21,'2019-03-16 03:15:14',0,1,'','','avast@miranet.ru','','',NULL,0),(22,22,'2020-05-19 12:41:55',0,1,'','','vika@miranet.ru','','',NULL,0),(23,23,'2020-10-11 16:34:22',0,1,'','','julia@miranet.ru','','',NULL,0),(24,24,'2021-11-20 17:09:55',0,1,'','','mat@miranet.ru','','',NULL,0);

--
-- Table structure for table `searches`
--

CREATE TABLE `searches` (
  `search_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `type` int(3) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL,
  `data` text,
  PRIMARY KEY (`search_id`),
  UNIQUE KEY `uniqueness` (`user_id`,`type`,`name`),
  CONSTRAINT `user_id_fk_searches` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `searches`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `mail_host` varchar(128) NOT NULL,
  `alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `last_login` datetime DEFAULT NULL,
  `language` varchar(5) DEFAULT NULL,
  `preferences` text,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`,`mail_host`),
  KEY `alias_index` (`alias`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'mar@miranet.ru','127.0.0.1','','2012-05-24 23:40:05','2022-04-29 12:31:12','ru_RU','a:18:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";s:17:\"message_threading\";a:0:{}s:12:\"preview_pane\";s:1:\"1\";s:11:\"show_images\";i:2;s:9:\"list_cols\";a:9:{i:0;s:7:\"threads\";i:1;s:7:\"subject\";i:2;s:6:\"status\";i:3;s:4:\"from\";i:4;s:2:\"to\";i:5;s:4:\"date\";i:6;s:4:\"size\";i:7;s:4:\"flag\";i:8;s:10:\"attachment\";}s:18:\"calendar_timeslots\";s:1:\"1\";s:29:\"calendar_default_alarm_offset\";s:4:\"-15M\";s:25:\"calendar_default_calendar\";s:1:\"1\";s:11:\"top_posting\";b:1;s:8:\"timezone\";s:4:\"auto\";s:8:\"pagesize\";i:80;s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:15:\"namespace_fixed\";b:1;}'),(2,'spam@miranet.ru','127.0.0.1','','2012-05-28 18:53:16','2021-11-09 00:48:29','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(3,'samael@miranet.ru','127.0.0.1','','2012-06-03 11:45:40','2019-10-31 19:35:37','ru_RU','a:9:{s:16:\"message_sort_col\";s:4:\"from\";s:18:\"message_sort_order\";s:4:\"DESC\";s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(4,'admin@yalagina15.ru','127.0.0.1','','2012-06-03 11:49:38','2012-06-04 13:49:10','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(5,'mar@yalagina.ru','127.0.0.1','','2012-06-03 11:52:11','2012-06-04 13:53:20','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(6,'info@miranet.ru','127.0.0.1','','2012-06-03 22:46:21','2016-07-15 10:22:57','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(7,'natasha@miranet.ru','127.0.0.1','','2012-06-03 22:47:53','2012-10-03 16:17:08','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(8,'home@miranet.ru','127.0.0.1','','2012-06-04 13:59:41','2012-06-04 14:24:07','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(9,'admin@miranet.ru','127.0.0.1','','2012-06-09 23:57:11','2012-06-19 00:22:11','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(10,'test@yalagina.ru','127.0.0.1','','2012-06-12 22:39:38','2012-06-13 23:45:15','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(11,'mar@fst-racing.ru','127.0.0.1','','2012-06-13 00:32:27','2012-06-13 00:32:27','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(12,'samael','127.0.0.1','','2012-06-25 12:35:51','2012-06-25 12:35:51','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(13,'mar','127.0.0.1','','2012-06-25 17:04:21','2012-07-04 15:39:28','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(14,'jury@miranet.ru','127.0.0.1','','2013-03-24 18:45:47','2013-03-24 18:45:47','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(15,'psy@dmitriy-x.ru','127.0.0.1','','2014-04-14 13:07:48','2014-04-14 13:07:48','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(16,'postmaster@miranet.ru','127.0.0.1','','2015-05-31 10:38:18','2017-12-24 23:11:18','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(17,'admin@yalagina.ru','127.0.0.1','','2015-08-23 22:02:29','2015-08-24 14:44:41','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(18,'uran@miranet.ru','127.0.0.1','','2017-04-13 15:15:19','2017-04-13 16:16:01','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(19,'hostmaster@yalagina.ru','127.0.0.1','','2017-04-13 15:52:49','2017-12-24 23:09:34','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(20,'dasha@miranet.ru','127.0.0.1','','2017-08-17 21:58:45','2021-09-03 16:30:39','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(21,'avast@miranet.ru','127.0.0.1','','2019-03-16 03:15:14','2019-03-16 03:15:14','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(22,'vika@miranet.ru','127.0.0.1','','2020-05-19 12:41:55','2022-03-24 10:51:46','ru_RU','a:9:{s:16:\"message_sort_col\";s:7:\"subject\";s:18:\"message_sort_order\";s:4:\"DESC\";s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(23,'julia@miranet.ru','127.0.0.1','','2020-10-11 16:34:21','2020-10-11 16:34:21','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}'),(24,'mat@miranet.ru','127.0.0.1','','2021-11-20 17:09:55','2021-11-20 17:09:55','ru_RU','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}');


