[boo]

In April 2020, the Brazilian shopping website HomeRefill suffered a data breach that impacted 194k users. The attack led to the exposure of data including Email addresses, Full names, Phone numbers, Dates of birth and Passwords stored as SHA512 hashes. The website was breached by @donjuji - "initial attack vector was misconfigured aws s3 bucket".



Compromised data: Email addresses, Full names, Phone numbers, Dates of birth, Passwords

sample:

LOCK TABLES `system_user` WRITE;
/*!40000 ALTER TABLE `system_user` DISABLE KEYS */;
INSERT INTO `system_user` VALUES (1,NULL,'Admin',NULL,NULL,'admin','admin@homerefill.com.br','admin@homerefill.com.br',NULL,0,'cpo27kdsi54c4o04c40w40s0okwkkkk','MP8TnkrdcEAm6FItEggNRcl9n1tFp48vBFYgIk3Rgsbj2hnFIgqPAdgmtk/zGXJrZSvkBxIHinIWVcaNIVEVBg==','2015-09-25 07:16:44',0,0,NULL,'1429914997',NULL,'a:2:{i:0;s:10:\"ROLE_ADMIN\";i:1;s:24:\"ROLE_FATTURA_VIEW_TICKET\";}',0,NULL,NULL,NULL,1,'Feliz','2016-12-01 21:51:18','pf',NULL,NULL,NULL,1,0,0,0,1,NULL,1,0,'+55','11','+55','11',NULL,NULL),(2,8,'Caio Paiola','37548910819',NULL,'caio paiola','caiotest@homerefill.com.br','caiotest@homerefill.com.br','60413869',0,'cpo27kdsi54c4o04c40w40s0okwkkkk','0mzHt2EpIL1CYOA+hKOprHUm3rSIzMPg6Gpwbq+Q5BImhTQtjXrAhI8BwhG+e2X0KmJb73p3WnwL8FtSl/LzDQ==','2017-05-04 22:26:38',0,0,NULL,'1429915226',NULL,'a:2:{i:0;s:10:\"ROLE_ADMIN\";i:1;s:28:\"ROLE_FATTURA_TICKET_SHOWFLOW\";}',0,NULL,4,'2015-10-23 00:00:00',0,'Feliz',NULL,'pf',NULL,NULL,NULL,1,0,0,0,0,'2015-10-23 00:00:00',1,47.34,'+55','11','+55','11',NULL,NULL),(3,NULL,'Guilherme Aere Dos Santos','38717205859','1234','guilherme aere dos santos','guilherme@homerefill.com.br','guilherme@homerefill.com.br','991249218',1,'e6t2sim5wjk00s0k4s4cg8c0swc8kko','IgL83RxbaK4xXEBg9kLzgT8HatfPoxKjom1KwqBjD/apvD3DyPPy543EqoYkyz7+UWmmPj2+IxfEBM7OGelGsg==','2020-04-01 21:34:36',0,0,NULL,'1429928449',NULL,'a:120:{i:0;s:10:\"ROLE_ADMIN\";i:1;s:22:\"ROLE_ACCOUNT_LIST_USER\";i:2;s:24:\"ROLE_ACCOUNT_CREATE_USER\";i:3;s:22:\"ROLE_ACCOUNT_EDIT_USER\";i:4;s:9:\"ROLE_USER\";i:5;s:24:\"ROLE_FATTURA_LIST_TICKET\";i:6;s:24:\"ROLE_FATTURA_VIEW_TICKET\";i:7;s:26:\"ROLE_FATTURA_CREATE_TICKET\";i:8;s:26:\"ROLE_FATTURA_CANCEL_TICKET\";i:9;s:36:\"ROLE_FATTURA_ADD_OBSERVATIONS_TICKET\";i:10;s:35:\"ROLE_FATTURA_TICKET_PAYMENT_HISTORY\";i:11;s:28:\"ROLE_FATTURA_VIEW_TICKET_LOG\";i:12;s:33:\"ROLE_FATTURA_TICKET_PROCESS_RETRY\";i:13;s:28:\"ROLE_FATTURA_TICKET_SHOWFLOW\";i:14;s:42:\"ROLE_FATTURA_TICKET_COMPLEMENTARY_DELIVERY\";i:15;s:31:\"ROLE_FATTURA_ACCESS_ORDER_PANEL\";i:16;s:36:\"ROLE_FATTURA_ACCESS_EXPEDITION_PANEL\";i:17;s:38:\"ROLE_FATTURA_MANAGER_TICKET_EXPEDITION\";i:18;s:45:\"ROLE_FINANCIAL_ACCESS_PRECIFICATION_REVISIONS\";i:19;s:33:\"ROLE_FINANCIAL_EDIT_PRECIFICATION\";i:20;s:40:\"ROLE_FINANCIAL_CONSOLIDATE_PRECIFICATION\";i:21;s:39:\"ROLE_FINANCIAL_INACTIVATE_PRECIFICATION\";i:22;s:31:\"ROLE_FINANCIAL_ACCESS_COST_BASE\";i:23;s:42:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_COST_BASE\";i:24;s:32:\"ROLE_FINANCIAL_LIST_MANUFACTURER\";i:25;s:53:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_MANUFACTURER_CATALOG\";i:26;s:26:\"ROLE_FINANCIAL_LIST_BROKER\";i:27;s:47:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_BROKER_CATALOG\";i:28;s:28:\"ROLE_FINANCIAL_LIST_PROVIDER\";i:29;s:49:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_PROVIDER_CATALOG\";i:30;s:31:\"ROLE_FINANCIAL_LIST_CONCURRENCE\";i:31;s:52:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_CONCURRENCE_CATALOG\";i:32;s:24:\"ROLE_FINANCIAL_LIST_CARD\";i:33;s:29:\"ROLE_FINANCIAL_LIST_USER_CARD\";i:34;s:25:\"ROLE_FINANCIAL_LIST_ORDER\";i:35;s:31:\"ROLE_FINANCIAL_LIST_TRANSACTION\";i:36;s:39:\"ROLE_FINANCIAL_LIST_TRANSACTION_BY_CARD\";i:37;s:27:\"ROLE_FINANCIAL_LIST_CATALOG\";i:38;s:40:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_CATALOG\";i:39;s:34:\"ROLE_FINANCIAL_CONSOLIDATE_CATALOG\";i:40;s:33:\"ROLE_FINANCIAL_INACTIVATE_CATALOG\";i:41;s:32:\"ROLE_FINANCIAL_LIST_CATALOG_ITEM\";i:42;s:34:\"ROLE_FINANCIAL_CREATE_CATALOG_ITEM\";i:43;s:34:\"ROLE_FINANCIAL_UPDATE_CATALOG_ITEM\";i:44;s:30:\"ROLE_MARKETING_ACCESS_SHOWCASE\";i:45;s:27:\"ROLE_MARKETING_ADD_SHOWCASE\";i:46;s:30:\"ROLE_MARKETING_REMOVE_SHOWCASE\";i:47;s:35:\"ROLE_MARKETING_INSERT_ITEM_SHOWCASE\";i:48;s:35:\"ROLE_MARKETING_REMOVE_ITEM_SHOWCASE\";i:49;s:31:\"ROLE_MARKETING_ACCESS_HIGHLIGHT\";i:50;s:28:\"ROLE_MARKETING_ADD_HIGHLIGHT\";i:51;s:27:\"ROLE_MARKETING_ACCESS_SCORE\";i:52;s:24:\"ROLE_MARKETING_ADD_SCORE\";i:53;s:27:\"ROLE_MARKETING_UPDATE_SCORE\";i:54;s:29:\"ROLE_MARKETING_DOWNLOAD_SCORE\";i:55;s:38:\"ROLE_OPERATION_LIST_STOCK_TRANSITIONAL\";i:56;s:34:\"ROLE_OPERATION_LIST_PHYSICAL_STOCK\";i:57;s:36:\"ROLE_OPERATION_LIST_PURCHASE_REQUEST\";i:58;s:35:\"ROLE_OPERATION_NEW_PURCHASE_REQUEST\";i:59;s:36:\"ROLE_OPERATION_EDIT_PURCHASE_REQUEST\";i:60;s:36:\"ROLE_OPERATION_VIEW_PURCHASE_REQUEST\";i:61;s:38:\"ROLE_OPERATION_CANCEL_PURCHASE_REQUEST\";i:62;s:53:\"ROLE_OPERATION_CHANGE_RECEIVING_DATE_PURCHASE_INVOICE\";i:63;s:37:\"ROLE_OPERATION_ACCESS_NECESSITY_PANEL\";i:64;s:53:\"ROLE_OPERATION_NECESSITY_PANEL_DOWNLOAD_REPORT_CYCLES\";i:65;s:51:\"ROLE_OPERATION_NECESSITY_PANEL_DOWNLOAD_REPORT_DAYS\";i:66;s:28:\"ROLE_PANEL_SERVICE_LIST_USER\";i:67;s:28:\"ROLE_PANEL_SERVICE_INFO_USER\";i:68;s:30:\"ROLE_PANEL_SERVICE_CANCEL_USER\";i:69;s:38:\"ROLE_PANEL_SERVICE_RESET_PASSWORD_USER\";i:70;s:37:\"ROLE_PANEL_SERVICE_LIST_COMMUNICATION\";i:71;s:36:\"ROLE_PANEL_SERVICE_NEW_COMMUNICATION\";i:72;s:35:\"ROLE_PANEL_SERVICE_LIST_USER_REFILL\";i:73;s:37:\"ROLE_PANEL_SERVICE_UPDATE_USER_REFILL\";i:74;s:43:\"ROLE_PANEL_SERVICE_LIST_USER_ACTION_HISTORY\";i:75;s:38:\"ROLE_PANEL_SERVICE_LIST_REFILL_HISTORY\";i:76;s:36:\"ROLE_PANEL_SERVICE_LIST_USER_VOUCHER\";i:77;s:35:\"ROLE_PANEL_SERVICE_NEW_USER_VOUCHER\";i:78;s:35:\"ROLE_PANEL_SERVICE_LIST_USER_WALLET\";i:79;s:37:\"ROLE_PANEL_SERVICE_UPDATE_USER_WALLET\";i:80;s:37:\"ROLE_PANEL_SERVICE_SKIP_USER_DELIVERY\";i:81;s:42:\"ROLE_PANEL_SERVICE_UNDO_SKIP_USER_DELIVERY\";i:82;s:42:\"ROLE_PANEL_SERVICE_LIST_USER_LOGIN_HISTORY\";i:83;s:38:\"ROLE_PANEL_SERVICE_ALTER_USER_CALENDAR\";i:84;s:38:\"ROLE_PANEL_SERVICE_RECOVER_USER_REFILL\";i:85;s:30:\"ROLE_PANEL_SERVICE_MAKE_CLIENT\";i:86;s:23:\"ROLE_PRODUCT_ACCESS_MIX\";i:87;s:26:\"ROLE_PRODUCT_RENAME_IN_MIX\";i:88;s:25:\"ROLE_PRODUCT_DOWNLOAD_MIX\";i:89;s:38:\"ROLE_PRODUCT_CREATE_AND_UPDATE_PRODUCT\";i:90;s:35:\"ROLE_PRODUCT_CREATE_AND_UPDATE_CODE\";i:91;s:24:\"ROLE_PRODUCT_SECTOR_LIST\";i:92;s:37:\"ROLE_PRODUCT_SECTOR_CREATE_AND_UPDATE\";i:93;s:30:\"ROLE_PRODUCT_MANUFACTURER_LIST\";i:94;s:43:\"ROLE_PRODUCT_MANUFACTURER_CREATE_AND_UPDATE\";i:95;s:23:\"ROLE_PRODUCT_BRAND_LIST\";i:96;s:36:\"ROLE_PRODUCT_BRAND_CREATE_AND_UPDATE\";i:97;s:28:\"ROLE_PRODUCT_BRAND_LINE_LIST\";i:98;s:41:\"ROLE_PRODUCT_BRAND_LINE_CREATE_AND_UPDATE\";i:99;s:26:\"ROLE_PRODUCT_CATEGORY_LIST\";i:100;s:39:\"ROLE_PRODUCT_CATEGORY_CREATE_AND_UPDATE\";i:101;s:30:\"ROLE_PRODUCT_SUB_CATEGORY_LIST\";i:102;s:43:\"ROLE_PRODUCT_SUB_CATEGORY_CREATE_AND_UPDATE\";i:103;s:24:\"ROLE_PRODUCT_FAMILY_LIST\";i:104;s:37:\"ROLE_PRODUCT_FAMILY_CREATE_AND_UPDATE\";i:105;s:50:\"ROLE_SYSTEM_SETTINGS_COMMUNICATION_SUGGESTION_LIST\";i:106;s:52:\"ROLE_SYSTEM_SETTINGS_COMMUNICATION_SUGGESTION_CREATE\";i:107;s:50:\"ROLE_SYSTEM_SETTINGS_COMMUNICATION_SUGGESTION_EDIT\";i:108;s:50:\"ROLE_SYSTEM_SETTINGS_COMMUNICATION_OCCURRENCE_LIST\";i:109;s:52:\"ROLE_SYSTEM_SETTINGS_COMMUNICATION_OCCURRENCE_CREATE\";i:110;s:50:\"ROLE_SYSTEM_SETTINGS_COMMUNICATION_OCCURRENCE_EDIT\";i:111;s:46:\"ROLE_SYSTEM_SETTINGS_SUSPEND_REFILL_POPUP_LIST\";i:112;s:46:\"ROLE_SYSTEM_SETTINGS_SUSPEND_REFILL_POPUP_EDIT\";i:113;s:22:\"ROLE_BACKOFFICE_ACCESS\";i:114;s:29:\"ROLE_BACKOFFICE_ACCESS_ORDERS\";i:115;s:31:\"ROLE_BACKOFFICE_ACCESS_INVOICES\";i:116;s:27:\"ROLE_BACKOFFICE_ACCESS_SPOT\";i:117;s:26:\"ROLE_BACKOFFICE_ACCESS_BID\";i:118;s:33:\"ROLE_BACKOFFICE_ACCESS_PREDICTION\";i:119;s:28:\"ROLE_BACKOFFICE_ACCESS_STOCK\";}',0,NULL,7723,'2015-10-23 00:00:00',1,'Triste','2016-07-27 00:45:38','pf','999925758','1990-04-20 00:00:00','Client',1,1,0,1,0,'2015-10-23 00:00:00',5,1515.52,'+55','11','+55','11','[\"896719e3-c1e1-4384-a243-9f5a9be26e23\",\"c14db5ed-486a-4e53-9133-c3d4fb2614e4\",\"08dc47cb-b2b4-4a85-8bb4-442cc57b51e3\",\"507a4c44-e167-4b8f-b7df-d720aea583b8\",\"f58231c7-3d98-430a-995b-7f144ffb6c65\",\"3a36b0b1-067c-48ed-8dd7-9b3414529035\",\"b5997968-cb89-4f61-b325-c5c7d99b72e2\",\"bbb96d7d-0924-4d7b-9be5-e11a7d2f4158\",\"d591f49f-cd4d-4188-a9c1-df86d1841217\",\"\",\"fdb87544-bdf0-431f-98d3-41cb27b46c6c\",\"c48184bb-6c13-4272-8e9a-cb9b8a0c6e9c\",\"09bc22a5-1ee1-428d-9feb-00309003c9ac\",\"8c3bceb1-d3bd-49ea-9a28-df6149b5c817\",\"97718aef-42f7-4f09-8d60-77a545a1b3b2\",\"1ed7cb53-5527-494e-90b4-e5f959756046\",\"a16d6b6b-1b03-463b-a572-fcc389c13b50\"]',NULL),(5,13,'Daniel Mauad Gebara','25510943807','1234','daniel mauad gebara','daniel@hubert.com.br.cancelado','daniel@hubert.com.br.cancelado','31463909',1,'bhctedt9i3kggockcos0w8g0ggkg008','uROnk2AhOKSmGuhjUMjoNrGm5t2bEecJq1f2uCm+MW0E4xQAz0j9KT42WWBmPKwBz4vgf4FxkLlyOH6IMPVv6A==','2015-12-03 08:42:50',0,0,NULL,'1429997826',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,231,'2015-10-23 00:00:00',0,'Feliz','2016-12-01 21:51:08','pf',NULL,NULL,'Canceled',1,1,0,0,1,'2015-10-23 00:00:00',5,0,'+55','11','+55','11',NULL,NULL),(11,NULL,'andre machado','38994292810','1234','andre machado','andremsdeoliveira@gmail.com','andremsdeoliveira@gmail.com','37217927',1,'knwnjrdmu2ow4ksc44w00w8w084wos4','Y+qg9KZadPbNTpM+T/2e+W/sSBDIKXAt91VVAK+arOtl3N0YvgizB2Pkb4X8sEDSc9LPwwj/aM1I9cN2CiRjZQ==','2018-08-15 17:31:06',0,0,NULL,'1430341821',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,18,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,413.24,'+55','11','+55','11','23d27595-68ed-4cd3-b57a-cc8eaa2cf82f',NULL),(13,8,'Bruno de Sousa Mokarzel','22280914808','1234','bruno de sousa mokarzel','mokarzel@gmail.com','mokarzel@gmail.com','974931521',1,'bo4yh0fxe6o8wooo4wssgwoo8o48ooo','5Y0UfjQY2glcYz0cKWCTsfNB44CBT8G2rKEfEnM0eOeDr1HBhTCJroxYJSemmprhdv8cnHa3HC9Ql/m8rm0yMA==','2020-01-08 11:11:55',0,0,NULL,'1430358571',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,22,'2015-10-23 00:00:00',0,'Feliz','2017-07-16 14:18:55','pf','974931521',NULL,'Canceled',1,1,0,0,0,'2015-10-23 00:00:00',5,495.18,'+55','11','+55','11','',NULL),(15,13,'Raquel Gebara','28571056811','1234','raquel gebara','raquel@gebara.com.br.cancelado','raquel@gebara.com.br.cancelado','982247919',1,'7z4jzivo5l0kc80o04g008osscoo4o0','OvzpGghAAengq5WKtQQilUez/FPc50rOCvvKaCCxUfGzoSPa0lIgLgkrdqvUHFohh7BX6RJhGTz9w/WxMGENSQ==','2015-12-10 18:54:45',0,0,NULL,'1430790389',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,24,'2015-10-23 00:00:00',0,'Feliz','2016-12-01 21:52:26','pf',NULL,NULL,'Canceled',1,1,0,0,1,'2015-10-23 00:00:00',5,0,'+55','11','+55','11',NULL,NULL),(16,NULL,'ANDREA SILVA DE FREITAS','25821442826','1234','andrea silva de freitas','andreaalumi@hotmail.com','andreaalumi@hotmail.com','23896272',1,'s7h1k2x42rk00ssc00kok4co84kgsow','JET7opMoeN4aElo1dy7cBf3pmDwS//2Nw9CbzOL4kQnr2Wp0E2OqhueRrroBp8UK/8NfHV06HQ2IONJGELGkmg==',NULL,0,0,NULL,'1430836891',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,26,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,55.19,'+55','11','+55','11',NULL,NULL),(17,NULL,'João Dupin','02478416336','1234','joão dupin','jodupin@hotmail.com','jodupin@hotmail.com','99462048',1,'5qm824kckmckw40sok8oocc84wo0cs8','bc2b9tZXDw8uMrIG2qTyaL8vwt9WyZhostKlaB/ufbHFTFDQq0DlskQqk8n6vUmfqvrb8FDO+ox5DZ65qWKczA==',NULL,0,0,NULL,'1430870518',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,28,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,22.47,'+55','11','+55','11',NULL,NULL),(18,8,'Bruno Mizrahi',NULL,NULL,'bruno mizrahi','bruno@homerefill.com.br','bruno@homerefill.com.br',NULL,0,'hh1k2lrgv4occ0gwsg44okogssc4kco','curtCGMGXA9vcZoiow0G0Z68cRx88Q18Zo3Je9FA9XWorHvSNzblf8iWuaVfg7Jp1BYqobTLSmfF4EcoqZP9Mg==','2015-09-03 20:25:06',0,0,NULL,'1430948299',NULL,'a:2:{i:0;s:10:\"ROLE_ADMIN\";i:1;s:9:\"ROLE_USER\";}',0,NULL,NULL,NULL,0,'Feliz','2016-12-01 21:52:31','pf',NULL,NULL,NULL,1,0,0,0,1,NULL,1,0,'+55','11','+55','11',NULL,NULL),(19,9,'andrea barcellos','14419248840','1234','andrea barcellos','andreallos@bol.com.br','andreallos@bol.com.br','982451055',1,'pwir6qt9x40k0gw40g4cggs0c84ws0w','3iwbBjdIzNUWXHYzL5RUYTLl4bCJZc4T7nbkcOgr+8kLe5X3exP/7cP+jrRSt4IJSBG0kj7gJVbXOasNtQG7SQ==','2017-07-12 13:36:35',0,0,NULL,'1430956107',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,30,'2015-10-23 00:00:00',0,'Feliz',NULL,'pf','982451055',NULL,'Canceled',1,1,0,1,0,'2015-10-23 00:00:00',5,11.88,'+55','11','+55','11',NULL,NULL),(25,8,'Patricia Cunha','22433999898','1234','patricia cunha','patricia.cunha135@gmail.com.vazio.cancelado','patricia.cunha135@gmail.com.vazio.cancelado','981815946',1,'i7v6iddle74g8kk808k084sk44k0s8k','AHUYb3MJarigFEmKjahGXbhpD2wmpnNbGU9zssJlA0koxnBhC9RJsuxP5z0Hjjn6UIov5WBiyBasxq3G5VO2nA==','2015-10-13 20:04:14',0,0,NULL,'1431021550',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,37,'2015-10-23 00:00:00',0,'Feliz','2016-12-01 21:51:56','pf',NULL,NULL,'Canceled',1,0,0,0,1,'2015-10-23 00:00:00',5,0,'+55','11','+55','11',NULL,NULL),(27,8,'Rodrigo Mauad Gebara','26733476827','1234','rodrigo mauad gebara','rmgebara@gmail.com.cancelado','rmgebara@gmail.com.cancelado','31463988',1,'gdgwjg19fvcck40s840ws0ow0k08kcc','D09CA+o3z85nQifHH/vC6TO4gWzcKM0kfAu6uNKOZCHMqlVr6SXmfb5eYFCvqgfhji4zbheibs5AG+6rQY65Iw==','2015-12-10 23:13:10',0,0,NULL,'1431022015',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,40,'2015-10-23 00:00:00',0,'Feliz','2016-12-01 21:51:59','pf',NULL,NULL,'Canceled',1,1,0,0,1,'2015-10-23 00:00:00',5,0,'+55','11','+55','11',NULL,NULL),(30,13,'Luiz Melo','38665234837','1234','luiz melo','luizfsmelo14@gmail.com','luizfsmelo14@gmail.com','959501945',1,'9jg1vdsa5pgk4oksw4sccsgkkowc80g','fh7ZWW+PQTwNJY2gYNB2shATTGs0DbISOerkiPngIvMy7FpfsJMc1OtDBU5KEaB39mXEU9QtEVtYfOPf2F5g0g==','2015-08-13 17:04:48',0,0,NULL,'1431119769',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,46,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,330.69,'+55','11','+55','11','1dd608f2-c6a1-11e3-851d-000c2940e62c',NULL),(32,8,'maria beatriz daud','37609780880','1234','maria beatriz daud','mariabeatriz.daud@gmail.com','mariabeatriz.daud@gmail.com','999829948',1,'2j99iqyath2c8oskwgs048g8ok0cgwc','J70Rkq3/1p0Z2u8GAM7/UeIXitIfSyZl8tff+MUhN56xMawTV8w0W4m6eV5YIGh5ktOIdiE2lrwNqj1TFvHCqQ==','2015-07-30 10:49:16',0,0,NULL,'1431362652',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,50,'2015-10-23 00:00:00',0,'Feliz',NULL,'pf',NULL,NULL,'Canceled',1,1,0,0,0,'2015-10-23 00:00:00',5,23.54,'+55','11','+55','11',NULL,NULL),(33,8,'GISELE FERRAZ','13613224895','1234','gisele ferraz','GIDAHER@UOL.COM.BR','gidaher@uol.com.br','50521471',1,'nsmc39ri3404cck8g4400w440wk8kg','PS+1I/3nlepw8Lc5es3yR84EPLgCURctzxLw+5Q1CFXkwRtaBdo4Fk2QT+FNB4wAVB+MfalkpCR5qBLDELp27g==',NULL,0,0,NULL,'1431377997',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,52,'2015-10-23 00:00:00',0,'Feliz',NULL,'pf',NULL,NULL,'Canceled',1,0,0,0,0,'2015-10-23 00:00:00',2,114.68,'+55','11','+55','11',NULL,NULL),(35,13,'Camila Securato','28374742828','1234','camila securato','camila.marechal115@gmail.com','camila.marechal115@gmail.com','988228688',1,'66f1uzxa2zgg4os0gsogcg84ocgk48g','8LW97Yi2dT+3iWFgZCzIRESqQr+ASJYNdLnLdiJgUhtbYQ2j43ePqCUQ3G7OgYE6xCnN2hb6CnOJu7viULQI2A==','2020-03-30 17:13:21',0,0,NULL,'1431487323',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,56,'2015-10-23 00:00:00',0,'Feliz','2016-07-25 18:16:37','pf',NULL,NULL,'Client',1,1,1,1,0,'2015-10-23 00:00:00',5,1454.99,'+55','11','+55','11','[\"22472ced-7e2a-42c7-8d6d-c5658b6012b7\",\"41cb4f38-eaa1-43a7-928e-6d9504d3ffba\",\"caf8368c-6d5e-40c2-a029-5ec897aa621a\"]',NULL),(37,NULL,'Susan simões','06019317854','1234','susan simões','susan@strategymkt.com.br','susan@strategymkt.com.br','38495015',1,'su7q3odfkn4w8csg8ksg4os0k0kw8ow','+3efaLpqVt/52uLEzVmf65f7+IqSVTzi9Qci6szl2gFvVkgwnxdrDbpWACfVa0mQQ6YOgqyFf457MV/eQIHjFw==',NULL,0,0,NULL,'1431990596',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,58,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,151.41,'+55','11','+55','11',NULL,NULL),(38,NULL,'André Lara','42099548889','1234','andré lara','andrelara@gmail.com','andrelara@gmail.com','996874455',1,'pj3nesv646oos88c4sksck8os4sg44c','Oau6aMghqYOgYxGyT0sSM8tEZiPax5OBCUdZAkxmrim/pFGLVaVEt+y3D/s1+EpUiIpyWz9ycQZ0VkJt+BGFsw==',NULL,0,0,NULL,'1432046233',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,60,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,15.5,'+55','11','+55','11',NULL,NULL),(39,8,'Luis Vairo','28188099830','1234','luis vairo','lvairo@sabiaresidencial.com.br','lvairo@sabiaresidencial.com.br','983450022',1,'cenx2b5rjy80oosso80o4c4wskcogc4','BxjtDXZrnPnbAKXhocvT/woqAln5hMlUrnSKCTfxDGGLQuROZst/ehwjFaUYtqBstGWMoaBjWdMlnv3G3fDW5w==','2015-10-09 19:00:51',0,0,NULL,'1432057706',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,62,'2015-10-23 00:00:00',0,'Neutro',NULL,'pf',NULL,NULL,'Canceled',1,1,0,1,0,'2015-10-23 00:00:00',5,18.87,'+55','11','+55','11',NULL,NULL),(40,NULL,'rogeria brandani','07138258801','1234','rogeria brandani','robrandani@uol.com.br','robrandani@uol.com.br','23060110',1,'64qopf4kiuo884o0coo0w0o8w0scgws','UBbaLFIxEoAX+I4hmxz2n05oKjSPq6no4KPcR8Z0BIxMPpkM3zbIKD7GJ9WVSDsFYtIj3B6wY3FkzhlTWMCpkA==',NULL,0,0,NULL,'1432063904',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,64,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,65.79,'+55','11','+55','11',NULL,NULL),(41,13,'MARCOS HADDAD CURY','27087865803','1234','marcos haddad cury','CURY.MARCOS@GMAIL.COM','cury.marcos@gmail.com','975704660',1,'6cdqih2ku3okwo0k4s4sk8gkgko4sks','VeybYOArXCPKmaP9R14qUNn8o1yU3Ac5d17tyPvP9drkKawK4vhfPq+LFXRF40aWAMu9bI/rla2PiLOz/A465g==','2018-02-26 09:48:07',0,0,NULL,'1432237758',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,66,'2015-10-23 00:00:00',0,'Feliz','2018-03-06 08:23:01','pf','999999999',NULL,'Canceled',1,1,1,1,1,'2015-10-23 00:00:00',5,0,'+55','11','+55','11','b9db3454-bd94-48ca-95bd-86c583997b1c',NULL),(42,9,'Marcia Kalil','09247655854','1234','marcia kalil','marcia@marciakalil.com.br','marcia@marciakalil.com.br','30630302',1,'p4mbpsq3ho0owksoksw8ckcwk844w04','DxoZIYrnepBZF6myfz8NApw80rJtE8AV9m2fwLptu9Zo3encRETr19TPO7QOO0mwgjZSbwbbzBUI6yC8Fh+EKg==','2017-03-20 08:58:57',0,0,NULL,'1432257232',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,68,'2015-10-23 00:00:00',0,'Feliz','2016-07-17 16:17:21','pf','11111111',NULL,'Canceled',1,1,0,0,0,'2015-10-23 00:00:00',5,326.91,'+55','11','+55','11',NULL,NULL),(43,NULL,'ana lucia bauer tartoni','30447181807','1234','ana lucia bauer tartoni','anitatartoni@hotmail.com','anitatartoni@hotmail.com','982086824',1,'vby4ne7575csk44g0sscos04g80wgk','mNYdcVfZG1bNAxryDWZ3HHOdW7M+o9b2iVPdtvXD+RZ07+ab1R6mv8B52rPONU31QfUb/S5vrUT7393++47Zug==','2015-05-22 10:33:33',0,0,NULL,'1432301613',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,70,NULL,0,'Feliz',NULL,'pf',NULL,NULL,'Prospect',1,0,0,0,0,NULL,1,27.46,'+55','11','+55','11',NULL,NULL),(44,17,'Daniel Silva','08218376720','1234','daniel silva','daniel@dcanm.com.br.cancelado','daniel@dcanm.com.br.cancelado','963202552',1,'17y2o8t5nldwk480g0wc0gw0kc44ok','Ueux56AEgnsTBOz8yTSAGNFLhrFx7KRfhNfItrObPhUNB0qpbCh+tr+rTSQymj+X8Ze3KBRRLmsrGgcuWdiguw==','2015-11-26 19:13:42',0,0,NULL,'1432327871',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,73,'2015-10-23 00:00:00',0,'Neutro',NULL,'pf','11',NULL,'Canceled',1,1,0,1,0,'2015-10-23 00:00:00',1,114.82,'+55','11','+55','11',NULL,NULL),(45,13,'Daniel Silva','08218376720','1234','daniel silva','danmunizsilva@gmail.com','danmunizsilva@gmail.com','112386000',1,'njuf4oibmuosggssokckkc8cwkw0488','/FBcHW7h85ZJ4CiimnbHhz6vL1sUBpnb1z6ROdu66/9pMnk5C7K65ooXqcPoACxKsDzTAObs+LZcErSzjHk8rg==','2015-05-22 17:51:40',0,0,NULL,'1432327900',NULL,'a:1:{i:0;s:9:\"ROLE_USER\";}',0,NULL,72,NULL,0,'Feliz','2016-12-01 21:52:28','pf',NULL,NULL,'Prospect',1,0,0,0,1,NULL,1,0,'+55','11','+55','55',NULL,NULL),(59,13,'Luiz Melo','38665234837','1234','luiz melo','luiz.melo@homerefill.com.br','luiz.melo@homerefill.com.br','959501945',1,'7hhlepwt3hookk0kwggwg00ww80080g','MC24Agz/YTiG1n0ve1M7nxS3R91lIDzNgvt0VL7dmhPDfcEhxjjgUBnh2VyFR+oaALxvBVuUcJ1k6pDDJP2usw==','2015-12-16 11:08:21',0,0,NULL,'1432736604',NULL,'a:111:{i:0;s:10:\"ROLE_ADMIN\";i:1;s:22:\"ROLE_ACCOUNT_LIST_USER\";i:2;s:24:\"ROLE_ACCOUNT_CREATE_USER\";i:3;s:22:\"ROLE_ACCOUNT_EDIT_USER\";i:4;s:24:\"ROLE_FATTURA_LIST_TICKET\";i:5;s:24:\"ROLE_FATTURA_VIEW_TICKET\";i:6;s:26:\"ROLE_FATTURA_CREATE_TICKET\";i:7;s:26:\"ROLE_FATTURA_CANCEL_TICKET\";i:8;s:36:\"ROLE_FATTURA_ADD_OBSERVATIONS_TICKET\";i:9;s:35:\"ROLE_FATTURA_TICKET_PAYMENT_HISTORY\";i:10;s:28:\"ROLE_FATTURA_VIEW_TICKET_LOG\";i:11;s:33:\"ROLE_FATTURA_TICKET_PROCESS_RETRY\";i:12;s:28:\"ROLE_FATTURA_TICKET_SHOWFLOW\";i:13;s:42:\"ROLE_FATTURA_TICKET_COMPLEMENTARY_DELIVERY\";i:14;s:31:\"ROLE_FATTURA_ACCESS_ORDER_PANEL\";i:15;s:36:\"ROLE_FATTURA_ACCESS_EXPEDITION_PANEL\";i:16;s:38:\"ROLE_FATTURA_MANAGER_TICKET_EXPEDITION\";i:17;s:45:\"ROLE_FINANCIAL_ACCESS_PRECIFICATION_REVISIONS\";i:18;s:33:\"ROLE_FINANCIAL_EDIT_PRECIFICATION\";i:19;s:40:\"ROLE_FINANCIAL_CONSOLIDATE_PRECIFICATION\";i:20;s:39:\"ROLE_FINANCIAL_INACTIVATE_PRECIFICATION\";i:21;s:31:\"ROLE_FINANCIAL_ACCESS_COST_BASE\";i:22;s:42:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_COST_BASE\";i:23;s:32:\"ROLE_FINANCIAL_LIST_MANUFACTURER\";i:24;s:53:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_MANUFACTURER_CATALOG\";i:25;s:26:\"ROLE_FINANCIAL_LIST_BROKER\";i:26;s:47:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_BROKER_CATALOG\";i:27;s:28:\"ROLE_FINANCIAL_LIST_PROVIDER\";i:28;s:49:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_PROVIDER_CATALOG\";i:29;s:31:\"ROLE_FINANCIAL_LIST_CONCURRENCE\";i:30;s:52:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_CONCURRENCE_CATALOG\";i:31;s:24:\"ROLE_FINANCIAL_LIST_CARD\";i:32;s:29:\"ROLE_FINANCIAL_LIST_USER_CARD\";i:33;s:25:\"ROLE_FINANCIAL_LIST_ORDER\";i:34;s:31:\"ROLE_FINANCIAL_LIST_TRANSACTION\";i:35;s:39:\"ROLE_FINANCIAL_LIST_TRANSACTION_BY_CARD\";i:36;s:27:\"ROLE_FINANCIAL_LIST_CATALOG\";i:37;s:40:\"ROLE_FINANCIAL_CREATE_AND_UPDATE_CATALOG\";i:38;s:34:\"ROLE_FINANCIAL_CONSOLIDATE_CATALOG\";i:39;s:33:\"ROLE_FINANCIAL_INACTIVATE_CATALOG\";i:40;s:32:\"ROLE_FINANCIAL_LIST_CATALOG_ITEM\";i:41;s:34:\"ROLE_FINANCIAL_CREATE_CATALOG_ITEM\";i:42;s:34:\"ROLE_FINANCIAL_UPDATE_CATALOG_ITEM\";i:43;s:30:\"ROLE_MARKETING_ACCESS_SHOWCASE\";i:44;s:27:\"ROLE_MARKETING_ADD_SHOWCASE\";i:45;s:30:\"ROLE_MARKETING_REMOVE_SHOWCASE\";i:46;s:35:\"ROLE_MARKETING_INSERT_ITEM_SHOWCASE\";i:47;s:35:\"ROLE_MARKETING_REMOVE_ITEM_SHOWCASE\";i:48;s:31:\"ROLE_MARKETING_ACCESS_HIGHLIGHT\";i:49;s:28:\"ROLE_MARKETING_ADD_HIGHLIGHT\";i:50;s:27:\"ROLE_MARKETING_ACCESS_SCORE\";i:51;s:24:\"ROLE_MARKETING_ADD_SCORE\";i:52;s:27:\"ROLE_MARKETING_UPDATE_SCORE\";i:53;s:29:\"ROLE_MARKETING_DOWNLOAD_SCORE\";i:54;s:38:\"ROLE_OPERATION_LIST_STOCK_TRANSITIONAL\";i:55;s:34:\"ROLE_OPERATION_LIST_PHYSICAL_STOCK\";i:56;s:36:\"ROLE_OPERATION_LIST_PURCHASE_REQUEST\";i:57;s:35:\"ROLE_OPERATION_NEW_PURCHASE_REQUEST\";i:58;s:36:\"ROLE_OPERATION_EDIT_PURCHASE_REQUEST\";i:59;s:36:\"ROLE_OPERATION_VIEW_PURCHASE_REQUEST\";i:60;s:38:\"ROLE_OPERATION_CANCEL_PURCHASE_REQUEST\";i:61;s:53:\"ROLE_OPERATION_CHANGE_RECEIVING_DATE_PURCHASE_INVOICE\";i:62;s:37:\"ROLE_OPERATION_ACCESS_NECESSITY_PANEL\";i:63;s:53:\"ROLE_OPERATION_NECESSITY_PANEL_DOWNLOAD_REPORT_CYCLES\";i:64;s:51:\"ROLE_OPERATION_NECESSITY_PANEL_DOWNLOAD_REPORT_DAYS\";i:65;s:27:\"ROLE_OPERATION_STOCK_UPLOAD\";i:66;s:28:\"ROLE_PANEL_SERVICE_LIST_USER\";i:67;s:28:\"ROLE_PANEL_SERVICE_INFO_USER\";i:68;s:30:\"ROLE_PANEL_SERVICE_CANCEL_USER\";i:69;s:38:\"ROLE_PANEL_SERVICE_RESET_PASSWORD_USER\";i:70;s:37:\"ROLE_PANEL_SERVICE_LIST_COMMUNICATION\";i:71;s:36:\"ROLE_PANEL_SERVICE_NEW_COMMUNICATION\";i:72;s:35:\"ROLE_PANEL_SERVICE_LIST_USER_REFILL\";i:73;s:37:\"ROLE_PANEL_SERVICE_UPDATE_USER_REFILL\";i:74;s:43:\"ROLE_PANEL_SERVICE_LIST_USER_ACTION_HISTORY\";i:75;s:38:\"ROLE_PANEL_SERVICE_LIST_REFILL_HISTORY\";i:76;s:36:\"ROLE_PANEL_SERVICE_LIST_USER_VOUCHER\";i:77;s:35:\"ROLE_PANEL_SERVICE_NEW_USER_VOUCHER\";i:78;s:35:\"ROLE_PANEL_SERVICE_LIST_USER_WALLET\";i:79;s:37:\"ROLE_PANEL_SERVICE_UPDATE_USER_WALLET\";i:80;s:37:\"ROLE_PANEL_SERVICE_SKIP_USER_DELIVERY\";i:81;s:42:\"ROLE_PANEL_SERVICE_UNDO_SKIP_USER_DELIVERY\";i:82;s:42:\"ROLE_PANEL_SERVICE_LIST_USER_LOGIN_HISTORY\";i:83;s:38:\"ROLE_PANEL_SERVICE_ALTER_USER_CALENDAR\";i:84;s:38:\"ROLE_PANEL_SERVICE_RECOVER_USER_REFILL\";i:85;s:23:\"ROLE_PRODUCT_ACCESS_MIX\";i:86;s:26:\"ROLE_PRODUCT_RENAME_IN_MIX\";i:87;s:25:\"ROLE_PRODUCT_DOWNLOAD_MIX\";i:88;s:38:\"ROLE_PRODUCT_CREATE_AND_UPDATE_PRODUCT\";i:89;s:35:\"ROLE_PRODUCT_CREATE_AND_UPDATE_CODE\";i:90;s:24:\"ROLE_PRODUCT_SECTOR_LIST\";i:91;s:37:\"ROLE_PRODUCT_SECTOR_CREATE_AND_UPDATE\";i:92;s:30:\"ROLE_PRODUCT_MANUFACTURER_LIST\";i:93;s:43:\"ROLE_PRODUCT_MANUFACTURER_CREATE_AND_UPDATE\";i:94;s:23:\"ROLE_PRODUCT_BRAND_LIST\";i:95;s:36:\"ROLE_PRODUCT_BRAND_CREATE_AND_UPDATE\";i:96;s:28:\"ROLE_PRODUCT_BRAND_LINE_LIST\";i:97;s:41:\"ROLE_PRODUCT_BRAND_LINE_CREATE_AND_UPDATE\";i:98;s:26:\"ROLE_PRODUCT_CATEGORY_LIST\";i:99;s:39:\"ROLE_PRODUCT_CATEGORY_CREATE_AND_UPDATE\";i:100;s:30:\"ROLE_PRODUCT_SUB_CATEGORY_LIST\";i:101;s:43:\"ROLE_PRODUCT_SUB_CATEGORY_CREATE_AND_UPDATE\";i:102;s:24:\"ROLE_PRODUCT_FAMILY_LIST\";i:103;s:37:\"ROLE_PRODUCT_FAMILY_CREATE_AND_UPDATE\";i:104;s:22:\"ROLE_BACKOFFICE_ACCESS\";i:105;s:29:\"ROLE_BACKOFFICE_ACCESS_ORDERS\";i:106;s:31:\"ROLE_BACKOFFICE_ACCESS_INVOICES\";i:107;s:27:\"ROLE_BACKOFFICE_ACCESS_SPOT\";i:108;s:26:\"ROLE_BACKOFFICE_ACCESS_BID\";i:109;s:33:\"ROLE_BACKOFFICE_ACCESS_PREDICTION\";i:110;s:28:\"ROLE_BACKOFFICE_ACCESS_STOCK\";}',0,NULL,90,'2015-10-23