[Al-Sheikh]

hi everyone  

today we have an small indian IT comapny  https://webguruz.in

Webguruz is a full-service digital marketing agency launched in 2008 by CEO Jaswinder Singh, with branches located domestically and overseas.

• 10,052 CANDIDATES
  

DROP TABLE IF EXISTS `candidates`;
CREATE TABLE `candidates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '1',
  `full_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_number` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '1:Male,2:Female',
  `marital_status` enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '1:Single,2:Married',
  `residence_address` mediumtext COLLATE utf8mb4_unicode_ci,
  `passport_number` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `place_of_birth` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hobbies` mediumtext COLLATE utf8mb4_unicode_ci,
  `current_salary` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_salary` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` longtext COLLATE utf8mb4_unicode_ci,
  `profile_token` longtext COLLATE utf8mb4_unicode_ci,
  `profile_id` longtext COLLATE utf8mb4_unicode_ci,
  `profile_token_date` datetime DEFAULT NULL,
  `test_status` enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '0:Pending,1:Accept,2:Reject',
  `department` enum('1','2','3','4','5','6','7','8','9') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '9' COMMENT '1:Digital Marketing, 2:Business Development, 3:Mobile Development, 4:Web Designing, 5:HR, 6:Admin, 7:Quality, 8:Web Development, 9:Other',
  `total_experience` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_relevant_experience` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sourcing` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_interview` date DEFAULT NULL,
  `interviewed_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interview_score` double(8,2) DEFAULT NULL,
  `notice_period` mediumtext COLLATE utf8mb4_unicode_ci,
  `current_location` mediumtext COLLATE utf8mb4_unicode_ci,
  `cv_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `offered_salary` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '0:No,1:Yes',
  `country_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT '478',
  `linked_in` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `candidates_user_id_index` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Lost (If you had this and want provide, please write to me or @Addka72424 via pm)

--------------------------------------------------------------------------------------------------------

and we have https://punjabharyanahighcourtbar.in
it was in same server

• active 11,786 user
  

-- Table structure for table `wp_users`

--

CREATE TABLE `wp_users` (
  `ID` bigint UNSIGNED NOT NULL,
  `user_login` varchar(60) NOT NULL DEFAULT '',
  `user_pass` varchar(255) NOT NULL DEFAULT '',
  `user_nicename` varchar(50) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_url` varchar(100) NOT NULL DEFAULT '',
  `user_registered` datetime DEFAULT NULL,
  `user_activation_key` varchar(255) NOT NULL DEFAULT '',
  `user_status` int NOT NULL DEFAULT '0',
  `display_name` varchar(250) NOT NULL DEFAULT '',
  `dues` decimal(11,2) NOT NULL DEFAULT '0.00',
  `id_card` tinyint NOT NULL DEFAULT '0',
  `address` text,
  `phone` varchar(225) DEFAULT NULL,
  `mobile` varchar(225) DEFAULT NULL,
  `father_name` varchar(225) DEFAULT NULL,
  `member_type` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wp_users`
--

https://gofile.io/d/pZJSQ3

----------------------------------------------------------------------------

old users and new users

• 21,379 Members 28-FEB
  

-- Database: `barassociationappdb`
--

-- --------------------------------------------------------

--
-- Table structure for table `members-28-feb`
--

CREATE TABLE `members-28-feb` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enrollment_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_avatar` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user.svg',
  `member_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternate_email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_membership` date DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `date_of_enrollment` date DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_contact_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `personal_contact_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sitting_place` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blood_group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--

DOWNLOAD LINK

if you need the webshell or the rest of the records .. msg me 

msg to Jaswinder Singh : stupid indian hahahaha
i found other data of thier subdomain : hrm.webguruz.in
they have 9694 total, Raw
same structure as candidates - https://gofile.io/d/dnQ3Sr

[Al-Sheikh]

i got more db's from same server (indian data) if someone intersted i can make new collection..

[Addka72424]

The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.

[Addka72424]

The link on this thread has been updated as of this post.

[Loki]

The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.