-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `idealtra_interview`
--

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

--
-- Table structure for table `employers`
--

CREATE TABLE `employers` (
  `id` bigint(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `website` varchar(255) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `company_video` varchar(255) DEFAULT NULL,
  `embedded_url` varchar(255) DEFAULT NULL,
  `address` varchar(500) NOT NULL,
  `country_id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `city` varchar(100) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `company_logo` varchar(200) DEFAULT NULL,
  `package_id` int(20) NOT NULL,
  `payment_status` enum('1','2','3','4') DEFAULT NULL COMMENT '1=>Approved, 2=>Pending, 3=>Expired, 4=>Rejected',
  `phone_no` varchar(20) NOT NULL,
  `alter_phone` varchar(20) DEFAULT NULL,
  `email_verified` timestamp NULL DEFAULT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '0' COMMENT '1=>Active, 0=>Inactive',
  `pass_resetlink` enum('0','1') DEFAULT '0',
  `last_login` datetime DEFAULT NULL,
  `master_empid` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expire_date` datetime DEFAULT NULL,
  `idealvideo_key` varchar(600) DEFAULT NULL,
  `purchased_idealapp` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employers`
--

INSERT INTO `employers` (`id`, `email`, `password`, `first_name`, `last_name`, `website`, `company_name`, `company_video`, `embedded_url`, `address`, `country_id`, `state_id`, `city`, `zip`, `company_logo`, `package_id`, `payment_status`, `phone_no`, `alter_phone`, `email_verified`, `status`, `pass_resetlink`, `last_login`, `master_empid`, `created_at`, `updated_at`, `expire_date`, `idealvideo_key`, `purchased_idealapp`) VALUES
(1, 'saravana@idealtraits.com', '$2y$10$kyMuJU/A7VZtDrqprTk18O9I6RoyBSOzJiXB01Gbg2.bUoArCnZIu', 'Saravana', 'Elumalai', 'http://www.ramkumar.com', 'Ramkumar info', '202301020716481.mp4', NULL, '4202 Hazelwood Avenue', 254, 139, 'Phyllis', '41554', '16639393071.png', 1, '1', '(515) 327-6550', '', NULL, '1', '1', '2022-05-03 20:12:25', NULL, '2022-05-03 13:13:41', '2023-01-02 13:47:58', '2022-08-01 00:00:00', 'Cly0vErvupCggIaWL5DHG7ZFiQI2AA', '1'),
(37, 'jeremy1@idealtraits.com', '$2y$10$GrXpirShGwzOjQyWz2qZUekXU9NC9OV2WaHDoUoCZ9mHf9V5Ogkee', 'Jeremy', 'Mlynarek', 'https://idealtraits.com', 'Mlynarek Agencies', NULL, '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/xx53A4uzC04\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>', '232 S Broadway', 254, 144, 'Lake Orion', '48362', '', 1, '1', '(810) 444-4444', '', NULL, '1', '0', NULL, NULL, '2022-07-12 15:05:00', '2023-01-24 13:42:31', '2022-10-10 00:00:00', '6hmevdL0wyumyWhbC6i3ufmNx0yz0v', '1'),
(38, 'banyansoftwares@gmail.com', '$2y$10$wGZVx4p1jefvMVKZ0iPuXOLeFpn0onHryGcnUR2F72B0AEcQn7IEC', 'Testing', 'Team', 'http://google.com', 'Dev Company', NULL, '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/sCEPGfaOFA8\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>', '20665 4th St', 254, 125, 'Saratoga', '3023', 'companylogo_20220722102514.png', 1, '1', '(989) 497-6933', NULL, NULL, '1', '0', NULL, NULL, '2022-07-22 10:25:14', '2022-07-29 13:13:12', '2022-10-20 10:25:14', NULL, '0'),
(39, 'dev@yopmail.com', '$2y$10$F5d7W/dU9hs24mlnkgwmFOgnPE60j6h2CvcQVlcs0N.b0G0sn20M6', 'Dev', 'Test', 'http://google.com', 'Dev Company', '', '', '20665 4th St', 254, 125, 'Saratoga', '3023', 'companylogo_20220722102642.png', 1, '1', '(989) 497-6933', NULL, NULL, '1', '0', NULL, NULL, '2022-07-22 10:26:42', '2022-07-22 10:26:42', '2022-10-20 10:26:42', NULL, '0'),
(40, 'ramkumar@idealtraits.com', '$2y$10$5IxpZASdyOZW6q6JlCJpu.CtF8babsoqWPAaZZgOSHPQvsM22gocq', 'Ramkumar', 'vaudevan', 'http://ramtest.com', 'test company', NULL, '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/RJeUgNdJoM0\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>', 'testadrress', 254, 123, 'test', '60601', 'companylogo_20220722103857.jpeg', 1, '1', '(654) 645-6465', NULL, NULL, '1', '0', NULL, NULL, '2022-07-22 10:38:57', '2022-07-22 10:59:09', '2022-10-20 10:38:57', NULL, '0'),
(41, 'idealvid@yopmail.com', '$2y$10$X14UGdx3oFhUX4qlEFGYTefuZo9msn1hz536ZfP5SzSt38erZZkO6', 'Idealvid', 'Test', 'http://youtube.com', 'Test Company', NULL, NULL, 'test', 254, 126, 'test', '5555', 'companylogo_20220722122204.png', 1, '1', '(111) 111-1111', NULL, NULL, '1', '0', NULL, NULL, '2022-07-22 12:22:04', '2022-07-22 12:22:04', '2022-10-20 12:22:04', NULL, '0'),
(42, 'sivakumar@yopmail.com', '$2y$10$xuQvc.9k8gHk5aHY.9zrn.lGG3YwzrM637mUb8TXerbZ.aXMHbH/.', 'Siva', 'Kumar', 'https://www.processdrive.com', 'Process Drive', NULL, NULL, 'Kirkland Street Oceanside', 254, 126, 'San Francisco', '7027', 'companylogo_20220722123834.jpg', 1, '1', '(850) 459-4520', NULL, NULL, '1', '0', NULL, NULL, '2022-07-22 12:38:34', '2022-07-22 12:38:34', '2022-10-20 12:38:34', NULL, '0'),
(44, 'pajanyaug1@yopmail.com', '$2y$10$HvOAOyT2qWRdF84GzmVORu7wGkV26vICYnDZ9bdXAQTvw6HUKfbBa', 'Pajany', 'Aug', 'https://idealtraits.com', 'New Company', NULL, NULL, 'Test', 254, 122, 'Alabama', '60500', 'companylogo_20220804123845.png', 1, '1', '(111) 111-1111', NULL, NULL, '1', '0', NULL, NULL, '2022-08-04 12:38:45', '2022-08-04 12:38:45', '2022-11-02 12:38:45', NULL, '0'),
(45, 'newuseraug01@yopmail.com', '$2y$10$azpK6iXSGVsM2XWxff/wb.GrczthV2/lnT8PvNWRKJhZFtiRwjUBK', 'New User`', 'Aug', 'https://idealtraits.com', 'Ideal New', NULL, NULL, '4 South Avenue', 254, 122, 'Alabama', '60500', 'companylogo_20220804131134.png', 1, '1', '(989) 497-9633', NULL, NULL, '1', '0', NULL, NULL, '2022-08-04 13:11:34', '2022-08-04 13:11:34', '2022-11-02 13:11:34', NULL, '0'),
(46, 'jazmynesdfwesdf@idealtraits.com', '$2y$10$aITFTCZBRExXvtm.GAM/FefA0OT7/WsUXOrr2L8cyWh5W7zPndw1e', 'Jaz', 'Jez', 'https://idealtraits.com', 'Jazmyne\'s Agency', NULL, 'https://youtu.be/w5rX1RlT7PU', '232 S Broadway', 254, 144, 'Lake Orion', '48362', '166015081346.png', 5, '1', '(989) 397-6402', NULL, NULL, '1', '0', NULL, NULL, '2022-08-10 16:52:30', '2022-11-03 13:51:38', '2022-08-11 16:52:30', NULL, '0'),
(47, 'jaztest2021@gmail.com', '$2y$10$0Fht/RN.MBKCUQeKulFdQe3.CRrm5PprG9kXxpJNteBR0JHcuNS.2', 'Jazmyne', 'Subuser', 'https://idealtraits.com', 'Jazmyne\'s Agency', NULL, 'https://youtu.be/w5rX1RlT7PU', '232 S Broadway', 254, 144, 'Lake Orion', '48362', '166015081346.png', 5, '1', '(989) 397-6402', NULL, NULL, '1', '0', NULL, 46, '2022-08-10 17:10:21', '2022-08-10 17:12:02', '2022-08-11 16:52:30', NULL, '0'),
(48, 'pajanynew@yopmail.com', '$2y$10$LPgkHrxUwSXQnkuKPjnK0.dMfWLpzRk0MQP6Sr0QJaKKwodJPppdK', 'Pajany', 'New', 'http://www.google.com', 'Test Company', NULL, NULL, 'Test Avenue', 254, 122, 'Alabama', '60500', NULL, 1, '1', '(989) 497-6933', NULL, NULL, '1', '0', NULL, NULL, '2022-08-11 05:37:46', '2022-08-11 05:37:46', '2022-11-09 05:37:46', NULL, '0'),
(49, 'newnew@yopmail.com', '$2y$10$05w0gGJKZW97rbajX0mANOW5S8WbvIKYTaY14qCtJPiv9elRWXNSu', 'New', 'Test', 'http://google.com', 'Test Company', NULL, NULL, 'Test Address', 254, 122, 'Alabama', '60500', NULL, 1, '1', '(989) 497-6933', NULL, NULL, '1', '0', NULL, NULL, '2022-08-11 05:55:40', '2022-08-11 05:55:40', '2022-11-09 05:55:40', NULL, '0'),
(50, 'pajanytech@gmail.com', '$2y$10$xb2DnzT4whFZnBl0ZZNNg.WuQ/aF5kFW8U51oGkTXSZpE2wuI0smy', 'Pajany', 'New', 'http://youtube.com', 'test', NULL, NULL, 'test', 254, 122, 'yrd', '60500', NULL, 1, '1', '(989) 498-6888', NULL, NULL, '1', '0', NULL, NULL, '2022-08-11 06:01:33', '2022-08-11 06:01:33', '2022-11-09 06:01:33', NULL, '0'),
(51, 'hari@yopmail.com', '$2y$10$ZEh1z75uyMgYCyu/2j.L3exxfZvnfP4DFpuf.tFsloF14sUrlB7my', 'kural', 'arasu', 'http://youtube.com', 'test kural info pvt ltd', NULL, NULL, 'om sakthi st,', 254, 2, 'newyork', '60500', '166091210951.png', 1, '1', '(845) 145-4984', NULL, NULL, '1', '0', NULL, NULL, '2022-08-19 11:38:08', '2022-08-19 12:28:29', '2022-11-17 11:38:08', NULL, '0'),
(53, 'jezowskijazmyne+1@gmail.com', '$2y$10$V0rxR7sXw2sAb3g90W4Ky.JZYqQhmf.N4B18h4L.nVbF9EdRy.78i', 'Jazmyne', 'Jezowski', 'https://idealtraits.com', 'Mlynarek Agencies', NULL, '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/xx53A4uzC04\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>', '232 S Broadway', 254, 144, 'Lake Orion', '48362', '', 1, '1', '(810) 444-4444', NULL, NULL, '1', '0', NULL, 37, '2022-09-07 16:04:26', '2023-01-16 17:21:24', '2022-10-10 00:00:00', NULL, '0'),
(54, 'jazmynejezowski+17@gmail.com', '$2y$10$VoEwcyzoprRPdAEB9.1SkeGgXci1DHGbEPITPDd/V5UEn8J1RtneO', 'Jazmyne', 'Jezowski', 'https://idealtraits.com', 'Mlynarek Agencies', NULL, '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/xx53A4uzC04\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>', '232 S Broadway', 254, 144, 'Lake Orion', '48362', '', 1, '1', '(810) 444-4444', NULL, NULL, '0', '0', NULL, 37, '2022-09-07 16:55:08', '2023-01-18 15:51:04', '2022-10-10 00:00:00', NULL, '0'),
(55, 'jazmyne+addnewbo@idealtraits.com', '$2y$10$yD5hCBCTRzhKkz/FVGUMFeIHGuN5jou4gLyiuvjuLb./JkTwiRnj.', 'addfrom', 'admin', 'http://google.com', 'add from admin', NULL, NULL, '232 S Broadway Rd', 254, 144, 'Lake Orion', '48362', 'companylogo_20220919134732.PNG', 5, '3', '(248) 387-2717', NULL, NULL, '1', '0', NULL, NULL, '2022-09-19 13:47:32', '2022-09-19 13:47:32', '2022-09-20 13:47:32', NULL, '0'),
(56, 'kevin@idealtraits.com', '$2y$10$NaGcmAGEaTdtt/R8gC3w/uotGwYO.k/ZHdWu9Z1kd9p7Eyimp0htW', 'Kevin', 'Mlynarek', 'https://idealtraits.com', 'IdealTraits Inc.', NULL, 'https://youtu.be/K80kOJRbPT8', '232 S Broadway Rd', 254, 144, 'Lake Orion', '48362', '166629295856.png', 7, '1', '(248) 387-2717', NULL, NULL, '1', '0', NULL, NULL, '2022-09-19 13:57:04', '2022-12-09 16:32:50', '2022-12-18 00:00:00', NULL, '0'),
(66, 'jeremy+pilotregistration@idealtraits.com', '$2y$10$OuVCxfF94/5ErABnAZCcgOIKHZsB0ZGtmeMQT5rquOsFe7KqSN.ey', 'Jeremy', 'Mlynarek', 'https://idealinterviews.com', 'Your Company Name', NULL, NULL, '232 S Broadway', 254, 144, 'Lake Orion', '48362', '166629514766.png', 10, '1', '(810) 222-2222', NULL, NULL, '1', '1', NULL, NULL, '2022-10-20 15:45:42', '2022-12-07 18:16:23', '2023-01-18 00:00:00', NULL, '0'),
(67, 'pajany@yopmail.com', '$2y$10$f0CVhbrFSvjVs/DrNnvby.vLSN9o2gda.Wc728IIhWsV/5JopQD4u', 'Pajany', 'Mathi', 'http://google.com', 'Test', NULL, NULL, 'test', 254, 34, '111', '60509', 'companylogo_20221020155543.jpg', 10, '1', '(111) 111-1111', NULL, NULL, '1', '0', NULL, NULL, '2022-10-20 15:55:43', '2022-12-07 18:15:49', '2023-01-18 00:00:00', NULL, '0'),
(70, 'mhigdon@allstate.com', '$2y$10$ws/sFxrETPmJpZ6TPZMtiejdG6JDaRgvt.b9QTRpj7WXx.0lE7OZm', 'Michael', 'Higdon', 'https://agents.allstate.com/michael-higdon-albertville-al.html', 'Michael Higdon: Allstate Insurance', NULL, NULL, '1024 Blount Ave', 254, 122, 'Guntersville', '35976', 'companylogo_20221021142909.png', 9, '3', '(256) 302-2021', NULL, NULL, '1', '0', NULL, NULL, '2022-10-21 14:29:09', '2023-01-24 19:36:04', '2023-01-19 14:29:09', NULL, '0'),
(71, 'stevedow@allstate.com', '$2y$10$hAdQzb6RBYpOnIY8uFPnVetLXATJwjd2lu5mM5uDsXaqen3RG6rxS', 'Steve', 'Dow', 'https://agents.allstate.com/steve-dow-castle-rock-co.html', 'Steve Dow: Allstate Insurance', NULL, NULL, '753 Maleta Ln #101', 254, 127, 'Castle Rock', '80108', 'companylogo_20221021143115.png', 9, '3', '(919) 637-4250', NULL, NULL, '1', '0', NULL, NULL, '2022-10-21 14:31:15', '2023-01-24 19:36:04', '2023-01-19 14:31:15', NULL, '0'),
(72, 'joshhouse@allstate.com', '$2y$10$b6VxoC8rONKDxmRCeGPE3u23Sl2EN5p4XElvtzqih6HLERIU7jdsW', 'Josh', 'House', 'https://agents.allstate.com/josh-house-trophy-club-tx1.html', 'Josh House: Allstate Insurance', NULL, NULL, '2550 Bobcat Blvd #105', 254, 165, 'Trophy Club', '76262', 'companylogo_20221021143223.png', 9, '3', '(817) 380-5489', NULL, NULL, '1', '0', NULL, NULL, '2022-10-21 14:32:23', '2023-01-24 19:36:04', '2023-01-19 14:32:23', NULL, '0'),
(74, 'a0c0678@allstate.com', '$2y$10$//44mDuRNNdVnMGLlqz.zOpCJRDc.8TrrBFZKM1zwhc2Wp2.JNwCO', 'Mike', 'Gopsha', 'https://agents.allstate.com/mike-gopsha-canton-ga.html', 'Mike Gopsha: Allstate Insurance', NULL, NULL, '1431 Riverstone Pkwy Ste 140', 254, 132, 'Canton', '30114', 'companylogo_20221021143510.png', 9, '3', '(503) 807-4511', NULL, NULL, '1', '0', NULL, NULL, '2022-10-21 14:35:10', '2023-01-24 19:36:04', '2023-01-19 14:35:10', NULL, '0');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `employers`
--
ALTER TABLE `employers`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `employers`
--
ALTER TABLE `employers`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;
COMMIT;

