File: /home/sanbercountryclu/cpmove_failed_mysql_dbs.1784905570/roundcube.sql
-- MySQL dump 10.13 Distrib 5.5.52, for Linux (x86_64)
--
-- Host: localhost Database: roundcube
-- ------------------------------------------------------
-- Server version 5.5.52-cll
/*!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 utf8 COLLATE utf8_bin NOT NULL,
`mail_host` varchar(128) NOT NULL,
`created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`last_login` datetime DEFAULT NULL,
`language` varchar(5) DEFAULT NULL,
`preferences` longtext,
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`username`,`mail_host`)
) ENGINE=InnoDB AUTO_INCREMENT=323 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
-- WHERE: user_id IN (226,68,250,199,80,161,73,66,81,302,64,65,114,237,281,74)
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`user_id`, `username`, `mail_host`, `created`, `last_login`, `language`, `preferences`) VALUES (64,'info@sanbercountryclub.com.py','localhost','2015-11-03 08:50:16','2023-12-06 11:38:40','es_ES','a:6:{s:11:\"search_mods\";a:4:{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:9:\"list_cols\";a:8:{i:0;s:7:\"threads\";i:1;s:6:\"fromto\";i:2;s:7:\"subject\";i:3;s:6:\"status\";i:4;s:4:\"date\";i:5;s:4:\"size\";i:6;s:4:\"flag\";i:7;s:10:\"attachment\";}s:11:\"client_hash\";s:32:\"83769063954616341102361e492de253\";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;}'),(65,'richard.martinez@sanbercountryclub.com.py','localhost','2015-11-04 12:01:29','2015-11-04 12:01:29','es_ES','a:3:{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;}'),(66,'contacto@sanbercountryclub.com.py','localhost','2015-11-06 14:56:18','2015-11-11 15:06:21','es_ES','a:3:{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;}'),(68,'administracion@sanbercountryclub.com.py','localhost','2015-11-11 15:32:19','2025-11-28 16:08:33','es_ES','a:5:{s:11:\"search_mods\";a:4:{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:11:\"client_hash\";s:32:\"cf15cb54e3792ea662f15b82664457a0\";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;}'),(73,'cobranzas@sanbercountryclub.com.py','localhost','2015-11-25 12:22:33','2016-04-15 09:14:26','es_ES','a:3:{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;}'),(74,'ventas@sanbercountryclub.com.py','localhost','2015-11-25 13:08:29','2023-11-29 11:29:26','es_ES','a:7:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";s:17:\"message_threading\";a:1:{s:11:\"INBOX.Trash\";b:0;}s:11:\"client_hash\";s:32:\"a1f424d7468f364bc7d04ff98dca6dcf\";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;}'),(80,'beatrizcaballero@sanbercountryclub.com.py','localhost','2015-12-16 09:11:10','2015-12-16 09:11:10','es_ES','a:5:{s:16:\"message_sort_col\";s:4:\"size\";s:18:\"message_sort_order\";s:3:\"ASC\";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;}'),(81,'credenciales@sanbercountryclub.com.py','localhost','2015-12-23 08:13:38','2019-07-25 16:25:08','es_ES','a:4:{s:11:\"client_hash\";s:32:\"3090d6ceea8e77ee8af1d0713943ea1e\";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;}'),(114,'test@sanbercountryclub.com.py','localhost','2016-07-25 14:47:46','2018-11-16 09:39:17','es_ES','a:2:{s:11:\"client_hash\";s:32:\"9ec656e9412ba4db9cdb540e26b8465f\";s:15:\"namespace_fixed\";b:1;}'),(161,'cobranzas2@sanbercountryclub.com.py','localhost','2017-06-16 15:16:45','2017-06-16 15:16:45','es_ES','a:2:{s:11:\"client_hash\";s:32:\"2d42f660e6a1b73daddba25c92675772\";s:15:\"namespace_fixed\";b:1;}'),(199,'ana.miltos@sanbercountryclub.com.py','localhost','2018-11-14 14:35:15','2018-11-14 14:35:15','es_ES','a:2:{s:11:\"client_hash\";s:32:\"4626eded32c94e5de76cacaf9386c298\";s:15:\"namespace_fixed\";b:1;}'),(226,'admin@sanbercountryclub.com.py','localhost','2020-02-12 09:35:25','2025-12-05 11:18:05','es_ES','a:2:{s:11:\"client_hash\";s:32:\"215c858b9f4398e23539f6d9334f46fc\";s:15:\"namespace_fixed\";b:1;}'),(237,'ventas1@sanbercountryclub.com.py','localhost','2020-09-14 15:40:39','2024-10-21 16:09:51','es_ES','a:8:{s:11:\"search_mods\";a:4:{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:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";s:23:\"addressbook_search_mods\";a:5:{s:4:\"name\";i:1;s:9:\"firstname\";i:1;s:7:\"surname\";i:1;s:5:\"email\";i:1;s:1:\"*\";i:1;}s:13:\"mail_pagesize\";i:25;s:17:\"message_threading\";a:1:{s:5:\"INBOX\";b:0;}s:11:\"client_hash\";s:32:\"be336a693821e8efaa7b0c8e4b8006e9\";s:15:\"namespace_fixed\";b:1;}'),(250,'administracionsb@sanbercountryclub.com.py','localhost','2022-01-06 11:05:35','2023-09-26 15:44:47','es_ES','a:2:{s:11:\"client_hash\";s:32:\"0624776102a695440583427e53d4240d\";s:15:\"namespace_fixed\";b:1;}'),(281,'ventas4@sanbercountryclub.com.py','localhost','2023-11-01 11:55:13','2026-01-03 14:20:23','es_ES','a:2:{s:11:\"client_hash\";s:32:\"15b9010ea725a9fa0890c97be04cfcde\";s:15:\"namespace_fixed\";b:1;}'),(302,'desa.country@sanbercountryclub.com.py','localhost','2024-07-11 11:55:56','2024-07-11 11:55:56','es_ES','a:2:{s:11:\"client_hash\";s:32:\"ba0f9d67e3a2cd3bc036ebe500f1ebbe\";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) 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` longtext,
`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=332 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `identities`
--
-- WHERE: user_id IN (226,68,250,199,80,161,73,66,81,302,64,65,114,237,281,74)
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 (64,64,'2015-11-03 08:50:16',0,1,'','','info@sanbercountryclub.com.py','','',NULL,0),(65,65,'2015-11-04 12:01:29',0,1,'','','richard.martinez@sanbercountryclub.com.py','','',NULL,0),(66,66,'2015-11-06 14:56:18',0,1,'','','contacto@sanbercountryclub.com.py','','',NULL,0),(68,68,'2015-11-11 15:32:19',0,1,'','','administracion@sanbercountryclub.com.py','','',NULL,0),(73,73,'2015-11-25 12:22:33',0,1,'','','cobranzas@sanbercountryclub.com.py','','',NULL,0),(74,74,'2015-11-25 13:08:29',0,1,'','','ventas@sanbercountryclub.com.py','','',NULL,0),(80,80,'2015-12-16 09:11:10',0,1,'','','beatrizcaballero@sanbercountryclub.com.py','','',NULL,0),(81,81,'2015-12-23 08:13:38',0,1,'','','credenciales@sanbercountryclub.com.py','','',NULL,0),(114,114,'2016-07-25 14:47:46',0,1,'','','test@sanbercountryclub.com.py','','',NULL,0),(161,161,'2017-06-16 15:16:45',0,1,'','','cobranzas2@sanbercountryclub.com.py','','',NULL,0),(199,199,'2018-11-14 14:35:15',0,1,'','','ana.miltos@sanbercountryclub.com.py','','',NULL,0),(227,226,'2020-02-12 09:35:25',0,1,'','','admin@sanbercountryclub.com.py','','',NULL,0),(238,237,'2020-09-14 15:40:39',0,1,'','','ventas1@sanbercountryclub.com.py','','',NULL,0),(251,250,'2022-01-06 11:05:35',0,1,'','','administracionsb@sanbercountryclub.com.py','','',NULL,0),(283,281,'2023-11-01 11:55:13',0,1,'','','ventas4@sanbercountryclub.com.py','','',NULL,0),(304,302,'2024-07-11 11:55:56',0,1,'','','desa.country@sanbercountryclub.com.py','','',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) 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=395 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contacts`
--
-- WHERE: user_id IN (226,68,250,199,80,161,73,66,81,302,64,65,114,237,281,74)
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 (373,'2018-11-24 10:36:22',0,'Ariel Prado','foodservice335@gmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Ariel Prado\r\nEMAIL;TYPE=INTERNET:foodservice335@gmail.com\r\nEND:VCARD',' foodservice335@gmail.com ariel prado',64),(377,'2021-12-23 12:08:09',0,'Edgar Marecos','edgarmf2@hotmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Edgar Marecos\r\nEMAIL;TYPE=INTERNET:edgarmf2@hotmail.com\r\nEND:VCARD',' edgarmf2@hotmail.com edgar marecos',74),(380,'2023-09-06 13:08:01',0,'','dulce.lopez@sanbercountryclub.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nEMAIL;TYPE=INTERNET;TYPE=OTHER:dulce.lopez@sanbercountryclub.com.py\r\nEND:VCARD',' dulce.lopez@sanbercountryclub.com.py',237),(381,'2023-06-22 13:11:03',0,'Ventas1','ventas1@sanbercountryclub.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Ventas1\r\nEMAIL;TYPE=INTERNET:ventas1@sanbercountryclub.com.py\r\nEND:VCARD',' ventas1@sanbercountryclub.com.py ventas1',237),(382,'2023-06-23 10:34:25',0,'Acazal','acazal@visionbanco.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Acazal\r\nEMAIL;TYPE=INTERNET:acazal@visionbanco.com\r\nEND:VCARD',' acazal@visionbanco.com acazal',237),(383,'2023-06-26 15:55:16',0,'Paz Peters','ppeters@paseolagaleria.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Paz Peters\r\nEMAIL;TYPE=INTERNET:ppeters@paseolagaleria.com.py\r\nEND:VCARD',' ppeters@paseolagaleria.com.py paz peters',237),(384,'2023-06-26 15:55:17',0,'Micaela Lozio','mlozio@paseolagaleria.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Micaela Lozio\r\nEMAIL;TYPE=INTERNET:mlozio@paseolagaleria.com.py\r\nEND:VCARD',' mlozio@paseolagaleria.com.py micala lozio',237),(385,'2023-06-28 10:58:53',0,'Olgacarolina','olgacarolina@msn.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Olgacarolina\r\nEMAIL;TYPE=INTERNET:olgacarolina@msn.com\r\nEND:VCARD',' olgacarolina@msn.com olgacarolina',237),(386,'2023-08-14 10:57:16',0,'Marcos Bertone| Digital Touch','marcosbertone@dt.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Marcos Bertone| Digital Touch\r\nEMAIL;TYPE=INTERNET:marcosbertone@dt.com.py\r\nEND:VCARD',' marcosbertone@dt.com.py marcos bertone| digital touch',237),(387,'2023-08-30 11:05:29',0,'Alan Acosta','aacosta@paseolagaleria.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Alan Acosta\r\nEMAIL;TYPE=INTERNET:aacosta@paseolagaleria.com.py\r\nEND:VCARD',' aacosta@paseolagaleria.com.py alan acosta',237),(388,'2023-09-21 14:26:33',0,'Administración','administracion@sanbercountryclub.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Administración\r\nEMAIL;TYPE=INTERNET:administracion@sanbercountryclub.com.py\r\nEND:VCARD',' administracion@sanbercountryclub.com.py administracion',237);
/*!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) 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=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contactgroups`
--
-- WHERE: user_id IN (226,68,250,199,80,161,73,66,81,302,64,65,114,237,281,74)
LOCK TABLES `contactgroups` WRITE;
/*!40000 ALTER TABLE `contactgroups` DISABLE KEYS */;
/*!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 2026-07-24 10:50:40
-- MySQL dump 10.13 Distrib 5.5.52, for Linux (x86_64)
--
-- Host: localhost Database: roundcube
-- ------------------------------------------------------
-- Server version 5.5.52-cll
/*!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 `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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contactgroupmembers`
--
-- WHERE: contact_id IN (373,377,380,381,382,383,384,385,386,387,388)
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 2026-07-24 10:50:40