--
-- Host: localhost    Database: roundcubemail
-- ------------------------------------------------------


--
-- Current Database: `roundcubemail`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `roundcubemail` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `roundcubemail`;

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

CREATE TABLE `cache` (
  `user_id` int(10) unsigned NOT NULL,
  `cache_key` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `expires` datetime DEFAULT NULL,
  `data` longtext NOT NULL,
  PRIMARY KEY (`user_id`,`cache_key`),
  KEY `expires_index` (`expires`),
  CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `cache` VALUES (1,'IMAP.mailboxes.05c7329682137ecdb00f5e396343c575','2023-08-20 22:50:34','YTo2Mjp7aTowO3M6NToiSU5CT1giO2k6MTtzOjExOiJJTkJPWC5UcmFzaCI7aToyO3M6MTI6IklOQk9YLkRyYWZ0cyI7aTozO3M6MTM6IklOQk9YLlBlbmRpbmciO2k6NDtzOjY6IkRyYWZ0cyI7aTo1O3M6NDoiSnVuayI7aTo2O3M6ODoiQXJjaGl2ZXMiO2k6NztzOjEzOiJBcmNoaXZlcy4yMDEwIjtpOjg7czoxMzoiQXJjaGl2ZXMuMjAxMSI7aTo5O3M6MTM6IkFyY2hpdmVzLjIwMTIiO2k6MTA7czoxMzoiQXJjaGl2ZXMuMjAxMyI7aToxMTtzOjEzOiJBcmNoaXZlcy4yMDE0IjtpOjEyO3M6MTM6IkFyY2hpdmVzLjIwMTUiO2k6MTM7czoxMzoiQXJjaGl2ZXMuMjAxNiI7aToxNDtzOjEzOiJBcmNoaXZlcy4yMDE3IjtpOjE1O3M6MTM6IkFyY2hpdmVzLjIwMTgiO2k6MTY7czoxMzoiQXJjaGl2ZXMuMjAxOSI7aToxNztzOjEzOiJBcmNoaXZlcy4yMDIwIjtpOjE4O3M6MTM6IkFyY2hpdmVzLjIwMjEiO2k6MTk7czoxNToiQXJjaGl2ZXMuQW1hem9uIjtpOjIwO3M6MjE6IkFyY2hpdmVzLkFtYXpvbi5vdGhlciI7aToyMTtzOjI1OiJBcmNoaXZlcy5BbWF6b24ucHVyY2hhc2VzIjtpOjIyO3M6MjI6IkFyY2hpdmVzLkFtZXJpY2FuIERhdGEiO2k6MjM7czoxNjoiQXJjaGl2ZXMuQXVkaWJsZSI7aToyNDtzOjE3OiJBcmNoaXZlcy5CdXNpbmVzcyI7aToyNTtzOjI5OiJBcmNoaXZlcy5CdXNpbmVzcy5DYXJhbyBTYWxlcyI7aToyNjtzOjIxOiJBcmNoaXZlcy5CdXN5IFRlYWNoZXIiO2k6Mjc7czoxODoiQXJjaGl2ZXMuQ2FsbG15d2F5IjtpOjI4O3M6MjA6IkFyY2hpdmVzLkNyb24gRGFlbW9uIjtpOjI5O3M6MTg6IkFyY2hpdmVzLkRlY3J5cHRlZCI7aTozMDtzOjMwOiJBcmNoaXZlcy5Fc3RhZG8gZGUgQ3VlbnRhIEJOQ1IiO2k6MzE7czoxODoiQXJjaGl2ZXMuRXRpcXVldGFzIjtpOjMyO3M6MTc6IkFyY2hpdmVzLkZhY3R1cmFzIjtpOjMzO3M6MjI6IkFyY2hpdmVzLkhlYWxpbmcgbmFtZXMiO2k6MzQ7czoxNToiQXJjaGl2ZXMuTGlub2RlIjtpOjM1O3M6MTc6IkFyY2hpdmVzLk1haWxwaWxlIjtpOjM2O3M6MTk6IkFyY2hpdmVzLk1haWx2ZWxvcGUiO2k6Mzc7czoxNToiQXJjaGl2ZXMuTWFpcml4IjtpOjM4O3M6Mjg6IkFyY2hpdmVzLk5hdGlvbmFsIEdlb2dyYXBoaWMiO2k6Mzk7czoyMDoiQXJjaGl2ZXMuTmF0dXJhbE5ld3MiO2k6NDA7czoxNToiQXJjaGl2ZXMuUGF5UGFsIjtpOjQxO3M6MTY6IkFyY2hpdmVzLlByaXZhdGUiO2k6NDI7czozMToiQXJjaGl2ZXMuUmF3IGFuZCBEZWxpY2lvdXMgbGlzdCI7aTo0MztzOjMzOiJBcmNoaXZlcy5Sb2NreSBNb3VudGFpbiBJbnN0aXR1dGUiO2k6NDQ7czoyMDoiQXJjaGl2ZXMuU2VsbGRpZ2l0YWwiO2k6NDU7czoxNzoiQXJjaGl2ZXMuc25hcHJhaWQiO2k6NDY7czoyMToiQXJjaGl2ZXMuU3F1aXJyZWxtYWlsIjtpOjQ3O3M6MjE6IkFyY2hpdmVzLlRIRi1taXNzaW5nMiI7aTo0ODtzOjIxOiJBcmNoaXZlcy5UaWdlciBEaXJlY3QiO2k6NDk7czoxODoiQXJjaGl2ZXMuVE9TIEJvYXJkIjtpOjUwO3M6Mzg6IkFyY2hpdmVzLlVuaW9uIG9mIENvbmNlcm5lZCBTY2llbnRpc3RzIjtpOjUxO3M6MTQ6IkFyY2hpdmVzLllvdW5nIjtpOjUyO3M6MTE6IkxlYXJuQXNTcGFtIjtpOjUzO3M6NjoibWFpcml4IjtpOjU0O3M6NzoibWFpcml4MiI7aTo1NTtzOjg6Ik5vdC1TcGFtIjtpOjU2O3M6NToiUXVldWUiO2k6NTc7czoxNDoiU0EtTWFya2VkLVNwYW0iO2k6NTg7czo0OiJTZW50IjtpOjU5O3M6NDoiU3BhbSI7aTo2MDtzOjM6IlRPUyI7aTo2MTtzOjY6IlVuc2VlbiI7fQ=='),(1,'IMAP.mailboxes.4d746d53d82328c0a70ca727a6f7b904','2023-08-23 18:58:50','YTo2Mjp7aTowO3M6NToiSU5CT1giO2k6MTtzOjExOiJJTkJPWC5UcmFzaCI7aToyO3M6MTI6IklOQk9YLkRyYWZ0cyI7aTozO3M6MTM6IklOQk9YLlBlbmRpbmciO2k6NDtzOjY6IkRyYWZ0cyI7aTo1O3M6NDoiSnVuayI7aTo2O3M6ODoiQXJjaGl2ZXMiO2k6NztzOjEzOiJBcmNoaXZlcy4yMDEwIjtpOjg7czoxMzoiQXJjaGl2ZXMuMjAxMSI7aTo5O3M6MTM6IkFyY2hpdmVzLjIwMTIiO2k6MTA7czoxMzoiQXJjaGl2ZXMuMjAxMyI7aToxMTtzOjEzOiJBcmNoaXZlcy4yMDE0IjtpOjEyO3M6MTM6IkFyY2hpdmVzLjIwMTUiO2k6MTM7czoxMzoiQXJjaGl2ZXMuMjAxNiI7aToxNDtzOjEzOiJBcmNoaXZlcy4yMDE3IjtpOjE1O3M6MTM6IkFyY2hpdmVzLjIwMTgiO2k6MTY7czoxMzoiQXJjaGl2ZXMuMjAxOSI7aToxNztzOjEzOiJBcmNoaXZlcy4yMDIwIjtpOjE4O3M6MTM6IkFyY2hpdmVzLjIwMjEiO2k6MTk7czoxNToiQXJjaGl2ZXMuQW1hem9uIjtpOjIwO3M6MjE6IkFyY2hpdmVzLkFtYXpvbi5vdGhlciI7aToyMTtzOjI1OiJBcmNoaXZlcy5BbWF6b24ucHVyY2hhc2VzIjtpOjIyO3M6MjI6IkFyY2hpdmVzLkFtZXJpY2FuIERhdGEiO2k6MjM7czoxNjoiQXJjaGl2ZXMuQXVkaWJsZSI7aToyNDtzOjE3OiJBcmNoaXZlcy5CdXNpbmVzcyI7aToyNTtzOjI5OiJBcmNoaXZlcy5CdXNpbmVzcy5DYXJhbyBTYWxlcyI7aToyNjtzOjIxOiJBcmNoaXZlcy5CdXN5IFRlYWNoZXIiO2k6Mjc7czoxODoiQXJjaGl2ZXMuQ2FsbG15d2F5IjtpOjI4O3M6MjA6IkFyY2hpdmVzLkNyb24gRGFlbW9uIjtpOjI5O3M6MTg6IkFyY2hpdmVzLkRlY3J5cHRlZCI7aTozMDtzOjMwOiJBcmNoaXZlcy5Fc3RhZG8gZGUgQ3VlbnRhIEJOQ1IiO2k6MzE7czoxODoiQXJjaGl2ZXMuRXRpcXVldGFzIjtpOjMyO3M6MTc6IkFyY2hpdmVzLkZhY3R1cmFzIjtpOjMzO3M6MjI6IkFyY2hpdmVzLkhlYWxpbmcgbmFtZXMiO2k6MzQ7czoxNToiQXJjaGl2ZXMuTGlub2RlIjtpOjM1O3M6MTc6IkFyY2hpdmVzLk1haWxwaWxlIjtpOjM2O3M6MTk6IkFyY2hpdmVzLk1haWx2ZWxvcGUiO2k6Mzc7czoxNToiQXJjaGl2ZXMuTWFpcml4IjtpOjM4O3M6Mjg6IkFyY2hpdmVzLk5hdGlvbmFsIEdlb2dyYXBoaWMiO2k6Mzk7czoyMDoiQXJjaGl2ZXMuTmF0dXJhbE5ld3MiO2k6NDA7czoxNToiQXJjaGl2ZXMuUGF5UGFsIjtpOjQxO3M6MTY6IkFyY2hpdmVzLlByaXZhdGUiO2k6NDI7czozMToiQXJjaGl2ZXMuUmF3IGFuZCBEZWxpY2lvdXMgbGlzdCI7aTo0MztzOjMzOiJBcmNoaXZlcy5Sb2NreSBNb3VudGFpbiBJbnN0aXR1dGUiO2k6NDQ7czoyMDoiQXJjaGl2ZXMuU2VsbGRpZ2l0YWwiO2k6NDU7czoxNzoiQXJjaGl2ZXMuc25hcHJhaWQiO2k6NDY7czoyMToiQXJjaGl2ZXMuU3F1aXJyZWxtYWlsIjtpOjQ3O3M6MjE6IkFyY2hpdmVzLlRIRi1taXNzaW5nMiI7aTo0ODtzOjIxOiJBcmNoaXZlcy5UaWdlciBEaXJlY3QiO2k6NDk7czoxODoiQXJjaGl2ZXMuVE9TIEJvYXJkIjtpOjUwO3M6Mzg6IkFyY2hpdmVzLlVuaW9uIG9mIENvbmNlcm5lZCBTY2llbnRpc3RzIjtpOjUxO3M6MTQ6IkFyY2hpdmVzLllvdW5nIjtpOjUyO3M6MTE6IkxlYXJuQXNTcGFtIjtpOjUzO3M6NjoibWFpcml4IjtpOjU0O3M6NzoibWFpcml4MiI7aTo1NTtzOjg6Ik5vdC1TcGFtIjtpOjU2O3M6NToiUXVldWUiO2k6NTc7czoxNDoiU0EtTWFya2VkLVNwYW0iO2k6NTg7czo0OiJTZW50IjtpOjU5O3M6NDoiU3BhbSI7aTo2MDtzOjM6IlRPUyI7aTo2MTtzOjY6IlVuc2VlbiI7fQ=='),(1,'IMAP.messagecount','2023-08-23 21:01:44','[encoded data, 5864 characters]');

--
-- 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,
  `expires` datetime DEFAULT NULL,
  `valid` tinyint(1) NOT NULL DEFAULT 0,
  `data` longtext NOT NULL,
  PRIMARY KEY (`user_id`,`mailbox`),
  KEY `expires_index` (`expires`),
  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 COLLATE=utf8_general_ci;

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

INSERT INTO `cache_index` VALUES (1,'INBOX','2023-09-12 21:01:44',1,'[encoded data, 510640 characters]