--
-- Host: localhost    Database: roundcube
-- ------------------------------------------------------


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

CREATE TABLE `cache` (
  `user_id` int 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=utf8mb3;

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

INSERT INTO `cache` VALUES (10,'IMAP.mailboxes.05c7329682137ecdb00f5e396343c575','2022-09-21 07:11:57','[encoded data, 43048 characters]'),(10,'IMAP.messagecount','2022-09-21 07:12:16','[encoded data, 56264 characters]'),(19,'IMAP.mailboxes.05c7329682137ecdb00f5e396343c575','2022-09-24 00:39:36','[encoded data, 13788 characters]'),(19,'IMAP.messagecount','2022-09-24 00:40:37','[encoded data, 21816 characters]'),(49,'IMAP.mailboxes.05c7329682137ecdb00f5e396343c575','2022-09-23 18:22:21','YTo1MTp7aTowO3M6NToiSU5CT1giO2k6MTtzOjEyOiJJTkJPWC5EcmFmdHMiO2k6MjtzOjE5OiJJTkJPWC5TZW50IE1lc3NhZ2VzIjtpOjM7czoxMDoiSU5CT1guSnVuayI7aTo0O3M6MTE6IklOQk9YLlRyYXNoIjtpOjU7czoxMjoiSU5CT1guQXJiZWl0IjtpOjY7czoxNToiSU5CT1guQXJiZWl0LkNGIjtpOjc7czozMjoiSU5CT1guQXJiZWl0LkRTQiBkaWdpdGFsIEFnZW50dXIiO2k6ODtzOjI2OiJJTkJPWC5BcmJlaXQuSG8mQXdnLWZpbmdlciI7aTo5O3M6MjY6IklOQk9YLkFyYmVpdC5NYXNjaGluZW5yaW5nIjtpOjEwO3M6MTg6IklOQk9YLkFyYmVpdC5tb3ZlYSI7aToxMTtzOjI3OiJJTkJPWC5BcmJlaXQuVGVhbSBDdXN0b21pemUiO2k6MTI7czoyMDoiSU5CT1guQXJiZWl0LldhbGRiYWQiO2k6MTM7czoxMzoiSU5CT1guQXJjaGl2ZSI7aToxNDtzOjEyOiJJTkJPWC5CSUxEQUsiO2k6MTU7czoxMjoiSU5CT1guRGl2ZXJzIjtpOjE2O3M6MjI6IklOQk9YLkRpdmVycy5EVUtvbmxpbmUiO2k6MTc7czoxODoiSU5CT1guSFNCIEFrYWRlbWllIjtpOjE4O3M6MTE6IklOQk9YLm1vdmVhIjtpOjE5O3M6OToiSU5CT1guT01UIjtpOjIwO3M6MTc6IklOQk9YLlJlY2hudW5nZW4gIjtpOjIxO3M6MjI6IklOQk9YLlJlY2hudW5nZW4gLjIwMjEiO2k6MjI7czoxMjoiSU5CT1guU2FtdWVsIjtpOjIzO3M6MTE6IklOQk9YLlNwYW1zIjtpOjI0O3M6MTQ6IklOQk9YLlRyYWluaW5nIjtpOjI1O3M6MzA6IklOQk9YLlRyYWluaW5nLmxvb2sgZ29vZCBuYWtlZCI7aToyNjtzOjMxOiJJTkJPWC5UcmFpbmluZy5TdXNhJkFMUS1zIFdvcmxkIjtpOjI3O3M6MjA6IklOQk9YLndpY2h0aWdlIE1haWxzIjtpOjI4O3M6NzoiQXJjaGl2ZSI7aToyOTtzOjg6IkFyY2hpdmVzIjtpOjMwO3M6MTM6IkFyY2hpdmVzLjIwMDkiO2k6MzE7czoxMzoiQXJjaGl2ZXMuMjAxMCI7aTozMjtzOjEzOiJBcmNoaXZlcy4yMDExIjtpOjMzO3M6MTM6IkFyY2hpdmVzLjIwMTIiO2k6MzQ7czoxMzoiQXJjaGl2ZXMuMjAxMyI7aTozNTtzOjEzOiJBcmNoaXZlcy4yMDE0IjtpOjM2O3M6ODoiYmVuamFtaW4iO2k6Mzc7czo5OiJjaHJpc3RpYW4iO2k6Mzg7czoxNjoiRGVsZXRlZCBNZXNzYWdlcyI7aTozOTtzOjY6IkRyYWZ0cyI7aTo0MDtzOjQ6Ikp1bmsiO2k6NDE7czoxNToibG9vayBnb29kIG5ha2VkIjtpOjQyO3M6NjoiTWFydGluIjtpOjQzO3M6NjoicmFmYWVsIjtpOjQ0O3M6NDoiU2VudCI7aTo0NTtzOjEzOiJTZW50IE1lc3NhZ2VzIjtpOjQ2O3M6NToiU3BhbXMiO2k6NDc7czoxNjoiU3VzYSZBTFEtcyBXb3JsZCI7aTo0ODtzOjE0OiJUZWFtIEN1c3RvbWl6ZSI7aTo0OTtzOjU6IlRyYXNoIjtpOjUwO3M6MTQ6IndpY2h0aWdlIE1haWxzIjt9'),(49,'IMAP.messagecount','2022-09-23 18:22:40','[encoded data, 4508 characters]'),(168,'IMAP.mailboxes.05c7329682137ecdb00f5e396343c575','2022-09-22 15:29:58','YTo0OntpOjA7czo1OiJJTkJPWCI7aToxO3M6NjoiRHJhZnRzIjtpOjI7czo0OiJTZW50IjtpOjM7czo1OiJUcmFzaCI7fQ=='),(168,'IMAP.mailboxes.4d746d53d82328c0a70ca727a6f7b904','2022-09-22 15:30:15','YTo0OntpOjA7czo1OiJJTkJPWCI7aToxO3M6NjoiRHJhZnRzIjtpOjI7czo0OiJTZW50IjtpOjM7czo1OiJUcmFzaCI7fQ=='),(168,'IMAP.messagecount','2022-09-22 15:33:18','YToxOntzOjU6IklOQk9YIjthOjM6e3M6MzoiQUxMIjtpOjkxO3M6NjoiRVhJU1RTIjtpOjkxO3M6NjoiVU5TRUVOIjtpOjA7fX0=');

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

CREATE TABLE `cache_index` (
  `user_id` int unsigned NOT NULL,
  `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `valid` tinyint(1) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  `expires` datetime DEFAULT 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=utf8mb3;

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

INSERT INTO `cache_index` VALUES (10,'INBOX',1,'TzoxODoicmN1YmVfcmVzdWx0X2luZGV4Ijo2OntzOjEwOiJpbmNvbXBsZXRlIjtiOjA7czoxMToiACoAcmF3X2RhdGEiO3M6MTMxOiI3NTM1NSA3NTM1NCA3NTM1MyA3NTM1MiA3NTM1MSA3NTM1MCA3NTM0OSA3NTM0OCA3NTM0NyA3NTM0NiA3NTM0NSA3NTM0MyA3NTM0MiA3NTM0NCA3NTM0MSA3NTMwMSA3NTI4NiA3NTI4NSA3NTI4NCA3NTI4MyA3NTEzNCA3NTEzNSI7czoxMDoiACoAbWFpbGJveCI7czo1OiJJTkJPWCI7czo3OiIAKgBtZXRhIjthOjE6e3M6MzoicG9zIjthOjA6e319czo5OiIAKgBwYXJhbXMiO2E6MDp7fXM6ODoiACoAb3JkZXIiO3M6NDoiREVTQyI7fQ==@date@0@1291220343@75356@220650','2022-09-21 07:11:57'),(19,'INBOX',1,'[encoded data, 379059 characters]