--
-- 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_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` VALUES ('ac3dbf41a0011f572b0708de70890554b775f825b42defe5914d7f9a304279acb8473167c71e562b',30,3,'Personal Access Token','[]',0,'2022-05-04 23:31:18','2022-05-04 23:31:18','2023-05-05 05:01:18'),('e0546ca098e05668699ab5e50c5edf5d204fb63303d3a6c3668da52c6e2b2eaa94cb74823cda2628',29,3,'Personal Access Token','[]',0,'2022-05-03 23:45:13','2022-05-03 23:45:13','2023-05-04 05:15:13'),('e01a7eca35253c32b610fc6b0913da93b841d33d15d347eb65649d52318180c0ff2890198c5cbb26',29,3,'Personal Access Token','[]',0,'2022-05-03 12:22:21','2022-05-03 12:22:21','2023-05-03 17:52:21'),('242b79676939f925c55cd007ffa67669cab8c096f9d80e65ee4566d941517da09e106076bb9400a3',29,3,'Personal Access Token','[]',0,'2022-05-03 13:34:28','2022-05-03 13:34:28','2023-05-03 19:04:28'),('d350b3c8c668da49198ea2d60f3c3d6a7b78be6ad3b8088dd654a604dda3e10fc9e3f1f33e294f69',29,3,'Personal Access Token','[]',0,'2022-05-03 13:34:43','2022-05-03 13:34:43','2023-05-03 19:04:43'),('45160ae6334568e684b43bfd1064c55ad5885a54a781273d7e20cda3c6206617d943a7e0f9a2450a',29,3,'Personal Access Token','[]',0,'2022-05-03 06:45:22','2022-05-03 06:45:22','2023-05-03 12:15:22'),('77e500169918d721a0ca95b08d300b343b56347afaf411e261e2ae5b2e1ff0154bc5a3e5fb14c770',3,3,'Personal Access Token','[]',0,'2022-05-03 03:35:58','2022-05-03 03:35:58','2023-05-03 09:05:58'),('ebac2ebf35770cc1fd5c7f9e45857b8372ade1ff6778b833f06e8b79892550f3a4c53574e1e66642',29,3,'Personal Access Token','[]',0,'2022-05-03 04:50:15','2022-05-03 04:50:15','2023-05-03 10:20:15'),('e153fad3fcdca0b23baa9a0de9d3cdc65539a1aeaf9ca8ed799a116905f7e4a33e0bfe119491b69d',29,3,'Personal Access Token','[]',0,'2022-05-03 04:57:57','2022-05-03 04:57:57','2023-05-03 10:27:57'),('cd883de89451b46a9f1cf5fa52fe002bc127cb6106fe495dec08b1077b4b9f5d9e7c834c2580e5bf',29,3,'Personal Access Token','[]',0,'2022-05-03 05:01:25','2022-05-03 05:01:25','2023-05-03 10:31:25'),('dd1a651b03169621f75e5d72fbc6cfc5dc8c682a7597390da56d58bac27058d02ba32274dc7b3974',29,3,'Personal Access Token','[]',0,'2022-05-03 05:02:40','2022-05-03 05:02:40','2023-05-03 10:32:40'),('984f7c45c4560bc62a9ebe03483c9e6a70024e5be4559ea083399420938bc3d98cf8dc967f4ada67',29,3,'Personal Access Token','[]',0,'2022-05-03 05:03:33','2022-05-03 05:03:33','2023-05-03 10:33:33'),('6c1e94898a4d2c1e7576bf3afadfdf3d90e41c703f2bef3e7cbc4dbcf02f6e5cad5bfd6a8d90fe70',29,3,'Personal Access Token','[]',0,'2022-05-03 05:06:20','2022-05-03 05:06:20','2023-05-03 10:36:20'),('7dafe4cf54c0faeb4ecd7a7fdb52da4eb6f43ca73ed35b5f4fdc10f90a8276ae07e4ed2be1a65528',29,3,'Personal Access Token','[]',0,'2022-05-03 05:13:30','2022-05-03 05:13:30','2023-05-03 10:43:30'),('1c1e297385af99a84ed0cb692ce358bb6b51f2fd5382c9b8688ea6926dbdb84463beca8f178b2c3e',29,3,'Personal Access Token','[]',0,'2022-05-03 05:22:35','2022-05-03 05:22:35','2023-05-03 10:52:35'),('9c8e78a8603e44a44c299634b7483378f2b6081689e6dca67f4c9c186836d448516c1d4cb662d2e4',29,3,'Personal Access Token','[]',0,'2022-05-03 05:23:25','2022-05-03 05:23:25','2023-05-03 10:53:25'),('8a584ded5742c34879a6c1638c87ea2fe43f5c62b3dd0f2f625b2fe91118c5974c59c40c10e5e19b',29,3,'Personal Access Token','[]',0,'2022-05-03 06:44:44','2022-05-03 06:44:44','2023-05-03 12:14:44'),('7e8e84f39fd80e1363a0b1e559000207948406621845948d85c55a3d5f43360b17211734e52b2b90',6,3,'Personal Access Token','[]',0,'2022-05-04 23:30:13','2022-05-04 23:30:13','2023-05-05 05:00:13'),('0b0da4170b562e20ae694c9143c74d3f18debb49f704cee4dee75596d0fcaa21a666f5e486d73a15',1,3,'Personal Access Token','[]',0,'2022-05-20 07:27:04','2022-05-20 07:27:04','2023-05-20 07:27:04');

--
-- 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_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` VALUES (1,NULL,'Laravel Personal Access Client','EoaBbobTvPJnPFFhJw6NQLXY1Nx3sHckyMOzWPaE',NULL,'http://localhost',1,0,0,'2022-02-14 06:13:25','2022-02-14 06:13:25'),(2,NULL,'Laravel Password Grant Client','sUJbUoeSOLUAjebishG9jOEY4X1E4kZEh30COE55','users','http://localhost',0,1,0,'2022-02-14 06:13:25','2022-02-14 06:13:25'),(3,NULL,'Laravel Personal Access Client','CaLzWXYDitYZmrP33uvjbSQXaJoZ68JbYkAxgk9J',NULL,'http://localhost',1,0,0,'2022-02-15 01:24:32','2022-02-15 01:24:32'),(4,NULL,'Laravel Password Grant Client','vRs7IMPP1VPXcZY131E4sZruGM6iBWHVkMdujI0O','users','http://localhost',0,1,0,'2022-02-15 01:24:32','2022-02-15 01:24:32');

--
-- 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 `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` VALUES ('jeeva@gmail.com','4aXMuKiyJs','2022-05-04 02:08:28','2022-05-04'),('jeeva@gmail.com','9ZCJT0h3Hb','2022-05-04 02:11:42','2022-05-04'),('jeeva@gmail.com','HH7O1liAno','2022-05-04 02:12:10','2022-05-04'),('jeeva@gmail.com','erqdgqyy1d','2022-05-04 02:12:58','2022-05-04'),('jeeva@gmail.com','aIe1Z5rNVW','2022-05-04 02:13:00','2022-05-04'),('swapna.brammait@gmail.com','PR3mdziNyv','2022-05-04 02:13:43','2022-05-04'),('swapna.brammait@gmail.com','ZPYLRBV8UX','2022-05-04 02:14:26','2022-05-04');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--

INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\User',1,'Personal Access Token','5b4a350a6cf60dfaa1b00c388a87130131a60404ad93b92cb2158c8c34496278','[\"*\"]',NULL,'2022-02-15 00:09:31','2022-02-15 00:09:31'),(2,'App\\Models\\User',1,'Personal Access Token','986fa6e28deb4e8733a9b8a67f34389c6a7b6d385bae12c06241e19505de9ef9','[\"*\"]',NULL,'2022-02-15 00:16:14','2022-02-15 00:16:14'),(3,'App\\Models\\User',1,'Personal Access Token','d4ac4904dda89d55f4ae2ee640473d98f7b98a35aef01449c49f197127d13064','[\"*\"]',NULL,'2022-02-15 00:16:16','2022-02-15 00:16:16'),(4,'App\\Models\\User',1,'Personal Access Token','99c2e11ebc299b7b4d55e42467b3970586236c8228510547386b36e71a12bdff','[\"*\"]',NULL,'2022-02-15 00:16:17','2022-02-15 00:16:17'),(5,'App\\Models\\User',1,'Personal Access Token','8d00b81d78323cdcc177ad81da3e56ef91d655649ec82b5ecbffa58d493e517c','[\"*\"]',NULL,'2022-02-15 00:18:09','2022-02-15 00:18:09'),(6,'App\\Models\\User',1,'Personal Access Token','45642bb826e65957ca826a4f02fabe79828d830f6cd436ea0d1fe5dbd4805ca3','[\"*\"]',NULL,'2022-02-15 00:18:10','2022-02-15 00:18:10'),(7,'App\\Models\\User',1,'Personal Access Token','0104e3d5e2e4d79036d83ca90b920c79e686042c6676f8829d29c8e638ca6987','[\"*\"]',NULL,'2022-02-15 00:19:16','2022-02-15 00:19:16'),(8,'App\\Models\\User',1,'Personal Access Token','fc5731573142bf4896df0e3608dcfea57b37f023e4fc7ad5ab66820d111a89b8','[\"*\"]',NULL,'2022-02-15 00:25:39','2022-02-15 00:25:39'),(9,'App\\Models\\User',1,'Personal Access Token','e51ccdc39892d3c012d997f498cfdf6e20ce7f1f91952f6d23114383c915ea86','[\"*\"]',NULL,'2022-02-15 00:31:03','2022-02-15 00:31:03'),(10,'App\\Models\\User',1,'Personal Access Token','9770adabc1375cdb9fce284a6a8328329bcc0c66d0eb87441eaea6500227752d','[\"*\"]',NULL,'2022-02-15 00:31:04','2022-02-15 00:31:04'),(11,'App\\Models\\User',2,'Personal Access Token','ca01ca8885eb75470d264b338bfbf9bf07efd7e35e6f2b61208b34456dc6f1d1','[\"*\"]',NULL,'2022-02-15 00:41:33','2022-02-15 00:41:33'),(12,'App\\Models\\User',2,'Personal Access Token','6e65540bef17a54e5fb89519a9dd14e121c497f6b5358e2513765050d5032c5a','[\"*\"]',NULL,'2022-02-15 00:41:43','2022-02-15 00:41:43'),(13,'App\\Models\\User',1,'Personal Access Token','b265872be0864f583364c159033ce11f8057cd70d95e8fcde5a1511c7bbd2d08','[\"*\"]',NULL,'2022-02-15 00:44:00','2022-02-15 00:44:00'),(14,'App\\Models\\User',1,'Personal Access Token','171a8c4c89cc9e27975609b6c36e1afcf968627b37220061129eaa3f492393cb','[\"*\"]',NULL,'2022-02-15 00:46:17','2022-02-15 00:46:17'),(15,'App\\Models\\User',1,'Personal Access Token','3ec996059b6ba1daf6e15169ae7ad49a20fbb4c72cd8318fa3d49445c6caaa70','[\"*\"]',NULL,'2022-02-15 00:46:18','2022-02-15 00:46:18'),(16,'App\\Models\\User',1,'Personal Access Token','81595165ab5c8579573fa3e30f2716b132e41de3976400be97f5b40199f136e2','[\"*\"]',NULL,'2022-02-15 00:46:19','2022-02-15 00:46:19'),(17,'App\\Models\\User',1,'Personal Access Token','45cc018e79fd4225b1f3d788eb2472e3970aa3d905495970ce279348d5d337b9','[\"*\"]',NULL,'2022-02-15 00:47:25','2022-02-15 00:47:25'),(18,'App\\Models\\User',1,'Personal Access Token','154ab85926354a180a6392d80e12ea61d2984d656522c425570e4cedacf563ed','[\"*\"]',NULL,'2022-02-15 00:47:26','2022-02-15 00:47:26'),(19,'App\\Models\\User',1,'Personal Access Token','4b17c5df578f7ce71924606add88060a6222c4bd3dbc7d8222ad990d71536411','[\"*\"]',NULL,'2022-02-15 00:49:48','2022-02-15 00:49:48'),(20,'App\\Models\\User',1,'Personal Access Token','9dcc3f629e0efffe26dd0d7b5ce0fc82adbe190a6e31fb1118814f15277a9867','[\"*\"]',NULL,'2022-02-15 00:53:55','2022-02-15 00:53:55'),(21,'App\\Models\\User',1,'Personal Access Token','7cee2b80f755442b09304b33968f583acc752e691eaacbd7c3e3d70d917fd9e6','[\"*\"]',NULL,'2022-02-15 01:01:36','2022-02-15 01:01:36'),(22,'App\\Models\\User',1,'Personal Access Token','84aacc02b0c41f1da3191219855bd2de31c64f75822940d97948034d856af97b','[\"*\"]',NULL,'2022-02-15 01:09:25','2022-02-15 01:09:25'),(23,'App\\Models\\User',1,'Personal Access Token','0be0fae0a60f309c23d69be1df3355a8f7415200052c322f0242b5720d139a90','[\"*\"]',NULL,'2022-02-15 01:13:10','2022-02-15 01:13:10'),(24,'App\\Models\\User',1,'Personal Access Token','b30200b2567d9087d04696c0c1e9d8d37f5cbc621075c5630342a32dac5f50c8','[\"*\"]',NULL,'2022-02-15 01:15:58','2022-02-15 01:15:58'),(25,'App\\Models\\User',1,'Personal Access Token','7e548029a5a39f84c134019856d85d86f31b8534a9174cc9596e96e160e37681','[\"*\"]',NULL,'2022-02-15 01:18:51','2022-02-15 01:18:51'),(26,'App\\Models\\User',1,'Personal Access Token','be74be14978a2ede2471cfaf869765cd600688563d1db3b36328c12e61989c9b','[\"*\"]',NULL,'2022-02-15 01:18:53','2022-02-15 01:18:53'),(27,'App\\Models\\User',1,'Personal Access Token','7bf99d9ce729c7a450b49ae6a1a96ce8a0844e8b08c5f7e7525919df6577b222','[\"*\"]',NULL,'2022-02-15 01:18:56','2022-02-15 01:18:56'),(28,'App\\Models\\User',1,'Personal Access Token','316b5f0e0561fd58d1a3b6eac4d28d975285816b6fd16f41bf542960015709b8','[\"*\"]',NULL,'2022-02-15 01:19:55','2022-02-15 01:19:55'),(29,'App\\Models\\User',1,'Personal Access Token','6adf99e939b654cd618e000753b7f42600c0e8fdbbfde24692accdffd6a729ca','[\"*\"]',NULL,'2022-02-15 01:19:56','2022-02-15 01:19:56'),(30,'App\\Models\\User',1,'Personal Access Token','14d6de7af2e3fe58f38673f3c522f7a13d2f6ae563ea7266080ab5c97ba1dd97','[\"*\"]',NULL,'2022-02-15 01:19:57','2022-02-15 01:19:57'),(31,'App\\Models\\User',1,'Personal Access Token','276a6e288e21ec9d2ce2c40a162482c3ff4b48832666c3d1bd224313f1775761','[\"*\"]',NULL,'2022-02-15 01:20:13','2022-02-15 01:20:13');

--
-- 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_otps`
--

CREATE TABLE `user_otps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `otp` bigint(20) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_otps`
--

INSERT INTO `user_otps` VALUES (12,30,1885,'2022-05-04','2022-05-04',NULL),(9,26,3729,'2022-05-04','2022-05-04',NULL),(7,29,2090,'2022-05-03','2022-05-03',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);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_id` int(11) NOT NULL COMMENT 'Admin-1,Student-2,Employee-3,Firm-4',
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sro_number` varchar(125) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `location_zone` int(11) DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` int(11) DEFAULT NULL COMMENT '0-male,1-female,2-others',
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0-Registered,1-Completed,2-Attended Exam,4-Password Set,5-Mobile Verified',
  `website_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefered_location_to_work` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (3,'Jeevodhaya Milk',4,'swapna.brammait@gmail.com',NULL,'$2y$10$amMkuGy2FgxCWU.sNyWSruOr75eOGYrXhprQQ1brVQLEQdecSgSsC','',NULL,3,'sfds vbcb',0,'2344546345',0,'ww.nhh.bmn',NULL,'ZPYLRBV8UX','2022-02-15 01:31:06','2022-05-04 03:42:42',NULL),(1,'admin',1,'admin@gmail.com',NULL,'$2y$10$Psy1SlDl5un/sTBl3VrSUujQsVeZ6OVr7k/NGa7yazdvOHzi8oS3O','0',NULL,1,'xxxxx',1,'8157678978',0,'',NULL,NULL,'2022-02-15 00:40:36','2022-05-03 13:27:10',NULL),(5,'swapna',3,'swapn1a@gmail.com',NULL,'$2y$10$mufOsTwSBg.oI/zPnEMGIOKdnh.N6hQERNQ1SAYWWW7aDCIN4e/dq','0',NULL,1,'',0,'8157378978',0,NULL,'1',NULL,'2022-02-15 02:50:54','2022-02-15 02:50:54',NULL),(6,'sneha',2,'sneha@gmail.com',NULL,'$2y$10$s4QWaQ8X2gc6b60nr/bZXeRk2R7I/3PpFXejHTKKTa4NbDR7IeVzO','2222','2012-01-18',2,'sdee',2,'6667786754',0,NULL,'1',NULL,'2022-02-15 04:11:27','2022-05-19 02:14:19',NULL),(7,'sneha',2,'snehsa@gmail.com',NULL,'$2y$10$eT9AgRh90pw19fW6teKdAuLdVgDTAl1LBcD7v3gtiiRmbplfQTgdC','2222','2012-01-18',3,'sdee',2,'6667786754',1,NULL,'2',NULL,'2022-02-08 04:11:41','2022-05-20 06:24:57','2022-05-20'),(8,'arunima',4,'arunima@gmail.com',NULL,'$2y$10$s4QWaQ8X2gc6b60nr/bZXeRk2R7I/3PpFXejHTKKTa4NbDR7IeVzO','0',NULL,1,'xxxxx',0,'9157838644',0,'',NULL,NULL,'2022-02-15 01:31:06','2022-02-15 01:31:06',NULL),(9,'sneha1',2,'snecha@gmail.com',NULL,'$2y$10$s4QWaQ8X2gc6b60nr/bZXeRk2R7I/3PpFXejHTKKTa4NbDR7IeVzO','22221','2022-05-07',2,'sdee',1,'6667786751',0,'','3',NULL,'2022-02-15 00:40:36','2022-05-19 09:34:06',NULL),(12,'Jeevdgdodhaya Milkdd',4,'jeevdgfda@gmail.com',NULL,'$2y$10$mPGziJhaXif00OIQJCPn2OXIT1BbvFDlqS.GAY/.zQrogH/Bxbiau','0',NULL,2,'hhjkj',NULL,'8344546345',0,'www.xcx.m',NULL,NULL,'2022-02-24 04:34:38','2022-05-02 05:54:50',NULL),(29,'Jeevodhaya Milk',4,'jeevca@gmail.com',NULL,'$2y$10$5o4Mj3ipj6SrcmGTTahBzOXsz3GCFX563aAdgav7FiiPhIxzBdsdS',NULL,NULL,3,'sfds vbcb',NULL,'2344546345',0,'ww.nhh.bmn',NULL,NULL,'2022-05-03 03:21:33','2022-05-03 05:53:00',NULL),(30,'achus',2,'swapna@gmail.com',NULL,'$2y$10$B9TTF7OHRfU3oo/ueyp2v.YNf/2WMn5Iqx0QYVmk47GBQeJ97Zley','2222','2012-01-18',NULL,'sdee',2,'6667786754',0,NULL,'3',NULL,'2022-05-04 04:58:38','2022-05-05 01:14:23',NULL);
/*!50112 PREPARE s FROM @disable_bulk_load */;
/*!50112 EXECUTE s */;
/*!50112 DEALLOCATE PREPARE s */;


