File: /home/w3com/cpmove_failed_mysql_dbs.1778522996/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 (109,244,213,35,236,255,227,248,112,132,131,202,174,163,187,228,276,235,165,14,34,204,173,30,317,176,214,57,32,273,211,266,166,17,316,169,278,11,128,31,229,90,240,221,251,274,264,205,12,82,59,100,290,256,56,315,168)
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`user_id`, `username`, `mail_host`, `created`, `last_login`, `language`, `preferences`) VALUES (11,'nadia.sosa@w3.com.py','localhost','2014-07-11 12:49:12','2014-09-30 15:22:25','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;}'),(12,'sergio.came@w3.com.py','localhost','2014-07-18 13:18:46','2014-08-20 12:49:00','es_ES','a:4:{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: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;}'),(14,'istvan.nagy@w3.com.py','localhost','2014-08-08 17:26:43','2022-12-23 09:48:40','es_ES','a:12:{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:10:\"htmleditor\";i:1;s:11:\"show_images\";i:2;s:15:\"default_charset\";s:5:\"UTF-8\";s:9:\"list_cols\";a:8:{i:0;s:7:\"threads\";i:1;s:7:\"subject\";i:2;s:4:\"flag\";i:3;s:6:\"status\";i:4;s:6:\"fromto\";i:5;s:4:\"date\";i:6;s:4:\"size\";i:7;s:10:\"attachment\";}s:12:\"preview_pane\";s:1:\"0\";s:11:\"client_hash\";s:32:\"9fdba53ce98c271f71228d0bb1cc066b\";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,'marcelo.gonzalez@w3.com.py','localhost','2014-09-29 17:09:05','2015-04-14 16:21:53','en_US','a:6:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";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: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;}'),(30,'jose.avalos@w3.com.py','localhost','2014-12-12 08:15:50','2015-11-18 07:53:06','es_ES','a:6:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";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: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;}'),(31,'oscar.oviedo@w3.com.py','localhost','2015-01-26 09:36:41','2015-01-26 09:41:23','en_US','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;}'),(32,'liza.martinez@w3.com.py','localhost','2015-02-04 10:14:44','2017-07-13 13:31:13','es_ES','a:4:{s:11:\"client_hash\";s:32:\"73e6a7fae656da5735e561c7f94e5cdd\";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;}'),(34,'javier.lopez@w3.com.py','localhost','2015-02-09 10:25:14','2020-02-27 12:31:44','es_ES','a:7:{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:\"8e59317104a4c36ee5196fb6fc49ad37\";s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";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;}'),(35,'belen.alarcon@w3.com.py','localhost','2015-02-11 12:54:51','2025-07-30 08:36:43','es_ES','a:8:{s:16:\"message_sort_col\";s:6:\"fromto\";s:18:\"message_sort_order\";s:3:\"ASC\";s:12:\"preview_pane\";s:1:\"0\";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:\"f040183fec2f5bab211ede18d957ff33\";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;}'),(56,'w3com','localhost','2015-09-23 12:01:41','2020-02-27 13:41:34','es_ES','a:6:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:3:\"ASC\";s:11:\"client_hash\";s:32:\"c271fe7a7d88a9c6541ad7ca031f9535\";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;}'),(57,'leo.gaona@w3.com.py','localhost','2015-09-23 15:33:43','2018-06-25 15:45:01','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:\"fe068e0dd44298b00f4debf1646b7872\";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;}'),(59,'soporte@w3.com.py','localhost','2015-10-15 09:44:50','2025-07-15 09:26:18','es_ES','a:4:{s:11:\"client_hash\";s:32:\"680f13a960e186aaaf17ab648b7f13b2\";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;}'),(82,'smtp@w3.com.py','localhost','2015-12-23 09:45:16','2015-12-23 09:45:16','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;}'),(90,'paulo.santos@w3.com.py','localhost','2016-02-19 14:58:24','2016-11-16 09:07:45','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:\"6a2d966b25f09fda508b605004a47e89\";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;}'),(100,'test@w3.com.py','localhost','2016-04-14 16:44:26','2016-04-15 09:58:13','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;}'),(109,'alejandro.mussi@w3.com.py','localhost','2016-05-27 12:41:08','2025-04-08 09:07:10','en_US','a:2:{s:11:\"client_hash\";s:32:\"a344d94cca534c02f57cca6905751141\";s:15:\"namespace_fixed\";b:1;}'),(112,'daisy.benitez@w3.com.py','localhost','2016-06-24 07:48:28','2020-02-27 13:27:12','es_ES','a:2:{s:11:\"client_hash\";s:32:\"428ad47a21a78fcb9a892f2e961ebca1\";s:15:\"namespace_fixed\";b:1;}'),(128,'orne.tirabosco@w3.com.py','localhost','2016-08-12 11:44:05','2016-10-18 17:07:39','es_ES','a:2:{s:11:\"client_hash\";s:32:\"f8786ce25c4042c324556dca070bf648\";s:15:\"namespace_fixed\";b:1;}'),(131,'dinamoparaguay@w3.com.py','localhost','2016-08-25 16:54:11','2016-08-25 16:54:11','es_ES','a:2:{s:11:\"client_hash\";s:32:\"3a00faaa4380b6f411ec7f0002000e18\";s:15:\"namespace_fixed\";b:1;}'),(132,'derlis.cabrera@w3.com.py','localhost','2016-08-29 09:13:13','2020-02-27 12:43:10','es_ES','a:2:{s:11:\"client_hash\";s:32:\"5361e5f43a77b8e06cb71fd15c8b7cca\";s:15:\"namespace_fixed\";b:1;}'),(163,'felipa.pereira@w3.com.py','localhost','2017-06-28 15:37:57','2020-02-27 12:24:38','es_ES','a:5:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:3:\"ASC\";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:\"51195cd9b7433df7c0df94d06638dd28\";s:15:\"namespace_fixed\";b:1;}'),(165,'info@w3.com.py','localhost','2017-07-11 11:18:01','2025-04-14 16:02:24','es_ES','a:3:{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:\"c07cbcd88d1d02d903ca970b6c174a15\";s:15:\"namespace_fixed\";b:1;}'),(166,'marcelo.acosta@w3.com.py','localhost','2017-07-13 12:29:47','2017-07-13 12:31:51','es_ES','a:2:{s:11:\"client_hash\";s:32:\"7b9cf4f5b197fc689fac895db10e63c6\";s:15:\"namespace_fixed\";b:1;}'),(168,'xavi.lopez@w3.com.py','localhost','2017-08-29 17:05:15','2017-08-29 17:05:15','es_ES','a:2:{s:11:\"client_hash\";s:32:\"c6bb62bb729730a5cf0e87df9276a0b4\";s:15:\"namespace_fixed\";b:1;}'),(169,'martin.cubilla@w3.com.py','localhost','2017-08-29 17:10:13','2026-04-26 19:07:21','es_ES','a:5:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";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:\"67248625b6b7d66de9450737ec44a840\";s:15:\"namespace_fixed\";b:1;}'),(173,'jleivafarfan@w3.com.py','localhost','2017-09-29 16:34:59','2023-02-17 09:05:16','es_ES','a:7:{s:16:\"message_sort_col\";s:6:\"fromto\";s:18:\"message_sort_order\";s:4:\"DESC\";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:14:\"message_extwin\";i:1;s:15:\"default_charset\";s:5:\"UTF-8\";s:11:\"client_hash\";s:32:\"f712e35fe975838dbbe1180b71ed6227\";s:15:\"namespace_fixed\";b:1;}'),(174,'enrique.santacruz@w3.com.py','localhost','2017-10-03 09:51:20','2017-10-03 10:01:44','es_ES','a:2:{s:11:\"client_hash\";s:32:\"7eb7e101b2e0fa4780a1186d13044d3c\";s:15:\"namespace_fixed\";b:1;}'),(176,'julio.ozorio@w3.com.py','localhost','2017-10-23 09:28:50','2017-10-24 16:08:18','es_ES','a:2:{s:11:\"client_hash\";s:32:\"591a7e467334f5e844194952ed5062c1\";s:15:\"namespace_fixed\";b:1;}'),(187,'formelcomercio@w3.com.py','localhost','2018-04-18 10:39:02','2018-04-18 14:27:30','es_ES','a:2:{s:11:\"client_hash\";s:32:\"290f0763d44bb3da6c01f2e316e91eab\";s:15:\"namespace_fixed\";b:1;}'),(202,'endrigo.rivas@w3.com.py','localhost','2018-11-20 16:18:29','2018-11-20 16:18:29','es_ES','a:3:{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:\"b7a25fc0d9cab4c7dd9db30e5eb86eff\";s:15:\"namespace_fixed\";b:1;}'),(204,'jazmin.figueredo@w3.com.py','localhost','2018-12-04 10:05:30','2018-12-04 10:05:30','es_ES','a:2:{s:11:\"client_hash\";s:32:\"b1fcb48aabc72c008792e95222abc1fa\";s:15:\"namespace_fixed\";b:1;}'),(205,'saul.sanchez@w3.com.py','localhost','2018-12-05 10:07:32','2020-02-27 12:44:07','es_ES','a:5:{s:16:\"message_sort_col\";s:6:\"fromto\";s:18:\"message_sort_order\";s:3:\"ASC\";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:\"e827025c3d672aed049015cac8a5bf11\";s:15:\"namespace_fixed\";b:1;}'),(211,'mailing@w3.com.py','localhost','2019-02-11 16:02:10','2022-01-26 16:35:31','es_ES','a:2:{s:11:\"client_hash\";s:32:\"eda94f570a0477081519a76e6eaf54a5\";s:15:\"namespace_fixed\";b:1;}'),(213,'antonella.azuaga@w3.com.py','localhost','2019-03-25 10:36:10','2021-02-26 09:50:40','es_ES','a:6:{s:16:\"message_sort_col\";s:7:\"arrival\";s:18:\"message_sort_order\";s:4:\"DESC\";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:3:{i:0;s:7:\"threads\";i:1;s:7:\"subject\";i:2;s:6:\"status\";}s:11:\"client_hash\";s:32:\"0a6b13b6e76040700897cb66df824643\";s:15:\"namespace_fixed\";b:1;}'),(214,'land1@w3.com.py','localhost','2019-04-11 20:21:48','2019-04-11 20:21:48','es_ES','a:2:{s:11:\"client_hash\";s:32:\"7f9bef6c457869b1ffe5135fbcdaadc7\";s:15:\"namespace_fixed\";b:1;}'),(221,'paz.bernardes@w3.com.py','localhost','2019-07-03 09:20:39','2025-04-14 16:10:14','es_ES','a:3:{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:\"65713b0fa30d4acb11d552e7b38f1935\";s:15:\"namespace_fixed\";b:1;}'),(227,'communitymanager@w3.com.py','localhost','2020-02-27 12:32:54','2020-02-27 12:32:54','es_ES','a:2:{s:11:\"client_hash\";s:32:\"18efa963119f04833df4067b1f656aa9\";s:15:\"namespace_fixed\";b:1;}'),(228,'gerencia@w3.com.py','localhost','2020-02-27 12:34:38','2020-02-27 12:34:38','es_ES','a:2:{s:11:\"client_hash\";s:32:\"7b5924b387436dba3e1400d5f6f59f19\";s:15:\"namespace_fixed\";b:1;}'),(229,'pamela.perez@w3.com.py','localhost','2020-03-30 15:52:09','2020-04-21 13:53:40','es_ES','a:2:{s:11:\"client_hash\";s:32:\"2d42a9329af55f47ab771cf8fece637a\";s:15:\"namespace_fixed\";b:1;}'),(235,'impresora.alejandro@w3.com.py','localhost','2020-04-13 11:37:23','2020-04-13 11:37:23','es_ES','a:2:{s:11:\"client_hash\";s:32:\"5fbf00a2628603da60be80e6604fdbb4\";s:15:\"namespace_fixed\";b:1;}'),(236,'belen.araujo@w3.com.py','localhost','2020-04-21 13:54:34','2021-12-01 09:18:36','es_ES','a:2:{s:11:\"client_hash\";s:32:\"d50cbe72062e8917847e15f7f1c4f535\";s:15:\"namespace_fixed\";b:1;}'),(240,'pautas@w3.com.py','localhost','2020-10-01 11:06:21','2020-10-01 11:06:21','es_ES','a:2:{s:11:\"client_hash\";s:32:\"299b849bf3a717499f019ad6d4db6bf6\";s:15:\"namespace_fixed\";b:1;}'),(244,'amussi@w3.com.py','localhost','2021-04-30 09:07:20','2021-04-30 09:07:20','es_ES','a:2:{s:11:\"client_hash\";s:32:\"1508d1a9edbab8447ad0058821f6610d\";s:15:\"namespace_fixed\";b:1;}'),(248,'cpanel@w3.com.py','localhost','2021-11-08 15:36:35','2021-11-08 15:36:35','es_ES','a:2:{s:11:\"client_hash\";s:32:\"e59509dfcc7f667c252714a998f02576\";s:15:\"namespace_fixed\";b:1;}'),(251,'proveedores@w3.com.py','localhost','2022-01-17 11:19:29','2022-01-17 11:19:29','es_ES','a:2:{s:11:\"client_hash\";s:32:\"3a20546655423264ff3fd8e73865aa1f\";s:15:\"namespace_fixed\";b:1;}'),(255,'certificados@w3.com.py','localhost','2022-01-31 14:31:24','2022-01-31 14:31:24','es_ES','a:2:{s:11:\"client_hash\";s:32:\"cd0fee0b86621c1e3f942e2be648195b\";s:15:\"namespace_fixed\";b:1;}'),(256,'victor.segovia@w3.com.py','localhost','2022-02-07 10:38:16','2022-02-07 10:38:16','es_ES','a:2:{s:11:\"client_hash\";s:32:\"f2ca621c1841e0ee1c06d5d03a0f250f\";s:15:\"namespace_fixed\";b:1;}'),(264,'rosa.simbron@w3.com.py','localhost','2022-09-29 13:57:29','2025-09-30 19:32:24','es_ES','a:5:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";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:\"4b50b25dacc823c647f03935ab954678\";s:15:\"namespace_fixed\";b:1;}'),(266,'marcas@w3.com.py','localhost','2022-10-07 10:04:44','2022-10-07 10:04:44','es_ES','a:2:{s:11:\"client_hash\";s:32:\"9f8af8c51334a13d9451a7d744da6a54\";s:15:\"namespace_fixed\";b:1;}'),(273,'macbook@w3.com.py','localhost','2023-01-12 15:33:47','2023-01-12 15:33:47','es_ES','a:2:{s:11:\"client_hash\";s:32:\"c323ac41fa5a31e34710ce5210cc58d7\";s:15:\"namespace_fixed\";b:1;}'),(274,'redesocialesbiooil@w3.com.py','localhost','2023-02-01 16:50:23','2026-04-28 13:56:55','es_ES','a:2:{s:11:\"client_hash\";s:32:\"361de788ad323aaf3e2305c2043cf5ff\";s:15:\"namespace_fixed\";b:1;}'),(276,'giannina.pereira@w3.com.py','localhost','2023-04-21 15:09:21','2023-04-21 15:09:21','es_ES','a:3:{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:\"792d6375c030f3b8559115844d1939a8\";s:15:\"namespace_fixed\";b:1;}'),(278,'mc@w3.com.py','localhost','2023-10-16 09:55:19','2023-10-16 09:55:19','es_ES','a:2:{s:11:\"client_hash\";s:32:\"321a7f14002992f5aa073544f4450fba\";s:15:\"namespace_fixed\";b:1;}'),(290,'testins@w3.com.py','localhost','2024-03-25 15:55:38','2024-03-25 15:55:38','es_ES','a:2:{s:11:\"client_hash\";s:32:\"582e334dc2412f3caf911f2c94d6c9ce\";s:15:\"namespace_fixed\";b:1;}'),(315,'webmaster@w3.com.py','localhost','2025-06-18 09:03:44','2025-06-18 09:03:44','es_ES','a:2:{s:11:\"client_hash\";s:32:\"0a8c1d881a6de4240163dad1d0988cac\";s:15:\"namespace_fixed\";b:1;}'),(316,'marcos.frutos@w3.com.py','localhost','2025-08-06 09:22:37','2025-08-06 09:22:37','es_ES','a:2:{s:11:\"client_hash\";s:32:\"331561b14ed1d514c16242e55cf15349\";s:15:\"namespace_fixed\";b:1;}'),(317,'juan.marin@w3.com.py','localhost','2026-01-14 16:41:47','2026-01-14 16:41:47','es_ES','a:3:{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:\"fc9945f0a0b72fa2d227182e3fb28c68\";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 (109,244,213,35,236,255,227,248,112,132,131,202,174,163,187,228,276,235,165,14,34,204,173,30,317,176,214,57,32,273,211,266,166,17,316,169,278,11,128,31,229,90,240,221,251,274,264,205,12,82,59,100,290,256,56,315,168)
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 (11,11,'2014-07-11 12:49:13',0,1,'','','nadia.sosa@w3.com.py','','',NULL,0),(12,12,'2014-07-18 13:18:46',0,1,'','','sergio.came@w3.com.py','','',NULL,0),(14,14,'2014-08-08 17:26:44',0,1,'','','istvan.nagy@w3.com.py','','',NULL,0),(17,17,'2014-09-29 17:09:05',0,1,'','','marcelo.gonzalez@w3.com.py','','',NULL,0),(30,30,'2014-12-12 08:15:50',0,1,'','','jose.avalos@w3.com.py','','',NULL,0),(31,31,'2015-01-26 09:36:41',0,1,'','','oscar.oviedo@w3.com.py','','',NULL,0),(32,32,'2015-02-04 10:14:44',0,1,'','','liza.martinez@w3.com.py','','',NULL,0),(34,34,'2015-02-09 10:25:14',0,1,'','','javier.lopez@w3.com.py','','',NULL,0),(35,35,'2015-02-11 12:54:51',0,1,'','','belen.alarcon@w3.com.py','','',NULL,0),(56,56,'2015-09-23 12:01:41',0,1,'w3com','','w3com@w3.com.py','','',NULL,0),(57,57,'2015-09-23 15:33:43',0,1,'','','leo.gaona@w3.com.py','','',NULL,0),(59,59,'2015-10-15 09:44:50',0,1,'','','soporte@w3.com.py','','',NULL,0),(82,82,'2015-12-23 09:45:16',0,1,'','','smtp@w3.com.py','','',NULL,0),(90,90,'2016-02-19 14:58:24',0,1,'','','paulo.santos@w3.com.py','','',NULL,0),(100,100,'2016-04-14 16:44:26',0,1,'','','test@w3.com.py','','',NULL,0),(109,109,'2016-05-27 12:41:08',0,1,'','','alejandro.mussi@w3.com.py','','',NULL,0),(112,112,'2016-06-24 07:48:28',0,1,'','','daisy.benitez@w3.com.py','','',NULL,0),(128,128,'2016-08-12 11:44:06',0,1,'','','orne.tirabosco@w3.com.py','','',NULL,0),(131,131,'2016-08-25 16:54:11',0,1,'','','dinamoparaguay@w3.com.py','','',NULL,0),(132,132,'2016-08-29 09:13:13',0,1,'','','derlis.cabrera@w3.com.py','','',NULL,0),(163,163,'2017-06-28 15:37:57',0,1,'','','felipa.pereira@w3.com.py','','',NULL,0),(165,165,'2017-07-11 11:18:01',0,1,'','','info@w3.com.py','','',NULL,0),(166,166,'2017-07-13 12:29:47',0,1,'','','marcelo.acosta@w3.com.py','','',NULL,0),(168,168,'2017-08-29 17:05:15',0,1,'','','xavi.lopez@w3.com.py','','',NULL,0),(169,169,'2017-08-29 17:10:14',0,1,'','','martin.cubilla@w3.com.py','','',NULL,0),(173,173,'2017-09-29 16:34:59',0,1,'','','jleivafarfan@w3.com.py','','',NULL,0),(174,174,'2017-10-03 09:51:20',0,1,'','','enrique.santacruz@w3.com.py','','',NULL,0),(176,176,'2017-10-23 09:28:50',0,1,'','','julio.ozorio@w3.com.py','','',NULL,0),(187,187,'2018-04-18 10:39:03',0,1,'','','formelcomercio@w3.com.py','','',NULL,0),(202,202,'2018-11-20 16:18:29',0,1,'','','endrigo.rivas@w3.com.py','','',NULL,0),(204,204,'2018-12-04 10:05:30',0,1,'','','jazmin.figueredo@w3.com.py','','',NULL,0),(205,205,'2018-12-05 10:07:32',0,1,'','','saul.sanchez@w3.com.py','','',NULL,0),(211,211,'2019-02-11 16:02:10',0,1,'','','mailing@w3.com.py','','',NULL,0),(213,213,'2019-03-25 10:36:10',0,1,'','','antonella.azuaga@w3.com.py','','',NULL,0),(214,214,'2019-04-11 20:21:48',0,1,'','','land1@w3.com.py','','',NULL,0),(222,221,'2019-07-03 09:20:39',0,1,'','','paz.bernardes@w3.com.py','','',NULL,0),(228,227,'2020-02-27 12:32:54',0,1,'','','communitymanager@w3.com.py','','',NULL,0),(229,228,'2020-02-27 12:34:38',0,1,'','','gerencia@w3.com.py','','',NULL,0),(230,229,'2020-03-30 15:52:09',0,1,'','','pamela.perez@w3.com.py','','',NULL,0),(236,235,'2020-04-13 11:37:23',0,1,'','','impresora.alejandro@w3.com.py','','',NULL,0),(237,236,'2020-04-21 13:54:34',0,1,'','','belen.araujo@w3.com.py','','',NULL,0),(241,240,'2020-10-01 11:06:21',0,1,'','','pautas@w3.com.py','','',NULL,0),(245,244,'2021-04-30 09:07:20',0,1,'','','amussi@w3.com.py','','',NULL,0),(249,248,'2021-11-08 15:36:35',0,1,'','','cpanel@w3.com.py','','',NULL,0),(252,251,'2022-01-17 11:19:29',0,1,'','','proveedores@w3.com.py','','',NULL,0),(256,255,'2022-01-31 14:31:24',0,1,'','','certificados@w3.com.py','','',NULL,0),(257,256,'2022-02-07 10:38:16',0,1,'','','victor.segovia@w3.com.py','','',NULL,0),(265,264,'2022-09-29 13:57:29',0,1,'','','rosa.simbron@w3.com.py','','',NULL,0),(267,266,'2022-10-07 10:04:44',0,1,'','','marcas@w3.com.py','','',NULL,0),(275,273,'2023-01-12 15:33:47',0,1,'','','macbook@w3.com.py','','',NULL,0),(276,274,'2023-02-01 16:50:23',0,1,'','','redesocialesbiooil@w3.com.py','','',NULL,0),(278,276,'2023-04-21 15:09:21',0,1,'','','giannina.pereira@w3.com.py','','',NULL,0),(280,278,'2023-10-16 09:55:19',0,1,'','','mc@w3.com.py','','',NULL,0),(292,290,'2024-03-25 15:55:38',0,1,'','','testins@w3.com.py','','',NULL,0),(324,315,'2025-06-18 09:03:44',0,1,'','','webmaster@w3.com.py','','',NULL,0),(325,316,'2025-08-06 09:22:37',0,1,'','','marcos.frutos@w3.com.py','','',NULL,0),(326,317,'2026-01-14 16:41:47',0,1,'','','juan.marin@w3.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 (109,244,213,35,236,255,227,248,112,132,131,202,174,163,187,228,276,235,165,14,34,204,173,30,317,176,214,57,32,273,211,266,166,17,316,169,278,11,128,31,229,90,240,221,251,274,264,205,12,82,59,100,290,256,56,315,168)
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 (374,'2020-09-22 14:08:15',0,'Psi','psi@psi.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Psi\r\nEMAIL;TYPE=INTERNET:psi@psi.com.py\r\nEND:VCARD',' psi@psi.com.py psi',14),(375,'2020-11-16 14:05:08',0,'Alicia Diaz Peña Cipolla','alicia.diaz@boller.com.py','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Alicia Diaz Peña Cipolla\r\nEMAIL;TYPE=INTERNET:alicia.diaz@boller.com.py\r\nEND:VCARD',' alicia.diaz@boller.com.py alicia diaz pena cipolla',14);
/*!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 (109,244,213,35,236,255,227,248,112,132,131,202,174,163,187,228,276,235,165,14,34,204,173,30,317,176,214,57,32,273,211,266,166,17,316,169,278,11,128,31,229,90,240,221,251,274,264,205,12,82,59,100,290,256,56,315,168)
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-05-11 12:25:07
-- 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 (374,375)
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-05-11 12:25:07