November 22, 2022 at 6:35 AM
Date: November 2022
Tables:
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`role` int(11) NOT NULL COMMENT '0-Superadmin, 1 -Subbroker , 2 - Another Role',
`userRights` text COLLATE utf8_unicode_ci NOT NULL,
`sunbroker_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`sub_email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`sub_additionalemail` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`contactNo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`bankName` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
`bank_account` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`ifscCode` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`gst_No` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`equity_sub_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`subbroker_arn` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`euin` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`address` text COLLATE utf8_unicode_ci NOT NULL,
`products` text COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
Rows: ~2000
Format: .sql ( only users table )
The origin is not 100% sure. The dump may belong somehow to https://www.jhaveritrade.com/ but most likely is directly from the app https://play.google.com/store/apps/details?id=com.wave.JeTradePlus.
The data ranges from early 2018 up to today, although there have been no recent registrations. Status reports in the DB are still being generated.
Example:
Tables:
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`role` int(11) NOT NULL COMMENT '0-Superadmin, 1 -Subbroker , 2 - Another Role',
`userRights` text COLLATE utf8_unicode_ci NOT NULL,
`sunbroker_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`sub_email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`sub_additionalemail` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`contactNo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`bankName` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
`bank_account` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`ifscCode` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`gst_No` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`equity_sub_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`subbroker_arn` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`euin` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`address` text COLLATE utf8_unicode_ci NOT NULL,
`products` text COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
Rows: ~2000
Format: .sql ( only users table )
The origin is not 100% sure. The dump may belong somehow to https://www.jhaveritrade.com/ but most likely is directly from the app https://play.google.com/store/apps/details?id=com.wave.JeTradePlus.
The data ranges from early 2018 up to today, although there have been no recent registrations. Status reports in the DB are still being generated.
Example:
INSERT INTO `users` VALUES ('2','YASH JHAVERI-6 (PRERNA NARESH PUROHIT)','[email protected]','$2y$10$bB8rt/sQsFHFv2rb2WHpyua5/GG7EZuGpfkVcU53NFoNw03yKQN.S','j1KD0bP0DF7EV2pVcmgOldsaLKi5se1ZGexS0foJfDO7xgMMwUnnWLhzA33Y','1','','1211','[email protected]','','9909945955','','','','','','','','','','0000-00-00 00:00:00','2017-11-09 17:11:16'),('3','PRAMESH INVESTMENT WAGHODIA','[email protected]','$2y$10$qs2O1MtSihSZDyJLYhWWHuatszery98I/DbKjeNv/0MYru.lFXLAO','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1228','[email protected]','','9825246177','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('4','NIMISHA MAHESHKUMAR PATEL','[email protected]','$2y$10$yYdGfNWljm9djsa63A0O.OfEY0OhoWn4ExJi9BN5C/oN1OdHSy0bW','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1232','[email protected]','','9924151600','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('5','RAJNIKANT S PATEL','[email protected]','$2y$10$NQNsNmbRtDGOgByZ7hIcP.3ZqHu/A2rWRt2P2I/XqjU79GtyH76PO','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1233','[email protected]','','9925223468','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('6','BHARAT JAYANTILAL GANDHI','[email protected]','$2y$10$4b0uJpnnz7tuXSC7XZwXgelXN.Uj4AyXFzvE7o6Qnm2JZ4YLXpNiS','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1246','[email protected]','','9825119036','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('7','INVEX CONSULTANCY (JYOTI MASAND)','[email protected]','$2y$10$cB6Kwc3T.o2Qlkw32RYfdOAPKnDKPb5/SEPNwol7UFpwCX6gXdcye','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1259','[email protected]','','9376217259','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00')