Havenly.com | Online Interior Design and Home Decorating | 1.4 Million Members

whlx · Thursday at 1:24 PM

In June 2020, the interior design website Havenly suffered a data breach which impacted almost 1.4 million members of the service. The exposed data included email addresses, names, phone numbers, geographic locations and passwords stored as SHA-1 hashes, all of which was subsequently shared extensively throughout online hacking communities.

Compromised data: Email addresses, Geographic locations, Names, Passwords, Phone numbers

Sample:

USER_ID,EMAIL,FIRST_NAME,LAST_NAME,USER_CREATED,ADDRESS,CITY,STATE,ZIP_CODE,LTV_LIFETIME
423243,heatherying@yahoo.com,Heather,Yang,,,,,,0.0
1722420,steph.montalvo@gmail.com,Steph,,2021-01-03 01:01:28,,,,,0.0
1722419,Angienicolek@yahoo.com,Ang,,2021-01-03 01:00:17,,,,,0.0
1722418,djwelcome@gmail.com,Dan,Welcome,2021-01-03 00:59:47,,,,,79.0
1722417,Socoto73@hotmail.com,Mimi,,2021-01-03 00:59:16,,,,,0.0
1722416,Jamie.bailey2802@gmail.com,Jamie,,2021-01-03 00:58:52,,,,,0.0
1722415,simranbhutani03@gmail.com,Sam,,2021-01-03 00:58:40,,,,,0.0
1722414,Oliviaawilliams8@gmail.com,Olivia,,2021-01-03 00:58:07,,,,,0.0
1722413,iamhopeclark@gmail.com,Hope,,2021-01-03 00:58:04,,,,,0.0
1722412,paul@nimmea.com,Paul,,2021-01-03 00:57:43,,,,,0.0
1722411,cheri-isaacs@comcast.net,Cheri,,2021-01-03 00:57:36,,,,,0.0
1722410,Mariejoej@live.com,Marie-joe,Dreik,2021-01-03 00:57:31,,,,,0.0
1722409,Arizv872@gmail.com,Alina,,2021-01-03 00:57:22,,,,,0.0
1722408,christina.delsman@gmail.com,Christina,Delsman,2021-01-03 00:56:12,,,,,0.0
1722407,Elfmdn510@gmail.com,MeteoJenn,,2021-01-03 00:55:59,,,,,0.0
1722406,Kgmotley20@gmail.com,Amy,,2021-01-03 00:55:22,,,,,0.0
1722405,jcmatlaw@aol.com,Jill,,2021-01-03 00:55:09,,,,,0.0
1722404,Wolfek92@gmail.com,Kelsey,,2021-01-03 00:54:39,,,,,0.0
1722403,amandaghagood@gmail.com,Amanda,Hagood,2021-01-03 00:54:31,,,,,0.0
1722402,danelle.crow@gmail.com,Danelle,,2021-01-03 00:54:28,,,,,0.0

And:

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vip` tinyint(1) NOT NULL DEFAULT '0',
`username` varchar(128) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) DEFAULT NULL,
`photo` varchar(255) DEFAULT NULL,
`password` varchar(128) NOT NULL,
`email` varchar(128) NOT NULL,
`phone_number` varchar(10) DEFAULT NULL,
`zip_code` varchar(6) DEFAULT NULL,
`timezone` varchar(50) NOT NULL DEFAULT 'America/Denver',
`stripe_customer` varchar(100) NOT NULL,
`referral_source_id` int(3) DEFAULT NULL,
`referral_source_details` varchar(200) DEFAULT NULL,
`role` varchar(64) DEFAULT NULL,
`support` tinyint(1) NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`welcome_sent` tinyint(1) NOT NULL DEFAULT '0',
`likely_to_order` datetime DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`notes` varchar(255) DEFAULT NULL,
`preferred_designer_id` int(11) DEFAULT NULL,
`allow_reminders` tinyint(1) NOT NULL DEFAULT '1',
`allow_notifications` tinyint(1) NOT NULL DEFAULT '1',
`allow_activity_summaries` tinyint(1) NOT NULL DEFAULT '1',
`allow_newsletters` tinyint(1) NOT NULL DEFAULT '1',
`fb_id` varchar(255) DEFAULT NULL,
`source` varchar(128) DEFAULT NULL,
`medium` varchar(2000) DEFAULT NULL,
`campaign` varchar(2000) DEFAULT NULL,
`content` varchar(2000) DEFAULT NULL,
`term` varchar(2000) DEFAULT NULL,
`referer` varchar(2000) DEFAULT NULL,
`landing_page` varchar(100) DEFAULT NULL,
`avatar` varchar(200) DEFAULT NULL,
`notification_email_sent` tinyint(1) NOT NULL DEFAULT '0',
`smooch_id` varchar(255) DEFAULT NULL,
`subscription_offered` tinyint(1) DEFAULT '0',
`subscription_enabled` tinyint(1) DEFAULT '0',
`discount_enabled` tinyint(1) DEFAULT '0',
`mailing_segment` int(11) DEFAULT NULL,
`international` tinyint(1) NOT NULL DEFAULT '0',
`partner_flow_id` int(11) DEFAULT NULL,
`dq_user_since` datetime DEFAULT NULL,
`abandoned_cart_promo_sent_on` datetime DEFAULT NULL,
`partner_user_id` int(11) DEFAULT NULL,
`airbnb_access_type` int(11) DEFAULT NULL,
`password_reset_id` varchar(255) DEFAULT NULL,
`password_reset_expiration` datetime DEFAULT NULL,
`is_conversion_specialist_client` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `IDX_1483A5E9343FDBBA` (`referral_source_id`),
KEY `IDX_1483A5E98DBADDDA` (`preferred_designer_id`),
KEY `email_idx` (`email`),
KEY `fb_id_idx` (`fb_id`),
KEY `created_idx` (`created`),
KEY `source_idx` (`source`),
KEY `idx_user_role` (`role`) USING BTREE,
KEY `IDX_1483A5E9B95C6E06` (`partner_flow_id`),
CONSTRAINT `FK_1483A5E9343FDBBA` FOREIGN KEY (`referral_source_id`) REFERENCES `referral_sources` (`id`),
CONSTRAINT `FK_1483A5E98DBADDDA` FOREIGN KEY (`preferred_designer_id`) REFERENCES `designers` (`id`),
CONSTRAINT `FK_1483A5E9B95C6E06` FOREIGN KEY (`partner_flow_id`) REFERENCES `partner_flows` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1375999 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,0,'Awaiting Assignment','Awaiting Assignment','Awaiting','Assignment',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','hello@havenly.com','3038024456','','America/Denver','',7,'','user',0,'2014-02-10 02:13:15','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',NULL,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(237,0,'Mariam Khan','Mariam Khan','Mariam','Khan',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','mariamkhan1@gmail.com','9174451774','','America/Denver','cus_3fM0rBhPeSD36b',7,'','customer',0,'2014-03-14 19:48:25','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(238,0,'Keri Henry','Keri Henry','Keri','Henry',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','kfletch500@gmail.com','713-705-47','','America/Denver','cus_3fM0YoXBOaEQRx',7,'','customer',0,'2014-03-14 19:48:26','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(239,0,'Mary Trice','Mary Trice','Mary','Trice',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','maryemarshall@gmail.com','323-877-70','','America/Denver','cus_3fM0DaNaj7h67Z',7,'','customer',0,'2014-03-14 19:48:26','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(240,0,'Brooke Day','Brooke Day','Brooke ','Day',NULL,'e33d8b4c3b5e84faa1b204b61fcfe49a8f676e10','bntrinh11@gmail.com','832-878-66','','America/Chicago','cus_3fM0Dt0420YYBB',7,'','customer',0,'2014-03-14 19:48:27','2017-09-28 17:14:30',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(241,0,'Marika Horn','Marika Horn','Marika','Horn',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','marika.c.horn@gmail.com','7138828786','','America/Denver','cus_3fM0ZB524Pgr4K',7,'','customer',0,'2014-03-14 19:48:27','2018-10-02 19:07:34',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(242,0,'Coventry Berg','Coventry Berg','Coventry','Berg',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','coventryberg@gmail.com','904.547.19','','America/Denver','cus_3fM0CMikeJQzPm',7,'','customer',0,'2014-03-14 19:48:27','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',NULL,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(243,0,'Abby Savidan','Abby Savidan','Abby','Savidan',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','savidan.abby@gmail.com','330-289-60','','America/Denver','cus_3fM03cEbjqDu0M',7,'','customer',0,'2014-03-14 19:48:28','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',NULL,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(244,0,'Kareem Grant','Kareem Grant','Kareem','Grant',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','kareem.grant@gmail.com','2404322210','','America/Denver','cus_3fM0B5b1sUhYEY',7,'','customer',0,'2014-03-14 19:48:28','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(245,0,'Edwin Chen','Edwin Chen','Edwin','Chen',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','hello@echen.me','415-493-87','','America/Denver','cus_3fM0BNXcLpuoUE',7,'','customer',0,'2014-03-14 19:48:29','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(246,0,'Kristen Farman','Kristen Farman','Kristen','Farman',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','kbella77@yahoo.com','9174495714','','America/Denver','cus_3fM0d9nSLGjPaR',7,'','customer',0,'2014-03-14 19:48:29','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'approximately 8\'x11\'. classic, but not \"little kid\". he will have his toys that will make it more kid-like. wants to paint the walls blue, but not baby blue and not too dark - blue with gray in it to look more grown up as he gets older. not sure what ',NULL,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(247,0,'Dean Zacharias','Dean Zacharias','Dean','Zacharias',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','Inquiries@Properkidproblems.com','865-567-60','','America/Denver','cus_3fM0SnzacUtOrT',7,'','customer',0,'2014-03-14 19:48:29','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(248,0,'Reva Lewis','Reva Lewis','Reva','Lewis',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','Reva.cyronfraser@gmail.com','3478851479','','America/Denver','cus_3fM00xZ3c0uXFJ',7,'','customer',0,'2014-03-14 19:48:30','2017-09-28 17:53:51',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(249,0,'Katie Allanson','Katie Allanson','Katie','Allanson',NULL,'2008a2d20f973b7953abb367a8c4e935d2ea7ff6','katieallanson@gmail.com','3126594488','','America/Chicago','cus_3fM0kFAWRtEQuY',7,'','customer',0,'2014-03-14 19:48:31','2018-08-16 21:00:45',0,'2016-07-08 14:10:03',1,'',NULL,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(250,0,'Leslie Labruto','Leslie Labruto','Leslie','Labruto',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','leslie.labruto@gmail.com','7327575573','','America/Denver','cus_3fM0Eqw4lb3Xgy',7,'','customer',0,'2014-03-14 19:48:31','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(251,0,'Stephanie Maxwell','Stephanie Maxwell','Stephanie','Maxwell',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','SteffieMaxwell@gmail.com','720-323-35','','America/Denver','cus_3fM0t9uEKT0dnP',7,'','customer',0,'2014-03-14 19:48:32','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',NULL,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(252,0,'Kristin Kelly','Kristin Kelly','Kristin','Kelly',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','kristinkelly13@gmail.com','6123252925','','America/Denver','cus_3fM0gfSIwCaiMh',7,'','customer',0,'2014-03-14 19:48:32','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(253,0,'Katie Flynn','Katie Flynn','Katie','Flynn',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','Katielittleflynn@gmail.com','NA','','America/Denver','cus_3fM0qIWVViwyng',7,'','customer',0,'2014-03-14 19:48:32','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(254,0,'Jill DiIanni','Jill DiIanni','Jill','DiIanni',NULL,'eab55c47f41bed299c1993878a105644b79fbaa3','diianni@gmail.com','7244338816','','America/New_York','cus_3fM02kIoEDw3xg',7,'','customer',0,'2014-03-14 19:48:33','2019-03-11 17:53:37',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(255,0,'Sonal Sampat','Sonal Sampat','Sonal','Sampat',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','sonal.r.sampat@gmail.com','540-247-23','','America/Denver','cus_3fM0lc1WeShHlM',7,'','customer',0,'2014-03-14 19:48:33','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(256,0,'Diane Beasley','Diane Beasley','Diane','Beasley',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','Diane.Beasley@gmail.com','6467530755','','America/Denver','cus_3fM0hDtqgk3xVr',7,'','customer',0,'2014-03-14 19:48:33','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(257,0,'Talar Hovnanian','Talar Hovnanian','Talar','Hovnanian',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','talhov@gmail.com','714','','America/Denver','cus_3fM01kTsoeDe2C',7,'','customer',0,'2014-03-14 19:48:34','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(258,0,'Leslie Pitts','Leslie Pitts','Leslie','Pitts',NULL,'6e55438887eae619313d47bb1a0739ba61ffd21f','lgpitts@gmail.com','9172391031','','America/Chicago','cus_3fM0OpZpB4IU0x',7,'','customer',0,'2014-03-14 19:48:34','2017-09-28 17:14:30',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(259,0,'Rebecca Brown','Rebecca Brown','Rebecca','Brown',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','rebeccasbrown@gmail.com','301-943-04','','America/Denver','cus_3fM044wazTd6j9',7,'','customer',0,'2014-03-14 19:48:35','2017-09-28 17:53:52',0,'0000-00-00 00:00:00',1,'',290,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(260,0,'Lindsey Goldstein','Lindsey Goldstein','Lindsey','Goldstein',NULL,'397ecb5c1d0e90a6b2c4698bb24e0aa1b36ea0c2','lindseybgoldstein@gmail.com','8479244653','','America/New_York','cus_3fM0tgcK0swCqA',7,'','customer',0,'2014-03-14 19:48:35','2018-10-25 21:07:48',0,'2018-10-25 21:07:44',1,'',11865,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'eddf88da62c675c8f5881663',0,0,0,1,0,NULL,'2018-08-27 04:12:21',NULL,NULL,NULL,NULL,NULL,0),(261,0,'Jeremy Rainwater','Jeremy Rainwater','Jeremy','Rainwater',NULL,'d8d5a6403f3ddffab0de729ef813b9ad938ef225','jeremy.rainwater@yahoo.com','(713) 853-','','America/Denver','cus_3fM02Z8KVNdmhQ',7,'','customer',0,'2014-03-14 19:48:36','2017-09-28 17:53:52',0,'0000-00-00