-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 18, 2021 at 10:45 PM
-- Server version: 5.6.49-cll-lve
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `db_task_manage`
--

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `temp_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` tinyint(4) NOT NULL COMMENT '1 = Admin, 2 = Employee',
  `status` tinyint(4) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_seen` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `username`, `email`, `email_verified_at`, `password`, `temp_password`, `role`, `status`, `created_by`, `remember_token`, `photo`, `last_seen`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin', 'admin@test.com', NULL, '$2y$10$LjB84H2vj.zr6CkWQKjeZ.l/6/0IDpgZeHbIaHF7U/a24GXUxJNKu', 'admin@2020', 1, 1, NULL, NULL, '5fbe2e6aaef8f.jpg', '2021-02-10 10:25:52', NULL, '2021-02-10 17:25:52'),
(5, 'Sabber Hossain', 'sabber', 'sabber.shaglobal@gmail.com', NULL, '$2y$10$JJologxZowSIUwgx/EknVegyJ5TF27Si8WAukFZursnAwOIU2o4O.', 'sabber', 2, 1, 1, NULL, '5fbe2c8cb2306.jpeg', '2021-01-25 17:51:13', '2020-10-27 15:37:35', '2021-01-26 00:51:13'),
(7, 'Faisal Ahmed', 'poraguk', 'poraguk@yahoo.com', NULL, '$2y$10$BvB986aqMbFtCiK1P9lpb.Cb3sCvZs4od/ypbzSwjEhxbucgL6KA6', '12341234', 3, 1, 1, NULL, '5fc4ca4815c91.jpeg', '2021-02-16 17:38:57', '2020-10-28 22:38:58', '2021-02-17 00:38:57'),
(8, 'Tasmia Akter', 'tasmia', 'shantotasmia@gmail.com', NULL, '$2y$10$FriPxlY8hSZrf1pjS2Vko.YCugHo3AYJE3DXq45ZdM161ndyaT0KG', 'tasmia2020', 1, 1, 1, NULL, '5fd5356d73d59.jpeg', '2021-02-18 17:23:02', '2020-10-29 01:10:45', '2021-02-19 00:23:02'),
(9, 'Susan Stout', 'susan', 'susan.stout@hotmail.co.uk', NULL, '$2y$10$YVM6RSxN1f9uZZVWx1Y.yOWGJ6.mmf6EqDoyQgbu3qjuPbWWoEZeq', 'Admin12', 2, 2, 1, NULL, '5fc4ee65d04cf.jpeg', '2021-01-19 17:22:37', '2020-10-30 00:43:13', '2021-01-30 00:32:21'),
(10, 'MD Imam Hossain', 'Imam', 'hossain.shaglobal@gmail.com', NULL, '$2y$10$0el9BiedMWwt/7ND2ZYJ6Oohk7YV10Vlt2BLO5DHPtTyLpLvdWuai', 'smallworld1', 2, 1, 1, NULL, '5fc4ee7a9ec7f.jpeg', '2021-02-16 19:27:29', '2020-10-30 00:53:02', '2021-02-17 02:27:29'),
(11, 'Manjeet Kaur', 'Manjeet', 'ahbabandcoltd@gmail.com', NULL, '$2y$10$Ij7DdSkEwz93WcL6XJxHWewqn/POdUwWJUgGrFALqERwTqe5lN7Ue', 'Money1', 2, 1, 1, NULL, '5fc4eeb947533.png', '2021-02-16 19:59:55', '2020-10-30 01:04:58', '2021-02-17 02:59:55'),
(12, 'Charanjeeet Kaur', 'Charanjeet', 'ahbabandcoltd@gmail.com', NULL, '$2y$10$oT/r4ADO5YEYiVhRVAXSne7Aq9m4kCb/abD2mpTe.AVZqfhQ4/zBG', 'Money2', 2, 1, 1, NULL, '5fc4ef5b8189a.png', '2021-02-16 19:59:34', '2020-10-30 01:15:09', '2021-02-17 02:59:34'),
(13, 'Sanam Mia', 'Sanam', 'sanam@shaglobal.com', NULL, '$2y$10$3WUdaBdtVwE6lI3JRqAUd.el2KON1uwxatpe25NBcuTdYGNqiCrMC', 'owner1', 1, 1, 1, NULL, '5fc4ef14c89a2.jpeg', '2020-12-04 23:32:42', '2020-10-30 01:26:15', '2020-12-05 06:32:42'),
(14, 'Noorjahan Mia', 'Noorjahan', 'admin@shaglobal.com', NULL, '$2y$10$9II/v/qOTk5eFNnk865ZDe2kPtvcaMq75MnR6c52vnxiuSJ5az/7m', 'owner2', 2, 1, 1, NULL, NULL, NULL, '2020-10-30 01:36:42', '2020-10-30 01:36:42'),
(15, 'Mohammed Tahmid Mia', 'Tahmid', 'tahmid@shaglobal.com', NULL, '$2y$10$xNQQOC26oM2vICM9CF4YLuOGKtD8QNejy.OHyfp.2BzdwsIvnQkN.', 'business1', 1, 1, 1, NULL, '5fc4ef032b5cb.jpeg', '2021-02-09 17:03:45', '2020-10-30 01:41:50', '2021-02-10 00:03:45'),
(16, 'Anis Mia', 'Anis', 'admin@shaglobal.com', NULL, '$2y$10$ESvQAgn.PpqJL/jBio57LOVXvUfs9IvJyqWy60aFRYzVBbGb5h7mS', 'legal1', 2, 1, 1, NULL, NULL, NULL, '2020-10-30 01:45:40', '2020-10-30 01:45:40'),
(17, 'Leane Moore', 'Leane', 'leanesmoore@gmail.com', NULL, '$2y$10$jRwvGliOA89KLdA2m5tEF.rx7fK8hCf/qvVd7mAih725BL3N/a6UK', 'books1', 1, 1, 1, NULL, '5fc4eef3b3439.jpeg', '2021-02-15 18:59:54', '2020-10-30 01:58:07', '2021-02-16 01:59:54'),
(18, 'Nusrat Jahan', 'Nusrat', 'nusrat9947@gmail.com', NULL, '$2y$10$.aV06RTMwPcVrlwn3jye4umrYKM.inj8d3S2TEI1TqWKYOiMy.Vq.', 'money3', 2, 1, 1, NULL, '5fc4eee512115.jpeg', '2021-02-16 09:10:43', '2020-10-30 02:49:30', '2021-02-16 16:10:43'),
(19, 'Mohammed monjurul Ahsan', 'Monju', 'monju@shaglobal.com', NULL, '$2y$10$BEqLYrES.i5nCEDRt97cs.hmdZNEmhN/KKu6K6b5LCJytp2A7d5Ca', 'business2', 2, 1, 1, NULL, '5fc4eed65b112.jpeg', '2021-02-16 18:48:57', '2020-10-30 02:58:36', '2021-02-17 01:48:57'),
(20, 'MD Foyez Ahmed Monzil', 'Monzil', 'monzilahmed50@gmail.com', NULL, '$2y$10$Wzs0RGIAXOlCknBKkj9pNeuTuMe/HTZAbxQmJJbiG809Zy5NXKsg6', 'smallworld2', 2, 1, 1, NULL, '5fc4eec8762e3.jpeg', '2021-02-15 15:43:16', '2020-10-30 03:04:00', '2021-02-15 22:43:16'),
(21, 'SWARUP KRISHNA SAHA', 'swarup', 'swarupsahaaiub@gmail.com', NULL, '$2y$10$y8MIzv/KXyEjIEBaVopXw.GvM0n2Umx9dT5Lg7489jpKS.ha70rBO', '12345', 1, 1, 1, NULL, NULL, '2020-11-14 08:25:04', '2020-11-12 20:02:37', '2020-11-23 23:37:07'),
(22, 'Md. Shahpran', 'shahpran', 'shahpran.shaprime@gmail.com', NULL, '$2y$10$MIDIKOWUlVz1rZuzKWxwa.XbWW1ejdQqnqGkmOFfUnpE67RIxmWtO', '123456', 2, 1, 1, NULL, '5fbe3b5d3b01e.jpg', '2021-02-15 05:43:56', '2020-11-12 21:02:00', '2021-02-15 12:43:56'),
(23, 'Mahmudul Hasan', 'mamun', 'mamun@shaprime.com', NULL, '$2y$10$oB9nrcAKLbEZ/Kb/zDIVceaITqylepTGUaHwPIRPU54AhQkkQSsnC', 'mamun', 2, 1, 1, NULL, '5fc1251fb0797.png', '2021-02-04 16:18:47', '2020-11-12 21:04:21', '2021-02-04 23:18:47'),
(24, 'Md. Abu Taher', 'ataher', 'taher282@gmail.com', NULL, '$2y$10$x4tdXYGl7J5xpsnoYYW2kO1H5pJQW2DIg/k/cmzjdga9WLVo2EW5.', 'ataher', 1, 1, 1, NULL, '5fc5cadc384db.jpeg', '2021-02-16 06:49:09', '2020-11-15 11:22:13', '2021-02-16 13:49:09'),
(25, 'Mizanul Hoque Chowdhury', 'Mizan Chowdhury', 'mizanshaprime@gmail.com', NULL, '$2y$10$HWKkNhruy.M4lCxqSLtakOs1gSb9NYBx64t0yBEDpQH2j.70HMom.', 'mizanshaprime', 2, 1, 24, NULL, '5fc5caa23b1fd.jpg', '2021-02-10 06:14:37', '2020-11-15 12:21:04', '2021-02-10 13:14:37'),
(26, 'Urmi Dey', 'Urmi', 'urmi.shaprime@gmail.com', NULL, '$2y$10$6ezadKANTZvHx7WNS1i2uu4N0XQIJtW.3aI9IWuX5E.jaLWhmf2vy', 'urmi@shaprime', 2, 1, 24, NULL, '5fc5ca5d27dee.jpg', '2021-02-14 04:11:38', '2020-11-15 12:33:09', '2021-02-14 11:11:38'),
(27, 'Md. Shamannoor Mohiyan', 'Mohiyan', 'mohiyan.sg@gmail.com', NULL, '$2y$10$IEoCr1Xtb6.1Y74yIf13UecVboi56LvhvRbfQoh1GjMXIkPXbLc4i', 'SHAIT20', 2, 1, 24, NULL, '5fc5ed6cf2af1.jpg', '2021-02-18 12:17:13', '2020-11-15 12:48:34', '2021-02-18 19:17:13'),
(28, 'Arafat Rasul', 'Arafat', 'dristy1984@gmail.com', NULL, '$2y$10$TryTdKTz0JmThBicgaYpQekomMqgQXShAcRt1Uyz9k2muwCAJYnpG', 'Arafat@123', 2, 1, 24, NULL, '5fc5cb2de67a5.jpg', '2021-02-12 10:13:58', '2020-11-15 13:15:31', '2021-02-12 17:13:58'),
(29, 'TORAB ALI', 'torab', 'torab.ali1@gmail.com', NULL, '$2y$10$ofoIyIWx2H91XigoW7cBIOFLw.x1G9sy2rUVsNBp7rVgAlDkecnti', 'Salatun239', 2, 1, 24, NULL, '5fc5ed593e106.jpg', '2021-02-08 09:24:40', '2020-11-15 13:33:42', '2021-02-08 16:24:40'),
(30, 'Anup Das', 'anup', 'anupdas20181920@gmail.com', NULL, '$2y$10$KrKpV..VgPEIF597vRW.dOfvcGx9dlX.gK35c8QaE7b/TDXBHHWxS', '12345', 2, 1, 24, NULL, '5fc5ca3931ff4.jpg', NULL, '2020-11-15 13:46:02', '2020-12-01 11:44:41'),
(31, 'Ezaz Hasan Khan', 'ezaz', 'ezazk726@gmail.com', NULL, '$2y$10$zOcL6b4BQljCVDDAcUc3CO2HpTvMpo0hz6vAFqiIpBWKRslqzpl1e', '12345', 2, 1, 24, NULL, '5fc5c6a0411f3.jpg', NULL, '2020-11-15 13:51:53', '2020-12-01 11:29:20'),
(32, 'Forhan Ahmed  Chowdhury', 'forhan', 'f.a.chowdhury@hotmail.com', NULL, '$2y$10$lQO7b6qdM4LLBXlfqKWVy../65POIvXf6MKoWGQ25/ldaPoXoQyxi', '12345', 2, 1, 24, NULL, '5fc5c685f0139.jpg', '2021-02-16 05:01:55', '2020-11-15 13:58:44', '2021-02-16 12:01:55'),
(33, 'Md. Anisur Rahman Chowdhury', 'archowdhury', 'arlimon93@gmail.com', NULL, '$2y$10$LO0PZQq7avvkJ38kNPgxae9P.lrkvVLswOtJnLc4TVsAP8wowOL7O', 'Limon123', 2, 1, 24, NULL, '5fc5c6682ff0a.jpg', '2021-02-10 04:27:45', '2020-11-15 14:07:26', '2021-02-10 11:27:45'),
(34, 'Nazmus Shakir', 'shakir', 'Nazmusshakir720@gmail.com', NULL, '$2y$10$9y8nvop9Mz2jtZNMaNXb0uMGyac.ahjn7lg26MXtQz644fle4MBzW', 'shakir12345', 2, 1, 24, NULL, '5fc5c814e9b70.jpeg', '2020-11-30 09:43:41', '2020-11-15 16:11:20', '2020-12-01 11:35:32'),
(35, 'Hassan Mohammad Gulam Kibria', 'Hassan', 'kibria06md@gmail.com', NULL, '$2y$10$zAjpDVrqhR.bZcKPBV2P.u0AxWb/RfR4uvf2/AecmG3wNy/HY3MCu', '360390', 2, 1, 24, NULL, '5fc5c82ee3e6e.jpg', '2021-02-10 13:58:00', '2020-11-15 16:16:02', '2021-02-10 20:58:00'),
(36, 'Jalal Ahmad', 'jalal', 'jalalbg6@gmail.com', NULL, '$2y$10$4mWXbYmWnj08jhVjAtYS6OxF381wQRu6dFToak/JEtsjJT7Nx3c.y', '932533', 2, 1, 24, NULL, '5fc5fa1a7b591.jpeg', '2020-12-01 09:33:19', '2020-11-15 16:25:48', '2020-12-01 16:33:19'),
(37, 'S M Fazle Rabbi', 'frabbi', 'fazle.aiub@gmail.com', NULL, '$2y$10$dYJyl7hrDr87vO0eEjqSX.qxo7hi38XdCjWKChrq.NFQH49rpBnSO', 'sadaf@#2019', 2, 1, 24, NULL, '5fc5ed069eafd.jpg', '2021-01-30 10:16:04', '2020-11-16 12:19:22', '2021-01-30 17:16:04'),
(38, 'Redwan Ahmed', 'Redwan', 'redwan.ahmed02@gmail.com', NULL, '$2y$10$ImxW/2SeqXMNmv6wQDafOu.XovFRB2.FdNzXg3.dnum12W7TnAhEO', '12345', 2, 1, 24, NULL, NULL, NULL, '2020-11-16 12:34:06', '2020-12-22 13:04:46'),
(39, 'Koyes Ahmed', 'koyes', 'koyes@shaglobal.com', NULL, '$2y$10$GKBsTYT55mm5K0VUWU8VO./ktMnbM7juJPPZsXzrLpRm2tQbzcjcO', 'koyes2017721055', 2, 1, 24, NULL, '5fc5c9e584008.jpg', '2021-01-26 19:00:22', '2020-11-16 12:44:13', '2021-01-27 02:00:22'),
(40, 'Jesmin Akter Rani', 'jesmin', 'tafsiar@gmail.com', NULL, '$2y$10$NEwQARFLLjVBx4YkpX4gvuimBgdmd8zD9Cm9MVZYf0VQgFdE4Tjr2', 'jesmin123', 2, 1, 24, NULL, '5fc4f0145223b.jpeg', '2020-12-07 04:37:38', '2020-11-16 13:00:04', '2020-12-22 13:04:26'),
(41, 'John Chowdhury', 'john', 'john.fashionit@gmail.com', NULL, '$2y$10$cAJasw944ArFqb90wS71GOn.53mHHMg6hUR0Zmg0ksFDgu/icWgOS', '466809', 2, 1, 24, NULL, '5fc229d8ef867.jpg', '2021-02-10 10:26:23', '2020-11-16 13:19:01', '2021-02-10 17:26:23'),
(42, 'Vanu Lal Das', 'vanu', 'vanustar83@gmail.com', NULL, '$2y$10$zwKKmlM4RejInB59MN1y6OaFW7hyiDTNmRmLrwV8bPwmMiH6N54oK', '12345', 2, 2, 24, NULL, '5fbf5ac65d39d.jpeg', '2021-01-29 17:31:10', '2020-11-19 14:29:26', '2021-01-30 00:31:43'),
(43, 'Shamim Ahmed', 'shamim', 'shamim@shaglobal.com', NULL, '$2y$10$V7zqiTVTrGljO2mqCLXihO5S6un4faH9EjSQljiBS4BZoCQUvLIz6', '12345', 2, 1, 24, NULL, '5fc5ca01d4b96.jpg', '2021-01-25 09:56:24', '2020-11-19 14:41:34', '2021-01-25 16:56:24'),
(44, 'Nurul Amin Chowdhury (Nipu)', 'nipu', 'nipushaglobal@gmail.com', NULL, '$2y$10$TtVeIhNfD6fGSdWZ84ALauaKMKGfhL9fOHHDn3x5lz8JZ4Uebae3a', '12345', 2, 1, 24, NULL, '5fbfe977c8c97.jpg', '2021-01-22 13:58:18', '2020-11-23 14:41:15', '2021-01-22 20:58:18'),
(45, 'Rubel Ahmed', 'rubel', 'rubelahmed480@gmail.com', NULL, '$2y$10$PefyU9QNVmbMWRvxeG2KruwqOBDhuPTiocMHCgIHJ4lQsz9BCh8PO', '12345', 2, 1, 24, NULL, '5fc21d18c4833.jpg', '2021-02-13 13:44:48', '2020-11-23 14:48:25', '2021-02-13 20:44:48'),
(46, 'Md. Rashedul Hasan', 'Rashed', 'rashedjosan@gmail.com', NULL, '$2y$10$po5tzwMFgYlcCqBCNr152.cf6QctTEB/cGy0ED.0iu.2MOooQKrI.', 'Rashed2020!', 3, 1, 24, NULL, '5fc502579fe21.jpeg', '2021-01-13 21:20:51', '2020-11-26 19:19:31', '2021-01-14 04:20:51'),
(47, 'Test', 'test123', 'as@test.com', NULL, '$2y$10$y2tP0wY7Oe1RZUr/zRdjbea2kTTFlBq75/dfheYWh8J6Ta4twp18W', 'test', 1, 2, 1, NULL, NULL, '2021-01-19 17:24:40', '2020-11-26 20:37:12', '2021-01-20 00:24:40'),
(48, 'Ruhel Ahmed', 'ruhel', 'ruhelahmed1993@gmail.com', NULL, '$2y$10$8wytpRee6CdhRjGYBkRJAOY0vnrqtm/8kpO3AusMiYFDWlrJZAyNK', '12345', 2, 1, 24, NULL, '5fc5ecec497a2.jpg', NULL, '2020-11-29 17:19:14', '2020-12-01 14:12:44'),
(49, 'Md. Mirja Husen Hridoy', 'hridoy', 'mirjahussain517@gmail.com', NULL, '$2y$10$fuhqIdJLriO29zFwkHJdyOGcAcodgX2RzoyDB1t0I7cnjCEz5NZM6', '12345', 2, 1, 24, NULL, '5fc5ecdf2a450.jpg', NULL, '2020-11-29 17:22:56', '2020-12-22 13:03:53'),
(50, 'Mahfuzur Rahman', 'mahfuz', 'mahfuzhr81ecl@gmail.com', NULL, '$2y$10$Ytk4Y6S0r/ARydeEQRfwUuj77nnTz7TKFZlHnyQ6XZeuY7Vcg38Fu', '12345', 2, 1, 24, NULL, '5ff6fa66ee146.jpeg', '2021-02-14 04:16:39', '2021-01-07 19:11:18', '2021-02-14 11:16:39'),
(51, 'Abu Naim MD Sajjad Karim Sohag', 'Sohag', 'sss_sohag_sss@yahoo.com', NULL, '$2y$10$GwevQKgxm8AEq/Jj5PSsLu60jKu53zYBR5tDxRmInwTE3BOy3zfiu', 'Shaglobal2021', 2, 1, 17, NULL, NULL, '2021-02-18 16:15:31', '2021-01-28 23:28:18', '2021-02-18 23:15:31');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
