--
-- Host: localhost    Database: assarbbq_placementdb
-- ------------------------------------------------------

/*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */;
/*!50717 PREPARE s FROM @rocksdb_get_is_supported */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;
/*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` VALUES (1,'CA','2022-02-23 00:00:00','2020-06-02 23:35:50'),(2,'CS','2020-04-11 00:00:08','0000-00-00 00:00:00'),(3,'CMA','2022-02-23 00:00:00','2020-06-02 23:35:50'),(8,'CFA','2020-04-11 00:00:08','0000-00-00 00:00:00'),(9,'FRM','2020-04-11 00:00:08','0000-00-00 00:00:00');

--
-- Table structure for table `exam_questions`
--

CREATE TABLE `exam_questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `mark` int(11) DEFAULT NULL,
  `option1` text,
  `option2` text,
  `option3` text,
  `option4` text,
  `correct_option` tinyint(3) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `exam_questions`
--

INSERT INTO `exam_questions` VALUES (7,'First number',10,'1','2','3','4',1,'2022-04-22 04:06:51','2022-04-22 04:06:51',NULL),(6,'Hi how are you?',1,'fine','ok','not ok','none of the above',2,'2022-03-07 02:29:59','2022-03-08 02:51:24',NULL);

--
-- Table structure for table `exam_times`
--

CREATE TABLE `exam_times` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `exam_times`
--

INSERT INTO `exam_times` VALUES (3,10,'2022-03-07 08:59:17','2022-03-07 09:00:23');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `firm_details`
--

CREATE TABLE `firm_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `contact_person_name` varchar(255) DEFAULT NULL,
  `no_of_partners_id` int(11) DEFAULT NULL,
  `exposure_offered` text,
  `stipened_offered` text,
  `about_firm` text,
  `block_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0-blocked,1-not_blocked',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `firm_details`
--

INSERT INTO `firm_details` VALUES (1,3,'aradhya',2,'20000','1004','Old Firm',0,NULL,'2022-04-20 23:27:08',NULL),(4,8,'swetha',1,'20000','1004','Old Firm',1,NULL,'2022-02-24 23:39:03',NULL),(7,16,'Aryas',2,'20000','66004','Olxcxd Firm',0,'2022-03-10 00:28:04','2022-03-10 00:28:04',NULL),(8,17,'Aryas',2,'20000','66004','Olxcxd Firm',0,'2022-04-21 00:08:30','2022-04-21 00:10:19','2022-04-21'),(11,29,'aradhya',2,'20000','1004','Old Firm',0,'2022-05-03 03:21:33','2022-05-03 05:53:00',NULL);

--
-- Table structure for table `firm_galleries`
--

CREATE TABLE `firm_galleries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `firm_galleries`
--

INSERT INTO `firm_galleries` VALUES (8,30,'/uploads/054249WIN_20200415_16_12_00_Pro.jpg','2022-05-04 00:12:49','2022-05-04 00:12:49',NULL),(9,30,'/uploads/054249WIN_20200415_16_12_19_Pro.jpg','2022-05-04 00:12:49','2022-05-04 00:12:49',NULL),(10,3,'/uploads/054249WIN_20200415_16_12_00_Pro.jpg','2022-05-04 00:12:49','2022-05-04 00:12:49',NULL),(11,8,'/uploads/054249WIN_20200415_16_12_19_Pro.jpg','2022-05-04 00:12:49','2022-05-04 00:12:49',NULL);

--
-- Table structure for table `firm_requirements`
--

CREATE TABLE `firm_requirements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT 'firm id',
  `looking_role_id` int(11) NOT NULL COMMENT 'employee or student',
  `entry_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '(0-Direct entry,1-IPCC group requirement',
  `maximum_no_of_ipcc_attempts` int(11) NOT NULL,
  `qualification_needed` int(11) DEFAULT NULL,
  `work_experience` text,
  `area` varchar(255) DEFAULT NULL,
  `minimum_test_mark` int(11) NOT NULL,
  `prefered_gender` tinyint(2) DEFAULT NULL COMMENT '0-male,1-female',
  `other_requirements` text NOT NULL,
  `approval_status` enum('approved','expired','pending') DEFAULT 'pending' COMMENT '0-pending,1-approved,2-expired',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `firm_requirements`
--

INSERT INTO `firm_requirements` VALUES (1,3,2,1,2,1,'7 yrs','CDXC',18,0,'xc dc\r\ndcd \r\ndcds','expired','2022-01-31 18:30:00',NULL,NULL),(2,8,3,0,2,2,'10 yrs','CDXC',20,1,'xxfadgsd','approved','2022-02-05 18:30:00',NULL,NULL),(4,3,2,1,3,3,'8 yrs','CDXC',130,1,'dgsdxz\r\ndcds','approved','2022-02-02 18:30:00','2022-04-22 01:42:23',NULL),(5,30,2,0,4,1,'1 yrs','',50,0,'cxbfc cxvbfx','pending','2022-05-03 06:16:48','2022-05-03 06:16:48',NULL);

--
-- Table structure for table `location_zones`
--

CREATE TABLE `location_zones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `location_zones`
--

INSERT INTO `location_zones` VALUES (1,'Kerala','2022-02-15 18:30:00','2022-05-19 11:29:54',NULL),(2,'Karnatka','2022-02-23 05:46:29','2022-02-23 05:50:12',NULL),(3,'Mumbai','2022-03-08 02:01:31','2022-03-08 02:01:31',NULL),(4,'Kolkata','2022-04-20 04:38:32','2022-04-20 04:38:32',NULL),(5,'Delhi','2022-05-19 11:30:10','2022-05-19 11:30:10',NULL);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2019_08_19_000000_create_failed_jobs_table',1),(9,'2019_12_14_000001_create_personal_access_tokens_table',1);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_key` varchar(255) NOT NULL,
  `data_id` int(20) NOT NULL,
  `data_read_status` tinyint(3) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `number_of_partners`
--

CREATE TABLE `number_of_partners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no_of_partners` varchar(125) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `number_of_partners`
--

INSERT INTO `number_of_partners` VALUES (1,'<2',NULL,NULL),(2,'2-5',NULL,NULL),(3,'5-8',NULL,NULL),(4,'8-10',NULL,NULL),(5,'>10',NULL,NULL);

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2022-02-14 06:13:25','2022-02-14 06:13:25'),(2,3,'2022-02-15 01:24:32','2022-02-15 01:24:32');

--
-- Table structure for table `qualifications`
--

CREATE TABLE `qualifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `qualifications`
--

INSERT INTO `qualifications` VALUES (1,'Direct Entry',NULL,NULL),(2,'IPCC Single Group',NULL,NULL),(3,'IPCC Both Groups',NULL,NULL);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `role_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin',1,'2022-02-17 04:43:46','0000-00-00 00:00:00'),(2,'Student',2,'2022-02-17 04:43:46','0000-00-00 00:00:00'),(3,'Employee',3,'2022-02-17 04:44:05','0000-00-00 00:00:00'),(4,'Firm',4,'2022-02-17 04:44:05','0000-00-00 00:00:00');

--
-- Table structure for table `user_application_offer_letters`
--

CREATE TABLE `user_application_offer_letters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_application_id` int(11) NOT NULL,
  `offer_letter` text NOT NULL,
  `offer_letter_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0-not sent,1-offered',
  `offer_letter_accept_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0-reject,1-accepted',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_application_offer_letters`
--


--
-- Table structure for table `user_applications`
--

CREATE TABLE `user_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `firm_requirement_id` int(11) NOT NULL,
  `application_status` enum('applied','assigned','shortlisted','rejected','offered','offer_accepted','offer_rejected') DEFAULT NULL COMMENT '0-applied,1-short_listed,2-offer_letter_recieved',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_applications`
--

INSERT INTO `user_applications` VALUES (1,6,1,'applied','2022-03-09 10:46:09','0000-00-00 00:00:00',NULL),(2,30,5,'assigned','2022-05-06 04:46:20','0000-00-00 00:00:00',NULL),(6,30,1,'offered','2022-05-05 11:20:45','2022-02-23 03:55:09',NULL),(4,9,2,'assigned','2022-04-22 09:25:57','2022-04-22 03:55:57',NULL),(5,5,2,'shortlisted','2022-03-09 10:47:11','2022-02-23 03:55:09',NULL),(7,6,4,'applied','2022-05-05 11:18:17','2022-05-03 00:20:09',NULL);

--
-- Table structure for table `user_course_pursuings`
--

CREATE TABLE `user_course_pursuings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_course_pursuings`
--

INSERT INTO `user_course_pursuings` VALUES (1,5,1,NULL,NULL,NULL),(21,6,8,'2022-04-20 09:38:36','2022-05-02 07:17:33','2022-05-02'),(3,7,3,NULL,'2022-05-02 07:21:56','2022-05-02'),(4,9,5,NULL,'2022-05-19 08:27:51','2022-05-19'),(20,6,9,'2022-04-20 09:38:36','2022-05-02 07:17:33','2022-05-02'),(22,6,9,'2022-05-02 07:17:33','2022-05-02 07:19:10','2022-05-02'),(23,6,8,'2022-05-02 07:17:33','2022-05-02 07:19:10','2022-05-02'),(24,6,9,'2022-05-02 07:19:10','2022-05-02 07:21:29','2022-05-02'),(25,6,8,'2022-05-02 07:19:10','2022-05-02 07:21:29','2022-05-02'),(26,6,9,'2022-05-02 07:21:29','2022-05-02 07:22:28','2022-05-02'),(27,6,8,'2022-05-02 07:21:29','2022-05-02 07:22:28','2022-05-02'),(28,7,9,'2022-05-02 07:21:56','2022-05-20 06:24:57','2022-05-20'),(29,7,8,'2022-05-02 07:21:56','2022-05-20 06:24:57','2022-05-20'),(30,6,9,'2022-05-02 07:22:28','2022-05-02 09:25:51','2022-05-02'),(31,6,8,'2022-05-02 07:22:28','2022-05-02 09:25:51','2022-05-02'),(32,6,9,'2022-05-02 09:25:51','2022-05-02 18:33:19','2022-05-02'),(33,6,8,'2022-05-02 09:25:51','2022-05-02 18:33:19','2022-05-02'),(34,6,9,'2022-05-02 18:33:19','2022-05-02 18:33:27','2022-05-02'),(35,6,8,'2022-05-02 18:33:19','2022-05-02 18:33:27','2022-05-02'),(36,6,9,'2022-05-02 18:33:27','2022-05-03 04:56:49','2022-05-03'),(37,6,8,'2022-05-02 18:33:27','2022-05-03 04:56:49','2022-05-03'),(38,6,9,'2022-05-03 04:56:49','2022-05-19 07:44:19','2022-05-19'),(39,6,8,'2022-05-03 04:56:49','2022-05-19 07:44:19','2022-05-19'),(40,30,9,'2022-05-05 06:44:23','2022-05-05 06:46:28','2022-05-05'),(41,30,8,'2022-05-05 06:44:23','2022-05-05 06:46:28','2022-05-05'),(42,30,9,'2022-05-05 06:46:28','2022-05-05 06:46:28',NULL),(43,30,8,'2022-05-05 06:46:28','2022-05-05 06:46:28',NULL),(44,6,9,'2022-05-19 07:44:19','2022-05-19 07:44:19',NULL),(45,6,8,'2022-05-19 07:44:19','2022-05-19 07:44:19',NULL),(46,9,9,'2022-05-19 08:27:51','2022-05-19 08:57:08','2022-05-19'),(47,9,8,'2022-05-19 08:27:51','2022-05-19 08:57:08','2022-05-19'),(48,9,9,'2022-05-19 08:57:08','2022-05-19 09:13:06','2022-05-19'),(49,9,8,'2022-05-19 08:57:08','2022-05-19 09:13:06','2022-05-19'),(50,9,9,'2022-05-19 09:13:06','2022-05-19 09:19:28','2022-05-19'),(51,9,9,'2022-05-19 09:19:28','2022-05-19 09:26:28','2022-05-19'),(52,9,9,'2022-05-19 09:26:28','2022-05-19 09:34:06','2022-05-19'),(53,9,9,'2022-05-19 09:34:06','2022-05-19 09:34:06',NULL);

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `qualification_id` int(11) NOT NULL,
  `college_name` varchar(255) DEFAULT NULL,
  `tenth_passed_year` int(11) NOT NULL,
  `tenth_percentage` int(11) NOT NULL,
  `twelfth_passed_year` int(11) NOT NULL,
  `twelfth_percentage` int(11) NOT NULL,
  `cpt_number_of_attempts` int(11) NOT NULL,
  `ipcc_number_of_attempts` int(11) NOT NULL,
  `cpt_percentage` varchar(255) DEFAULT NULL,
  `cpt_passed_year` int(11) DEFAULT NULL,
  `ipcc_percentage` varchar(255) DEFAULT NULL,
  `ipcc_passed_year` int(11) DEFAULT NULL,
  `itt_orientation_status` int(11) NOT NULL DEFAULT '0' COMMENT '0-incompleted,1-completed',
  `degree` varchar(255) DEFAULT NULL,
  `other_professional_course` varchar(255) DEFAULT NULL,
  `achievements` text,
  `awards` text,
  `career_objectives` text,
  `extra_curicular_activities` text,
  `skills` text,
  `other_professional_achievements` text,
  `resume` text,
  `selection_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0-not_appointed,1-appointed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` VALUES (1,6,4,'Viswajyoythi college',2006,93,2008,94,2,4,'70',2021,'80',2022,0,'BCOM','BTECH','CCV BBB','STATE AWARD','BEING A SOELF MOTIVATEF person','sc fd','php,codeignuteer,Laravel','cxxgbf fhfth fhg vhtg fhg','ds',1,'2022-02-22 18:30:00','2022-05-02 03:55:51',NULL),(3,5,2,'vjcer',2006,90,2008,90,2,2,NULL,NULL,NULL,NULL,0,'bcom','MBA','dfdgb','dfbdf','fdbd','fdbfgxh','cfbhfg','fbgfh','fds',0,'2022-02-22 18:30:00','2020-04-11 00:31:29',NULL),(4,9,1,'vjcer',2006,93,2008,94,2,4,'70',2021,'80',2022,1,'BCOM','BTECH','CCV BBB','dfbdf','BEING A SOELF MOTIVATEF person','sc fd','php,codeignuteer','cxxgbf fhfth fhg vhtg fhg','/documents/142928troubleshoot.pdf',0,'2022-02-22 18:30:00','2022-05-19 14:29:28',NULL),(5,7,4,'vjcer',2006,93,2008,94,2,4,'70',2021,'80',2022,0,'BCOM','BTECH','CCV BBB','dfbdf','BEING A SOELF MOTIVATEF person','sc fd','php,codeignuteer,Laravel','cxxgbf fhfth fhg vhtg fhg','public/documents/6KCgUi8rBMvOGS1cf6Sj5HKQtjC6tDwGFOZmlhXq.pdf',0,'2022-02-22 18:30:00','2022-05-20 06:24:57','2022-05-20'),(7,12,4,NULL,2006,93,2008,94,2,4,'70',2021,'80',2022,0,'BCOM','BTECH','CCV BBB',NULL,'BEING A SOELF MOTIVATEF person','sc fd','php,codeignuteer,Laravel','cxxgbf fhfth fhg vhtg fhg',NULL,0,'2022-05-02 04:10:06','2022-05-02 04:10:06',NULL),(10,13,4,NULL,2006,93,2008,94,2,4,'70',2021,'80',2022,0,'BCOM','BTECH','CCV BBB',NULL,'BEING A SOELF MOTIVATEF person','sc fd','php,codeignuteer,Laravel','cxxgbf fhfth fhg vhtg fhg',NULL,0,'2022-05-02 05:23:49','2022-05-02 05:23:49',NULL),(11,30,4,NULL,2006,93,2008,94,2,4,'70',2021,'80',2022,0,'BCOM','BTECH','CCV BBB',NULL,'BEING A SOELF MOTIVATEF person','sc fd','php,codeignuteer,Laravel','cxxgbf fhfth fhg vhtg fhg','public/documents/owwclf3G4dfVip5LcEXtBMnyNv4BE83UDb3lY8dX.doc',0,'2022-05-04 23:30:52','2022-05-05 00:49:15',NULL);

--
-- Table structure for table `user_exam_answers`
--

CREATE TABLE `user_exam_answers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `question_id` int(11) DEFAULT NULL,
  `answer_option` int(11) DEFAULT NULL,
  `score` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_exam_answers`
--

INSERT INTO `user_exam_answers` VALUES (10,6,6,3,0,'2022-05-02 12:37:17','2022-05-02 12:37:17',NULL),(9,6,7,1,10,'2022-05-02 12:37:17','2022-05-02 12:37:17',NULL),(12,30,6,3,0,'2022-05-05 00:59:16','2022-05-05 00:59:16',NULL),(11,30,7,1,10,'2022-05-05 00:59:16','2022-05-05 00:59:16',NULL);

--
-- Table structure for table `user_exam_details`
--

CREATE TABLE `user_exam_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `total_score` int(11) DEFAULT NULL,
  `exam_attended_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '	0-pending,1-attended test	',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_exam_details`
--

INSERT INTO `user_exam_details` VALUES (8,30,10,1,'2022-05-05 00:59:16','2022-05-05 00:59:16',NULL),(7,6,10,1,'2022-05-02 12:37:17','2022-05-02 12:37:17',NULL);

--
-- Table structure for table `user_work_experiences`
--

CREATE TABLE `user_work_experiences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `firm_name` varchar(255) NOT NULL,
  `no_of_years` int(11) NOT NULL,
  `area` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_work_experiences`
--

INSERT INTO `user_work_experiences` VALUES (1,5,'ameaka',2,'web developer','2019-08-13 05:01:33','2020-04-11 06:01:29',NULL),(2,5,'vox',1,'web developer','2019-08-13 05:01:33','2020-04-11 06:01:29',NULL),(8,6,'Amala Stores',3,'watch repairer','2022-04-20 09:38:36','2022-05-02 07:17:33','2022-05-02'),(7,6,'Avani',4,'accountant','2022-04-20 09:38:36','2022-05-02 07:17:33','2022-05-02'),(9,6,'Avani',4,'accountant','2022-05-02 07:17:33','2022-05-02 07:19:10','2022-05-02'),(10,6,'Amala Stores',3,'watch repairer','2022-05-02 07:17:33','2022-05-02 07:19:10','2022-05-02'),(11,6,'Avani',4,'accountant','2022-05-02 07:19:10','2022-05-02 07:21:29','2022-05-02'),(12,6,'Amala Stores',3,'watch repairer','2022-05-02 07:19:10','2022-05-02 07:21:29','2022-05-02'),(13,6,'Avani',4,'accountant','2022-05-02 07:21:29','2022-05-02 07:22:28','2022-05-02'),(14,6,'Amala Stores',3,'watch repairer','2022-05-02 07:21:29','2022-05-02 07:22:28','2022-05-02'),(15,7,'Avani',4,'accountant','2022-05-02 07:21:56','2022-05-20 06:24:57','2022-05-20'),(16,7,'Amala Stores',3,'watch repairer','2022-05-02 07:21:56','2022-05-20 06:24:57','2022-05-20'),(17,6,'Avani',4,'accountant','2022-05-02 07:22:28','2022-05-02 09:25:51','2022-05-02'),(18,6,'Amala Stores',3,'watch repairer','2022-05-02 07:22:28','2022-05-02 09:25:51','2022-05-02'),(19,6,'Avani',4,'accountant','2022-05-02 09:25:51','2022-05-02 18:33:19','2022-05-02'),(20,6,'Amala Stores',3,'watch repairer','2022-05-02 09:25:51','2022-05-02 18:33:19','2022-05-02'),(21,7,'Avani',4,'accountant','2022-05-02 09:38:45','2022-05-20 06:24:57','2022-05-20'),(22,7,'Amala Stores',3,'watch repairer','2022-05-02 09:38:45','2022-05-20 06:24:57','2022-05-20'),(23,12,'Avani',4,'accountant','2022-05-02 09:40:06','2022-05-02 09:40:06',NULL),(24,12,'Amala Stores',3,'watch repairer','2022-05-02 09:40:06','2022-05-02 09:40:06',NULL),(25,12,'Avani',4,'accountant','2022-05-02 09:40:43','2022-05-02 09:40:43',NULL),(26,12,'Amala Stores',3,'watch repairer','2022-05-02 09:40:43','2022-05-02 09:40:43',NULL),(27,12,'Avani',4,'accountant','2022-05-02 09:45:40','2022-05-02 09:45:40',NULL),(28,12,'Amala Stores',3,'watch repairer','2022-05-02 09:45:40','2022-05-02 09:45:40',NULL),(29,13,'Avani',4,'accountant','2022-05-02 09:46:00','2022-05-02 09:55:19','2022-05-02'),(30,13,'Amala Stores',3,'watch repairer','2022-05-02 09:46:00','2022-05-02 09:55:19','2022-05-02'),(31,13,'Avani',4,'accountant','2022-05-02 09:55:19','2022-05-02 09:56:26','2022-05-02'),(32,13,'Amala Stores',3,'watch repairer','2022-05-02 09:55:19','2022-05-02 09:56:26','2022-05-02'),(33,13,'Avani',4,'accountant','2022-05-02 09:56:26','2022-05-02 09:57:16','2022-05-02'),(34,13,'Amala Stores',3,'watch repairer','2022-05-02 09:56:26','2022-05-02 09:57:16','2022-05-02'),(35,13,'Avani',4,'accountant','2022-05-02 09:58:19','2022-05-02 10:53:49','2022-05-02'),(36,13,'Amala Stores',3,'watch repairer','2022-05-02 09:58:19','2022-05-02 10:53:49','2022-05-02'),(37,13,'Avani',4,'accountant','2022-05-02 10:53:49','2022-05-02 10:59:51','2022-05-02'),(38,13,'Amala Stores',3,'watch repairer','2022-05-02 10:53:49','2022-05-02 10:59:51','2022-05-02'),(39,13,'Avani',4,'accountant','2022-05-02 10:59:51','2022-05-04 10:52:26','2022-05-04'),(40,13,'Amala Stores',3,'watch repairer','2022-05-02 10:59:51','2022-05-04 10:52:26','2022-05-04'),(41,6,'Avani',4,'accountant','2022-05-02 18:33:19','2022-05-02 18:33:27','2022-05-02'),(42,6,'Amala Stores',3,'watch repairer','2022-05-02 18:33:19','2022-05-02 18:33:27','2022-05-02'),(43,6,'Avani',4,'accountant','2022-05-02 18:33:27','2022-05-03 04:56:49','2022-05-03'),(44,6,'Amala Stores',3,'watch repairer','2022-05-02 18:33:27','2022-05-03 04:56:49','2022-05-03'),(45,6,'Avani',4,'accountant','2022-05-03 04:56:49','2022-05-19 07:44:19','2022-05-19'),(46,6,'Amala Stores',3,'watch repairer','2022-05-03 04:56:49','2022-05-19 07:44:19','2022-05-19'),(47,13,'Avani',4,'accountant','2022-05-04 10:52:26','2022-05-04 10:52:26',NULL),(48,13,'Amala Stores',3,'watch repairer','2022-05-04 10:52:26','2022-05-04 10:52:26',NULL),(49,30,'Avani',4,'accountant','2022-05-05 05:00:52','2022-05-05 05:01:27','2022-05-05'),(50,30,'Amala Stores',3,'watch repairer','2022-05-05 05:00:52','2022-05-05 05:01:27','2022-05-05'),(51,30,'Avani',4,'accountant','2022-05-05 05:01:27','2022-05-05 05:01:48','2022-05-05'),(52,30,'Amala Stores',3,'watch repairer','2022-05-05 05:01:27','2022-05-05 05:01:48','2022-05-05'),(53,30,'Avani',4,'accountant','2022-05-05 05:01:48','2022-05-05 05:54:37','2022-05-05'),(54,30,'Amala Stores',3,'watch repairer','2022-05-05 05:01:48','2022-05-05 05:54:37','2022-05-05'),(55,30,'Avani',4,'accountant','2022-05-05 05:54:37','2022-05-05 06:44:23','2022-05-05'),(56,30,'Amala Stores',3,'watch repairer','2022-05-05 05:54:37','2022-05-05 06:44:23','2022-05-05'),(57,30,'Avani',4,'accountant','2022-05-05 06:44:23','2022-05-05 06:46:28','2022-05-05'),(58,30,'Amala Stores',3,'watch repairer','2022-05-05 06:44:23','2022-05-05 06:46:28','2022-05-05'),(59,30,'Avani',4,'accountant','2022-05-05 06:46:28','2022-05-05 06:46:28',NULL),(60,30,'Amala Stores',3,'watch repairer','2022-05-05 06:46:28','2022-05-05 06:46:28',NULL),(61,6,'Avani',4,'accountant','2022-05-19 07:44:19','2022-05-19 07:44:19',NULL),(62,6,'Amala Stores',3,'watch repairer','2022-05-19 07:44:19','2022-05-19 07:44:19',NULL),(63,9,'Avani',4,'accountant','2022-05-19 08:27:51','2022-05-19 08:57:08','2022-05-19'),(64,9,'Amala Stores',3,'watch repairer','2022-05-19 08:27:51','2022-05-19 08:57:08','2022-05-19'),(65,9,'Avani',4,'accountant','2022-05-19 08:57:08','2022-05-19 08:57:08',NULL),(66,9,'Amala Stores',3,'watch repairer','2022-05-19 08:57:08','2022-05-19 08:57:08',NULL);
/*!50112 PREPARE s FROM @disable_bulk_load */;
/*!50112 EXECUTE s */;
/*!50112 DEALLOCATE PREPARE s */;


