--
-- 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 `itipinvitations`
--

CREATE TABLE `itipinvitations` (
  `token` varchar(64) NOT NULL,
  `event_uid` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `event` text NOT NULL,
  `expires` datetime DEFAULT NULL,
  `cancelled` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`token`),
  KEY `uid_idx` (`event_uid`,`user_id`),
  KEY `fk_itipinvitations_user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `itipinvitations`
--


--
-- 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 `session`
--

CREATE TABLE `session` (
  `sess_id` varchar(128) NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `ip` varchar(40) NOT NULL,
  `vars` mediumtext NOT NULL,
  PRIMARY KEY (`sess_id`),
  KEY `changed_index` (`changed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `session`
--

INSERT INTO `session` VALUES ('011np8k3le46fqu1hpcj1755e0','2022-04-18 13:42:47','2022-04-18 13:42:47','209.141.36.231','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('07gpmhdbuctufju3bq4ju6pha3','2022-05-02 22:01:08','2022-05-02 22:01:08','198.235.24.160','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('1ii26ed4qpk42f0ahdiqsmal47','2022-04-21 07:39:08','2022-04-21 07:39:08','42.193.8.97','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('1p1mcut40j6i3q6je6d4teg4m5','2022-04-30 18:24:12','2022-04-30 18:24:12','205.210.31.14','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('36fsn4qt2n0jiccpa6v0rrgd54','2022-04-27 04:46:08','2022-04-27 04:46:08','198.235.24.25','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('3ncbqmc09lh6kplrc3mkg6ul12','2022-04-21 07:10:49','2022-04-21 07:10:49','111.7.100.16','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('4bk135pmuj002l8ggc6pcua5m5','2022-04-21 10:21:16','2022-04-21 10:21:16','205.210.31.5','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('4cj8imckmpir1kc3anb7s7hqt7','2022-04-13 17:37:36','2022-04-13 17:37:36','77.74.177.119','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('4dnitujl3i4jp50r7m78gqkl31','2022-04-12 15:34:12','2022-04-12 15:34:12','38.242.249.246','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('4g20fvln6a6c4nqq3eej8oc3j0','2022-04-24 04:02:50','2022-04-24 04:02:50','65.154.226.166','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('56fcomqaoh0mtb3rrg9nhr4km1','2022-04-28 12:32:42','2022-04-28 12:32:42','167.248.133.119','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('57qankqde7dsncnnv6ldcp2m44','2022-04-21 07:22:12','2022-04-21 07:22:12','8.31.2.98','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('5roaqnvvil016v3h9frudm3h75','2022-04-21 05:57:54','2022-04-21 05:57:54','111.7.100.19','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('6ulso1epsds9nbfp33sjo23f10','2022-04-10 02:40:34','2022-04-10 02:40:34','192.168.200.6','bGFuZ3VhZ2V8czo1OiJydV9SVSI7dGVtcHxiOjE7c2tpbnxzOjU6ImxhcnJ5Ijs='),('87l7nh3j1meovalruse0qj0pc1','2022-04-21 04:53:48','2022-04-21 04:53:48','209.141.35.128','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('8o49a7nqv828ol9afa42kue8g3','2022-04-18 14:13:20','2022-04-18 14:13:20','162.142.125.10','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('8pe5gpg9rh4k8h38g7emriok64','2022-04-22 03:12:09','2022-04-22 03:12:09','205.210.31.12','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('8vfoiof8339t1ce55dseqec0d3','2022-04-26 16:02:09','2022-04-26 16:02:09','111.7.100.16','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('90a0dk32dvb8tqo88hfvsk50j1','2022-04-29 08:07:18','2022-04-29 08:07:18','198.235.24.23','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('90cg1usf7argjtf5jtp3gv2b01','2022-04-19 07:48:04','2022-04-19 07:48:04','198.235.24.29','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('9uq16an0a1pft55csel8cil2n5','2022-04-10 18:17:17','2022-04-10 18:17:17','92.118.160.41','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('a093ehrpnnrhibbse0tcg5r6u2','2022-04-21 13:13:02','2022-04-21 13:13:02','124.223.193.80','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('au54l1l7s6g4997rlnshotvnp6','2022-04-18 13:42:50','2022-04-18 13:42:50','111.7.100.17','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('bchhk95i0tcnq9bh4hl7t713v5','2022-04-21 07:21:41','2022-04-21 07:21:41','209.141.42.155','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('c6rd6v2ig4jpp197snlmu0slb2','2022-04-12 12:08:20','2022-04-12 12:08:20','38.242.249.246','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('cc7jcc5fj3a03073l1t05n2p86','2022-04-27 01:15:58','2022-04-27 01:15:58','42.193.8.97','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('elje43jq1mfft6uk305ki92ii5','2022-04-21 06:40:42','2022-04-21 06:40:42','205.185.116.89','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('fnv0mhhr2o987btm0h52dresh7','2022-04-24 02:35:52','2022-04-24 02:35:52','205.210.31.16','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('g52vf4ghhfff46bood9bjvqqs4','2022-04-21 07:22:21','2022-04-21 07:22:21','211.95.50.7','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('gadnbrha1npohuj9kf1clo5hn0','2022-04-21 08:10:14','2022-04-21 08:10:14','205.185.117.203','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('gj7r84obhr9hm3mktotd9lv9i4','2022-04-30 01:45:29','2022-04-30 01:45:29','106.10.122.53','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('i3tgdg8hspaobr3rfvj4esv5l0','2022-04-21 17:32:44','2022-04-21 17:32:44','205.210.31.158','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('imh6ghbjeel44ah9e1eu3n9dn7','2022-04-21 01:27:24','2022-04-21 01:27:24','142.54.177.163','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('jierpqvm5pf1h9ihm04u4novg7','2022-04-14 16:04:26','2022-04-14 16:04:26','205.210.31.31','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('jlnav1o6seu52anav6b247nd14','2022-04-21 07:10:47','2022-04-21 07:10:47','209.141.41.193','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('khvuda56hb2udmemoh1u1c5dq3','2022-04-22 22:58:57','2022-04-22 22:58:57','205.210.31.17','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('ktfd6jr1l3pjvq7o21ogmics77','2022-04-21 06:40:44','2022-04-21 06:40:44','211.95.50.7','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('kvt7mjn6efjno9jos92kr6fnt6','2022-04-26 16:02:00','2022-04-26 16:02:00','104.28.242.52','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('m5npv0qgi3qpn3l6tvo7e19fa3','2022-04-21 05:57:11','2022-04-21 05:57:11','205.185.122.184','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('mc59i322nooh6c5u2d8oilfrt5','2022-04-28 12:32:42','2022-04-28 12:32:42','167.248.133.119','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('mmcvj4v3i8o6gcf6laal0rrpm6','2022-04-21 07:35:52','2022-04-21 07:35:52','111.7.100.17','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('mof3s5j613koiurjm82lceoqm7','2022-04-29 12:31:12','2022-04-29 12:33:45','192.168.200.6','bGFuZ3VhZ2V8czo1OiJydV9SVSI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp7aTowO2E6Mjp7aTowO3M6NjoiSU5CT1guIjtpOjE7czoxOiIuIjt9fXM6NToib3RoZXIiO047czo2OiJzaGFyZWQiO2E6Mjp7aTowO2E6Mjp7aTowO3M6ODoiI3NoYXJlZC4iO2k6MTtzOjE6Ii4iO31pOjE7YToyOntpOjA7czo3OiJzaGFyZWQuIjtpOjE7czoxOiIuIjt9fXM6NjoicHJlZml4IjtzOjY6IklOQk9YLiI7fWltYXBfZGVsaW1pdGVyfHM6MToiLiI7dXNlcl9pZHxzOjE6IjEiO3VzZXJuYW1lfHM6MTQ6Im1hckBtaXJhbmV0LnJ1IjtzdG9yYWdlX2hvc3R8czo5OiIxMjcuMC4wLjEiO3N0b3JhZ2VfcG9ydHxpOjE0MztzdG9yYWdlX3NzbHxOO3Bhc3N3b3JkfHM6MzI6IkhOTjJZMmNkVG83WGhYUXlNdjRnNWZHK0hkMjlNWE0wIjtsb2dpbl90aW1lfGk6MTY1MTIyMTA3Mjt0aW1lem9uZXxzOjEzOiJFdXJvcGUvTW9zY293Ijt0YXNrfHM6NDoibWFpbCI7aW1hcF9ob3N0fHM6OToiMTI3LjAuMC4xIjttYm94fHM6NToiSU5CT1giO3NvcnRfY29sfHM6NDoiZGF0ZSI7c29ydF9vcmRlcnxzOjQ6IkRFU0MiO1NUT1JBR0VfVEhSRUFEfGE6Mjp7aTowO3M6MTQ6Ik9SREVSRURTVUJKRUNUIjtpOjE7czoxMDoiUkVGRVJFTkNFUyI7fVNUT1JBR0VfUVVPVEF8YjoxO1NUT1JBR0VfTElTVC1FWFRFTkRFRHxiOjA7cXVvdGFfZGlzcGxheXxzOjQ6InRleHQiO2xpc3RfYXR0cmlifGE6NDp7czo0OiJuYW1lIjtzOjg6Im1lc3NhZ2VzIjtzOjI6ImlkIjtzOjExOiJtZXNzYWdlbGlzdCI7czo1OiJjbGFzcyI7czo0ODoicmVjb3Jkcy10YWJsZSBtZXNzYWdlbGlzdCBzb3J0aGVhZGVyIGZpeGVkaGVhZGVyIjtzOjE1OiJvcHRpb25zbWVudWljb24iO3M6NDoidHJ1ZSI7fXNraW5fcGF0aHxzOjExOiJza2lucy9sYXJyeSI7dW5zZWVuX2NvdW50fGE6Nzp7czo1OiJJTkJPWCI7aTo2MTtzOjEwOiJJTkJPWC5TZW50IjtpOjA7czoxMjoiSU5CT1guRHJhZnRzIjtpOjA7czoxMDoiSU5CT1guSnVuayI7aTozNTtzOjExOiJJTkJPWC5UcmFzaCI7aTowO3M6OToiSU5CT1guT0ZEIjtpOjY5O3M6MzI6IklOQk9YLiZCQ0VFUGdSRkJFQUVNQVE5QkRVRVBRUSstIjtpOjA7fWZvbGRlcnN8YToyOntzOjU6IklOQk9YIjthOjI6e3M6MzoiY250IjtpOjg1O3M6NjoibWF4dWlkIjtpOjExODc3O31zOjEwOiJJTkJPWC5TZW50IjthOjI6e3M6MzoiY250IjtpOjc7czo2OiJtYXh1aWQiO2k6OTI1O319U1RPUkFHRV9TT1JUfGI6MTtwYWdlfGk6MTtTVE9SQUdFX0FDTHxiOjE7'),('ot9n6ceuscsvss6n075389dc64','2022-04-21 08:10:16','2022-04-21 08:10:16','211.95.50.4','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('piul45hn6agpog50v08qrjjda3','2022-04-21 04:53:53','2022-04-21 04:53:53','36.99.136.136','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('ppcq4nc2gkqgg93stvuhudi8l1','2022-04-18 12:58:32','2022-04-18 13:09:39','192.168.200.6','bGFuZ3VhZ2V8czo1OiJydV9SVSI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp7aTowO2E6Mjp7aTowO3M6NjoiSU5CT1guIjtpOjE7czoxOiIuIjt9fXM6NToib3RoZXIiO047czo2OiJzaGFyZWQiO2E6Mjp7aTowO2E6Mjp7aTowO3M6ODoiI3NoYXJlZC4iO2k6MTtzOjE6Ii4iO31pOjE7YToyOntpOjA7czo3OiJzaGFyZWQuIjtpOjE7czoxOiIuIjt9fXM6NjoicHJlZml4IjtzOjY6IklOQk9YLiI7fWltYXBfZGVsaW1pdGVyfHM6MToiLiI7dXNlcl9pZHxzOjE6IjEiO3VzZXJuYW1lfHM6MTQ6Im1hckBtaXJhbmV0LnJ1IjtzdG9yYWdlX2hvc3R8czo5OiIxMjcuMC4wLjEiO3N0b3JhZ2VfcG9ydHxpOjE0MztzdG9yYWdlX3NzbHxOO3Bhc3N3b3JkfHM6MzI6IndGdEt5QWpiK1UwT2NhajlhZ1BNdVQyZllvU2lJdVZjIjtsb2dpbl90aW1lfGk6MTY1MDI3MjMxMjt0aW1lem9uZXxzOjEzOiJFdXJvcGUvTW9zY293Ijt0YXNrfHM6NDoibWFpbCI7aW1hcF9ob3N0fHM6OToiMTI3LjAuMC4xIjttYm94fHM6NToiSU5CT1giO3NvcnRfY29sfHM6NDoiZGF0ZSI7c29ydF9vcmRlcnxzOjQ6IkRFU0MiO1NUT1JBR0VfVEhSRUFEfGE6Mjp7aTowO3M6MTQ6Ik9SREVSRURTVUJKRUNUIjtpOjE7czoxMDoiUkVGRVJFTkNFUyI7fVNUT1JBR0VfUVVPVEF8YjoxO1NUT1JBR0VfTElTVC1FWFRFTkRFRHxiOjA7cXVvdGFfZGlzcGxheXxzOjQ6InRleHQiO2xpc3RfYXR0cmlifGE6NTp7czo0OiJuYW1lIjtzOjg6Im1lc3NhZ2VzIjtzOjI6ImlkIjtzOjExOiJtZXNzYWdlbGlzdCI7czo1OiJjbGFzcyI7czo0ODoicmVjb3Jkcy10YWJsZSBtZXNzYWdlbGlzdCBzb3J0aGVhZGVyIGZpeGVkaGVhZGVyIjtzOjE1OiJvcHRpb25zbWVudWljb24iO3M6NDoidHJ1ZSI7czo3OiJjb2x1bW5zIjthOjk6e2k6MDtzOjc6InRocmVhZHMiO2k6MTtzOjc6InN1YmplY3QiO2k6MjtzOjY6InN0YXR1cyI7aTozO3M6NDoiZnJvbSI7aTo0O3M6MjoidG8iO2k6NTtzOjQ6ImRhdGUiO2k6NjtzOjQ6InNpemUiO2k6NztzOjQ6ImZsYWciO2k6ODtzOjEwOiJhdHRhY2htZW50Ijt9fXNraW5fcGF0aHxzOjExOiJza2lucy9sYXJyeSI7dW5zZWVuX2NvdW50fGE6MTp7czo1OiJJTkJPWCI7aToyMDt9Zm9sZGVyc3xhOjE6e3M6NToiSU5CT1giO2E6Mjp7czozOiJjbnQiO2k6Mzg7czo2OiJtYXh1aWQiO2k6MTE4MzA7fX1TVE9SQUdFX1NPUlR8YjoxO2Jyb3dzZXJfY2Fwc3xhOjM6e3M6MzoicGRmIjtzOjE6IjEiO3M6NToiZmxhc2giO3M6MToiMCI7czozOiJ0aWYiO3M6MToiMCI7fXNhZmVfbWVzc2FnZXN8YToxOntzOjExOiJJTkJPWDoxMTgzMCI7YjoxO313cml0ZWFibGVfYWJvb2t8YjoxOw=='),('s1oq4q39mu157uo83cdkqa5ue6','2022-04-26 16:02:03','2022-04-26 16:02:03','211.95.50.7','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('sni727kkcj5p2l9tmkrelm02e3','2022-04-29 18:21:56','2022-04-29 18:21:56','198.235.24.30','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('tr6dpo6phjeq3s4jrkosup2hs6','2022-04-26 16:02:02','2022-04-26 16:02:02','205.185.122.184','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('ttljuafpstfa5p1im43kelhpb6','2022-04-21 07:35:47','2022-04-21 07:35:47','8.31.2.62','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('utenvnrsptcbii88a84o5jnsd4','2022-04-27 22:47:10','2022-04-27 22:47:10','163.172.180.25','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs='),('v9bbc60263f0v4dd1or6qnhra7','2022-05-04 01:36:54','2022-05-04 01:36:54','143.198.18.208','dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9HQiI7dGFza3xzOjU6ImxvZ2luIjs=');

--
-- 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;}');


