-- 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=1540 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--
-- WHERE:  user_id IN (236,1395,248,249,1141,117,1537,299)

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`user_id`, `username`, `mail_host`, `created`, `last_login`, `language`, `preferences`) VALUES (117,'serene@askpl.com.sg','localhost','2014-05-15 14:20:43','2017-02-27 17:21:20','en_US','a:5:{s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:11:\"client_hash\";s:32:\"7212ceff408266f0a943e58215cb05cd\";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;}'),(236,'alex@askpl.com.sg','localhost','2014-06-03 17:59:40','2015-09-10 12:03:48','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;}'),(248,'kee@askpl.com.sg','localhost','2014-06-05 17:45:01','2014-06-05 17:58:07','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;}'),(249,'kelvin@askpl.com.sg','localhost','2014-06-05 17:49:10','2015-11-20 16:35:14','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;}'),(299,'vincent@askpl.com.sg','localhost','2014-06-19 12:20:21','2017-02-28 16:27:46','en_US','a:10:{s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:18:\"message_show_email\";b:1;s:15:\"default_charset\";s:5:\"UTF-8\";s:16:\"message_sort_col\";s:7:\"subject\";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:\"575d95a2ca550a29cb67d727100beb24\";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;}'),(1141,'lynette@askpl.com.sg','localhost','2015-11-20 16:09:49','2016-02-02 10:05:17','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;}'),(1395,'ask@askpl.com.sg','localhost','2016-08-15 17:08:31','2017-02-23 16:55:08','en_GB','a:3:{s:9:\"junk_mbox\";s:10:\"INBOX.spam\";s:11:\"client_hash\";s:32:\"b8ec18c3bbb9f1b133ccd4442c1edd0f\";s:15:\"namespace_fixed\";b:1;}'),(1537,'tatt@askpl.com.sg','localhost','2017-02-21 11:40:09','2017-02-21 11:40:09','en_GB','a:3:{s:11:\"client_hash\";s:32:\"a946e3f57b1b43484884acf22bbf9ed4\";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) 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=1577 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `identities`
--
-- WHERE:  user_id IN (236,1395,248,249,1141,117,1537,299)

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 (116,117,'2016-11-29 11:29:56',0,1,'SERENE TAN','','serene@askpl.com.sg','','','<div class=\"pre\"><span style=\"text-decoration: underline\"><span style=\"color: #0000ff; font-family: \'book antiqua\', palatino, serif; font-size: 12pt; text-decoration: underline\">ASK ELECTRONIC PTE LTD</span></span></div>\r\n<div class=\"pre\"> </div>\r\n<div class=\"pre\"><strong><em><span style=\"font-size: 12pt\">SERENE TAN</span></em></strong></div>',1),(234,236,'2014-06-03 17:59:40',0,1,'','','alex@askpl.com.sg','','',NULL,0),(246,248,'2014-06-05 17:45:01',0,1,'','','kee@askpl.com.sg','','',NULL,0),(247,249,'2014-06-05 17:49:10',0,1,'','','kelvin@askpl.com.sg','','',NULL,0),(299,299,'2016-11-29 11:54:53',0,1,'Vincent Yong','','vincent@askpl.com.sg','','','<p><span style=\"font-family: trebuchet ms,geneva,sans-serif; font-size: 10pt\">Best regards,</span></p>\r\n<p><strong><span style=\"font-family: trebuchet ms,geneva,sans-serif; font-size: 10pt\">Vincent Yong</span></strong></p>\r\n<p> -</p>\r\n<p><span style=\"font-family: trebuchet ms,geneva,sans-serif; font-size: 10pt\"><strong>A S K Electronic Pte Ltd</strong></span></p>\r\n<p><span style=\"font-family: trebuchet ms,geneva,sans-serif; font-size: 10pt\">10, Jalan Besar, #01-05/06</span></p>\r\n<p><span style=\"font-family: trebuchet ms,geneva,sans-serif; font-size: 10pt\">Sim Lim Tower, Singapore 208787</span></p>\r\n<p><span style=\"font-family: trebuchet ms,geneva,sans-serif; font-size: 10pt\"><strong>Tel</strong>: +65 6296 0226 (4 Lines)  <strong>Fax</strong>: +65 6295 0020</span></p>\r\n<p><span style=\"font-family: trebuchet ms,geneva,sans-serif; font-size: 10pt\"><strong>Emai</strong>l: <a href=\"mailto:Vincent@askpl.com.sg\">Vincent@askpl.com.sg</a></span></p>',1),(1152,1141,'2015-11-20 16:09:49',0,1,'','','lynette@askpl.com.sg','','',NULL,0),(1423,1395,'2016-08-15 17:08:31',0,1,'','','ask@askpl.com.sg','','',NULL,0),(1574,1537,'2017-02-21 11:40:09',0,1,'','','tatt@askpl.com.sg','','',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=3994 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contacts`
--
-- WHERE:  user_id IN (236,1395,248,249,1141,117,1537,299)

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 (3028,'2015-08-19 18:42:19',0,'Lim Ah Ho','ahho@tp.edu.sg','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Lim Ah Ho\r\nEMAIL;TYPE=INTERNET:ahho@tp.edu.sg\r\nEND:VCARD',' ahho@tp.edu.sg lim ho',117),(3826,'2016-11-09 09:59:43',0,'Luxstyle','mail@luxstyleintl.com','Luxstyle','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Luxstyle;;;\r\nFN:Luxstyle\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:mail@luxstyleintl.com\r\nEND:VCARD',' luxstyle mail@luxstyleintl.com',117),(476,'2014-06-05 17:46:23',0,'Yong Vincent','vincent@askpl.com.sg','Yong','Vincent','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Vincent;Yong;;;\r\nFN:Yong Vincent\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:vincent@askpl.com.sg\r\nEND:VCARD',' yong vincent vincent@askpl.com.sg',248),(477,'2014-06-05 17:47:02',0,'Kelvin Yong','kelvin@askpl.com.sg','Kelvin','Yong','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Yong;Kelvin;;;\r\nFN:Kelvin Yong\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:kelvin@askpl.com.sg\r\nEND:VCARD',' kelvin yong kelvin@askpl.com.sg',248),(478,'2014-06-05 17:47:30',0,'Serene Tan','serene@askpl.com.sg','Serene','Tan','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Tan;Serene;;;\r\nFN:Serene Tan\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:serene@askpl.com.sg\r\nEND:VCARD',' serene tan serene@askpl.com.sg',248),(479,'2014-06-05 17:47:57',0,'Alex Chua','alex@askpl.com.sg','Alex','Chua','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Chua;Alex;;;\r\nFN:Alex Chua\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:alex@askpl.com.sg\r\nEND:VCARD',' alex chua alex@askpl.com.sg',248),(480,'2014-06-05 17:48:23',0,'Ask','ask@askpl.com.sg','Ask','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Ask;;;\r\nFN:Ask\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:ask@askpl.com.sg\r\nEND:VCARD',' ask ask@askpl.com.sg',248),(481,'2014-06-05 17:49:41',0,'Serene Tan','serene@askpl.com.sg','Serene','Tan','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Tan;Serene;;;\r\nFN:Serene Tan\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:serene@askpl.com.sg\r\nEND:VCARD',' serene tan serene@askpl.com.sg',249),(482,'2014-06-05 17:50:03',0,'Alex Chua','alex@askpl.com.sg','Alex','Chua','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Chua;Alex;;;\r\nFN:Alex Chua\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:alex@askpl.com.sg\r\nEND:VCARD',' alex chua alex@askpl.com.sg',249),(483,'2014-06-05 17:50:42',0,'Kee Tan','kee@askpl.com.sg','Kee','Tan','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Tan;Kee;;;\r\nFN:Kee Tan\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:kee@askpl.com.sg\r\nEND:VCARD',' kee tan kee@askpl.com.sg',249),(484,'2014-06-05 17:51:10',0,'Vincent Yong','vincent@askpl.com.sg','Vincent','Yong','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Yong;Vincent;;;\r\nFN:Vincent Yong\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:vincent@askpl.com.sg\r\nEND:VCARD',' vincent yong vincent@askpl.com.sg',249),(485,'2014-06-05 17:54:27',0,'Ask','ask@askpl.com.sg','Ask','','BEGIN:VCARD\r\nVERSION:3.0\r\nN:;Ask;;;\r\nFN:Ask\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:ask@askpl.com.sg\r\nEND:VCARD',' ask ask@askpl.com.sg',249),(3780,'2016-09-10 11:51:11',0,'Foh Chit Yee','chityee@yewlee.com.sg','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Foh Chit Yee\r\nEMAIL;TYPE=INTERNET:chityee@yewlee.com.sg\r\nEND:VCARD',' chityee@yewlee.com.sg foh chit yee',299),(3783,'2016-09-13 11:44:56',0,'suntronics','suntronics@pacific.net.sg','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:suntronics\r\nEMAIL;TYPE=INTERNET:suntronics@pacific.net.sg\r\nEND:VCARD',' suntronics@pacific.net.sg suntronics',299),(3790,'2016-09-22 15:58:19',0,'Shirah Hong','shirah@ap.logicalis.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Shirah Hong\r\nEMAIL;TYPE=INTERNET:shirah@ap.logicalis.com\r\nEND:VCARD',' shirah@ap.logicalis.com shirah hong',299),(3792,'2016-09-27 17:55:34',0,'Dominic Ang','dmncag1993@gmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Dominic Ang\r\nEMAIL;TYPE=INTERNET:dmncag1993@gmail.com\r\nEND:VCARD',' dmncag1993@gmail.com dominic ang',299),(3832,'2016-11-10 18:43:50',0,'David','david@pse.com.sg','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:David\r\nEMAIL;TYPE=INTERNET:david@pse.com.sg\r\nEND:VCARD',' david@pse.com.sg david',299),(3963,'2017-02-17 11:05:05',0,'Keegan Lim','keegan.lim@dormakaba.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Keegan Lim\r\nEMAIL;TYPE=INTERNET:keegan.lim@dormakaba.com\r\nEND:VCARD',' keegan.lim@dormakaba.com keegan lim',299),(3991,'2017-02-23 10:46:16',0,'Lim Chuan LEE (SPRING)','LEE_Lim_Chuan@spring.gov.sg','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Lim Chuan LEE (SPRING)\r\nEMAIL;TYPE=INTERNET:LEE_Lim_Chuan@spring.gov.sg\r\nEND:VCARD',' lee_lim_chuan@spring.gov.sg lim chuan lee (spring)',299);
/*!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=44 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contactgroups`
--
-- WHERE:  user_id IN (236,1395,248,249,1141,117,1537,299)

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 2017-03-01  5:13:42
-- 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 (3028,3826,476,477,478,479,480,481,482,483,484,485,3780,3783,3790,3792,3832,3963,3991)

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 2017-03-01  5:13:42
