DATABASE NERASOLGH.COM — 26M FULL PII + BANK DATA + GEO + HASHES (SQL DUMP)

Quote: Wrote:INSERT INTO iwms_new.customers (CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_TYPE,CUSTOMER_STATUS,EMAIL_ADDRESS,PRIMARY_PHONE,SECONDARY_PHONE,HOUSE_NO,STREET_NO,STREET_NAME,SUBURB,LOCATION,POSTAL_ADDRESS,CONTACT_NAME,CONTACT_NUMBER,CONTACT_EMAIL,LATITUDE,LONGITUDE,USER_ID,COMMUNITY_ID,CREATED_ON,UPDATED_ON,DELETED_ON,SERVICE_PROVIDER_CODE,GENDER,OLD_ID,RATE,TOTAL_BINS,BINS_REQUESTED,FIRST_NAME,LAST_NAME,MIDDLE_NAME,DIGITAL_ADDRESS,AREA_ID,PROPERTY_CODE,DELETED_BY,DISCOUNT,TAXABLE,BANK_DETAILS,DEACTIVATED_BY,DEACTIVATED_DATE,COLLECTOR_ID,RESTORE_DATE,password,opt,isVerified,canLogin,is_default_password,last_invoice_date,last_invoice_no,last_invoice_year_month,sys_col1,sys_col2,cust_outst_bal,stm_lastupd) VALUES
('06000001','DUNYO ROBERT','R','Active',NULL,'0552481777','0552481777','G330',NULL,'OCEAN ST',NULL,NULL,NULL,'ROBERT','0552481777',NULL,NULL,NULL,'ACC900322',7176,'2023-09-21 06:47:02','2023-09-21 06:47:02',NULL,'12','M',NULL,NULL,0,NULL,'ROBERT','DUNYO',NULL,'GD-248-7812',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$lbh5QG4CAaHr75LwBp8E/Ocv4dN37FyIzfRn9teL0eh7W3LvDt5bC',NULL,'N','Y','Y','2023-09-21 06:47:02','30183223092112','2023-09','20240119.133716.283868','',0.00,'20240119.133716.283868'),
('08000001','Oforiwaa Margaret','R','Active',NULL,'0557867479',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Oforiwaa Margaret','0557867479',NULL,'5.76606','-0.007745','ACC114957',5937,'2023-09-29 17:57:04','2023-09-29 17:57:04',NULL,'12','Female',NULL,NULL,NULL,NULL,'Margaret','Oforiwaa',NULL,NULL,NULL,NULL,NULL,NULL,'n','',NULL,NULL,NULL,NULL,'$2y$10$RPeMndV8RsupRlmfJbc1/.BPCRuDRJrYmdy0q8WKO2Tqgt3CH2IuG',NULL,'N','Y','Y','2023-09-29 17:57:04','92234023092912','2023-09','20240119.133716.344175','',0.00,'20240119.133716.344175'),
('09000001','OKYIRE TETTEH','R','Active',NULL,'0244327511','0244327511',NULL,NULL,NULL,NULL,NULL,NULL,'TETTEH','0244327511',NULL,NULL,NULL,'ACC900322',7066,'2023-09-21 06:34:14','2023-09-21 06:34:14',NULL,'12','M',NULL,NULL,0,NULL,'TETTEH','OKYIRE',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UFAHEyL3V7crZRMFgoU5w.tFGHMnXlilc1dCq5AYDErjei6CDPU4e',NULL,'N','Y','Y','2023-09-21 06:34:14','07136123092112','2023-09','20240119.133716.403928','',0.00,'20240119.133716.403928'),
('10000001','Ewurakua Ewurakua','R','Active',NULL,'0555560753',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ACC900322',8893,'2023-09-20 11:00:50','2023-09-20 11:00:50',NULL,'12','F',NULL,NULL,0,NULL,'Ewurakua','Ewurakua',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$Eqo2tyZzrUzmrEvgPXjYieNzSQYd8.tRM7T4FTn.n.7AYhKCBNwca',NULL,'N','Y','Y','2023-09-20 11:00:50','94495123092012','2023-09','20240119.133716.461927','',0.00,'20240119.133716.461927'),
('11000001','MAN SETH GOOD','R','InActive',NULL,'0248593034','0248593031',NULL,NULL,NULL,NULL,NULL,NULL,'MAN SETH GOOD','0200854586',NULL,'5.63963963963964','-0.10863393439025044','AGT971821',5868,'2019-06-20 09:45:26','2023-12-27 09:35:11',NULL,'11','Male',NULL,20.00,0,NULL,'GOOD','MAN','SETH',NULL,NULL,NULL,NULL,NULL,'n',NULL,'ACC899534','2023-12-27 09:35:11',NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2020-03-12 15:25:51','99384220031211','2020-02','20240119.133716.529288','',57.06,'20240809.205921.590227'),
('11000002','TETTEH','R','Active',NULL,'0249967915',NULL,'B/1147/10',NULL,NULL,NULL,NULL,NULL,'TETTEH','0249967915',NULL,'5.638099999999999','0.00509','AGT132081',94,'2019-09-02 12:07:50','2019-09-10 09:46:58','2019-09-10 09:46:58.187000','11','Male',NULL,32.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y',NULL,NULL,NULL,'20240119.133716.588030','',-1.00,'20240119.133716.588030'),
('11000003','OBUDAI EMMANUEL','R','Active',NULL,'0242782047',NULL,'k.39',NULL,NULL,NULL,NULL,NULL,'OBUDAI ON EMMANUEL','0242782047',NULL,'5.6882805','-0.0168371','ACC154754',5868,'2019-09-07 10:38:43','2022-03-04 15:51:55',NULL,'11','M',NULL,NULL,0,NULL,'EMMANUEL','OBUDAI',NULL,'GB-010-8092',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:00','05459123120611','2023-11','20240119.133716.710092','',1179.00,'20240405.171211.286305'),
('11000004','NKETSIA FAUSTINA','R','Active',NULL,'0549047576',NULL,'k 35 Nouvelle street',NULL,'Nouvelle street',NULL,NULL,NULL,'NKETSIA FAUSTINA','0549047576',NULL,'5.6878738','-0.0176284','ACC154754',5868,'2019-09-07 11:26:26','2022-03-04 15:51:56',NULL,'11','F',NULL,NULL,0,NULL,'FAUSTINA','NKETSIA',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:21','20347123120611','2023-11','20240119.133716.825279','',265.00,'20240119.133716.825279'),
('11000005','ABDULAI MUSAH','R','Active',NULL,'0244372881',NULL,'k.2',NULL,NULL,NULL,NULL,NULL,'ABDULAI MUSAH','0244372881',NULL,'5.6880771','-0.0172327','ACC154754',5868,'2019-09-07 11:34:11','2022-03-04 15:51:56',NULL,'11','M',NULL,NULL,0,NULL,'MUSAH','ABDULAI',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:21','60286223120611','2023-11','20240119.133716.944574','',165.00,'20240119.133716.944574'),
('11000006','MCKEOWN JAMES','R','Active',NULL,'0245908868',NULL,'# 21 Annan street',NULL,NULL,NULL,NULL,NULL,'MCKEOWN JAMES','0245908868',NULL,'5.6878738','-0.0176284','ACC154754',6567,'2019-09-07 11:59:55','2022-10-31 15:40:15',NULL,'11','M',NULL,NULL,0,NULL,'JAMES','MCKEOWN',NULL,'GB - 010 - 5458',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2024-08-05 19:46:34','35470024080511','2024-07','20240119.133717.027872','Active',1075.00,'20240805.194634.425488');
('11000007','ASEIDU AKUA','R','InActive',NULL,'0206644628',NULL,'# 15 Annan Street',NULL,NULL,NULL,NULL,NULL,'ASEIDU AKUA','0206644628',NULL,'5.6880771','-0.0172327','ACC154754',5868,'2019-09-07 12:05:53','2023-12-27 20:38:58',NULL,'11','F',NULL,NULL,0,NULL,'AKUA','ASEIDU',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'ACC240045','2023-12-27 20:38:58',NULL,NULL,'$2y$10$DKhOpor9aeepV1HKCS6ZDe1iyMLEUgmfUyJzHTf2BErYHT0IbxhRq',NULL,NULL,'Y','N','2023-12-06 13:18:21','14592023120611','2023-11','20240119.133717.150491','',385.00,'20240119.133717.150491'),
('11000008','AGYEMAN AKORFA AMANDA','R','Active','mandienna@gmail.com','0243503020',NULL,'# 17 Annan Street',NULL,NULL,NULL,NULL,NULL,'AGYEMAN AKORFA AMANDA','0243503020','mandienna@gmail.com','5.6878738','-0.0176284','ACC154754',5868,'2019-09-07 12:28:09','2022-03-04 15:51:58',NULL,'11','F',NULL,NULL,0,NULL,'AMANDA','AGYEMAN','AKORFA','GB - 010 - 5556',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:21','88269923120611','2023-11','20240119.133717.263453','',-5.00,'20240119.133717.263453'),
('11000009','CHEMICALS BENTRONIC AGRO','C','Active',NULL,'0244741367',NULL,'GB-010-9169',NULL,NULL,NULL,NULL,NULL,'BENTRONIC AGRO CHEMICALS','0244741367',NULL,'5.7049148','-0.014779','ACC154754',1982,'2019-09-07 12:49:26','2022-09-19 17:57:35',NULL,'11','Corporate',NULL,55.00,0,NULL,'BENTRONIC AGRO','CHEMICALS',NULL,'GB-010-9169',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2024-08-05 19:46:34','04019324080511','2024-07','20240119.133717.393949','',145.00,'20240807.224817.346076'),
('11000010','MOTORS WORSHIP GOD','C','Active',NULL,'0246610011',NULL,'GB-010-9169',NULL,NULL,NULL,NULL,NULL,'WORSHIP GOD MOTORS','0246610011',NULL,'5.6878738','-0.0176284','ACC154754',1982,'2019-09-07 12:52:09','2022-09-19 17:57:36',NULL,'11','F',NULL,55.00,0,NULL,'WORSHIP GOD','MOTORS',NULL,'GB-010-9169',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2024-08-05 19:46:34','06924124080511','2024-07','20240119.133717.521359','',0.00,'20240807.224059.830843'),
('11000011','ENTERPRISE QUEENS KROSS','C','Active',NULL,'0545012950',NULL,'GB-010-9169',NULL,NULL,NULL,NULL,NULL,'QUEENS KROSS ENTERPRISE','0545012950',NULL,'5.6878738','-0.0176284','ACC154754',1982,'2019-09-07 12:56:14','2022-09-19 17:57:37',NULL,'11','F',NULL,55.00,0,NULL,'QUEENS KROSS','ENTERPRISE',NULL,'GB-010-9169',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2024-08-05 19:46:34','63270224080511','2024-07','20240119.133717.647197','',-40.00,'20240808.200412.695133'),
('11000012',' CORNER BAR','C','InActive',NULL,'0243447319',NULL,'M.E - B - 245',NULL,NULL,NULL,NULL,NULL,'CORNER BAR','0243447319',NULL,'5.6878738','-0.0176284','ACC154754',5868,'2019-09-07 13:06:22','2022-03-04 15:52:00',NULL,'96','Female',NULL,NULL,0,NULL,'CORNER BAR',NULL,NULL,'GB-010-9169',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2021-10-07 12:08:53','01091621100711','2021-09','20240119.133717.729415','InActive',960.00,'20240119.133717.729415'),
('11000013',' KWABENA YEBOAH MOTORS','C','Active',NULL,'0244206595',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KWABENA YEBOAH MOTORS','0244206595',NULL,'5.6951756','-0.0146741','ACC154754',1982,'2019-09-07 13:26:26','2022-09-19 17:57:38',NULL,'11','Male',NULL,50.00,0,NULL,'KWABENA YEBOAH MOTORS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2024-08-05 19:46:34','39204224080511','2024-07','20240119.133717.838892','',1970.00,'20240805.194634.919874'),
('11000014','HLORKA DELIGHT FATI','R','InActive',NULL,'0278676683',NULL,'Nouvelle street',NULL,NULL,NULL,NULL,NULL,'DELIGHT FATI HLORKA','0278676683',NULL,'5.6959644','-0.0160964','ACC154754',5868,'2019-09-07 13:36:06','2022-03-04 15:52:02',NULL,'96',NULL,NULL,NULL,0,NULL,'DELIGHT FATI','HLORKA',NULL,'GB - 002 - 4085',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2021-06-04 06:44:43','92493321060411','2021-05','20240119.133717.926988','InActive',70.00,'20240119.133717.926988'),
('11000015','OBENG OPHELIA','R','Active',NULL,'0541668432',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'OBENG OPHELIA','0541668432',NULL,'5.6880771','-0.0172327','ACC154754',5868,'2019-09-07 13:48:38','2022-03-04 15:52:02',NULL,'11','Female',NULL,NULL,0,NULL,'OPHELIA','OBENG',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','18995023120611','2023-11','20240119.133718.038198','',445.00,'20240119.133718.038198'),
('11000016','ADDO WINIFRED','R','Active',NULL,'0246217449',NULL,'Nouvelle Street',NULL,NULL,NULL,NULL,NULL,'ADDO WINIFRED','0246217449',NULL,'5.6959644','-0.0160963','ACC154754',5868,'2019-09-07 13:56:30','2022-03-04 15:52:03',NULL,'11','Female',NULL,NULL,0,NULL,'WINIFRED','ADDO',NULL,'GB - 002 - 3084',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','30102223120611','2023-11','20240119.133718.164364','',5.00,'20240119.133718.164364');
('11000017','AYONGO GEORGINA','R','Active',NULL,'0201310186',NULL,'Nouvelle Street',NULL,NULL,NULL,NULL,NULL,'AYONGO GEORGINA','0201310186',NULL,'5.6959633','-0.0160967','ACC154754',5868,'2019-09-07 14:09:08','2022-03-04 15:52:03',NULL,'11','Female',NULL,NULL,0,NULL,'GEORGINA','AYONGO',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','24073223120611','2023-11','20240119.133718.259669','InActive',380.00,'20240119.133718.259669'),
('11000018',' NOUVELL SCHOOL COMPLEX','C','Active','s.kwadzo@yahoo.com','0241455086','0243577952','INST/203 ASH',NULL,NULL,NULL,NULL,NULL,'NOUVELL SCHOOL COMPLEX','0241455086','s.kwadzo@yahoo.com','5.6880094','-0.0173646','ACC154754',1982,'2019-09-07 14:29:08','2022-09-19 17:57:39',NULL,'11','Male',NULL,55.00,0,NULL,'NOUVELL SCHOOL COMPLEX',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2024-08-05 19:46:35','17292924080511','2024-07','20240119.133718.373623','',3390.00,'20240805.194635.037267'),

Click to expand...