-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 30, 2026 at 04:21 PM
-- Server version: 10.11.19-MariaDB
-- PHP Version: 8.4.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `bpmcom_npo`
--

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

--
-- Table structure for table `business_year`
--

CREATE TABLE `business_year` (
  `id` bigint(20) NOT NULL,
  `year` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `business_year`
--

INSERT INTO `business_year` (`id`, `year`, `slug`) VALUES
(2, '২০১৬-২০১৭', '16_17'),
(3, '২০১৭-২০১৮', '17_18'),
(4, '২০১৮-২০১৯', '18_19'),
(5, '২০১৯-২০২০', '19_20'),
(6, '২০২০-২০২১', '20_21'),
(7, '২০২১-২০২২', '21_22'),
(8, '২০২২-২০২৩', '22_23'),
(9, '২০২৩-২০২৪', '23_24'),
(10, '২০২৪-২০২৫', '24-25'),
(11, '২০২৫-২০২৬', '25-26');

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

--
-- Table structure for table `data_files`
--

CREATE TABLE `data_files` (
  `id` bigint(20) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `instituteID` bigint(20) NOT NULL,
  `approval` varchar(3) NOT NULL DEFAULT 'no',
  `status` varchar(20) NOT NULL DEFAULT 'Unread'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `data_files`
--

INSERT INTO `data_files` (`id`, `file_name`, `dateCreated`, `dateUpdated`, `instituteID`, `approval`, `status`) VALUES
(4, 'gVesKyIvrctlnQSL', '2018-11-12 11:20:46', '2018-12-03 02:29:38', 2, 'yes', 'Downloaded'),
(11, 'eHrvKmaD0tP7ZWJ9', '2018-11-20 01:34:47', '0000-00-00 00:00:00', 6, 'yes', 'Read'),
(12, 'gfdqhZjcoJnPQSYi', '2018-11-20 11:13:13', '2018-12-03 02:54:41', 7, 'yes', 'Read'),
(13, '2sKW5vb4teoMCS1H', '2018-11-21 12:21:10', '2018-11-21 12:22:19', 8, 'yes', 'Read'),
(14, 'Jhe2HofsFAkzuTvr', '2018-11-21 01:22:55', '0000-00-00 00:00:00', 9, 'yes', 'Read'),
(15, 'j30dvLGToQaUhx2f', '2018-11-21 04:16:27', '0000-00-00 00:00:00', 10, 'yes', 'Read'),
(16, 'p6sKg3dL54OutM2Q', '2018-11-21 07:38:01', '2018-12-03 02:51:53', 1, 'yes', 'Downloaded'),
(17, 'oVQWl72sNHECrIgh', '2018-11-21 08:45:37', '2018-12-05 12:13:15', 11, 'yes', 'Unread'),
(26, 'HpIavVQ5WElSPNxh', '2019-04-07 04:48:11', '2019-04-07 04:48:47', 56, 'yes', 'Downloaded'),
(28, 'jCvXUqyILp38OJW1', '2019-04-15 03:47:45', '2019-04-15 03:49:29', 60, 'yes', 'Downloaded'),
(34, '7pfBNuGrFeyYZObV', '2019-08-17 03:29:20', '2019-08-17 03:38:12', 71, 'yes', 'Unread'),
(35, 'fn7xpF8aHBJKh9U3', '2020-01-14 09:51:00', '2020-02-11 02:16:26', 79, 'yes', 'Downloaded'),
(36, 'PHX9JGExrhNwCVvp', '2020-01-19 11:00:36', '0000-00-00 00:00:00', 82, 'yes', 'Read'),
(37, 'af2Vd98gLkliyxYs', '2020-01-19 12:11:59', '2020-02-13 11:31:11', 83, 'yes', 'Downloaded'),
(38, 'vMcGS2rmydsg56Af', '2020-01-19 06:27:03', '2020-01-19 06:49:18', 85, 'yes', 'Downloaded'),
(39, '3kLxFWDjX9tKAJ5c', '2020-01-20 10:10:15', '0000-00-00 00:00:00', 86, 'yes', 'Downloaded'),
(40, 'mDMH7zubeUVLaPlg', '2020-01-21 11:01:50', '2020-02-19 07:32:35', 88, 'yes', 'Downloaded'),
(41, 'HuaQgXesfCxTS2R6', '2020-01-22 12:22:01', '2020-01-22 12:31:42', 89, 'yes', 'Downloaded'),
(42, 'ubqYGQiH8hMalLom', '2020-01-25 10:37:07', '0000-00-00 00:00:00', 91, 'yes', 'Unread'),
(43, 'RYfbdvi9e16oGsAc', '2020-01-26 05:10:29', '0000-00-00 00:00:00', 95, 'yes', 'Downloaded'),
(44, 'vcitV3E1JxMFlugd', '2020-02-09 10:38:26', '0000-00-00 00:00:00', 105, 'yes', 'Downloaded'),
(45, '1Pbjr2gxiXFOeKfn', '2020-02-10 01:47:54', '2020-02-10 03:48:04', 96, 'yes', 'Downloaded'),
(46, 'hi8QrvXsEReAMI05', '2020-02-12 11:37:06', '2020-02-17 02:54:01', 102, 'yes', 'Read'),
(48, 'qHJGvcP0R9Bz4OCD', '2020-02-13 04:18:23', '2020-02-13 04:38:57', 80, 'yes', 'Unread'),
(49, 'yIPbNuz74plAsvYL', '2020-02-16 06:01:29', '0000-00-00 00:00:00', 99, 'yes', 'Unread'),
(50, '20wJDPxVfSNsY8mb', '2020-02-17 10:59:53', '2020-02-17 11:07:54', 87, 'yes', 'Unread'),
(51, 'vUs4j3zBmyYxeEuk', '2020-02-18 06:44:46', '0000-00-00 00:00:00', 98, 'yes', 'Unread'),
(52, 'bIM65rPvm49iUBaz', '2020-02-23 03:19:42', '2020-02-23 03:51:25', 101, 'yes', 'Unread'),
(53, 'Wm52n6oEOlR8pDcS', '2020-03-02 12:02:56', '2021-12-05 04:46:23', 106, 'yes', 'Unread'),
(54, 'DoL7wy0BKisqCNIA', '2020-03-03 12:40:49', '0000-00-00 00:00:00', 109, 'yes', 'Unread'),
(55, 'ZJnM8qOtKE7aiUFR', '2020-03-05 10:26:13', '2020-03-05 10:26:30', 108, 'yes', 'Read'),
(57, 'My2TIGcizXO7pKdU', '2020-08-24 11:54:59', '2020-09-22 12:46:10', 119, 'yes', 'Unread'),
(58, 'keuqhdDItQ9EnpcC', '2020-09-09 08:44:35', '2020-09-10 11:09:12', 125, 'yes', 'Read'),
(59, 'fVXYqBJ0AcF7wiag', '2020-09-21 09:47:30', '0000-00-00 00:00:00', 130, 'yes', 'Downloaded'),
(60, 'OW8B2rCVv5xSbf7n', '2020-09-23 09:01:42', '2020-09-23 09:02:59', 124, 'yes', 'Read'),
(61, 'QTxif4WbPn27E1Ly', '2020-09-23 12:25:39', '0000-00-00 00:00:00', 124, 'yes', 'Downloaded'),
(62, 'dLCEIpuso5UPMi2g', '2020-10-01 10:02:20', '2020-10-01 10:14:05', 139, 'yes', 'Read'),
(63, 'nH0kchRBJtduXD2o', '2020-10-08 05:54:53', '0000-00-00 00:00:00', 147, 'yes', 'Unread'),
(64, 'jnJqXwHGLWeypYmU', '2020-10-11 09:55:13', '0000-00-00 00:00:00', 148, 'yes', 'Unread'),
(65, 'MEkCd90Xn8HhURxf', '2020-10-12 11:34:31', '0000-00-00 00:00:00', 152, 'yes', 'Unread'),
(66, '6o5slyXgHLbnk1N7', '2020-10-13 02:01:17', '2020-10-13 02:04:46', 112, 'no', 'Unread'),
(67, 'kM8mdpi50uLYsvJj', '2020-10-14 09:59:33', '2020-10-14 10:16:28', 115, 'no', 'Unread'),
(68, 'TapYJgPZs5zG7XR8', '2020-10-14 10:20:33', '2020-10-14 10:32:27', 155, 'yes', 'Unread'),
(69, 'qkmM1yajrBsINVuv', '2023-09-26 09:53:02', '0000-00-00 00:00:00', 173, 'yes', 'Unread'),
(70, 'YzC2ZpHOeRXGstaV', '2024-05-17 02:32:52', '0000-00-00 00:00:00', 177, 'yes', 'Unread'),
(71, '4EYPplgZLujNRdfe', '2026-07-05 09:35:43', '0000-00-00 00:00:00', 182, 'yes', 'Unread');

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`id`, `name`) VALUES
(1, '  শিক্ষা      '),
(2, 'ট্যানারী ও লেদার সেক্টর '),
(3, 'পরিবহন সেক্টর '),
(4, ' পাট সেক্টর '),
(5, 'কৃষি সেক্টর '),
(6, 'চিনি ও খাদ্য সেক্টর '),
(7, 'আবাসিক হোটেল'),
(8, 'প্রকৌশল সেক্টর'),
(9, 'রসায়ন সেক্টর'),
(10, 'ব্যাংক, বীমা ও অন্যান্য আর্থিক\r\nপ্রতিষ্ঠান'),
(11, 'বস্ত্র শিল্প');

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

--
-- Table structure for table `institute`
--

CREATE TABLE `institute` (
  `id` bigint(20) NOT NULL,
  `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `departmentID` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `institute`
--

INSERT INTO `institute` (`id`, `name`, `address`, `departmentID`) VALUES
(1, 'Bogra polytechnic Institute, Bogra', 'Bogra', 1),
(2, 'BEPZA, Dhaka', 'Dhaka', 5),
(3, 'Dhaka Polytechnic Intitute', 'Dhaka', 1),
(6, 'BRTA, Mirpur', '', 3),
(7, 'BSEC', '', 8),
(8, 'Radission', '', 7),
(9, 'Ashuganj fertilizer', '', 9),
(10, 'Mohimaganj sugar mill', '', 6),
(11, 'new_agro@gmail.com', '', 5),
(14, 'Lalbag Tannery', '', 2),
(33, 'Test Institute', '', 1),
(34, 'Test Institute', '', 1),
(35, 'Test Institute', '', 1),
(36, 'Kunja Mahipur B.U High School', '', 1),
(37, 'Bogra Azizul Haque', '', 1),
(56, 'Joypurhat Sugar Mills Ltd', '', 6),
(60, 'Joypurhat Sugar Mills Ltd', '', 6),
(61, 'shaptak', '', 1),
(69, 'Motijheel Textile', '', 11),
(70, 'test', '', 1),
(71, 'Motijheel New Model High School', '', 1),
(72, 'north bengal sugar mill', '', 6),
(73, 'North Bengal sugar Mills Ltd.', '', 6),
(74, 'mubarakgong sugar mills ltd', '', 6),
(75, 'mubarakgong sugar mills ltd', '', 6),
(76, 'mubarakgong sugar mills ltd', '', 6),
(77, 'mubarakgong sugar mills ltd', '', 6),
(78, 'Hr It', '', 1),
(79, 'The City Bank Ltd', '', 10),
(80, 'Jamuna Bank Limited', '', 10),
(81, 'Southeast Bank Limited', '', 10),
(82, 'The City Bank', '', 10),
(83, 'Janata Bank Limited', '', 10),
(85, 'Bank Asia', '', 10),
(86, 'Bank Asia Limited', '', 10),
(87, 'Ansar-VDP Unnayan Bank', '', 10),
(88, 'Southeast Bank Limited', '', 10),
(89, 'Rakub', '', 10),
(90, 'BRAC BANK ', '', 10),
(91, 'rjsm', '', 1),
(92, 'Mercantile Bank Limited', '', 10),
(93, 'Mercantile Bank Limited', '', 10),
(94, 'Bangladesh Rice Research Institute', '', 5),
(95, 'Bank Alfalah Limited', '', 10),
(96, 'Mercantile Bank Limited', '', 10),
(97, 'BRAC Bank ', '', 10),
(98, 'BRAC BANK', '', 10),
(99, 'Rakub', '', 10),
(100, 'ZAMZAM SWEETS AND BAKES LTD', '', 5),
(101, 'Rupali Bank Limited', '', 10),
(102, 'Agrani Bank Limited', '', 10),
(104, 'Eastern Bank Limited', '', 10),
(105, 'Sonali Bank Ltd.', '', 10),
(106, 'Renwick Jajneshwar & Co. BD Ltd.', '', 10),
(107, 'joypurhat sugar mills ltd', '', 6),
(108, 'Meridian Foods Limited', '', 5),
(109, 'Shyampur Sugar Mills Ltd.', '', 10),
(110, 'Islami Bank Bangladesh Limited', '', 10),
(111, 'Islami Bank Bangladesh Limited', '', 10),
(112, 'Bangladesh Sugar And Food Industries LTD.', '', 6),
(113, 'Shyampur Sugar Mills Ltd', '', 6),
(114, 'Shyampur Sugar Mills Ltd', '', 6),
(115, 'Natore Sugar Mills Limited ', '', 6),
(116, 'Natore Sugar Mills Limited ', '', 6),
(117, 'Mind Concord Bangladesh   ', '', 8),
(118, 'Shyampur Sugar Mills Ltd', '', 10),
(119, 'pabnasugarmillsltd', '', 10),
(120, 'FARIDPUR SUGAR MILLS LTD', '', 6),
(121, 'North Bengal Sugar Mills Limited', '', 6),
(122, 'carew & co(bangladesh) ltd.', '', 6),
(123, 'carew & co(bangladesh) ltd.', '', 6),
(124, 'Carew  and Co (BD) Ltd.', '', 6),
(125, 'kushtia sugar mills ltd.', '', 6),
(126, 'Shyampur Sugar Mills Ltd', '', 10),
(127, 'Shyampur Sugar Mills Ltd', '', 10),
(128, 'Setabganjsugarmill', '', 6),
(129, 'renwick', '', 6),
(130, 'Thakurgaon Sugar Mills Ltd.', '', 6),
(131, 'Rajshahi Sugar Mills Ltd', '', 6),
(132, 'Sugar Test Institute', '', 6),
(133, 'Carew  and Co (BD) Ltd.', '', 6),
(134, 'Panchagarh Sugar Mills Ltd.', '', 6),
(135, 'shympur sugarmills limited', '', 6),
(136, 'MobarakgonjSugarMills', '', 6),
(137, 'Shyampur Sugar Mills Ltd', '', 10),
(138, 'Shyampur Sugar Mills Ltd', '', 6),
(139, 'Babu', '', 6),
(140, 'Zeal Bangla Sugar Mells Ltd.', '', 6),
(141, 'zbsm', '', 6),
(142, 'BSCIC', '', 10),
(143, 'BBS', '', 1),
(144, 'Shyampur Sugar Mills Ltd', '', 6),
(145, 'BANGLADESH DEVELOPMENT BANK LIMITED', '', 10),
(146, 'MERCANTILE BANK LIMITED', '', 10),
(147, 'ONE Bank Limited', '', 10),
(148, 'Dhaka Bank', '', 3),
(149, 'ONE Bank Limited', '', 10),
(150, 'Bank Alfalah', '', 10),
(151, 'IFIC Bank Ltd', '', 10),
(152, 'Trust Bank Ltd.', '', 10),
(153, 'Agrani Bank Limited', '', 10),
(154, ' ‍SONALI BANK LIMITED', '', 10),
(155, 'Parjatan motel', '', 3),
(156, 'Parjatan motel', '', 3),
(157, 'Parjatan motel', '', 7),
(158, 'Parjatan motel', '', 7),
(159, 'United Commercial Bank Limited', '', 10),
(160, 'NPO', '', 6),
(161, 'NPO', '', 6),
(162, 'NPO', '', 6),
(163, 'NPO', '', 6),
(164, 'NPO', '', 6),
(165, 'thakurgaon sugar mills limited', '', 6),
(166, 'Rahimafrooz Storage Power Business', '', 9),
(167, 'Rahimafrooz Globatt Limited', '', 8),
(168, 'জয়পুরহাট সুগার মিলস্ লি.', '', 6),
(169, 'Joypurhat Sugar Mills Ltd', '', 6),
(170, 'Faridpur sugar mills Ltd', '', 6),
(171, 'SP TRADING HOUSE', '', 1),
(172, 'Bangladesh Institute of Nuclear Agriculture ', '', 5),
(173, 'Beximco Pharma', '', 9),
(174, 'Maple Leaf Hotel & Resort Ltd.', '', 7),
(175, 'Oriel Window', '', 2),
(176, 'Oriel Window', '', 11),
(177, 'BANGLADESH UNIVERSITY', '', 1),
(178, 'Pacific Jeans Group', '', 11),
(179, 'Utshab Technology Ltd.', '', 1),
(180, 'Boss Trading International ', '', 5),
(181, 'Online Sheba Telecom', '', 1),
(182, 'ABC Jute Industries Ltd. ', '', 4);

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

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` bigint(20) NOT NULL,
  `uname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `longitude` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `latitude` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `link` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`id`, `uname`, `longitude`, `latitude`, `link`) VALUES
(1, 'Morshed Habib', '23.744856', '90.388971', 'http://tascrb.com');

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

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

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `departmentID` bigint(20) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1-admin, 2-data entry operator'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `wsxq_admin`
--

CREATE TABLE `wsxq_admin` (
  `id` bigint(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(32) NOT NULL,
  `u_name` varchar(50) DEFAULT NULL,
  `status` enum('0','1') NOT NULL,
  `registered` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `lastlogon` timestamp NOT NULL DEFAULT current_timestamp(),
  `image` varchar(225) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1-super admin,2-admin,3-data entry operator, 4 dpt incharge, 5 admin_npo',
  `permission` enum('0','1') NOT NULL,
  `instituteID` bigint(20) NOT NULL,
  `password_recovery` text NOT NULL,
  `departmentID` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `wsxq_admin`
--

INSERT INTO `wsxq_admin` (`id`, `email`, `password`, `u_name`, `status`, `registered`, `lastlogon`, `image`, `type`, `permission`, `instituteID`, `password_recovery`, `departmentID`) VALUES
(28, 'mhsohel017@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'Morshed Habib', '1', '2018-12-01 18:12:58', '2018-11-30 21:00:00', '', 1, '1', 0, '', 0),
(161, 's.63hossain@gmail.com', '8a9f5b1b5f4030855e971969cca0767b', 'Md. Shakhawat Hossain', '1', '2019-04-15 09:03:57', '2019-04-15 09:03:57', '', 3, '0', 60, '', 0),
(181, 'npobanna@gmail.com', '25d55ad283aa400af464c76d713c07ad', 'Hasan Ul Banna', '1', '2019-09-12 05:39:23', '2019-09-12 05:39:23', '', 2, '0', 73, '', 6),
(183, 'maz2021@yahoo.com', '25d55ad283aa400af464c76d713c07ad', 'Arifuzzama', '1', '2019-09-12 05:41:40', '2019-09-12 05:41:40', '', 3, '0', 73, '', 0),
(186, 'jannat.npo@gmail.com', '1ac68cfd864b65cb564d8b67f399c665', 'jannatul', '1', '2019-09-12 05:46:08', '2019-09-12 05:46:08', '', 2, '0', 75, '', 6),
(188, 'monirnpo82@gmail.com', '589abd4e394177e17920ae924e843e02', 'Moniruzzaman', '1', '2019-09-12 05:51:32', '2019-09-12 05:51:32', '', 2, '0', 76, '', 6),
(189, 'monirnpo82@gmail.com', '589abd4e394177e17920ae924e843e02', 'Moniruzzaman', '1', '2019-09-12 05:53:15', '2019-09-12 05:53:15', '', 2, '0', 77, '', 6),
(190, 'reza.nasir143@gmail.com', 'e940408397e46043f277af8f6859bc4c', 'Nasir uddin', '1', '2019-09-23 05:32:21', '2019-09-23 05:32:21', '', 2, '0', 78, '', 1),
(191, 'rezaur.shadman@thecitybank.com', '1a77366cf211ae100d7f502cc69be592', 'Md. Rezaur Rahman Shadman', '1', '2020-01-14 03:49:14', '2020-01-14 03:49:14', '', 2, '0', 79, '', 10),
(192, 'jblmis@jamunabank.com.bd', 'c5fab9d67f2862b765b149f572199cc7', 'erteza', '1', '2020-01-15 08:59:39', '2020-01-15 08:59:39', '', 2, '0', 80, '', 10),
(193, 'naser@southeastbank.com.bd', '61bd60c60d9fb60cc8fc7767669d40a1', 'Syed Abu Naser', '1', '2020-01-19 04:20:13', '2020-01-19 04:20:13', '', 2, '0', 81, '', 10),
(194, 'abul.afroz@thecitybank.com', '743aecd64bf7fe25fdc644fafa55f3d5', 'Abul K M Afroz', '1', '2020-01-19 04:44:46', '2020-01-19 04:44:46', '', 2, '0', 82, '', 10),
(195, 'mis@janatabank-bd.com', 'e10adc3949ba59abbe56e057f20f883e', 'Sohag', '1', '2020-01-19 06:10:10', '2020-01-19 06:10:10', '', 2, '0', 83, '', 10),
(197, 'tahmid.rashid@bankasia', '7341477c39ea5d73a4e7966713c3874a', 'Tahmidur Rashid', '1', '2020-01-19 12:21:52', '2020-01-19 12:21:52', '', 2, '0', 85, '', 10),
(198, 'tahmid.rashid@bankasia-bd.com', '7341477c39ea5d73a4e7966713c3874a', 'Tahmidur Rashid', '1', '2020-01-20 04:02:01', '2020-01-20 04:02:01', '', 2, '0', 86, '', 10),
(199, 'avubrecovery@gmail.com', '736de6cc1693369803ec5b226d6629f5', 'Uttam Kumar Guha', '1', '2020-01-20 09:17:43', '2020-01-20 09:17:43', '', 2, '0', 87, '', 10),
(200, 'avubrecovery@gmail.com', '736de6cc1693369803ec5b226d6629f5', 'Badal Chandra Debnath', '1', '2020-01-20 09:46:52', '2020-01-20 09:46:52', '', 3, '0', 87, '', 0),
(201, 'tariqul.islam@southeastbank.com.bd', 'ccfe8ef44f66051a9b3f73b58c84f7d7', 'Mohammad Tariqul Islam', '1', '2020-01-21 04:44:38', '2020-01-21 04:44:38', '', 2, '0', 88, '', 10),
(202, 'en.sohag@gmail.com', '632476a7832863b0a6de6a20300830fe', 'Md. Sohag Hossain', '1', '2020-01-22 05:45:42', '2020-01-22 05:45:42', '', 2, '0', 89, '', 10),
(203, 'maliha.sinthia@bracbank.com', 'a09ea25f4c27abba25145560944cc794', 'Maliha Ahmed Sinthia', '1', '2020-01-27 06:52:26', '2020-01-22 06:50:21', '', 2, '0', 90, 'o5JTMytEhBg7caOred5Qkl1ALbrMRwXN0CDZTGIwBbpPOEJDxvFQuGHlzj6RXj4PhgkdnAYVVHU76nxN323fS2oCt8', 10),
(204, 'fm.nazmulhossen@gmail.com', 'f87636a0e430a6f58517e6791e2c6cc8', 'nazmul', '1', '2020-01-25 04:36:06', '2020-01-25 04:36:06', '', 2, '0', 91, '', 1),
(205, 'farukhossain@mblbd.com', '8f2d7c1713b75f663cf23b2d6382ed44', 'Mohammod Faruk Hossen', '1', '2020-01-26 05:57:42', '2020-01-26 05:57:42', '', 2, '0', 92, '', 10),
(206, 'farukhossain@gmail.com', '8f2d7c1713b75f663cf23b2d6382ed44', 'Mohammod Faruk Hossen', '1', '2020-01-26 05:59:11', '2020-01-26 05:59:11', '', 2, '0', 93, '', 10),
(207, 'imran238bau@gmail.com', 'fc0cc678319f748b5fb00583c5e7cdf9', 'Md. Imran Omar', '1', '2020-01-26 09:43:32', '2020-01-26 09:43:32', '', 2, '0', 94, '', 5),
(208, 'tamanna.islam@bankalfalah.com.bd', '5c7e607aac5110fcc422b2fc9d29fd13', 'Tamanna Islam', '1', '2020-01-26 11:08:34', '2020-01-26 11:08:34', '', 2, '0', 95, '', 10),
(209, 'monzurul.karim@mblbd.com', '1564fad6afd4245f8d4e93e8de58f783', 'Md. Monzurul Karim', '1', '2020-01-26 11:23:48', '2020-01-26 11:23:48', '', 2, '0', 96, '', 10),
(210, 'abdullah.29898@bracbank.com', '5c1741b1e727b5dd2d0abc96eb6f6c74', 'Mohammad Abdullah', '1', '2020-01-27 06:55:58', '2020-01-27 06:55:58', '', 2, '0', 97, '', 10),
(211, 'maliha18005@gmail.com', 'a8c05d71987e4885ba72d28df25be56c', 'Maliha Ahmed', '1', '2020-01-27 18:18:39', '2020-01-27 18:18:39', '', 2, '0', 98, '', 10),
(212, 'en.sohag@gmail.com', '5e933f77245a9590aa30c3646076cc0d', 'Md. Sohag Hossain', '1', '2020-01-28 08:44:20', '2020-01-28 08:44:20', '', 2, '0', 99, '', 10),
(213, 'asraf.sohel@gmail.com', '6b10a360f299333ad0e1795a52f72081', 'MD ASRAF UDDIN', '1', '2020-02-01 18:37:41', '2020-02-01 18:37:41', '', 2, '0', 100, '', 5),
(214, 'ho-mis@rupalibank.org', 'a9a51064160c1628a9cc23fedd5ce77e', 'MIS Division', '1', '2020-02-02 06:45:05', '2020-02-02 06:45:05', '', 2, '0', 101, '', 10),
(215, 'dgmicd1@agranibank.org', 'b6ca03617b7959d13e04793bfd420e21', 'Debika Majumder', '1', '2020-02-05 06:07:47', '2020-02-05 06:07:47', '', 2, '0', 102, '', 10),
(217, 'anupam.singha@ebl-bd.com', 'f816f6f429ff36adda61d85649ee1b77', 'Sree Anupam Singha Chowdhury', '1', '2020-02-05 06:48:50', '2020-02-05 06:48:50', '', 2, '0', 104, '', 10),
(218, 'dgmipfd@sonalibank.com.bd', 'e10adc3949ba59abbe56e057f20f883e', 'sbl', '1', '2020-02-09 04:34:03', '2020-02-09 04:34:03', '', 2, '0', 105, '', 10),
(220, 'bhadra035@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'Sohag Kumar Bhdra', '1', '2020-02-12 05:37:49', '2020-02-11 08:22:51', '', 3, '0', 83, '', 0),
(221, 'mhsohel017@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'Habib', '1', '2020-02-13 04:24:01', '2020-02-13 04:24:01', '', 2, '0', 106, '', 10),
(225, 'maz2021@yahoo.com', '25f9e794323b453885f5181f1b624d0b', 'Arihuzzaman', '1', '2020-02-16 07:57:06', '2020-02-16 07:57:06', '', 5, '0', 0, '', 0),
(226, 'admin_npo@shaptakbd.com', '25f9e794323b453885f5181f1b624d0b', 'AdminNPO', '1', '2020-02-16 08:00:29', '2020-02-16 08:00:29', '', 5, '0', 0, '', 0),
(227, 'aminulnpo@gmail.com', '4384f09cbc69c98f74dcdadc642701c9', 'Aminul Islam', '1', '2024-12-15 06:44:54', '2020-02-16 08:01:05', '', 1, '0', 0, '', 0),
(228, 'mehedinpo@gmail.com', 'b2023820a60123ef4e6869bacaf7d90c', 'Md. Mehedi Hasan', '1', '2020-03-01 08:57:27', '2020-03-01 08:15:32', '', 4, '0', 0, '', 6),
(229, 'mehedinpo@gmail.com', '25f9e794323b453885f5181f1b624d0b', 'Md. Mehedi Hasan', '1', '2020-03-01 08:21:50', '2020-03-01 08:21:50', '', 4, '0', 0, '', 10),
(230, 'renwick.kushtia@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'Kazi Nazrul Islam', '1', '2020-03-02 05:52:45', '2020-03-02 05:52:45', '', 2, '0', 106, '', 10),
(231, 'zamanbsfic@gmail.com', '84ddeea7cfbd7d32635cb56fe693ced3', 'zaman', '1', '2020-03-02 07:00:47', '2020-03-02 07:00:47', '', 2, '0', 107, '', 6),
(232, 'robiul.hossen@meridiangroupbd.com', 'e10adc3949ba59abbe56e057f20f883e', 'Md. Robiul Hossen', '1', '2020-03-03 04:40:55', '2020-03-03 04:40:55', '', 2, '0', 108, '', 5),
(233, 'jewelbsfic@gmail.com', '94db32251d866c11261d4a55da868a29', 'Khandakar Nurelahi Jewel', '1', '2020-03-03 05:17:00', '2020-03-03 05:17:00', '', 2, '0', 109, '', 10),
(234, 'iss.iad@islamibankbd.com', '14b3595146011c3e4000ff8085e1acfb', 'Md. Ibrahim Bhuiyan', '1', '2020-03-05 09:23:32', '2020-03-05 09:23:32', '', 2, '0', 110, '', 10),
(235, 'iss.iad@islamibankbd.com', '137a2dcc18c5161df1dc09df58ac7718', 'Md. Ibrahim Bhuiyan', '1', '2020-03-05 09:24:42', '2020-03-05 09:24:42', '', 2, '0', 111, '', 10),
(236, 'arazzakchem@gmail.com', '505a39891951a4f974fbde6e98fcbacb', 'Md. Abdur Razzak', '1', '2020-03-07 04:35:04', '2020-03-07 04:35:04', '', 2, '0', 112, '', 6),
(238, 'jewelbsfic@gmail.com', '94db32251d866c11261d4a55da868a29', 'Khandakar Nurelahi Jewel', '1', '2020-03-11 05:20:04', '2020-03-11 05:20:04', '', 2, '0', 113, '', 6),
(239, 'nurelahi.bd@gmail.com', '94db32251d866c11261d4a55da868a29', 'Jewel', '1', '2020-03-11 05:22:05', '2020-03-11 05:22:05', '', 2, '0', 114, '', 6),
(240, 'nazmunnahar.npo@gmail.com', 'b7f6593421d9f21bdd5caef01b24f5c8', 'Nazmunnahar', '1', '2020-03-12 05:31:24', '2020-03-12 05:31:24', '', 4, '0', 0, '', 6),
(241, 'nazmunnahar.npo@gmail.com', 'f0a1e3f1567f8b2fa54c433e7151295b', 'Nazmunnahar', '1', '2020-03-12 05:33:03', '2020-03-12 05:33:03', '', 4, '0', 0, '', 10),
(242, 'natoresm@gmail.com', 'c2348e5cbbc3f98e711dcbaff65a25ce', 'Md. Nazmul Haque Razu', '1', '2022-07-24 07:28:23', '2020-03-12 06:00:33', '', 2, '0', 115, 'tRlLZ1fU8x0ETKVb3PXGAyovShJphKPeNM8zSYubWOYFs4a6mJwACck1Zg0nX994Mt3dEVNaD7kBdrDHneuFpBQ2IR', 6),
(243, 'natoresm@gmail.com', 'c2348e5cbbc3f98e711dcbaff65a25ce', 'Md. Nazmul Haque Razu', '1', '2022-07-24 07:28:23', '2020-03-12 06:02:24', '', 2, '0', 116, 'tRlLZ1fU8x0ETKVb3PXGAyovShJphKPeNM8zSYubWOYFs4a6mJwACck1Zg0nX994Mt3dEVNaD7kBdrDHneuFpBQ2IR', 6),
(244, 'nazmulrazu13@gmail.com', '3feab6b32773e886c375f788af8a0ec5', 'Md. Nazmul Haque Razu', '1', '2020-03-12 06:07:45', '2020-03-12 06:07:45', '', 3, '0', 115, '', 0),
(246, 'rezasalim.ipe09@gmail.com', '8a93d434fd11e9d6e8884d01d6e62b3c', 'Salim Reza', '1', '2020-04-04 03:51:06', '2020-04-04 03:51:06', '', 2, '0', 117, '', 8),
(247, 'sohelmasud1984@gmail.com', 'b1e12ca66bd6d052d72cc65aebd5173d', 'Md. Sohel Masud', '1', '2020-08-20 04:09:16', '2020-08-20 04:09:16', '', 2, '0', 118, '', 10),
(248, 'pbsmltd@gmail.com', 'f1968c1d97ab0fc23ed75ab9127d305d', 'pbsm', '1', '2020-08-24 05:36:29', '2020-08-24 05:36:29', '', 2, '0', 119, '', 10),
(249, 'faridpursugarmills@gmail.com', '2c0e965ca95582a66b82d31e5b6adfa9', 'MIZANUR RAHMAN', '1', '2020-08-30 02:54:10', '2020-08-30 02:54:10', '', 2, '0', 120, '', 6),
(250, 'northbengalsm@gmail.com', '7e0f31fdf33a59376aa4d484a8fc93b8', 'North Bengal Sugar Mills Limited', '1', '2020-09-05 04:26:51', '2020-09-05 04:26:51', '', 2, '0', 121, '', 6),
(251, 'jillur.77@gmail.com', '1ff8a928c2226710ac05ed3120cdc1d2', 'md jillur rahman jewel', '1', '2020-09-08 04:38:39', '2020-09-08 04:38:39', '', 2, '0', 122, '', 6),
(252, 'abdulhalimdeputy2011@gmail.com', 'f862fd061e2c521caf6f06feb9b27a9d', 'Abdul Halim', '1', '2020-09-09 06:30:10', '2020-09-09 06:30:10', '', 2, '0', 123, '', 6),
(253, 'jillur.77@gmail.com', 'd66605bfe33c5f97a51efbbc00558345', 'Jillur Rahman', '1', '2020-09-09 06:51:21', '2020-09-09 06:51:21', '', 2, '0', 124, '', 6),
(254, 'parimalsen31@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'parimal sen', '1', '2020-09-09 08:03:32', '2020-09-09 08:03:32', '', 2, '0', 125, '', 6),
(255, 'sohelmasud1984@gmail.com', 'b1e12ca66bd6d052d72cc65aebd5173d', 'Md. Sohel Masud', '1', '2020-09-12 04:40:29', '2020-09-12 04:40:29', '', 2, '0', 126, '', 10),
(256, 'sohelmasud1984@gmail.com', 'b1e12ca66bd6d052d72cc65aebd5173d', 'Md. Sohel Masud', '1', '2020-09-12 04:46:21', '2020-09-12 04:46:21', '', 2, '0', 127, '', 10),
(257, 'setabganjsugarmill@yahoo.com', '759fca7021db2b6912ed4148199f2042', 'Setabganjsugarmill', '1', '2020-09-15 03:05:05', '2020-09-15 03:05:05', '', 2, '0', 128, '', 6),
(258, 'juni.1990@gmail.com', '2579d7dc7e2308a762c4ac9f7a100ff6', 'juni', '1', '2020-09-15 05:00:11', '2020-09-15 05:00:11', '', 2, '0', 129, '', 6),
(259, 'hasan.bsfic@gmail.com', '16377242ba991583e6d607e70d40df56', 'Md. Hasanujjaman', '1', '2020-09-15 06:20:49', '2020-09-15 06:20:49', '', 2, '0', 130, '', 6),
(260, 'sharifbsfic@gmail.com', 'cd863497add4227cd1d8481f52ca903a', 'A H M sharif', '1', '2020-09-16 06:05:52', '2020-09-16 06:05:52', '', 2, '0', 131, '', 6),
(261, 'mazidul.khan@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'Mazidul Islam Khan', '1', '2020-09-16 10:50:54', '2020-09-16 10:50:54', '', 2, '0', 132, '', 6),
(262, 'mazidul@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'Mazidul Focal Point', '1', '2020-09-16 10:52:05', '2020-09-16 10:52:05', '', 3, '0', 132, '', 0),
(263, 'mh@test.com', '827ccb0eea8a706c4c34a16891f84e7b', 'sohel', '1', '2020-09-16 12:34:30', '2020-09-16 12:34:30', '', 5, '0', 0, '', 0),
(264, 'jillur.77@gmail.com', 'd66605bfe33c5f97a51efbbc00558345', 'md jillur rahman jewel', '1', '2020-09-20 04:04:19', '2020-09-20 04:04:19', '', 2, '0', 133, '', 6),
(265, 'mhislamchem.bsfic@gmail.com', 'b4558d38daefb1e5992d5ac41ae5ed20', 'Md. Hasibul Islam', '1', '2020-09-21 06:01:41', '2020-09-21 06:01:41', '', 2, '0', 134, '', 6),
(266, '', 'd41d8cd98f00b204e9800998ecf8427e', '', '', '2020-09-22 06:44:37', '2020-09-22 06:44:37', '', 0, '0', 119, '', 0),
(267, 'sohelmasud1984@gmail.com', 'b1e12ca66bd6d052d72cc65aebd5173d', 'md.sohelmasud', '1', '2020-09-29 04:05:56', '2020-09-29 04:05:56', '', 2, '0', 135, '', 6),
(268, 'sohelmasud1984@gmail.com', 'b1e12ca66bd6d052d72cc65aebd5173d', '', '', '2020-09-29 16:43:42', '2020-09-29 16:43:42', '', 0, '0', 118, '', 0),
(269, 'sohelmasud1984@gmail.com', 'b1e12ca66bd6d052d72cc65aebd5173d', '', '1', '2020-09-29 16:44:18', '2020-09-29 16:44:18', '', 3, '0', 118, '', 0),
(270, 'sohelmasud1984@gmail.com', 'b1e12ca66bd6d052d72cc65aebd5173d', 'md.sohelmasud', '1', '2020-09-29 16:46:14', '2020-09-29 16:46:14', '', 3, '0', 118, '', 0),
(271, 'tutul.bsfic@gmail.com', '681e4c3a49f868c650f108e1bc9e4246', 'Zahidul Haque', '1', '2020-09-30 05:01:51', '2020-09-30 05:01:51', '', 2, '0', 136, '', 6),
(272, 'n.masud.mcc@gmail.com', 'f994073619d4355d5444b8253680503e', 'Md. Sohel Masud', '1', '2020-09-30 10:50:18', '2020-09-30 10:50:18', '', 2, '0', 137, '', 10),
(273, 'n.masud.mcc@gmail.com', 'f994073619d4355d5444b8253680503e', 'Md. Masudujjaman Sarker', '1', '2020-10-01 02:42:52', '2020-10-01 02:42:52', '', 2, '0', 138, '', 6),
(274, 'n.masud.mcc@gmail.com', 'f994073619d4355d5444b8253680503e', 'Md. Masudujjaman Sarker', '1', '2020-10-01 02:45:17', '2020-10-01 02:45:17', '', 3, '0', 137, '', 0),
(275, 'zbsmdp@gmail.com', '72cbf6377c8646d265cb3121c1d2daab', 'zbsm', '1', '2020-10-01 03:57:38', '2020-10-01 03:57:38', '', 2, '0', 139, '', 6),
(276, 'zbsmdp@gmail.com', '72cbf6377c8646d265cb3121c1d2daab', 'zbsm', '1', '2020-10-01 03:59:42', '2020-10-01 03:59:42', '', 2, '0', 140, '', 6),
(277, 'zbsmdp@gmail.com', '72cbf6377c8646d265cb3121c1d2daab', 'zbsm', '1', '2020-10-01 04:01:40', '2020-10-01 04:01:40', '', 2, '0', 141, '', 6),
(278, 'mahabub24nil@gmail.com', '78e6148880a91b97eb701826f108748b', 'Kazi mahabubur roshid', '1', '2020-10-01 14:27:29', '2020-10-01 14:27:29', '', 2, '0', 142, '', 10),
(279, 'mmiah5771@gmail.com', '1aa5876f8382e201d3400d490adeef7a', 'Md. Masum Miah ', '1', '2020-10-01 19:33:46', '2020-10-01 19:33:46', '', 2, '0', 143, '', 1),
(281, 's.sugarmills@yahoo.com', 'f994073619d4355d5444b8253680503e', 'Md. Masudujjaman Sarker', '1', '2020-10-05 03:30:12', '2020-10-05 03:30:12', '', 2, '0', 144, '', 6),
(282, 'musa.kajim@bdbl.com.bd', '25f9e794323b453885f5181f1b624d0b', 'SYED MUSA KAJIM NURI', '1', '2020-10-08 09:09:42', '2020-10-08 09:09:42', '', 2, '0', 145, '', 10),
(283, 'mbl.rpd@gmail.com', '5812cdfd0e80b201b30f2e13547274cf', 'SAIFUR RAHMAN', '1', '2020-10-08 10:43:27', '2020-10-08 10:43:27', '', 2, '0', 146, '', 10),
(284, 'ziaulhq@onebank.com', 'c50bd7c1f3aa7ab94aeec79882659fba', 'Ziaul Haque', '1', '2020-10-08 11:51:32', '2020-10-08 11:51:32', '', 2, '0', 147, '', 10),
(285, 'mdrsmltd@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'Rangpur Sugar Mills LTD.', '1', '2020-10-12 10:22:02', '2020-10-10 04:08:14', '', 3, '0', 112, '', 0),
(286, 'subratadhanmondi@gmail.com', '26843887718533fb43e74816a94fd049', 'Subrata Kumer Saha', '1', '2020-10-11 03:53:12', '2020-10-11 03:53:12', '', 2, '0', 148, '', 3),
(287, 'mamunur.rashid@onebank.com.bd', '06533ec04baf55a534de68db17d4fdce', 'Md. Mamunur Rashid', '1', '2020-10-11 06:30:13', '2020-10-11 06:30:13', '', 2, '0', 149, '', 10),
(288, 'mustafa.rabbi@bankalfalah.com.bd', '7ee046e0edf8a59a1317044887275739', 'Mustafa Rabbi', '1', '2020-10-11 07:29:56', '2020-10-11 07:29:56', '', 2, '0', 150, '', 10),
(289, 'fariha@ificbankbd.com', '581bac9a2806915b0e3ccf7a8a389464', 'Fariha Haider', '1', '2020-10-12 04:47:07', '2020-10-12 04:47:07', '', 2, '0', 151, '', 10),
(290, 'ullashsadat@gmail.com', '4225353479f9738f7a83a87c9778ac93', 'Sadat Hossain', '1', '2020-10-12 05:32:29', '2020-10-12 05:32:29', '', 2, '0', 152, '', 10),
(291, 'dgmcad@agranibank.org', 'bd60ec7294c829f64968bfe0cc964113', 'Arifin', '1', '2020-10-13 04:39:05', '2020-10-13 04:39:05', '', 2, '0', 153, '', 10),
(292, 'dgmmsd@sonalibank.com.bd', '1479045b85dfd1f256b2c091b41ce5aa', 'MD. ABUL BASHAR', '1', '2020-10-13 09:37:20', '2020-10-13 09:37:20', '', 2, '0', 154, '', 10),
(293, 'rangpurmotel@gmail.com', '581d43283a1cd46be64a0f788f97239b', 'Sayed tariqul islam', '1', '2020-10-14 04:19:24', '2020-10-14 04:19:24', '', 2, '0', 155, '', 3),
(294, 'rangpurmotel@gmail.com', '581d43283a1cd46be64a0f788f97239b', 'Sayed tariqul islam', '1', '2020-10-14 04:26:02', '2020-10-14 04:26:02', '', 2, '0', 156, '', 3),
(295, 'rangpurmotel@gmail.com', '581d43283a1cd46be64a0f788f97239b', 'Sayed tariqul islam', '1', '2020-10-14 04:41:13', '2020-10-14 04:41:13', '', 2, '0', 157, '', 7),
(296, 'bpcpmrangpur@gmail.com', '767f1d8f4ec9b31063b7e713326b630d', 'Sayed tariqul islam', '1', '2020-10-14 04:49:50', '2020-10-14 04:49:50', '', 2, '0', 158, '', 7),
(297, 'aziz.rahman@ucb.com.bd', '17b7d6cc68afbe9d5f6f0023cde6f776', 'Md. Azizur Rahman', '1', '2020-10-14 05:24:48', '2020-10-14 05:24:48', '', 2, '0', 159, '', 10),
(298, 'naimurrahman222007@gmail.com', '4abaf95f49dcd5afe4aa09bf5b832b30', 'Naimur Rahman ', '1', '2021-08-12 05:32:43', '2021-08-12 05:32:43', '', 2, '0', 160, '', 6),
(299, 'naimurrahman.si.npo@gmail.com', '4abaf95f49dcd5afe4aa09bf5b832b30', 'Naimur ', '1', '2021-08-16 03:25:39', '2021-08-16 03:25:39', '', 2, '0', 161, '', 6),
(300, 'naimurrahman222007@gmail.com', '4abaf95f49dcd5afe4aa09bf5b832b30', 'Naimur Rahman ', '1', '2021-08-24 08:46:11', '2021-08-24 08:46:11', '', 2, '0', 162, '', 6),
(301, 'naimurrahman222007@gmail.com', '4abaf95f49dcd5afe4aa09bf5b832b30', 'Naimur Rahman ', '1', '2021-08-24 08:47:17', '2021-08-24 08:47:17', '', 2, '0', 163, '', 6),
(302, 'ferjanahoque@gmail.com', '5b11a454215775fb9e1470fc49abc184', 'Farzana', '1', '2021-08-25 03:53:32', '2021-08-25 03:53:32', '', 2, '0', 164, '', 6),
(303, 'tsm_noor@yahoo.com', '25f9e794323b453885f5181f1b624d0b', 'thakurgaon sugar mills limited', '1', '2022-01-09 06:33:10', '2022-01-09 06:33:10', '', 2, '0', 165, '', 6),
(304, 'naimurrahman.si.npo@gmail.com', '4abaf95f49dcd5afe4aa09bf5b832b30', 'Naimur ', '', '2022-02-09 05:46:48', '2022-02-09 05:46:48', '', 0, '0', 161, '', 0),
(305, 'shahinm1989@gmail.com', '318bfdbcbd2b74bec3b67a9a1ae6c83b', 'Md. Shahinuzzaman', '1', '2022-03-27 07:21:58', '2022-03-27 07:21:58', '', 2, '0', 166, '', 9),
(306, 'shahinm1989@gmail.com', '5d33028e5e64362543908cd3c927fc12', 'Md. Shahinuzzaman', '1', '2022-03-27 07:25:52', '2022-03-27 07:25:52', '', 2, '0', 167, '', 8),
(307, 'productionjsm65@gmail.com', '2524ebac55be6cc09e41bd51d52fa74d', 'ব্যবস্থাপক(ল্যাবরেটরী )', '1', '2022-08-02 05:37:59', '2022-08-02 05:37:59', '', 2, '0', 168, '', 6),
(308, 'productionjsm65@gmail.com', 'e9dae8a9b8ea13c3abf413948d2a805c', 'Manager(Production & Lab)', '1', '2022-08-02 05:45:31', '2022-08-02 05:45:31', '', 2, '0', 169, '', 6),
(309, 'faridpursugarmills@yahoo.com', 'aca6fe12274500e9840071070964476b', 'Md Mizanur Rahman', '1', '2022-08-09 07:24:55', '2022-08-09 07:24:55', '', 2, '0', 170, '', 6),
(310, 'skmdmonirulh@gmail.com', 'b2178533f125be9ebf757c40708d05f4', 'SK MD MONIRUL HASAN', '1', '2022-09-12 06:00:36', '2022-09-12 06:00:36', '', 2, '0', 171, '', 1),
(311, 'sefa.entom@gmail.com', 'a763ca2b379520420fd637f4f7966f0f', 'MD. SEFAUR RAHMAN ', '1', '2022-10-02 07:33:17', '2022-10-02 07:33:17', '', 2, '0', 172, '', 5),
(312, 'dhm@bpl.net', 'bec2b8c8f00a184e3ce7372118957e93', 'Dr. Hasan Mahmood', '1', '2023-09-26 03:51:56', '2023-09-26 03:51:56', '', 2, '0', 173, '', 9),
(313, 'hrm@mapleleafhotels.com', '4bee669705fd1c822758cc26e749adb4', 'Hasan', '1', '2024-02-17 07:05:45', '2024-02-17 07:05:45', '', 2, '0', 174, '', 7),
(314, 'noman.orielwindow@gmail.com', '2a38b9c1868bd0384407107f77bda4e7', 'NOMAN', '1', '2024-05-16 06:48:56', '2024-05-16 06:48:56', '', 2, '0', 175, '', 2),
(315, 'noman.orielwindow@gmail.com', '2a38b9c1868bd0384407107f77bda4e7', 'NOMAN', '1', '2024-05-16 07:09:38', '2024-05-16 07:09:38', '', 2, '0', 176, '', 11),
(316, 'md.zihadul@gmail.com', '3edf4ace1d62faf29cdb9af2fb50c8ef', 'MD ZIHADUL ISLAM', '1', '2024-05-17 08:30:51', '2024-05-17 08:30:51', '', 2, '0', 177, '', 1),
(317, 'enamchy08@gmail.com', '45aae525885ef2825d299e54eb81e668', 'Md.Enamul Haque Chowdhury', '1', '2025-03-10 08:32:55', '2025-03-10 08:32:55', '', 2, '0', 178, '', 11),
(318, 'ajoydutta@gmail.com', '256355f5624cac034a8fb5277341ccdc', 'Ajoy Dutta', '1', '2025-08-27 13:33:43', '2025-08-27 13:33:43', '', 2, '0', 179, '', 1),
(319, 'mdabushaheen550@gmail.com', '44356cc681f27ee3d84e09f60468cd92', 'Abu Shaheen ', '1', '2025-10-03 20:51:54', '2025-10-03 20:51:54', '', 2, '0', 180, '', 5),
(320, 'dashakash522@gmail.com', '0b0a6f3cdc17d129a12fa883f755c5fe', 'Akash Dash', '1', '2025-10-18 01:45:40', '2025-10-18 01:45:40', '', 2, '0', 181, '', 1),
(321, 'labu.math@gmail.com', '25f9e794323b453885f5181f1b624d0b', 'Amjad Hossain', '1', '2026-07-05 03:29:41', '2026-07-05 03:29:41', '', 2, '0', 182, '', 4);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `data_files`
--
ALTER TABLE `data_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dptID` (`instituteID`);

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

--
-- Indexes for table `institute`
--
ALTER TABLE `institute`
  ADD PRIMARY KEY (`id`),
  ADD KEY `departmentID` (`departmentID`);

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

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

--
-- Indexes for table `wsxq_admin`
--
ALTER TABLE `wsxq_admin`
  ADD PRIMARY KEY (`id`),
  ADD KEY `departmentID` (`instituteID`),
  ADD KEY `departmentID_2` (`departmentID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `business_year`
--
ALTER TABLE `business_year`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `data_files`
--
ALTER TABLE `data_files`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `institute`
--
ALTER TABLE `institute`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=183;

--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wsxq_admin`
--
ALTER TABLE `wsxq_admin`
  MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=322;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `data_files`
--
ALTER TABLE `data_files`
  ADD CONSTRAINT `data_files_ibfk_1` FOREIGN KEY (`instituteID`) REFERENCES `institute` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `institute`
--
ALTER TABLE `institute`
  ADD CONSTRAINT `institute_ibfk_1` FOREIGN KEY (`departmentID`) REFERENCES `department` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`departmentID`) REFERENCES `department` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
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 */;
