-- MySQL dump 10.13  Distrib 5.7.41, for Linux (x86_64)
--
-- Host: localhost    Database: roundcube
-- ------------------------------------------------------
-- Server version	5.7.41-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `mail_host` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `last_login` datetime DEFAULT NULL,
  `language` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preferences` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`,`mail_host`)
) ENGINE=InnoDB AUTO_INCREMENT=1435 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--
-- WHERE:  user_id IN (1277)

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`user_id`, `username`, `mail_host`, `created`, `last_login`, `language`, `preferences`) VALUES (1277,'info@48elektrik.com.tr','localhost','2022-09-22 12:10:37','2023-08-27 00:57:22','tr_TR','a:6:{s:6:\"layout\";s:10:\"widescreen\";s:12:\"archive_mbox\";s:13:\"INBOX.Archive\";s:11:\"search_mods\";a:5:{s:1:\"*\";a:2:{s:7:\"subject\";i:1;s:4:\"from\";i:1;}s:10:\"INBOX.Sent\";a:2:{s:7:\"subject\";i:1;s:2:\"to\";i:1;}s:12:\"INBOX.Drafts\";a:2:{s:7:\"subject\";i:1;s:2:\"to\";i:1;}s:5:\"INBOX\";a:2:{s:7:\"subject\";i:1;s:4:\"from\";i:1;}s:10:\"INBOX.spam\";a:2:{s:7:\"subject\";i:1;s:4:\"from\";i:1;}}s:11:\"client_hash\";s:16:\"aPHW0ggPS7l4y8as\";s:9:\"junk_mbox\";s:10:\"INBOX.spam\";s:15:\"namespace_fixed\";b:1;}');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

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

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reply-to` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `bcc` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `signature` longtext COLLATE utf8mb4_unicode_ci,
  `html_signature` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`identity_id`),
  KEY `user_identities_index` (`user_id`,`del`),
  KEY `email_identities_index` (`email`,`del`),
  CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `identities`
--
-- WHERE:  user_id IN (1277)

LOCK TABLES `identities` WRITE;
/*!40000 ALTER TABLE `identities` DISABLE KEYS */;
INSERT INTO `identities` (`identity_id`, `user_id`, `changed`, `del`, `standard`, `name`, `organization`, `email`, `reply-to`, `bcc`, `signature`, `html_signature`) VALUES (1289,1277,'2022-09-22 12:10:37',0,1,'','','info@48elektrik.com.tr','','',NULL,0);
/*!40000 ALTER TABLE `identities` ENABLE KEYS */;
UNLOCK TABLES;

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

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `email` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstname` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `surname` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `vcard` longtext COLLATE utf8mb4_unicode_ci,
  `words` mediumtext COLLATE utf8mb4_unicode_ci,
  `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=438 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contacts`
--
-- WHERE:  user_id IN (1277)

LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
INSERT INTO `contacts` (`contact_id`, `changed`, `del`, `name`, `email`, `firstname`, `surname`, `vcard`, `words`, `user_id`) VALUES (416,'2022-11-02 08:50:53',0,'akademi muhasebe','akademismmm@hotmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:akademi muhasebe\r\nEMAIL;TYPE=INTERNET:akademismmm@hotmail.com\r\nEND:VCARD',' akademismmm@hotmail.com akademi muhasebe',1277),(417,'2022-11-14 15:55:36',0,'Asli Tarakcioglu (Osdem Obi C5)','asli.tarakcioglu@qnbfinansbank.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Asli Tarakcioglu (Osdem Obi C5)\r\nEMAIL;TYPE=INTERNET:asli.tarakcioglu@qnbfinansbank.com\r\nEND:VCARD',' asli.tarakcioglu@qnbfinansbank.com asli tarakcioglu (osdem obi c5)',1277),(419,'2022-11-30 12:30:44',0,'Edenred Türkiye','musteri@ticket.com.tr','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Edenred Türkiye\r\nEMAIL;TYPE=INTERNET:musteri@ticket.com.tr\r\nEND:VCARD',' musteri@ticket.com.tr edenred turkiye',1277),(426,'2023-01-11 11:19:54',0,'Erengul Dogan (Osdem Obi C5)','erengul.dogan@qnbfinansbank.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Erengul Dogan (Osdem Obi C5)\r\nEMAIL;TYPE=INTERNET:erengul.dogan@qnbfinansbank.com\r\nEND:VCARD',' erengul.dogan@qnbfinansbank.com erengul dogan (osdem obi c5)',1277),(435,'2023-07-15 11:59:04',0,'48Elektrik Aydinlatma','48elektrikveaydinlatma@gmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:48Elektrik Aydinlatma\r\nEMAIL;TYPE=INTERNET:48elektrikveaydinlatma@gmail.com\r\nEND:VCARD',' 48elektrikveaydinlatma@gmail.com 48elektrik aydinlatma',1277),(414,'2022-10-06 17:05:33',1,'Muhasebe','finans@eksporthirdavat.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Muhasebe\r\nEMAIL;TYPE=INTERNET:finans@eksporthirdavat.com\r\nEND:VCARD',' finans@eksporthirdavat.com muhasebe',1277);
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
UNLOCK TABLES;

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

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) COLLATE utf8mb4_unicode_ci 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 AUTO_INCREMENT=1334 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contactgroups`
--
-- WHERE:  user_id IN (1277)

LOCK TABLES `contactgroups` WRITE;
/*!40000 ALTER TABLE `contactgroups` DISABLE KEYS */;
INSERT INTO `contactgroups` (`contactgroup_id`, `user_id`, `changed`, `del`, `name`) VALUES (13,1277,'2023-03-20 08:35:26',0,'Imported Contacts'),(21,1277,'2023-03-20 12:18:01',0,'Imported Contacts 2'),(52,1277,'2023-03-21 16:33:40',0,'Imported Contacts 3'),(61,1277,'2023-03-22 08:36:11',0,'Imported Contacts 4'),(70,1277,'2023-03-22 13:04:36',0,'Imported Contacts 5'),(77,1277,'2023-03-22 19:13:05',0,'Imported Contacts 6'),(86,1277,'2023-03-23 08:29:15',0,'Imported Contacts 7'),(98,1277,'2023-03-24 08:29:32',0,'Imported Contacts 8'),(121,1277,'2023-03-25 08:29:23',0,'Imported Contacts 9'),(135,1277,'2023-03-25 15:05:29',0,'Imported Contacts 10'),(136,1277,'2023-03-25 15:09:07',0,'Imported Contacts 11'),(164,1277,'2023-03-27 08:28:04',0,'Imported Contacts 12'),(177,1277,'2023-03-27 12:03:30',0,'Imported Contacts 13'),(182,1277,'2023-03-27 13:15:34',0,'Imported Contacts 14'),(196,1277,'2023-03-27 18:14:51',0,'Imported Contacts 15'),(205,1277,'2023-03-28 08:33:03',0,'Imported Contacts 16'),(211,1277,'2023-03-28 09:12:26',0,'Imported Contacts 17'),(222,1277,'2023-03-28 16:34:11',0,'Imported Contacts 18'),(227,1277,'2023-03-29 08:36:37',0,'Imported Contacts 19'),(238,1277,'2023-03-29 12:03:44',0,'Imported Contacts 20'),(245,1277,'2023-03-29 16:18:24',0,'Imported Contacts 21'),(257,1277,'2023-03-30 08:36:19',0,'Imported Contacts 22'),(266,1277,'2023-03-30 10:47:19',0,'Imported Contacts 23'),(286,1277,'2023-03-30 18:11:19',0,'Imported Contacts 24'),(287,1277,'2023-03-30 19:17:00',0,'Imported Contacts 25'),(295,1277,'2023-03-31 08:31:34',0,'Imported Contacts 26'),(340,1277,'2023-04-01 08:34:35',0,'Imported Contacts 27'),(378,1277,'2023-04-03 08:30:51',0,'Imported Contacts 28'),(388,1277,'2023-04-03 11:22:56',0,'Imported Contacts 29'),(402,1277,'2023-04-04 08:31:07',0,'Imported Contacts 30'),(414,1277,'2023-04-04 14:41:06',0,'Imported Contacts 31'),(419,1277,'2023-04-04 16:50:55',0,'Imported Contacts 32'),(432,1277,'2023-04-05 08:34:16',0,'Imported Contacts 33'),(433,1277,'2023-04-05 08:41:28',0,'Imported Contacts 34'),(452,1277,'2023-04-05 14:14:33',0,'Imported Contacts 35'),(454,1277,'2023-04-05 16:28:58',0,'Imported Contacts 36'),(463,1277,'2023-04-06 08:37:13',0,'Imported Contacts 37'),(466,1277,'2023-04-06 10:07:48',0,'Imported Contacts 38'),(467,1277,'2023-04-06 10:18:15',0,'Imported Contacts 39'),(470,1277,'2023-04-06 12:16:52',0,'Imported Contacts 40'),(507,1277,'2023-04-07 08:39:12',0,'Imported Contacts 41'),(518,1277,'2023-04-07 09:42:58',0,'Imported Contacts 42'),(533,1277,'2023-04-07 12:35:43',0,'Imported Contacts 43'),(542,1277,'2023-04-07 14:25:02',0,'Imported Contacts 44'),(564,1277,'2023-04-08 09:07:05',0,'Imported Contacts 45'),(570,1277,'2023-04-08 19:11:42',0,'Imported Contacts 46'),(579,1277,'2023-04-10 08:31:08',0,'Imported Contacts 47'),(597,1277,'2023-04-10 13:06:45',0,'Imported Contacts 48'),(606,1277,'2023-04-10 18:53:10',0,'Imported Contacts 49'),(617,1277,'2023-04-11 08:31:26',0,'Imported Contacts 50'),(621,1277,'2023-04-11 08:51:41',0,'Imported Contacts 51'),(640,1277,'2023-04-11 16:57:49',0,'Imported Contacts 52'),(641,1277,'2023-04-11 17:26:36',0,'Imported Contacts 53'),(642,1277,'2023-04-11 17:31:34',0,'Imported Contacts 54'),(644,1277,'2023-04-11 18:44:37',0,'Imported Contacts 55'),(664,1277,'2023-04-12 08:31:17',0,'Imported Contacts 56'),(698,1277,'2023-04-13 08:32:02',0,'Imported Contacts 57'),(709,1277,'2023-04-13 11:54:29',0,'Imported Contacts 58'),(714,1277,'2023-04-13 17:34:50',0,'Imported Contacts 59'),(718,1277,'2023-04-14 08:34:17',0,'Imported Contacts 60'),(730,1277,'2023-04-14 13:49:04',0,'Imported Contacts 61'),(735,1277,'2023-04-14 16:17:11',0,'Imported Contacts 62'),(738,1277,'2023-04-15 08:30:12',0,'Imported Contacts 63'),(748,1277,'2023-04-17 08:32:40',0,'Imported Contacts 64'),(764,1277,'2023-04-18 08:31:20',0,'Imported Contacts 65'),(794,1277,'2023-04-18 15:15:24',0,'Imported Contacts 66'),(799,1277,'2023-04-19 08:35:22',0,'Imported Contacts 67'),(813,1277,'2023-04-19 15:46:28',0,'Imported Contacts 68'),(829,1277,'2023-04-20 08:33:57',0,'Imported Contacts 69'),(830,1277,'2023-04-20 09:28:59',0,'Imported Contacts 70'),(831,1277,'2023-04-20 09:30:35',0,'Imported Contacts 71'),(848,1277,'2023-04-24 08:31:28',0,'Imported Contacts 72'),(856,1277,'2023-04-24 09:53:31',0,'Imported Contacts 73'),(868,1277,'2023-04-25 08:34:16',0,'Imported Contacts 74'),(878,1277,'2023-04-25 11:28:25',0,'Imported Contacts 75'),(881,1277,'2023-04-25 15:01:41',0,'Imported Contacts 76'),(921,1277,'2023-04-26 08:30:24',0,'Imported Contacts 77'),(935,1277,'2023-04-26 16:56:22',0,'Imported Contacts 78'),(958,1277,'2023-04-27 18:15:13',0,'Imported Contacts 79'),(962,1277,'2023-04-28 08:35:50',0,'Imported Contacts 80'),(977,1277,'2023-04-28 18:45:28',0,'Imported Contacts 81'),(980,1277,'2023-04-29 08:31:25',0,'Imported Contacts 82'),(1007,1277,'2023-05-02 10:07:59',0,'Imported Contacts 83'),(1016,1277,'2023-05-02 17:13:32',0,'Imported Contacts 84'),(1018,1277,'2023-05-03 08:28:39',0,'Imported Contacts 85'),(1044,1277,'2023-05-04 08:29:38',0,'Imported Contacts 86'),(1045,1277,'2023-05-04 08:36:55',0,'Imported Contacts 87'),(1065,1277,'2023-05-05 08:32:02',0,'Imported Contacts 88'),(1066,1277,'2023-05-05 08:44:55',0,'Imported Contacts 89'),(1073,1277,'2023-05-05 16:02:57',0,'Imported Contacts 90'),(1080,1277,'2023-05-06 08:31:01',0,'Imported Contacts 91'),(1098,1277,'2023-05-08 08:30:35',0,'Imported Contacts 92'),(1112,1277,'2023-05-08 10:23:27',0,'Imported Contacts 93'),(1116,1277,'2023-05-08 15:17:03',0,'Imported Contacts 94'),(1135,1277,'2023-05-09 08:29:57',0,'Imported Contacts 95'),(1142,1277,'2023-05-09 09:27:48',0,'Imported Contacts 96'),(1174,1277,'2023-05-10 08:34:31',0,'Imported Contacts 97'),(1188,1277,'2023-05-10 12:55:56',0,'Imported Contacts 98'),(1200,1277,'2023-05-11 08:31:59',0,'Imported Contacts 99'),(1206,1277,'2023-05-11 10:46:04',0,'Imported Contacts 100'),(1207,1277,'2023-05-11 10:51:49',0,'Imported Contacts 101'),(1223,1277,'2023-05-12 08:40:25',0,'Imported Contacts 102'),(1229,1277,'2023-05-12 17:49:44',0,'Imported Contacts 103');
/*!40000 ALTER TABLE `contactgroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'roundcube'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-08-27  6:29:37
-- MySQL dump 10.13  Distrib 5.7.41, for Linux (x86_64)
--
-- Host: localhost    Database: roundcube
-- ------------------------------------------------------
-- Server version	5.7.41-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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 `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) REFERENCES `contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contactgroupmembers`
--
-- WHERE:  contactgroup_id IN (13,21,52,61,70,77,86,98,121,135,136,164,177,182,196,205,211,222,227,238,245,257,266,286,287,295,340,378,388,402,414,419)

LOCK TABLES `contactgroupmembers` WRITE;
/*!40000 ALTER TABLE `contactgroupmembers` DISABLE KEYS */;
/*!40000 ALTER TABLE `contactgroupmembers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'roundcube'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-08-27  6:29:37
-- MySQL dump 10.13  Distrib 5.7.41, for Linux (x86_64)
--
-- Host: localhost    Database: roundcube
-- ------------------------------------------------------
-- Server version	5.7.41-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `contactgroupmembers`
--
-- WHERE:  contactgroup_id IN (432,433,452,454,463,466,467,470,507,518,533,542,564,570,579,597,606,617,621,640,641,642,644,664,698,709,714,718,730,735,738,748)

LOCK TABLES `contactgroupmembers` WRITE;
/*!40000 ALTER TABLE `contactgroupmembers` DISABLE KEYS */;
/*!40000 ALTER TABLE `contactgroupmembers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'roundcube'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-08-27  6:29:37
-- MySQL dump 10.13  Distrib 5.7.41, for Linux (x86_64)
--
-- Host: localhost    Database: roundcube
-- ------------------------------------------------------
-- Server version	5.7.41-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `contactgroupmembers`
--
-- WHERE:  contactgroup_id IN (764,794,799,813,829,830,831,848,856,868,878,881,921,935,958,962,977,980,1007,1016,1018,1044,1045,1065,1066,1073,1080,1098,1112,1116,1135,1142)

LOCK TABLES `contactgroupmembers` WRITE;
/*!40000 ALTER TABLE `contactgroupmembers` DISABLE KEYS */;
/*!40000 ALTER TABLE `contactgroupmembers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'roundcube'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-08-27  6:29:38
-- MySQL dump 10.13  Distrib 5.7.41, for Linux (x86_64)
--
-- Host: localhost    Database: roundcube
-- ------------------------------------------------------
-- Server version	5.7.41-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `contactgroupmembers`
--
-- WHERE:  contactgroup_id IN (1174,1188,1200,1206,1207,1223,1229)

LOCK TABLES `contactgroupmembers` WRITE;
/*!40000 ALTER TABLE `contactgroupmembers` DISABLE KEYS */;
/*!40000 ALTER TABLE `contactgroupmembers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'roundcube'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-08-27  6:29:38
