--
-- Host: localhost    Database: imscp_roundcube
-- ------------------------------------------------------


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

CREATE TABLE `cache` (
  `user_id` int(10) unsigned NOT NULL,
  `cache_key` varchar(128) CHARACTER SET ascii NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `data` longtext NOT NULL,
  KEY `created_index` (`created`),
  KEY `user_cache_index` (`user_id`,`cache_key`),
  CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


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

CREATE TABLE `cache_index` (
  `user_id` int(10) unsigned NOT NULL,
  `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `valid` tinyint(1) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  PRIMARY KEY (`user_id`,`mailbox`),
  KEY `changed_index` (`changed`),
  CONSTRAINT `user_id_fk_cache_index` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


--
-- Table structure for table `cache_messages`
--

CREATE TABLE `cache_messages` (
  `user_id` int(10) unsigned NOT NULL,
  `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `data` longtext NOT NULL,
  `flags` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`mailbox`,`uid`),
  KEY `changed_index` (`changed`),
  CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_messages`
--


--
-- Table structure for table `cache_thread`
--

CREATE TABLE `cache_thread` (
  `user_id` int(10) unsigned NOT NULL,
  `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `data` longtext NOT NULL,
  PRIMARY KEY (`user_id`,`mailbox`),
  KEY `changed_index` (`changed`),
  CONSTRAINT `user_id_fk_cache_thread` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_thread`
--


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

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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `contactgroupmembers`
--

INSERT INTO `contactgroupmembers` VALUES (1,8,'2013-06-29 06:10:49'),(1,9,'2013-06-29 06:14:19'),(1,10,'2013-06-29 06:16:44'),(2,1,'2013-06-29 05:42:42'),(2,2,'2013-06-29 05:42:54'),(2,3,'2013-06-29 05:42:49'),(2,4,'2013-06-29 05:42:31'),(2,5,'2013-06-29 05:42:36'),(3,6,'2013-06-29 05:52:18'),(3,7,'2013-06-29 05:52:25'),(4,9,'2013-06-29 06:13:10'),(5,8,'2013-06-29 06:10:45'),(7,10,'2013-06-29 06:16:45'),(8,11,'2014-03-24 09:16:09'),(8,13,'2014-03-24 09:20:03'),(8,14,'2014-03-24 09:23:20'),(8,16,'2014-03-24 09:30:55'),(8,17,'2014-03-24 09:34:25'),(8,18,'2014-03-24 09:42:43'),(8,19,'2014-03-24 09:43:31'),(8,20,'2014-03-24 09:44:32'),(8,21,'2014-03-24 09:46:28'),(8,22,'2014-03-24 09:47:51'),(8,23,'2014-03-24 09:48:49'),(8,24,'2014-03-24 09:49:41'),(8,25,'2014-03-24 09:50:52'),(8,26,'2014-03-24 09:51:33'),(8,27,'2014-03-24 09:52:29'),(8,28,'2014-03-24 09:53:54'),(8,29,'2014-03-24 09:54:43'),(8,30,'2014-03-24 09:55:59'),(8,31,'2014-03-24 09:56:39'),(8,32,'2014-03-24 09:58:44'),(8,33,'2014-03-24 09:59:24');

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

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=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contactgroups`
--

INSERT INTO `contactgroups` VALUES (1,2,'2013-06-29 05:51:19',0,'EDI/AS2 Contacts'),(2,2,'2013-06-29 05:42:19',0,'Retail Service Systems'),(3,2,'2013-06-29 05:50:26',0,'VN Boyd'),(4,2,'2013-06-29 05:50:41',0,'VN Harden'),(5,2,'2013-06-29 05:50:51',0,'VN Corsicana'),(6,2,'2013-06-29 05:50:16',1,'Harden 2'),(7,2,'2013-06-29 05:50:33',0,'VN Sealy'),(8,9,'2014-03-24 09:15:00',0,'RSS Website Group');

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

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=38 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES (1,'2013-06-29 06:05:02',0,'Gary Davis','gary@retailservicesystems.com','Gary','Davis','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Davis;Gary;;;\r\nFN:Gary Davis\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:gary@retailservicesystems.com\r\nTITLE:Dealer Support Manager & Website\r\nORG:Retail Service Systems\\, Inc.\r\nADR;TYPE=work:;;6059 Frantz Road Suite #204;Dublin\\, OH;;43017;\r\nEND:VCARD',' gary davis gary@retailservicesystems.com dealer support manager & website retail service systems, inc. 6059 frantz road suite #204 dublin, 43017',2),(2,'2013-06-29 06:07:21',0,'Jerry Williams','jerry@retailservicesystems.com','Jerry','Williams','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Williams;Jerry;;;\r\nFN:Jerry Williams\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:jerry@retailservicesystems.com\r\nTITLE:General Manager\r\nORG:Retail Service Systems\\, Inc.\r\nX-GENDER:male\r\nTEL;TYPE=CELL:614-439-6984\r\nADR;TYPE=work:;;6059 Frantz Road\\, Suite 204;Dublin\\, OH;;43017;\r\nEND:VCARD',' jerry williams jerry@retailservicesystems.com general manager retail service systems, inc. 6144396984 6059 frantz road, suite dublin, 43017',2),(3,'2013-06-29 06:04:08',0,'George Varn','george@retailservicesystems.com','George','Varn','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Varn;George;;;\r\nFN:George Varn\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:george@retailservicesystems.com\r\nORG:Retail Service Systems\\, Inc.\r\nTEL;TYPE=work:850-508-1166\r\nEND:VCARD',' george varn george@retailservicesystems.com retail service systems, inc. 8505081166',2),(4,'2013-06-29 06:01:06',0,'Scott Andrew','scott@retailservicesystems.com','Scott','Andrew','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Andrew;Scott;;;\r\nFN:Scott Andrew\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:scott@retailservicesystems.com\r\nTITLE:President\r\nORG:Retail Service Systems\\, Inc.\r\nTEL;TYPE=work:864-525-6895 \r\nEND:VCARD',' scott andrew scott@retailservicesystems.com president retail service systems, inc. 8645256895',2),(5,'2013-06-29 06:02:50',0,'Amy Bowen','amy@retailservicesystems.com','Amy','Bowen','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Bowen;Amy;;;\r\nFN:Amy Bowen\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:amy@retailservicesystems.com\r\nTITLE:Senior Accountant\r\nORG:Retail Service Systems\\, Inc.\r\nX-GENDER:female\r\nTEL;TYPE=work:614-203-6126\r\nADR;TYPE=work:;;6059 Frantz Road Suite #204;Dublin\\, OH;;43017;\r\nEND:VCARD',' amy bowen amy@retailservicesystems.com senior accountant retail service systems, inc. 6142036126 6059 frantz road suite #204 dublin, 43017',2),(6,'2013-06-29 05:59:04',0,'Mary Hodapp','mhodapp@boydspecialtysleep.com','Mary','Hodapp','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Hodapp;Mary;;;\r\nFN:Mary Hodapp\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:mhodapp@boydspecialtysleep.com\r\nORG:Boyd Specialty Sleep and Accent Furniture\r\nTEL;TYPE=work:314-447-0731\r\nTEL;TYPE=workfax:314-881-0059\r\nEND:VCARD',' mary hodapp mhodapp@boydspecialtysleep.com boyd specialty sleep accent furniture 3144470731 3148810059',2),(7,'2013-06-29 05:59:19',0,'Chris Perkins','cperkins@boydspecialtysleep.com','Chris','Perkins','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Perkins;Chris;;;\r\nFN:Chris Perkins\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:cperkins@boydspecialtysleep.com\r\nORG:Boyd Specialty Sleep and Accent Furniture\r\nEND:VCARD',' chris perkins cperkins@boydspecialtysleep.com boyd specialty sleep accent furniture',2),(8,'2013-06-29 06:10:35',0,'Evelyn Broxson','ebroxson@corsicanabedding.com','Evelyn','Broxson','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Broxson;Evelyn;;;\r\nFN:Evelyn Broxson\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:ebroxson@corsicanabedding.com\r\nTITLE:EDI Coordinator\r\nORG:Corsicana Bedding\\, Inc.\r\nTEL;TYPE=work:888-341-2199\r\nEND:VCARD',' evelyn broxson ebroxson@corsicanabedding.com edi coordinator corsicana bedding, inc. 8883412199',2),(9,'2013-06-29 06:14:16',0,'Deanne Bland','deannebland@microdinc.com','Deanne','Bland','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Bland;Deanne;;;\r\nFN:Deanne Bland\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:deannebland@microdinc.com\r\nTITLE:EXIM EDI Project Coordinator\r\nORG:MicroD Inc.\r\nTEL;TYPE=work:704-927-3188 \r\nEND:VCARD',' deanne bland deannebland@microdinc.com exim project coordinator microd inc. 7049273188',2),(10,'2013-06-29 06:16:22',0,'Joel Souther','Joel.Souther@tempursealy.com,edisupport@sealy.com','Joel','Souther','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Souther;Joel;;;\r\nFN:Joel Souther\r\nEMAIL;TYPE=INTERNET;TYPE=WORK:Joel.Souther@tempursealy.com\r\nEMAIL;TYPE=INTERNET;TYPE=OTHER:edisupport@sealy.com\r\nTITLE:B2B/EDI Team\r\nORG:Tempur Sealy International\\, Inc.\r\nTEL;TYPE=work:336-861-3862\r\nEND:VCARD',' jol souther jol.souther@tempursealy.com edisupport@sealy.com b2b team tempur sealy international, inc. 3368613862',2),(11,'2014-03-24 09:16:09',0,'Scott Andrew','scott@retailservicesystems.com','Scott','Andrew','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Andrew;Scott;;;\r\nFN:Scott Andrew\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:scott@retailservicesystems.com\r\nTEL;TYPE=CELL:864-525-6895\r\nEND:VCARD',' scott andrew scott@retailservicesystems.com 8645256895',9),(12,'2014-03-24 09:18:31',0,'Chris Benhoff','Cbenhoff30@comcast.net','Chris','Benhoff','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Benhoff;Chris;;;\r\nFN:Chris Benhoff\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:Cbenhoff30@comcast.net\r\nADR;TYPE=home:;;;Baltimore\\, MD;;;\r\nEND:VCARD',' chris benhoff cbenhoff30@comcast.net baltimore,',9),(13,'2014-03-24 09:32:44',0,'Tim Buster','bustertc@comcast.net','Tim','Buster','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Buster;Tim;;;\r\nFN:Tim Buster\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:bustertc@comcast.net\r\nADR;TYPE=home:;;;Eugene\\, OR;;;\r\nURL;TYPE=homepage:http://eugenefurnituredirect.com/\r\nEND:VCARD',' tim buster bustertc@comcast.net eugene, http: eugenefurnituredirect.com',9),(14,'2014-03-24 09:23:20',0,'John Grof','j_grof@yahoo.com','John','Grof','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Grof;John;;;\r\nFN:John Grof\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:j_grof@yahoo.com\r\nADR;TYPE=home:;;j_grof@yahoo.com;Toledo\\, OH;;;\r\nEND:VCARD',' john grof j_grof@yahoo.com toledo,',9),(15,'2014-03-24 09:28:08',0,'Laura Hartwell','laurahartwell@gmail.com','Laura','Hartwell','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Hartwell;Laura;;;\r\nFN:Laura Hartwell\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:laurahartwell@gmail.com\r\nEND:VCARD',' laura hartwell laurahartwell@gmail.com',9),(16,'2014-03-24 09:30:55',0,'Don  Hodack','i_am_donho@yahoo.com','Don ','Hodack','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Hodack;Don ;;;\r\nFN:Don  Hodack\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:i_am_donho@yahoo.com\r\nADR;TYPE=home:;;;E. Atlanta\\, GA;;;\r\nEND:VCARD',' don hodack i_am_donho@yahoo.com e. atlanta,',9),(17,'2014-03-24 09:34:50',0,'Don  Jared','don.jared@yahoo.com','Don ','Jared','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Jared;Don ;;;\r\nFN:Don  Jared\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:don.jared@yahoo.com\r\nADR;TYPE=home:;;;Phoenix\\, AZ;;;\r\nURL;TYPE=homepage:http://phoenixfurnituredirect.com/\r\nEND:VCARD',' don jared don.jared@yahoo.com phonix, http: phonixfurnituredirect.com',9),(18,'2014-03-24 09:42:43',0,'Neal Kearney','nkearney71@gmail.com','Neal','Kearney','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Kearney;Neal;;;\r\nFN:Neal Kearney\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:nkearney71@gmail.com\r\nTEL;TYPE=home: 617-480-6970 \r\nEND:VCARD',' neal kearney nkearney71@gmail.com 6174806970',9),(19,'2014-03-24 09:43:31',0,'Rob Kradoska','realenterprises@verizon.net','Rob','Kradoska','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Kradoska;Rob;;;\r\nFN:Rob Kradoska\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:realenterprises@verizon.net\r\nTEL;TYPE=home: 215-355-3878 \r\nEND:VCARD',' rob kradoska realenterprises@verizon.net 2153553878',9),(20,'2014-03-24 09:44:32',0,'Jerry Krieg','kriegjlk@aol.com','Jerry','Krieg','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Krieg;Jerry;;;\r\nFN:Jerry Krieg\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:kriegjlk@aol.com\r\nTEL;TYPE=home: 253-537-3056 \r\nURL;TYPE=homepage:TacomaFurnitureDirect.com\r\nEND:VCARD',' jerry krieg kriegjlk@aol.com 2535373056 tacomafurnituredirect.com',9),(21,'2014-03-24 09:46:28',0,'Brad Loy','hfdloy@yahoo.com','Brad','Loy','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Loy;Brad;;;\r\nFN:Brad Loy\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:hfdloy@yahoo.com\r\nTEL;TYPE=home: 719-377-1523 \r\nURL;TYPE=homepage:http://coloradospringsfurnitureoutlet.com/\r\nEND:VCARD',' brad loy hfdloy@yahoo.com 7193771523 http: coloradospringsfurnitureoutlet.com',9),(22,'2014-03-24 09:47:51',0,'Laurie Loy','loy10@yahoo.com','Laurie','Loy','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Loy;Laurie;;;\r\nFN:Laurie Loy\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:loy10@yahoo.com\r\nTEL;TYPE=home: 719-377-1301 \r\nURL;TYPE=homepage:http://coloradospringsfurnitureoutlet.com/\r\nEND:VCARD',' laurie loy loy10@yahoo.com 7193771301 http: coloradospringsfurnitureoutlet.com',9),(23,'2014-03-24 09:48:49',0,'Donald MacBeth','totalqualitymerchandise@hotmail.com','Donald','MacBeth','BEGIN:VCARD\r\nVERSION:3.0\r\nN:MacBeth;Donald;;;\r\nFN:Donald MacBeth\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:totalqualitymerchandise@hotmail.com\r\nTEL;TYPE=home: 217-361-1357 \r\nEND:VCARD',' donald macbeth totalqualitymerchandise@hotmail.com 2173611357',9),(24,'2014-03-24 09:49:40',0,'Lynn Metzer','lynn_metzer@msn.com','Lynn','Metzer','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Metzer;Lynn;;;\r\nFN:Lynn Metzer\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:lynn_metzer@msn.com\r\nTEL;TYPE=home: 303-829-0553 \r\nEND:VCARD',' lynn metzer lynn_metzer@msn.com 3038290553',9),(25,'2014-03-24 09:50:52',0,'Keith Plaster','networkedge@hotmail.com','Keith','Plaster','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Plaster;Keith;;;\r\nFN:Keith Plaster\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:networkedge@hotmail.com\r\nTEL;TYPE=home: 920-217-1785 \r\nURL;TYPE=homepage:http://greenbayfurnituredirect.com/\r\nEND:VCARD',' keith plaster networkedge@hotmail.com 9202171785 http: greenbayfurnituredirect.com',9),(26,'2014-03-24 09:51:33',0,'Chuck Price','chuckprice53@gmail.com','Chuck','Price','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Price;Chuck;;;\r\nFN:Chuck Price\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:chuckprice53@gmail.com\r\nTEL;TYPE=home: 520-444-3111 \r\nEND:VCARD',' chuck price chuckprice53@gmail.com 5204443111',9),(27,'2014-03-24 09:52:29',0,'Bryan Rackley','bryrack@yahoo.com','Bryan','Rackley','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Rackley;Bryan;;;\r\nFN:Bryan Rackley\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:bryrack@yahoo.com\r\nTEL;TYPE=home: 304-541-3146 \r\nEND:VCARD',' bryan rackley bryrack@yahoo.com 3045413146',9),(28,'2014-03-24 09:53:54',0,'Steve Sowers','msteve.sowers@gmail.com','Steve','Sowers','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Sowers;Steve;;;\r\nFN:Steve Sowers\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:msteve.sowers@gmail.com\r\nTEL;TYPE=home: 928-920-8609 \r\nURL;TYPE=homepage:YumaFurnitureDirect.com\r\nEND:VCARD',' steve sowers msteve.sowers@gmail.com 9289208609 yumafurnituredirect.com',9),(29,'2014-03-24 09:54:43',0,'Fred Stillwagon','fredstillwagon@aol.com','Fred','Stillwagon','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Stillwagon;Fred;;;\r\nFN:Fred Stillwagon\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:fredstillwagon@aol.com\r\nTEL;TYPE=home: 330-207-0456 \r\nEND:VCARD',' fred stillwagon fredstillwagon@aol.com 3302070456',9),(30,'2014-03-24 09:55:59',0,'George Varn','george@retailservicesystems.com','George','Varn','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Varn;George;;;\r\nFN:George Varn\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:george@retailservicesystems.com\r\nTEL;TYPE=home: 850-508-1166 \r\nEND:VCARD',' george varn george@retailservicesystems.com 8505081166',9),(31,'2014-03-24 09:56:39',0,'Sandi Varn','sandivarn@embarqmail.com','Sandi','Varn','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Varn;Sandi;;;\r\nFN:Sandi Varn\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:sandivarn@embarqmail.com\r\nTEL;TYPE=home: 850-545-7112 \r\nEND:VCARD',' sandi varn sandivarn@embarqmail.com 8505457112',9),(32,'2014-03-24 09:58:44',0,'Bob Wert','went001@aol.com','Bob','Wert','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Wert;Bob;;;\r\nFN:Bob Wert\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:went001@aol.com\r\nTEL;TYPE=home: 530-570-9341 \r\nEND:VCARD',' bob wert went001@aol.com 5305709341',9),(33,'2014-03-24 09:59:24',0,'Jerry Williams','jerry@retailservicesystems.com','Jerry','Williams','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Williams;Jerry;;;\r\nFN:Jerry Williams\r\nEMAIL;TYPE=INTERNET;TYPE=HOME:jerry@retailservicesystems.com\r\nTEL;TYPE=home: 614-439-6984 \r\nEND:VCARD',' jerry williams jerry@retailservicesystems.com 6144396984',9),(34,'2014-09-04 14:34:35',0,'Tom Bonner','tbonner@corsicanabedding.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Tom Bonner\r\nEMAIL;TYPE=INTERNET:tbonner@corsicanabedding.com\r\nEND:VCARD',' tbonner@corsicanabedding.com tom bonner',2),(35,'2014-09-04 14:34:39',0,'Sherry Nunn','snunn@corsicanabedding.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Sherry Nunn\r\nEMAIL;TYPE=INTERNET:snunn@corsicanabedding.com\r\nEND:VCARD',' snunn@corsicanabedding.com sherry nunn',2),(36,'2016-03-20 17:43:43',0,'Mwwhitfield8487','mwwhitfield8487@gmail.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Mwwhitfield8487\r\nEMAIL;TYPE=INTERNET:mwwhitfield8487@gmail.com\r\nEND:VCARD',' mwwhitfield8487@gmail.com mwwhitfield8487',17),(37,'2016-05-25 20:20:35',1,'Pamela R.','pamela64_online@yahoo.com','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Pamela R.\r\nEMAIL;TYPE=INTERNET:pamela64_online@yahoo.com\r\nEND:VCARD',' pamela64_online@yahoo.com pamela r.',20);

--
-- Table structure for table `dictionary`
--

CREATE TABLE `dictionary` (
  `user_id` int(10) unsigned DEFAULT NULL,
  `language` varchar(5) NOT NULL,
  `data` longtext NOT NULL,
  UNIQUE KEY `uniqueness` (`user_id`,`language`),
  CONSTRAINT `user_id_fk_dictionary` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dictionary`
--


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

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` text,
  `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=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `identities`
--

INSERT INTO `identities` VALUES (1,1,'2013-06-15 17:52:01',0,1,'','','gary@retailservicesystems.com','','',NULL,0),(2,2,'2013-06-16 00:39:34',0,1,'William Lightning','Retail Service Systems','will@retailservicesystems.com','','','Thanks,\r\nWilliam Lightning\r\nRetail Service Systems',0),(3,3,'2013-06-16 09:43:25',0,1,'','','george@retailservicesystems.com','','',NULL,0),(4,4,'2013-06-16 14:11:58',0,1,'','','jerry@retailservicesystems.com','','',NULL,0),(5,5,'2013-06-17 14:17:51',0,1,'','','amy@retailservicesystems.com','','',NULL,0),(6,6,'2013-08-13 15:39:57',0,1,'','','xml@retailservicesystems.com','','',NULL,0),(7,7,'2013-08-26 10:27:44',0,1,'','','daff@retailservicesystems.com','','',NULL,0),(8,8,'2013-12-28 13:25:44',0,1,'','','Amy@retailservicesystems.com','','',NULL,0),(9,9,'2014-03-24 09:11:17',0,1,'','','tj@retailservicesystems.com','','',NULL,0),(11,11,'2014-08-13 10:00:38',0,1,'','','scott@retailservicesystems.com','','',NULL,0),(12,12,'2014-10-31 17:12:46',0,1,'','','brad@retailservicesystems.com','','',NULL,0),(13,13,'2014-10-31 17:46:33',0,1,'','','joel@retailservicesystems.com','','',NULL,0),(14,14,'2014-11-03 19:12:28',0,1,'','','Joel@retailservicesystems.com','','',NULL,0),(16,16,'2015-10-10 12:13:53',0,1,'','','kyle@retailservicesystems.com','','',NULL,0),(17,17,'2015-10-15 23:18:33',0,1,'Theron Wilson','RSS','theron@retailservicesystems.com','theron@retailservicesystems.com','','<pre>Theron A Wilson\r\nRetail Service Systems, Inc.\r\n410-707-8479\r\n\r\nCONFIDENTIALITY NOTICE:\r\nThe information in this electronic mail transmission and any documents accompanying it contain confidential information belonging to the sender, which is legally privileged. If you are not the intended recipient, you are hereby notified that any unauthorized use, disclosure, dissemination, copying, distribution of this communication, or any of its contents, is strictly prohibited. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you for your assistance.\r\n</pre>',1),(18,18,'2016-03-30 12:28:23',0,1,'','','vm@retailservicesystems.com','','',NULL,0),(19,19,'2016-05-10 15:00:36',0,1,'','','bob@retailservicesystems.com','','',NULL,0),(20,20,'2016-05-26 20:55:10',0,1,'Pam','','pam@retailservicesystems.com','','','<pre><span style=\"font-family: tahoma, arial, helvetica, sans-serif; font-size: small;\">Pamela Rapoza\r\nRegional Coordinator\r\nRetail Service Systems, Inc.</span>\r\n\r\n<span style=\"font-size: x-small; font-family: arial, helvetica, sans-serif;\"><strong><br /></strong></span></pre>',1),(21,21,'2016-06-27 11:39:28',0,1,'','','ryan@retailservicesystems.com','','',NULL,0),(22,22,'2016-09-02 00:01:45',0,1,'','','testimap@retailservicesystems.com','','',NULL,0),(23,23,'2016-09-15 13:58:08',0,1,'','','warranty@royalheritagefurniture.com','','',NULL,0),(24,24,'2016-09-22 19:25:35',0,1,'','','clifton@retailservicesystems.com','','',NULL,0);

--
-- Table structure for table `searches`
--

CREATE TABLE `searches` (
  `search_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `type` int(3) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL,
  `data` text,
  PRIMARY KEY (`search_id`),
  UNIQUE KEY `uniqueness` (`user_id`,`type`,`name`),
  CONSTRAINT `user_id_fk_searches` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `searches`
--


--
-- Table structure for table `system`
--

CREATE TABLE `system` (
  `name` varchar(64) NOT NULL,
  `value` mediumtext,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `system`
--

INSERT INTO `system` VALUES ('roundcube-version','2013011700');

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

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` text,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`,`mail_host`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'gary@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-06-15 17:52:01','2016-09-28 09:27:23','en_US','a:11:{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:9:\"list_cols\";a:8:{i:0;s:7:\"threads\";i:1;s:6:\"status\";i:2;s:6:\"fromto\";i:3;s:7:\"subject\";i:4;s:4:\"date\";i:5;s:4:\"size\";i:6;s:4:\"flag\";i:7;s:10:\"attachment\";}s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(2,'will@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-06-16 00:36:41','2016-09-21 14:13:24','en_US','a:13:{s:17:\"message_threading\";a: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:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";s:17:\"collapsed_folders\";s:0:\"\";s:11:\"show_images\";i:1;s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(3,'george@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-06-16 09:43:25','2013-06-16 11:15:47','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(4,'jerry@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-06-16 14:11:58','2016-09-29 09:03:40','en_US','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:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(5,'amy@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-06-17 14:17:51','2016-03-10 12:00:47','en_US','a:11:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";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:3:{s:7:\"subject\";i:1;s:4:\"from\";i:1;s:2:\"to\";i:1;}}s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(6,'xml@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-08-13 15:39:57','2014-01-09 01:09:28','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(7,'daff@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-08-26 10:27:44','2013-09-05 19:30:58','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(8,'Amy@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2013-12-28 13:25:44','2013-12-28 13:25:44','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(9,'tj@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2014-03-24 09:11:17','2016-12-05 10:55:34','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(11,'scott@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2014-08-13 10:00:38','2016-03-17 11:04:48','en_US','a:8:{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:11:\"INBOX.Trash\";a:2:{s:7:\"subject\";i:1;s:4:\"from\";i:1;}}s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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,'brad@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2014-10-31 17:12:46','2015-10-13 14:00:30','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(13,'joel@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2014-10-31 17:46:33','2015-11-03 16:52:17','en_US','a:10:{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:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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,'Joel@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2014-11-03 19:12:28','2014-11-06 10:47:30','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(16,'kyle@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2015-10-10 12:13:53','2015-10-10 12:30:01','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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,'theron@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2015-10-15 14:48:31','2017-06-09 07:32:45','en_US','a:9:{s:16:\"message_sort_col\";s:7:\"subject\";s:18:\"message_sort_order\";s:3:\"ASC\";s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(18,'vm@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2016-03-30 12:28:23','2016-03-30 12:28:23','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(19,'bob@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2016-05-10 15:00:36','2016-07-07 12:18:09','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(20,'pam@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2016-05-24 10:09:02','2016-08-31 11:13:40','en_US','a:13:{s:8:\"timezone\";s:4:\"auto\";s:11:\"date_format\";s:5:\"m/d/Y\";s:9:\"date_long\";s:9:\"m/d/Y H:i\";s:13:\"delete_always\";b:1;s:12:\"logout_purge\";b:1;s:17:\"message_threading\";a:1:{s:5:\"INBOX\";b:1;}s:18:\"strip_existing_sig\";b:0;s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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:15:\"namespace_fixed\";b:1;}'),(21,'ryan@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2016-06-27 11:39:28','2016-07-26 09:33:26','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(22,'testimap@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2016-09-02 00:01:45','2016-09-02 00:01:45','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(23,'warranty@royalheritagefurniture.com','imap.phoenix.retailservicesystems.com','2016-09-15 13:58:08','2016-09-15 14:30:59','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}'),(24,'clifton@retailservicesystems.com','imap.phoenix.retailservicesystems.com','2016-09-22 19:25:35','2016-10-04 08:27:57','en_US','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";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;}');


