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

START TRANSACTION;



--
-- Database: `u220599404_newschool`
--

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

--
-- Table structure for table `aboutus`
--

CREATE TABLE `aboutus` (
  `abid` int(11) NOT NULL,
  `about` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Academic_Session`
--

CREATE TABLE `Academic_Session` (
  `id` int(111) NOT NULL,
  `Academic_Session` varchar(255) NOT NULL,
  `Session_Year` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Academic_Session`
--

INSERT INTO `Academic_Session` (`id`, `Academic_Session`, `Session_Year`) VALUES
(2, '2025-2026', '2025'),
(5, '2026-2027', '2026');

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

--
-- Table structure for table `backup`
--

CREATE TABLE `backup` (
  `id` int(200) NOT NULL,
  `tracking_id` varchar(200) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `backup`
--

INSERT INTO `backup` (`id`, `tracking_id`, `amount`, `address`, `date_time`) VALUES
(10, 'Cryptos?rid=782752', '0.1', '134N7BmQZHSj2WU7kUaN8fFada32GpBXbg', '2017-04-03 14:37:40'),
(11, 'Cryptos?rid=782752', '0.1', '134N7BmQZHSj2WU7kUaN8fFada32GpBXbg', '2017-04-03 15:14:12'),
(15, 'Cryptos?rid=782752', '0.1', '134N7BmQZHSj2WU7kUaN8fFada32GpBXbg', '2017-04-03 16:30:28'),
(18, 'Cryptos?rid=782752', '0.15', '134N7BmQZHSj2WU7kUaN8fFada32GpBXbg', '2017-04-03 17:59:36');

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `banaid` int(11) NOT NULL,
  `bannar` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`banaid`, `bannar`) VALUES
(3, 'bannar/sld2.jpg');

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(111) NOT NULL,
  `title` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `video` varchar(255) NOT NULL,
  `desc` varchar(255) NOT NULL,
  `Author` varchar(255) NOT NULL,
  `created_at` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `title`, `photo`, `video`, `desc`, `Author`, `created_at`) VALUES
(4, 'Madrasha New Bulding', 'image/Notice/blog_1759304067_68dcd983801ad.jpeg', '', 'Madrasha New Bulding', 'Rabiul Islam', '2025-10-01 07:34:27'),
(5, 'মাদ্রাসার ছাদ ধালাই', '', 'image/Notice/videos/blog_video_1759304402_68dcdad228f46.mp4', 'মাদ্রাসার ছাদ ধালাই', 'Rabiul Islam', '2025-10-01 07:40:02'),
(6, '২৮তম বিরাট ধর্মিও জলসা!', 'image/Notice/blog_1759313682_68dcff126e224.jpeg', '', '২৮তম বিরাট ধর্মিও জলসা! বেরাদারানে ইসলাম, আস্সালামো আলাইকুম!\r\nবাদ আরজ এই যে, বর্তমান মুসলিম সমাজ মহান আল্লাহর ও তার রসুলের (সঃ) পথ পরিত্যাগ করে অন্ধকারের পথ অনুসরণ করছে। তাই মুসলিম * সমাজকে-সুপথে আনয়নের জন্য পবিত্র কুরআন ও হাদিসের অমিয়বানী শুনাইবার জন্য এ', 'Rabiul Islam', '2025-10-01 10:14:42'),
(7, '২৮তম বিরাট ধর্মিও জলসা!', 'image/Notice/blog_1759314463_68dd021fb4951.jpeg', '', '২৮তম বিরাট ধর্মিও জলসা! প্রথম রাত্রি বক্তাগণের নাম :-\r\n১। প্রধান বক্তা- হযরত আল্লামা মৌলানা ও মুফতি আব্দুল হাকিম চতুর্বেদী সাহেব, ফাজিলে দেবন্দ, রাজমহল, ঝাড়খণ্ড।\r\n২। বক্তা- হযরত আল্লামা ও মৌলানা আব্দুল জাব্বার আশরাফী সাহেব, দক্ষিন দিনাজপুর।\r\n* ৩। বক্তা- হ', 'Rabiul Islam', '2025-10-01 10:27:43'),
(8, 'মাদ্রাসার মেঝে ঢালাই', '', 'image/Notice/videos/blog_video_1759562053_68e0c94504cab.mp4', 'মাদ্রাসার মেঝে ঢালাই', 'Rafiqul Islam', '2025-10-04 07:14:13'),
(9, 'Madrasah Ahale Sunnat Islamia Nadishik - New Bildinge', 'image/Notice/blog_1771076550_69907bc6811db.jpg', '', 'Madrasah Ahale Sunnat Islamia Nadishik - New Bildinge', 'Madrasah Committee', '2026-02-14 13:42:30'),
(10, 'RAMDAN MOBARAK ISTHEHAR', 'image/Notice/blog_1771482949_6996af45c2719.jfif', '', 'RAMDAN MOBARAK ISTHEHAR', 'ADMIN', '2026-02-19 06:35:49');

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

--
-- Table structure for table `class_master`
--

CREATE TABLE `class_master` (
  `id` int(11) NOT NULL,
  `class_id` varchar(255) NOT NULL,
  `class_name` varchar(255) NOT NULL,
  `section` varchar(52) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_master`
--

INSERT INTO `class_master` (`id`, `class_id`, `class_name`, `section`) VALUES
(27, '', 'LKG 1', 'A,B,C,D'),
(28, '', 'LKG 2', 'A,B,C,D'),
(29, '', 'One', 'A,B,C,D'),
(30, '', 'Two', 'A,B,C,D'),
(31, '', 'Three', 'A,B,C,D'),
(32, '', 'Four', 'A,B,C,D');

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

--
-- Table structure for table `committe_members`
--

CREATE TABLE `committe_members` (
  `id` int(111) NOT NULL,
  `position` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `image_path` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `committe_members`
--

INSERT INTO `committe_members` (`id`, `position`, `full_name`, `phone`, `email`, `address`, `image_path`) VALUES
(56, 'Sobhapoti', 'SEKH HAMEDUR RAHAMAN', '9647890530', 'skhamedur@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/68343cd61c5e1_photoii.JPG'),
(57, 'Sho Sobhapoti', 'SANJARUL ISLAM', '9593648926', 'sanjarul1991@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/6990766e572c9_sdxsd.JPG'),
(58, 'Sompadok', 'MD MUSTAK ALAM', '9563241042', 'mustak1042@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/683442b2e6df7_hmustaq photo.JPG'),
(59, 'Sho Sompadok', 'SAHABUDDIN AHAMED', '9735021302', 'sahabuddin@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/683442b2e71d9_sahaphoto.JPG'),
(60, 'Cashier', 'RAFIQUL ISLAM', '7797149903', 'ri12873@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/68343bbbda0c6_WWO.JPG'),
(61, 'Auditor', 'SAMAD ALI', '8145134520', 'samad4520@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/683442b2e75e9_samadphoto.JPG'),
(62, 'Upodeshtar', 'KURBAN ALI', '8145796358', 'kurban6358@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/683442b2e7879_silipphoto.JPG'),
(63, 'Ispikar', 'MD RAJU ALI', '8906591616', 'raju1616@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/683442b2e7ad4_rajuphoto.JPG'),
(64, 'Motoyali', 'MD BISU', '8145852654', 'bisu2654@gmail.com', 'VILL-NADISHIK, PO-SINGIA, PS-CHANCHAL,        DIST-MALDA, STATE-WEST BENGAL - 732123', 'img/committee%2520membar/6834446ab3cbd_bisuphoto.JPG');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `alpha_2` varchar(200) NOT NULL DEFAULT '',
  `alpha_3` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `alpha_2`, `alpha_3`) VALUES
(1, 'Afghanistan', 'fl', 'afg'),
(2, 'Aland Islands', 'ax', 'ala'),
(3, 'Albania', 'al', 'alb'),
(4, 'Algeria', 'dz', 'dza'),
(5, 'American Samoa', 'as', 'asm'),
(6, 'Andorra', 'ad', 'and'),
(7, 'Angola', 'ao', 'ago'),
(8, 'Anguilla', 'ai', 'aia'),
(9, 'Antarctica', 'aq', 'ata'),
(10, 'Antigua and Barbuda', 'ag', 'atg'),
(11, 'Argentina', 'ar', 'arg'),
(12, 'Armenia', 'am', 'arm'),
(13, 'Aruba', 'aw', 'abw'),
(14, 'Australia', 'au', 'aus'),
(15, 'Austria', 'at', 'aut'),
(16, 'Azerbaijan', 'az', 'aze'),
(17, 'Bahamas', 'bs', 'bhs'),
(18, 'Bahrain', 'bh', 'bhr'),
(19, 'Bangladesh', 'bd', 'bgd'),
(20, 'Barbados', 'bb', 'brb'),
(21, 'Belarus', 'by', 'blr'),
(22, 'Belgium', 'be', 'bel'),
(23, 'Belize', 'bz', 'blz'),
(24, 'Benin', 'bj', 'ben'),
(25, 'Bermuda', 'bm', 'bmu'),
(26, 'Bhutan', 'bt', 'btn'),
(27, 'Bolivia, Plurinational State of', 'bo', 'bol'),
(28, 'Bonaire, Sint Eustatius and Saba', 'bq', 'bes'),
(29, 'Bosnia and Herzegovina', 'ba', 'bih'),
(30, 'Botswana', 'bw', 'bwa'),
(31, 'Bouvet Island', 'bv', 'bvt'),
(32, 'Brazil', 'br', 'bra'),
(33, 'British Indian Ocean Territory', 'io', 'iot'),
(34, 'Brunei Darussalam', 'bn', 'brn'),
(35, 'Bulgaria', 'bg', 'bgr'),
(36, 'Burkina Faso', 'bf', 'bfa'),
(37, 'Burundi', 'bi', 'bdi'),
(38, 'Cambodia', 'kh', 'khm'),
(39, 'Cameroon', 'cm', 'cmr'),
(40, 'Canada', 'ca', 'can'),
(41, 'Cape Verde', 'cv', 'cpv'),
(42, 'Cayman Islands', 'ky', 'cym'),
(43, 'Central African Republic', 'cf', 'caf'),
(44, 'Chad', 'td', 'tcd'),
(45, 'Chile', 'cl', 'chl'),
(46, 'China', 'cn', 'chn'),
(47, 'Christmas Island', 'cx', 'cxr'),
(48, 'Cocos (Keeling) Islands', 'cc', 'cck'),
(49, 'Colombia', 'co', 'col'),
(50, 'Comoros', 'km', 'com'),
(51, 'Congo', 'cg', 'cog'),
(52, 'Congo, The Democratic Republic of the', 'cd', 'cod'),
(53, 'Cook Islands', 'ck', 'cok'),
(54, 'Costa Rica', 'cr', 'cri'),
(55, 'Cote d\'Ivoire', 'ci', 'civ'),
(56, 'Croatia', 'hr', 'hrv'),
(57, 'Cuba', 'cu', 'cub'),
(58, 'Curacao', 'cw', 'cuw'),
(59, 'Cyprus', 'cy', 'cyp'),
(60, 'Czech Republic', 'cz', 'cze'),
(61, 'Denmark', 'dk', 'dnk'),
(62, 'Djibouti', 'dj', 'dji'),
(63, 'Dominica', 'dm', 'dma'),
(64, 'Dominican Republic', 'do', 'dom'),
(65, 'Ecuador', 'ec', 'ecu'),
(66, 'Egypt', 'eg', 'egy'),
(67, 'El Salvador', 'sv', 'slv'),
(68, 'Equatorial Guinea', 'gq', 'gnq'),
(69, 'Eritrea', 'er', 'eri'),
(70, 'Estonia', 'ee', 'est'),
(71, 'Ethiopia', 'et', 'eth'),
(72, 'Falkland Islands (Malvinas)', 'fk', 'flk'),
(73, 'Faroe Islands', 'fo', 'fro'),
(74, 'Fiji', 'fj', 'fji'),
(75, 'Finland', 'fi', 'fin'),
(76, 'France', 'fr', 'fra'),
(77, 'French Guiana', 'gf', 'guf'),
(78, 'French Polynesia', 'pf', 'pyf'),
(79, 'French Southern Territories', 'tf', 'atf'),
(80, 'Gabon', 'ga', 'gab'),
(81, 'Gambia', 'gm', 'gmb'),
(82, 'Georgia', 'ge', 'geo'),
(83, 'Germany', 'de', 'deu'),
(84, 'Ghana', 'gh', 'gha'),
(85, 'Gibraltar', 'gi', 'gib'),
(86, 'Greece', 'gr', 'grc'),
(87, 'Greenland', 'gl', 'grl'),
(88, 'Grenada', 'gd', 'grd'),
(89, 'Guadeloupe', 'gp', 'glp'),
(90, 'Guam', 'gu', 'gum'),
(91, 'Guatemala', 'gt', 'gtm'),
(92, 'Guernsey', 'gg', 'ggy'),
(93, 'Guinea', 'gn', 'gin'),
(94, 'Guinea-Bissau', 'gw', 'gnb'),
(95, 'Guyana', 'gy', 'guy'),
(96, 'Haiti', 'ht', 'hti'),
(97, 'Heard Island and McDonald Islands', 'hm', 'hmd'),
(98, 'Holy See (Vatican City State)', 'va', 'vat'),
(99, 'Honduras', 'hn', 'hnd'),
(100, 'Hong Kong', 'hk', 'hkg'),
(101, 'Hungary', 'hu', 'hun'),
(102, 'Iceland', 'is', 'isl'),
(103, 'India', 'in', 'ind'),
(104, 'Indonesia', 'id', 'idn'),
(105, 'Iran, Islamic Republic of', 'ir', 'irn'),
(106, 'Iraq', 'iq', 'irq'),
(107, 'Ireland', 'ie', 'irl'),
(108, 'Isle of Man', 'im', 'imn'),
(109, 'Israel', 'il', 'isr'),
(110, 'Italy', 'it', 'ita'),
(111, 'Jamaica', 'jm', 'jam'),
(112, 'Japan', 'jp', 'jpn'),
(113, 'Jersey', 'je', 'jey'),
(114, 'Jordan', 'jo', 'jor'),
(115, 'Kazakhstan', 'kz', 'kaz'),
(116, 'Kenya', 'ke', 'ken'),
(117, 'Kiribati', 'ki', 'kir'),
(118, 'Korea, Democratic People\'s Republic of', 'kp', 'prk'),
(119, 'Korea, Republic of', 'kr', 'kor'),
(120, 'Kuwait', 'kw', 'kwt'),
(121, 'Kyrgyzstan', 'kg', 'kgz'),
(122, 'Lao People\'s Democratic Republic', 'la', 'lao'),
(123, 'Latvia', 'lv', 'lva'),
(124, 'Lebanon', 'lb', 'lbn'),
(125, 'Lesotho', 'ls', 'lso'),
(126, 'Liberia', 'lr', 'lbr'),
(127, 'Libyan Arab Jamahiriya', 'ly', 'lby'),
(128, 'Liechtenstein', 'li', 'lie'),
(129, 'Lithuania', 'lt', 'ltu'),
(130, 'Luxembourg', 'lu', 'lux'),
(131, 'Macao', 'mo', 'mac'),
(132, 'Macedonia, The former Yugoslav Republic of', 'mk', 'mkd'),
(133, 'Madagascar', 'mg', 'mdg'),
(134, 'Malawi', 'mw', 'mwi'),
(135, 'Malaysia', 'my', 'mys'),
(136, 'Maldives', 'mv', 'mdv'),
(137, 'Mali', 'ml', 'mli'),
(138, 'Malta', 'mt', 'mlt'),
(139, 'Marshall Islands', 'mh', 'mhl'),
(140, 'Martinique', 'mq', 'mtq'),
(141, 'Mauritania', 'mr', 'mrt'),
(142, 'Mauritius', 'mu', 'mus'),
(143, 'Mayotte', 'yt', 'myt'),
(144, 'Mexico', 'mx', 'mex'),
(145, 'Micronesia, Federated States of', 'fm', 'fsm'),
(146, 'Moldova, Republic of', 'md', 'mda'),
(147, 'Monaco', 'mc', 'mco'),
(148, 'Mongolia', 'mn', 'mng'),
(149, 'Montenegro', 'me', 'mne'),
(150, 'Montserrat', 'ms', 'msr'),
(151, 'Morocco', 'ma', 'mar'),
(152, 'Mozambique', 'mz', 'moz'),
(153, 'Myanmar', 'mm', 'mmr'),
(154, 'Namibia', 'na', 'nam'),
(155, 'Nauru', 'nr', 'nru'),
(156, 'Nepal', 'np', 'npl'),
(157, 'Netherlands', 'nl', 'nld'),
(158, 'New Caledonia', 'nc', 'ncl'),
(159, 'New Zealand', 'nz', 'nzl'),
(160, 'Nicaragua', 'ni', 'nic'),
(161, 'Niger', 'ne', 'ner'),
(162, 'Nigeria', 'ng', 'nga'),
(163, 'Niue', 'nu', 'niu'),
(164, 'Norfolk Island', 'nf', 'nfk'),
(165, 'Northern Mariana Islands', 'mp', 'mnp'),
(166, 'Norway', 'no', 'nor'),
(167, 'Oman', 'om', 'omn'),
(168, 'Pakistan', 'pk', 'pak'),
(169, 'Palau', 'pw', 'plw'),
(170, 'Palestinian Territory, Occupied', 'ps', 'pse'),
(171, 'Panama', 'pa', 'pan'),
(172, 'Papua New Guinea', 'pg', 'png'),
(173, 'Paraguay', 'py', 'pry'),
(174, 'Peru', 'pe', 'per'),
(175, 'Philippines', 'ph', 'phl'),
(176, 'Pitcairn', 'pn', 'pcn'),
(177, 'Poland', 'pl', 'pol'),
(178, 'Portugal', 'pt', 'prt'),
(179, 'Puerto Rico', 'pr', 'pri'),
(180, 'Qatar', 'qa', 'qat'),
(181, 'Reunion', 're', 'reu'),
(182, 'Romania', 'ro', 'rou'),
(183, 'Russian Federation', 'ru', 'rus'),
(184, 'Rwanda', 'rw', 'rwa'),
(185, 'Saint Barthelemy', 'bl', 'blm'),
(186, 'Saint Helena, Ascension and Tristan Da Cunha', 'sh', 'shn'),
(187, 'Saint Kitts and Nevis', 'kn', 'kna'),
(188, 'Saint Lucia', 'lc', 'lca'),
(189, 'Saint Martin (French Part)', 'mf', 'maf'),
(190, 'Saint Pierre and Miquelon', 'pm', 'spm'),
(191, 'Saint Vincent and The Grenadines', 'vc', 'vct'),
(192, 'Samoa', 'ws', 'wsm'),
(193, 'San Marino', 'sm', 'smr'),
(194, 'Sao Tome and Principe', 'st', 'stp'),
(195, 'Saudi Arabia', 'sa', 'sau'),
(196, 'Senegal', 'sn', 'sen'),
(197, 'Serbia', 'rs', 'srb'),
(198, 'Seychelles', 'sc', 'syc'),
(199, 'Sierra Leone', 'sl', 'sle'),
(200, 'Singapore', 'sg', 'sgp'),
(201, 'Sint Maarten (Dutch Part)', 'sx', 'sxm'),
(202, 'Slovakia', 'sk', 'svk'),
(203, 'Slovenia', 'si', 'svn'),
(204, 'Solomon Islands', 'sb', 'slb'),
(205, 'Somalia', 'so', 'som'),
(206, 'South Africa', 'za', 'zaf'),
(207, 'South Georgia and The South Sandwich Islands', 'gs', 'sgs'),
(208, 'South Sudan', 'ss', 'ssd'),
(209, 'Spain', 'es', 'esp'),
(210, 'Sri Lanka', 'lk', 'lka'),
(211, 'Sudan', 'sd', 'sdn'),
(212, 'Suriname', 'sr', 'sur'),
(213, 'Svalbard and Jan Mayen', 'sj', 'sjm'),
(214, 'Swaziland', 'sz', 'swz'),
(215, 'Sweden', 'se', 'swe'),
(216, 'Switzerland', 'ch', 'che'),
(217, 'Syrian Arab Republic', 'sy', 'syr'),
(218, 'Taiwan, Province of China', 'tw', 'twn'),
(219, 'Tajikistan', 'tj', 'tjk'),
(220, 'Tanzania, United Republic of', 'tz', 'tza'),
(221, 'Thailand', 'th', 'tha'),
(222, 'Timor-Leste', 'tl', 'tls'),
(223, 'Togo', 'tg', 'tgo'),
(224, 'Tokelau', 'tk', 'tkl'),
(225, 'Tonga', 'to', 'ton'),
(226, 'Trinidad and Tobago', 'tt', 'tto'),
(227, 'Tunisia', 'tn', 'tun'),
(228, 'Turkey', 'tr', 'tur'),
(229, 'Turkmenistan', 'tm', 'tkm'),
(230, 'Turks and Caicos Islands', 'tc', 'tca'),
(231, 'Tuvalu', 'tv', 'tuv'),
(232, 'Uganda', 'ug', 'uga'),
(233, 'Ukraine', 'ua', 'ukr'),
(234, 'United Arab Emirates', 'ae', 'are'),
(235, 'United Kingdom', 'gb', 'gbr'),
(236, 'United States', 'us', 'usa'),
(237, 'United States Minor Outlying Islands', 'um', 'umi'),
(238, 'Uruguay', 'uy', 'ury'),
(239, 'Uzbekistan', 'uz', 'uzb'),
(240, 'Vanuatu', 'vu', 'vut'),
(241, 'Venezuela, Bolivarian Republic of', 've', 'ven'),
(242, 'Viet Nam', 'vn', 'vnm'),
(243, 'Virgin Islands, British', 'vg', 'vgb'),
(244, 'Virgin Islands, U.S.', 'vi', 'vir'),
(245, 'Wallis and Futuna', 'wf', 'wlf'),
(246, 'Western Sahara', 'eh', 'esh'),
(247, 'Yemen', 'ye', 'yem'),
(248, 'Zambia', 'zm', 'zmb'),
(249, 'Zimbabwe', 'zw', 'zwe');

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

--
-- Table structure for table `donate_culector`
--

CREATE TABLE `donate_culector` (
  `id` int(111) NOT NULL,
  `dc_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `father` varchar(255) NOT NULL,
  `d_o_b` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `addr1` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `bankacc` varchar(255) NOT NULL,
  `ifsccode` varchar(255) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_branch` varchar(255) NOT NULL,
  `bank_address` varchar(255) NOT NULL,
  `dasignation` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `aadhaar` varchar(255) NOT NULL,
  `pancard` varchar(255) NOT NULL,
  `bankpass` varchar(255) NOT NULL,
  `exp_crt` varchar(255) NOT NULL,
  `cb` varchar(255) NOT NULL,
  `joining_date` date NOT NULL,
  `votercard` varchar(255) NOT NULL,
  `user_stetus` enum('Block','Un-Block') NOT NULL DEFAULT 'Un-Block'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `donate_culector`
--

INSERT INTO `donate_culector` (`id`, `dc_id`, `name`, `father`, `d_o_b`, `gender`, `email`, `phone`, `addr1`, `city`, `state`, `zip`, `country`, `bankacc`, `ifsccode`, `bank_name`, `bank_branch`, `bank_address`, `dasignation`, `image`, `signature`, `aadhaar`, `pancard`, `bankpass`, `exp_crt`, `cb`, `joining_date`, `votercard`, `user_stetus`) VALUES
(4, 'DC00001', 'AMIN', 'KHOSDIL', '1964-10-22', 'Male', 'amin2026@gmail.com', '7407084517', 'VILL-NADISHIK , SINGIA, CHANCHAL, MALDA (W.B) 732123\r\nmalda', 'MALDA', 'West Bengal', '732123', 'India', '651845448787', 'PUNB0094320', 'Punjab National Bank', 'GOURIA', 'P.O MALLICKPARA,DIST MALDA', 'Donation Collector', 'img/employee69c536eb61e44_1774532331.jpg', 'img/employee69c536eb621e9_1774532331.jpg', 'img/employee69c536eb62339_1774532331.jpg', 'img/employee69c536eb62826_1774532331.jpg', 'img/employee/DC00001Rabiul islamvai bank account.jpeg', 'img/employee69904f70ba87d_1771065200.jpg', 'img/employee/DC00001Rabiul islamvai adhar.jpeg', '2026-02-13', 'img/employee69c536eb62a48_1774532331.jpg', 'Un-Block'),
(5, 'DC00002', 'Hasen Ali', 'Madrasah', '1975-01-01', 'Male', 'hasen2025@gmail.com', '8906692627', 'Vill- Nadishik, Po-Singia, Ps-Chanchal, Dist-Malda, (W.B) 732123', 'CHANCHAL', 'West Bengal', '732123', 'India', 'REJAIN000000522', 'YESB0CMSNOC', 'Yes Bank', 'CMS NATIONAL OPERATING CENTRE MMR', 'YES BANK TOWER IFC2 8TH FLOOR SB MARG ELPHINSTONE MUMBAI 400013', 'Donation Collector', 'img/employee/DC00002Hasen Alic5e4edda-1c79-4c47-8092-7739d97d8511.jpg', 'img/employee/DC00002Hasen AliSIG.JPG', 'img/employee/DC00002Hasen AliADHAR.jpg', 'img/employee/DC00002Hasen AliVOTER.jpg', 'img/employee/DC00002Hasen AliADHAR.jpg', 'img/employee/DC00002Hasen AliVOTER.jpg', 'img/employee/DC00002Hasen AliADHAR.jpg', '2026-02-14', '', 'Un-Block'),
(8, 'DC00003', 'sam', 'jodu', '2000-01-01', 'Male', 'abcd@gmail.com', '2222222222', 'nadishik', 'chanchal', 'West Bengal', '732123', 'India', '', '', '', '', '', 'Donation Collector', 'img/employee/DC00003ramRaisuddin-removebg-preview (1).png', 'img/employee/DC00003ramRaisuddin-removebg-preview.png', 'img/employee/DC00003ramRAFIQUL_ISLAM-removebg-preview-removebg-preview.png', 'img/employee6992acb474370_1771220148.png', '', '', '', '2026-02-16', 'img/employee6992acb474592_1771220148.png', 'Un-Block');

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

--
-- Table structure for table `donate_request`
--

CREATE TABLE `donate_request` (
  `id` int(111) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `stetus` enum('SUCCESS','PENDING') NOT NULL,
  `UTR` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `donate_request`
--

INSERT INTO `donate_request` (`id`, `name`, `phone`, `email`, `amount`, `order_id`, `stetus`, `UTR`, `date`) VALUES
(1, 'Rabiul islam', '6296949862', 'skp14.business@gmail.com', '1', 'ORD_682ceae992fd0', 'PENDING', '', '2025-05-20 20:49:45'),
(2, 'Rabiul islam', '6296949862', 'skp14.business@gmail.com', '1', 'ORD_682ceb3c53939', 'PENDING', '', '2025-05-20 20:51:08'),
(3, 'Rabiul islam', '6296949862', 'skp14.business@gmail.com', '1', 'ORD_682cec92819ef', 'PENDING', '', '2025-05-20 20:56:50'),
(4, 'Rabiul Islam', '6296949862', 'rabiulmou786@gmail.com', '1', 'ORD_682cf1a849ba7', 'PENDING', '', '2025-05-20 21:18:32'),
(5, 'RABIUL ISLAM', '6296949862', 'rejaindia2021@gmail.com', '1', 'ORD_682d610d419a2', 'PENDING', '', '2025-05-21 05:13:49'),
(6, 'RABIUL ISLAM', '6296949862', 'skp14.businesss@gmail.com', '1', 'ORD_682d61870b98f', 'SUCCESS', '626849229033', '2025-05-21 05:15:51'),
(7, 'ARSHAD REJA', '7797149903', 'uti20021990@gmail.com', '1', 'ORD_682d6c88ddfdd', 'SUCCESS', '381796262395', '2025-05-21 06:02:48'),
(8, 'RAFIQUL ISLAM', '7797149903', 'rejaindia2021@gmail.com', '1', 'ORD_682d75b6f3379', 'SUCCESS', '077435484375', '2025-05-21 12:11:58'),
(9, 'RABIUL ISLAM', '6296949862', 'rejaindia2021@gmail.com', '1', 'ORD_682ebf1a477e5', 'PENDING', '', '2025-05-22 11:37:22'),
(10, 'RABIUL ISLAM', '6296949862', 'rejaindia2021@gmail.com', '1', 'ORD_682ec027829dd', 'PENDING', '', '2025-05-22 11:41:51'),
(11, 'Reja India Nidhi Limited', '6296949862', 'rejaindia2021@gmail.com', '1', 'ORD_682ec09544d93', 'PENDING', '', '2025-05-22 11:43:41'),
(12, 'ARSHAD REJA', '6296949862', 'j@gmail.com', '1', 'ORD_6837e963d4223', 'PENDING', '', '2025-05-29 10:28:11'),
(13, 'RABIUL ISLAM', '6296949862', 'j@gmail.com', '1', 'ORD_6837ec42a0fae', 'SUCCESS', '798428946993', '2025-05-29 10:40:26'),
(14, 'Reja India Nidhi Limited', '7797149903', 'rejaindia2021@gmail.com', '1', 'ORD_6837ed0f3fb5f', 'SUCCESS', '355533071183', '2025-05-29 10:43:51'),
(15, 'Reja India Nidhi Limited', '6296949862', 'skp14.businesss@gmail.com', '1', 'ORD_68380a108ed86', 'PENDING', '', '2025-05-29 12:47:36'),
(16, 'RABIUL ISLAM', '6296949862', 'skp14.businesss@gmail.com', '1', 'ORD_68380d5b90339', 'SUCCESS', '551528625084', '2025-05-29 13:01:39'),
(17, 'RAFIQUL ISLAM', '7797149903', 'ri12873@gmail.com', '10', 'ORD_683821acf3bb6', 'SUCCESS', '142929164263', '2025-05-29 14:28:20'),
(18, 'ASHIK REJA', '7797149903', 'ri12873@gmail.com', '3', 'ORD_68382a2c76463', 'SUCCESS', '514979700245', '2025-05-29 15:04:36'),
(19, 'RABIUL ISLAM', '6296949862', '', '500', 'ORD_683833932dfc6', 'PENDING', '', '2025-05-29 15:44:43'),
(20, 'RABIUL ISLAM', '6296949862', '', '500', 'ORD_683834681b5eb', 'PENDING', '', '2025-05-29 15:48:16'),
(21, 'RABIUL ISLAM', '6296949862', '', '500', 'ORD_6838346e953a1', 'PENDING', '', '2025-05-29 15:48:22'),
(22, 'RABIUL ISLAM', '6296949862', '', '500', 'ORD_683834e3a6b7a', 'PENDING', '', '2025-05-29 15:50:19'),
(23, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_6838358187278', 'SUCCESS', '091052992660', '2025-05-29 15:52:57'),
(24, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_68383ba3810a4', 'PENDING', '', '2025-05-29 16:19:07'),
(25, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_68383e6e8f38f', 'PENDING', '', '2025-05-29 16:31:02'),
(26, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_683844e5de9b7', 'PENDING', '', '2025-05-29 16:58:37'),
(27, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_68384815ea1fc', 'PENDING', '', '2025-05-29 17:12:13'),
(28, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_68384ad797a54', 'PENDING', '', '2025-05-29 17:23:59'),
(29, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_6839443e7b562', 'PENDING', '', '2025-05-30 11:08:06'),
(30, 'RABIUL ISLAM', '6296949862', '', '1', 'ORD_683948dded531', 'PENDING', '', '2025-05-30 11:27:49'),
(31, 'Rabiul islam', '6296949862', 'skp14.business@gmail.com', '1', 'ORD_683a093b15c7e', 'PENDING', '', '2025-05-31 01:08:35'),
(32, 'Rabiul islam', '6296949862', 'skp14.business@gmail.com', '1', 'ORD_683a0a8795ef0', 'SUCCESS', '862476482226', '2025-05-31 01:14:07'),
(33, 'Habibur Rahaman', '9851525527', 'sabun525527@gmail.com', '1', 'ORD_683a8b0f39f3a', 'SUCCESS', '293359247520', '2025-05-31 10:22:31'),
(34, 'RAFIQUL ISLAM', '7797149903', 'yesbank20021990@gmail.com', '3', 'ORD_683addb4bc6f1', 'PENDING', '', '2025-05-31 16:15:08'),
(35, 'RAFIQUL ISLAM', '7797149903', 'yesbank20021990@gmail.com', '3', 'ORD_683adddd5c8bd', 'SUCCESS', '515119387629', '2025-05-31 16:15:49'),
(36, 'REJA INDIA ECONOMIC WELFARE FOUNDATION', '7797149903', 'yesbank20021990@gmail.com', '2', 'ORD_683ade6f48f71', 'PENDING', '', '2025-05-31 16:18:15'),
(37, 'Najimul ali', '8169028306', 'abcd@gmail.com', '1', 'ORD_683c733f83431', 'SUCCESS', '584994631294', '2025-06-01 21:05:27'),
(38, 'Safedul hoque', '9971328263', 'safedulh@gmail.com', '1', 'ORD_683c785e430a9', 'SUCCESS', '614825666492', '2025-06-01 21:27:18'),
(39, 'Najimul ali', '8169028306', 'najimulhoque8306@gmail.com', '1', 'ORD_683d078624df3', 'PENDING', '', '2025-06-02 07:38:06'),
(40, 'Najimul Hoque', '8169028306', 'najimulhoque8306@gmail.com', '1', 'ORD_683d07bad3567', 'PENDING', '', '2025-06-02 07:38:58'),
(41, 'Najimul ali', '8169028306', 'abcd@gmail.com', '1', 'ORD_683d07fc3a861', 'PENDING', '', '2025-06-02 07:40:04'),
(42, 'Najimul Hoque', '8169028306', 'najimulhoque8306@gmail.com', '1', 'ORD_683d096d87315', 'PENDING', '', '2025-06-02 07:46:13'),
(43, 'RABIUL ISLAM', '6296949862', 'skp14.businesss@gmail.com', '1', 'ORD_683d9064d42c9', 'PENDING', '', '2025-06-02 17:22:04'),
(44, 'RABIUL ISLAM', '6296949862', 'skp14.businesss@gmail.com', '1', 'ORD_683d937968ba0', 'SUCCESS', '925206168517', '2025-06-02 17:35:13'),
(45, 'Newtech', '7973248482', 'Pbx3noorsingh@gmail.com', '1', 'ORD_683dc72bdddfd', 'PENDING', '', '2025-06-02 21:15:47'),
(46, 'Newtech', '7009058061', 'Pbx3noorsingh@gmail.com', '1', 'ORD_683dca03c88c4', 'PENDING', '', '2025-06-02 21:27:55'),
(47, 'Newtech', '7009058061', 'Pbx3noorsingh@gmail.com', '1', 'ORD_683dca2a271b2', 'PENDING', '', '2025-06-02 21:28:34'),
(48, 'REJAUL HOQUE', '9932037780', 'hoquerejaul1984@gmail.com', '1', 'ORD_683f2a242b788', 'SUCCESS', '384748795249', '2025-06-03 22:30:20'),
(49, 'REJAUL HOQUE', '9932037780', 'hoquerejaul1984@gmail.com', '1', 'ORD_683f2aa211171', 'PENDING', '', '2025-06-03 22:32:26'),
(50, 'REJAUL HOQUE', '9932037780', 'hoquerejaul1984@gmail.com', '1', 'ORD_683f2acd556f1', 'PENDING', '', '2025-06-03 22:33:09'),
(51, 'Rabiul islam', '6296949862', 'skp14.business@gmail.com', '1', 'ORD_6841ef76d8250', 'PENDING', '', '2025-06-06 00:56:46'),
(52, 'Rabiul islam', '6296949862', 'skp14.business@gmail.com', '1', 'ORD_68471dafdf464', 'SUCCESS', '254157764765', '2025-06-09 23:15:19'),
(53, 'Rabiul Islam', '06296949862', 'rabiulmou786@gmail.com', '1', 'ORD_684ed1c6d3ea1', 'PENDING', '', '2025-06-15 19:29:34'),
(54, 'Rabiul Islam', '06296949862', 'rabiulmou786@gmail.com', '1', 'ORD_68599c5bd8d7e', 'PENDING', '', '2025-06-23 23:56:35'),
(55, 'RIEWF', '7797149903', 'rejaindia2021@gmail.com', '1', 'ORD_686273fbd9a90', 'SUCCESS', '281324895156', '2025-06-30 16:54:43'),
(56, 'RIEWF', '7797149903', 'malati1972@gmail.com', '1', 'ORD_68720e709caa3', 'PENDING', '', '2025-07-12 12:57:44'),
(57, 'rafiqul', '7797149903', 'rejaindia2021@gmail.com', '1', 'ORD_68720e9ba3376', 'PENDING', '', '2025-07-12 12:58:27'),
(58, 'rafiqul', '7797149903', 'rejaindia2021@gmail.com', '2', 'ORD_68720eb83ec47', 'PENDING', '', '2025-07-12 12:58:56'),
(59, 'RAFIQUL ISLAM', '7797149903', 'YESBANK20021990@GMAIL.COM', '1', 'ORD_687cf4fc0ce20', 'PENDING', '', '2025-07-20 19:24:04'),
(60, 'RAFIQUL ISLAM', '7797149903', 'YESBANK20021990@GMAIL.COM', '1', 'ORD_687cf50313bea', 'PENDING', '', '2025-07-20 19:24:11'),
(61, 'Kishan Thumar', '09313711637', 'kishanthummar2990299@gmail.com', '1', 'ORD_68ab70402a3fa', 'PENDING', '', '2025-08-25 01:34:16'),
(62, 'Kishan Thumar', '09313711637', 'kishanthummar2990299@gmail.com', '1', 'ORD_68ab706ed7315', 'PENDING', '', '2025-08-25 01:35:02'),
(63, 'Kishan Thumar', '09313711637', 'kishanthummar2990299@gmail.com', '1', 'ORD_68ab707159d88', 'PENDING', '', '2025-08-25 01:35:05'),
(64, 'Kishan Thumar', '09313711637', 'kishanthummar2990299@gmail.com', '1', 'ORD_68ab7073586fb', 'PENDING', '', '2025-08-25 01:35:07'),
(65, 'RAFIQUL ISLAM', '7797149903', 'meherunnesha1975@gmail.com', '1', 'ORD_68aeca459f304', 'PENDING', '', '2025-08-27 14:35:09');

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

--
-- Table structure for table `employee_attendancee`
--

CREATE TABLE `employee_attendancee` (
  `id` int(111) NOT NULL,
  `emp_id` varchar(255) NOT NULL,
  `curr_date` date NOT NULL,
  `attendece_month` varchar(255) NOT NULL,
  `attendece_year` varchar(255) NOT NULL,
  `attendece` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employee_attendancee`
--

INSERT INTO `employee_attendancee` (`id`, `emp_id`, `curr_date`, `attendece_month`, `attendece_year`, `attendece`) VALUES
(27, 'EP00001', '2026-02-01', '02', '26', 'H'),
(28, 'EP00002', '2026-02-01', '02', '26', 'H'),
(29, 'EP00003', '2026-02-01', '02', '26', 'H'),
(30, 'EP00004', '2026-02-01', '02', '26', 'H'),
(31, 'EP00005', '2026-02-01', '02', '26', 'H'),
(32, 'EP00001', '2026-02-02', '02', '26', 'H'),
(33, 'EP00002', '2026-02-02', '02', '26', 'H'),
(34, 'EP00003', '2026-02-02', '02', '26', 'H'),
(35, 'EP00004', '2026-02-02', '02', '26', 'H'),
(36, 'EP00005', '2026-02-02', '02', '26', 'H'),
(37, 'EP00001', '2026-02-03', '02', '26', 'H'),
(38, 'EP00002', '2026-02-03', '02', '26', 'H'),
(39, 'EP00003', '2026-02-03', '02', '26', 'H'),
(40, 'EP00004', '2026-02-03', '02', '26', 'H'),
(41, 'EP00005', '2026-02-03', '02', '26', 'H'),
(42, 'EP00001', '2026-02-04', '02', '26', 'H'),
(43, 'EP00002', '2026-02-04', '02', '26', 'H'),
(44, 'EP00003', '2026-02-04', '02', '26', 'H'),
(45, 'EP00004', '2026-02-04', '02', '26', 'H'),
(46, 'EP00005', '2026-02-04', '02', '26', 'H'),
(47, 'EP00001', '2026-02-05', '02', '26', 'H'),
(48, 'EP00002', '2026-02-05', '02', '26', 'H'),
(49, 'EP00003', '2026-02-05', '02', '26', 'H'),
(50, 'EP00004', '2026-02-05', '02', '26', 'H'),
(51, 'EP00005', '2026-02-05', '02', '26', 'H');

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

--
-- Table structure for table `emp_permission`
--

CREATE TABLE `emp_permission` (
  `id` int(20) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `module_name` varchar(350) NOT NULL,
  `pread` varchar(20) NOT NULL,
  `pcreate` varchar(20) NOT NULL,
  `pupdate` varchar(20) NOT NULL,
  `pdelete` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `emp_permission`
--

INSERT INTO `emp_permission` (`id`, `tid`, `module_name`, `pread`, `pcreate`, `pupdate`, `pdelete`) VALUES
(57, 'EP00002', 'Admin', '1', '', '', ''),
(58, 'EP00002', 'Madrasah Profile', '1', '1', '1', '1'),
(59, 'EP00002', 'Bank Master', '1', '1', '1', '1'),
(60, 'EP00002', 'Audit Report', '1', '1', '1', '1'),
(61, 'EP00002', 'Permission Module', '1', '', '', ''),
(62, 'EP00002', 'Add Permission', '1', '1', '1', '1'),
(63, 'EP00002', 'Permission List', '1', '1', '1', '1'),
(64, 'EP00002', 'Master', '1', '', '', ''),
(65, 'EP00002', 'Class Master', '1', '1', '1', '1'),
(66, 'EP00002', 'Subject Master', '1', '1', '1', '1'),
(67, 'EP00002', 'Salary Master', '1', '1', '1', '1'),
(68, 'EP00002', 'Payroll', '1', '', '', ''),
(69, 'EP00002', 'Salary Paid History', '1', '1', '1', '1'),
(70, 'EP00002', 'Salary Payment', '1', '1', '1', '1'),
(71, 'EP00002', 'Student', '1', '', '', ''),
(72, 'EP00002', 'New Student', '1', '1', '1', '1'),
(73, 'EP00002', 'Student List', '1', '1', '1', '1'),
(74, 'EP00002', 'Student ID Card', '1', '1', '1', '1'),
(75, 'EP00002', 'Student Admid Card', '1', '1', '1', '1'),
(76, 'EP00002', 'Student Result', '1', '1', '1', '1'),
(77, 'EP00002', 'Student Certificate', '1', '1', '1', '1'),
(78, 'EP00002', 'Student Markshit', '1', '1', '1', '1'),
(79, 'EP00002', 'Student Cerakter Certificate', '1', '1', '1', '1'),
(80, 'EP00002', 'Employee', '1', '', '', ''),
(81, 'EP00002', 'New Employee', '1', '1', '1', '1'),
(82, 'EP00002', 'Employee List', '1', '1', '1', '1'),
(83, 'EP00002', 'Employee ID Card', '1', '1', '1', '1'),
(84, 'EP00002', 'Donat Collector', '1', '', '', ''),
(85, 'EP00002', 'New Donat Collector', '1', '1', '1', '1'),
(86, 'EP00002', 'Donat Collector List', '1', '1', '1', '1'),
(87, 'EP00002', 'Donat Collector ID Card', '1', '1', '1', '1'),
(88, 'EP00002', 'Attendance', '1', '', '', ''),
(89, 'EP00002', 'Student Attendance', '1', '1', '1', '1'),
(90, 'EP00002', 'Employee Attendance', '1', '1', '1', '1'),
(91, 'EP00002', 'Student Attendance Report', '1', '1', '1', '1'),
(92, 'EP00002', 'Employee Attendance Report', '1', '1', '1', '1'),
(93, 'EP00002', 'Notice', '1', '', '', ''),
(94, 'EP00002', 'Creat Notice', '1', '1', '1', '1'),
(95, 'EP00002', 'Notice List', '1', '1', '1', '1'),
(96, 'EP00001', 'Admin', '1', '1', '1', '1'),
(97, 'EP00001', 'Madrasah Profile', '1', '1', '1', '1'),
(98, 'EP00001', 'Bank Master', '1', '1', '1', '1'),
(99, 'EP00001', 'Audit Report', '1', '1', '1', '1'),
(100, 'EP00001', 'Permission Module', '1', '1', '1', '1'),
(101, 'EP00001', 'Add Permission', '1', '1', '1', '1'),
(102, 'EP00001', 'Permission List', '1', '1', '1', '1'),
(103, 'EP00001', 'Master', '1', '1', '1', '1'),
(104, 'EP00001', 'Class Master', '1', '1', '1', '1'),
(105, 'EP00001', 'Subject Master', '1', '1', '1', '1'),
(106, 'EP00001', 'Salary Master', '1', '1', '1', '1'),
(107, 'EP00001', 'Payroll', '1', '1', '1', '1'),
(108, 'EP00001', 'Salary Paid History', '1', '1', '1', '1'),
(109, 'EP00001', 'Salary Payment', '1', '1', '1', '1'),
(110, 'EP00001', 'Student', '1', '1', '1', '1'),
(111, 'EP00001', 'New Student', '1', '1', '1', '1'),
(112, 'EP00001', 'Student List', '1', '1', '1', '1'),
(113, 'EP00001', 'Student ID Card', '1', '1', '1', '1'),
(114, 'EP00001', 'Student Admid Card', '1', '1', '1', '1'),
(115, 'EP00001', 'Student Result', '1', '1', '1', '1'),
(116, 'EP00001', 'Student Certificate', '1', '1', '1', '1'),
(117, 'EP00001', 'Student Markshit', '1', '1', '1', '1'),
(118, 'EP00001', 'Student Cerakter Certificate', '1', '1', '1', '1'),
(119, 'EP00001', 'Employee', '1', '1', '1', '1'),
(120, 'EP00001', 'New Employee', '1', '1', '1', '1'),
(121, 'EP00001', 'Employee List', '1', '1', '1', '1'),
(122, 'EP00001', 'Employee ID Card', '1', '1', '1', '1'),
(123, 'EP00001', 'Donat Collector', '1', '1', '1', '1'),
(124, 'EP00001', 'New Donat Collector', '1', '1', '1', '1'),
(125, 'EP00001', 'Donat Collector List', '1', '1', '1', '1'),
(126, 'EP00001', 'Donat Collector ID Card', '1', '1', '1', '1'),
(127, 'EP00001', 'Attendance', '1', '1', '1', '1'),
(128, 'EP00001', 'Student Attendance', '1', '1', '1', '1'),
(129, 'EP00001', 'Employee Attendance', '1', '1', '1', '1'),
(130, 'EP00001', 'Student Attendance Report', '1', '1', '1', '1'),
(131, 'EP00001', 'Employee Attendance Report', '1', '1', '1', '1'),
(132, 'EP00001', 'Notice', '1', '1', '1', '1'),
(133, 'EP00001', 'Creat Notice', '1', '1', '1', '1'),
(134, 'EP00001', 'Notice List', '1', '1', '1', '1');

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

--
-- Table structure for table `emp_role`
--

CREATE TABLE `emp_role` (
  `id` int(11) NOT NULL,
  `role` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `exam`
--

CREATE TABLE `exam` (
  `id` int(111) NOT NULL,
  `exam_name` varchar(255) NOT NULL,
  `exam_year` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exam`
--

INSERT INTO `exam` (`id`, `exam_name`, `exam_year`) VALUES
(1, '1st test ', '2025'),
(3, 'Final Exam', '2025');

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

--
-- Table structure for table `examtimetabale`
--

CREATE TABLE `examtimetabale` (
  `id` int(111) NOT NULL,
  `examname` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `table` varchar(255) NOT NULL,
  `acyear` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `examtimetabale`
--

INSERT INTO `examtimetabale` (`id`, `examname`, `class`, `subject`, `date`, `table`, `acyear`) VALUES
(3, '1st test ', 'Dorja Najra ( الباب مفتوح )', 'Quran Majeed ( قرآن مجيد )', '2026-03-26', '13:20', '2026'),
(4, '1st test ', 'Dorja Najra ( الباب مفتوح )', 'Urdu ( الأردية )', '2026-03-24', '13:20', '2026'),
(5, '1st test ', 'Dorja Tahataniya ( الباب مغلق )', 'Nuraani Talim Aowal ( نوراني تعليم أول )', '2026-03-24', '16:41', '2026'),
(6, '1st test ', 'Dorja Tahataniya ( الباب مغلق )', 'Tamire Aadob Aaowal ( بداية الآداب )', '2026-03-24', '16:41', '2026'),
(7, '1st test ', 'Dorja Tahataniya ( الباب مغلق )', 'Kerat ( كيرات )', '2026-03-24', '16:41', '2026'),
(8, '1st test ', 'Dorja Tahataniya ( الباب مغلق )', 'Nurani Talim Duom ( قبة نوراني تاليم )', '2026-03-24', '16:41', '2026'),
(9, '1st test ', 'Dorja Tahataniya ( الباب مغلق )', 'Tamiri Adam Duom ( هذا هو يوم آدم الخاص بي. )', '2026-03-24', '16:41', '2026');

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

--
-- Table structure for table `exam_marks`
--

CREATE TABLE `exam_marks` (
  `id` int(111) NOT NULL,
  `exam_name` varchar(255) NOT NULL,
  `subject_name` varchar(255) NOT NULL,
  `full_marks` varchar(255) NOT NULL,
  `pass_marks` varchar(255) NOT NULL,
  `class` varchar(222) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exam_marks`
--

INSERT INTO `exam_marks` (`id`, `exam_name`, `subject_name`, `full_marks`, `pass_marks`, `class`) VALUES
(8, '1st test ', 'Quran Majeed ( قرآن مجيد )', '100', '25', 'Dorja Najra ( الباب مفتوح )'),
(9, '1st test ', 'Urdu ( الأردية )', '100', '25', 'Dorja Najra ( الباب مفتوح )'),
(10, '1st test ', 'Nuraani Talim Aowal ( نوراني تعليم أول )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(11, '1st test ', 'Tamire Aadob Aaowal ( بداية الآداب )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(12, '1st test ', 'Kerat ( كيرات )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(13, '1st test ', 'Nurani Talim Duom ( قبة نوراني تاليم )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(14, '1st test ', 'Tamiri Adam Duom ( هذا هو يوم آدم الخاص بي. )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(15, '1st test ', 'FarsikiPoili ( الفارسية )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(16, '1st test ', 'Tashilul Msadir ( تسهيل المصادر )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(17, '1st test ', 'Minhajul Arbiya Aowal ( منهاج العربية الأولى )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(18, '1st test ', 'Tamike Kaoayedd ( تاميكا كاويد )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(19, '1st test ', 'Rashule Ekhram ( رسول إكرام )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(20, '1st test ', 'Kanune Soriyat Duom ( الشريعة في القبة )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(21, '1st test ', 'Anoyare Soriyat ( الشريعة في أنور )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(22, '1st test ', 'Maarfte Tajid ( تاجيد عبر )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(23, '1st test ', 'Mijanussrf ( ميزانوسراف )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(24, '1st test ', 'Faijula aadob ( فيض الأدب )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(25, '1st test ', 'Farsi kidsari ( كيدزيري الفارسية )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(26, '1st test ', 'Minhajul Arabia Duom ( منهاجول عربي دوم )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(27, '1st test ', 'All Montik (آل مونتيك)', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(28, '1st test ', 'Kanune Sariat Aowal ( الشريعة الإسلامية هي القانون الأول. )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(29, '1st test ', 'Marifte Tajit ( معرفة التجديد )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(30, '1st test ', 'Nohmir ( نوهمير )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(31, '1st test ', 'Pangiganji ( بانجيجانجي )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(32, '1st test ', 'Gulseta ( جولسيتا )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(33, '1st test ', 'Islami Ekhlak o Adab ( الأخلاق والآداب الإسلامية )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(34, '1st test ', 'Nejame Sariat ( الشريعة في نظام )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(35, '1st test ', 'Faijul Adab Duom ( قبة فيض الأدب )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(36, '1st test ', 'Jiaul Kerat ( زياول كيرات )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(37, '1st test ', 'Hedaitul Nuh ( هداية نوح )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(38, '1st test ', 'Ilmush Sega ( إيلموش سيجا )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(39, '1st test ', 'Nurul Eja ( نورول إيجا )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(40, '1st test ', 'Sorho Miatamil ( شاراه ميا تاميل )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(41, '1st test ', 'Mirkat ( الميركات )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(42, '1st test ', 'Muallemul Insa ( معلم إنشاء )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(43, '1st test ', 'Jiaul Kerat ( زياول كيرات )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(44, '1st test ', 'Kafiya ( قهوة )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(45, '1st test ', 'Osulos sasi ( أوسولوس ساسي )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(46, '1st test ', 'Soroh Tahajib ( تفسير التهجيب )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(47, '1st test ', 'Mukhtasarul kuduri ( مختصر الكودوري )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(48, '1st test ', 'Muallmul Insa ( معلم إنشاء )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(49, '1st test ', 'Jiaul Kerat ( زياول كيرات )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(50, '1st test ', 'Soroh Jami (شاروخ جامي)', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(51, '1st test ', 'Soroh Akaya ( السر واضح . )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(52, '1st test ', 'Nurul Anoar ( نورول أنور )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(53, '1st test ', 'Muao Imam Mohammad ( معاوية امام محمد )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(54, '1st test ', 'Kutbi ( كتبي )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(55, '1st test ', 'Riajus Salehin ( رياض الصالحين )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(56, '1st test ', 'Jameul Owakof ( جامع الوقف )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(57, '1st test ', 'Tofsire Jalalain ( الجلالين في التفسير )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(58, '1st test ', 'Miskat Sorif ( مشكاة شريف )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(59, '1st test ', 'Soroh Akaya Duom ( قبة شراه أكيا )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(60, '1st test ', 'Hedaya Aowalin ( هداية عوالين )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(61, '1st test ', 'Deoane MutNabbi ( ديوان المتنبي )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(62, '1st test ', 'Mollahason ( مالهسون )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(63, '1st test ', 'Tolkhisul Miktah ( التلخيص الميكتا )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(64, '1st test ', 'Jalalain Sorif ( جلالين شريف )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(65, '1st test ', 'Mukhtasarul Moni ( مختصر الموني )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(66, '1st test ', 'Siraji ( سيرازي )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(67, '1st test ', 'Al Balagatul Oajeh ( البلاغة الواضحة )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(68, '1st test ', 'Saba Muallaka ( سابا معلقا )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(69, '1st test ', 'Muwallemul Insasom ( مبالمول إنشاسوم )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(70, '1st test ', 'Bahare Soriyat ( الشريعة في بهار )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(71, '1st test ', 'Tirmijisorif Aowal ( الترمذي شريف أول )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(72, '1st test ', 'Huss Sami ( حسن سامي )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(73, '1st test ', 'Diowane  Hamsa ( ديوان حمسه )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(74, '1st test ', 'Madarejul Tonjil ( مادريزول تنزيل )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(75, '1st test ', 'Abu Daoud Sarif ( أبو داود الشريف )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(76, '1st test ', 'Muwallemul Insasom ( مبالمول إنشاسوم )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(77, '1st test ', 'Bahare Sariyat ( الشريعة في بهار )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(78, '1st test ', 'Bukhari Sarif ( البخاري شريف )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(79, '1st test ', 'baijaui Sarif ( بيجاوي شريف )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(80, '1st test ', 'Muslim Sarif ( مسلم شريف )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(81, '1st test ', 'Nesai Sarif ( شريف مخمور )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(82, '1st test ', 'Ibnee Maja ( ابن ماجه )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(83, 'Final Exam', 'Quran Majeed ( قرآن مجيد )', '100', '25', 'Dorja Najra ( الباب مفتوح )'),
(84, 'Final Exam', 'Urdu ( الأردية )', '100', '25', 'Dorja Najra ( الباب مفتوح )'),
(85, 'Final Exam', 'Nuraani Talim Aowal ( نوراني تعليم أول )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(86, 'Final Exam', 'Tamire Aadob Aaowal ( بداية الآداب )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(87, 'Final Exam', 'Kerat ( كيرات )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(88, 'Final Exam', 'Nurani Talim Duom ( قبة نوراني تاليم )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(89, 'Final Exam', 'Tamiri Adam Duom ( هذا هو يوم آدم الخاص بي. )', '100', '25', 'Dorja Tahataniya ( الباب مغلق )'),
(90, 'Final Exam', 'FarsikiPoili ( الفارسية )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(91, 'Final Exam', 'Tashilul Msadir ( تسهيل المصادر )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(92, 'Final Exam', 'Minhajul Arbiya Aowal ( منهاج العربية الأولى )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(93, 'Final Exam', 'Tamike Kaoayedd ( تاميكا كاويد )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(94, 'Final Exam', 'Rashule Ekhram ( رسول إكرام )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(95, 'Final Exam', 'Kanune Soriyat Duom ( الشريعة في القبة )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(96, 'Final Exam', 'Anoyare Soriyat ( الشريعة في أنور )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(97, 'Final Exam', 'Maarfte Tajid ( تاجيد عبر )', '100', '25', 'Dorja Ibtedaiya ( الباب مفتوح )'),
(98, 'Final Exam', 'Mijanussrf ( ميزانوسراف )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(99, 'Final Exam', 'Faijula aadob ( فيض الأدب )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(100, 'Final Exam', 'Farsi kidsari ( كيدزيري الفارسية )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(101, 'Final Exam', 'Minhajul Arabia Duom ( منهاجول عربي دوم )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(102, 'Final Exam', 'All Montik (آل مونتيك)', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(103, 'Final Exam', 'Kanune Sariat Aowal ( الشريعة الإسلامية هي القانون الأول. )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(104, 'Final Exam', 'Marifte Tajit ( معرفة التجديد )', '100', '25', 'Dorja Edadiya ( الباب مفتوح )'),
(105, 'Final Exam', 'Nohmir ( نوهمير )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(106, 'Final Exam', 'Pangiganji ( بانجيجانجي )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(107, 'Final Exam', 'Gulseta ( جولسيتا )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(108, 'Final Exam', 'Islami Ekhlak o Adab ( الأخلاق والآداب الإسلامية )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(109, 'Final Exam', 'Nejame Sariat ( الشريعة في نظام )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(110, 'Final Exam', 'Faijul Adab Duom ( قبة فيض الأدب )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(111, 'Final Exam', 'Jiaul Kerat ( زياول كيرات )', '100', '25', 'Dorja Ula ( افتح الباب )'),
(112, 'Final Exam', 'Hedaitul Nuh ( هداية نوح )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(113, 'Final Exam', 'Ilmush Sega ( إيلموش سيجا )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(114, 'Final Exam', 'Nurul Eja ( نورول إيجا )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(115, 'Final Exam', 'Sorho Miatamil ( شاراه ميا تاميل )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(116, 'Final Exam', 'Mirkat ( الميركات )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(117, 'Final Exam', 'Muallemul Insa ( معلم إنشاء )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(118, 'Final Exam', 'Jiaul Kerat ( زياول كيرات )', '100', '25', 'Dorja Saniya ( الباب سانيا )'),
(119, 'Final Exam', 'Kafiya ( قهوة )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(120, 'Final Exam', 'Osulos sasi ( أوسولوس ساسي )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(121, 'Final Exam', 'Soroh Tahajib ( تفسير التهجيب )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(122, 'Final Exam', 'Mukhtasarul kuduri ( مختصر الكودوري )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(123, 'Final Exam', 'Muallmul Insa ( معلم إنشاء )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(124, 'Final Exam', 'Jiaul Kerat ( زياول كيرات )', '100', '25', 'Dorja Salesa ( مبيعات الباب )'),
(125, 'Final Exam', 'Soroh Jami (شاروخ جامي)', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(126, 'Final Exam', 'Soroh Akaya ( السر واضح . )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(127, 'Final Exam', 'Nurul Anoar ( نورول أنور )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(128, 'Final Exam', 'Muao Imam Mohammad ( معاوية امام محمد )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(129, 'Final Exam', 'Kutbi ( كتبي )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(130, 'Final Exam', 'Riajus Salehin ( رياض الصالحين )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(131, 'Final Exam', 'Jameul Owakof ( جامع الوقف )', '100', '25', 'Dorja Rabiya ( الباب مغلق )'),
(132, 'Final Exam', 'Tofsire Jalalain ( الجلالين في التفسير )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(133, 'Final Exam', 'Miskat Sorif ( مشكاة شريف )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(134, 'Final Exam', 'Soroh Akaya Duom ( قبة شراه أكيا )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(135, 'Final Exam', 'Hedaya Aowalin ( هداية عوالين )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(136, 'Final Exam', 'Deoane MutNabbi ( ديوان المتنبي )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(137, 'Final Exam', 'Mollahason ( مالهسون )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(138, 'Final Exam', 'Tolkhisul Miktah ( التلخيص الميكتا )', '100', '25', 'Dorja Khamisa ( الباب مفتوح )'),
(139, 'Final Exam', 'Jalalain Sorif ( جلالين شريف )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(140, 'Final Exam', 'Mukhtasarul Moni ( مختصر الموني )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(141, 'Final Exam', 'Siraji ( سيرازي )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(142, 'Final Exam', 'Al Balagatul Oajeh ( البلاغة الواضحة )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(143, 'Final Exam', 'Saba Muallaka ( سابا معلقا )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(144, 'Final Exam', 'Muwallemul Insasom ( مبالمول إنشاسوم )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(145, 'Final Exam', 'Bahare Soriyat ( الشريعة في بهار )', '100', '25', 'Dorja Sadesa ( الباب مغلق )'),
(146, 'Final Exam', 'Tirmijisorif Aowal ( الترمذي شريف أول )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(147, 'Final Exam', 'Huss Sami ( حسن سامي )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(148, 'Final Exam', 'Diowane  Hamsa ( ديوان حمسه )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(149, 'Final Exam', 'Madarejul Tonjil ( مادريزول تنزيل )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(150, 'Final Exam', 'Abu Daoud Sarif ( أبو داود الشريف )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(151, 'Final Exam', 'Muwallemul Insasom ( مبالمول إنشاسوم )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(152, 'Final Exam', 'Bahare Sariyat ( الشريعة في بهار )', '100', '25', 'Dorja Sabea ( الباب مفتوح )'),
(153, 'Final Exam', 'Bukhari Sarif ( البخاري شريف )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(154, 'Final Exam', 'baijaui Sarif ( بيجاوي شريف )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(155, 'Final Exam', 'Muslim Sarif ( مسلم شريف )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(156, 'Final Exam', 'Nesai Sarif ( شريف مخمور )', '100', '25', 'Dorja Samena ( الباب سامينا )'),
(157, 'Final Exam', 'Ibnee Maja ( ابن ماجه )', '100', '25', 'Dorja Samena ( الباب سامينا )');

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

--
-- Table structure for table `footer`
--

CREATE TABLE `footer` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `pho` varchar(200) NOT NULL,
  `face` varchar(200) NOT NULL,
  `webs` varchar(200) NOT NULL,
  `conh` varchar(200) NOT NULL,
  `twi` varchar(200) NOT NULL,
  `gplus` varchar(200) NOT NULL,
  `ins` varchar(200) NOT NULL,
  `yous` varchar(200) NOT NULL,
  `about` text NOT NULL,
  `apply` text NOT NULL,
  `mission` text NOT NULL,
  `objective` text NOT NULL,
  `map` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `footer`
--

INSERT INTO `footer` (`id`, `email`, `pho`, `face`, `webs`, `conh`, `twi`, `gplus`, `ins`, `yous`, `about`, `apply`, `mission`, `objective`, `map`) VALUES
(2, 'info@bequesters.com', '+233808883675466', 'www.facebook.com/info@bequesters', 'www.bequesters.com', 'Lasvegas USA', 'www.twitter.com/info@bequesters', 'www.googleplus.com/oinfo@bequesters', 'www.in.com/info@bequesters', 'www.youtube.com/info@bequesters', 'About the system here. Thanks, We are just testing the software and we discover that the software is errors free. Thanks once again.', 'Who may apply here. Thabnks', 'Mission here. Thanks', 'System OBJECTIVE HERE. Thanks', '');

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

--
-- Table structure for table `hostel_donate_membar`
--

CREATE TABLE `hostel_donate_membar` (
  `id` int(111) NOT NULL,
  `hdmid` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `d-o-b` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `stetus` enum('Active','Block') NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostel_donate_membar`
--

INSERT INTO `hostel_donate_membar` (`id`, `hdmid`, `name`, `father_name`, `d-o-b`, `gender`, `phone`, `email`, `address`, `image`, `date`, `designation`, `stetus`) VALUES
(2, 'MHDM00001', 'Rafiqul Islam', 'Md Sarif', '1990-02-20', 'Male', '7797149903', 'ri12873@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/MHDM00001_6996d8c4109c3_1771493572.png', '30-07-2025', 'Vip Membar', 'Active'),
(3, 'MHDM00002', 'Nur Islam', 'Golam Rabbani ', '1982-01-02', 'Male', '7431810411', 'nurislam@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/MHDM00002_6996d96914cbe_1771493737.jpg', '16-02-2026', 'Vip Membar', 'Active');

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

--
-- Table structure for table `Income`
--

CREATE TABLE `Income` (
  `id` int(111) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `discription` varchar(255) NOT NULL,
  `date_timee` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `loan_info`
--

CREATE TABLE `loan_info` (
  `id` int(20) NOT NULL,
  `loan_id` varchar(252) NOT NULL,
  `borrower_id` varchar(200) NOT NULL,
  `Branch` varchar(200) NOT NULL,
  `baccount` varchar(200) NOT NULL,
  `name` text NOT NULL,
  `Phone` text NOT NULL,
  `Address` text NOT NULL,
  `Loan_Type` text NOT NULL,
  `l_terms` varchar(200) NOT NULL,
  `L_Duration` text NOT NULL,
  `amount` varchar(200) NOT NULL,
  `Total_Amount` varchar(200) NOT NULL,
  `T_Int_Amount` varchar(200) NOT NULL,
  `Emi_Amount` varchar(200) NOT NULL,
  `Loan_Fee` varchar(200) NOT NULL,
  `Inc_Fee` varchar(200) NOT NULL,
  `admincharge` varchar(255) NOT NULL,
  `gstfee` varchar(255) NOT NULL,
  `T_pay_Amount` varchar(200) NOT NULL,
  `Start_Date` varchar(200) NOT NULL,
  `pay_date` varchar(200) NOT NULL,
  `amount_topay` varchar(200) NOT NULL,
  `teller` varchar(200) NOT NULL,
  `remark` text NOT NULL,
  `status` enum('Pending','Approved','Reject') NOT NULL,
  `upstatus` enum('Under Proccess','Approved','Reject') NOT NULL,
  `Active_stetus` enum('Unctive','Active','Close') NOT NULL,
  `apply_date` text NOT NULL,
  `Gold_type` varchar(255) NOT NULL,
  `markt_price_p_gram` varchar(255) NOT NULL,
  `gold_Weight` text NOT NULL,
  `gold_calculet_price` varchar(255) NOT NULL,
  `Gold_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `membar`
--

CREATE TABLE `membar` (
  `id` int(111) NOT NULL,
  `nmid` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `d-o-b` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `stetus` enum('Active','Block') NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membar`
--

INSERT INTO `membar` (`id`, `nmid`, `name`, `father_name`, `d-o-b`, `gender`, `phone`, `email`, `address`, `image`, `date`, `designation`, `stetus`) VALUES
(21, 'MM00001', 'RAFIQUL ISLAM', 'MD SARIF', '1990-02-20', 'Male', '7797149903', 'ri12873@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6992c8e3aac33_1771227363.png', '30-05-2025', 'Madrash Membar', 'Active'),
(22, 'MM00002', 'SK HAMEDUR RAHAMAN', 'PIYARUDDIN', '1971-01-15', 'Male', '9647890530', 'hamedur1971@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6992c9672f6da_1771227495.png', '01-06-2025', 'Madrash Membar', 'Active'),
(23, 'MM00003', 'MUSTAQUE ALAM', 'SARFUR RAHAMAN', '1980-01-01', 'Male', '9563241042', 'mustaque2026@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6992c9ca50125_1771227594.jpg', '02-06-2025', 'Madrash Membar', 'Active'),
(24, 'MM00004', 'Sahabuddin Ahamed', 'Anowar', '1972-01-01', 'Male', '9735021302', 'sahabuddin@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6996d55771a5e_1771492695.jpg', '30-07-2025', 'Madrash Membar', 'Active'),
(25, 'MM00005', 'Samad Ali', 'Ajijur Rahaman', '1987-01-01', 'Male', '8145134520', 'samad@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6996d5b56a605_1771492789.jpg', '', 'Madrash Membar', 'Active'),
(26, 'MM00006', 'Kurban Ali', 'Samshuddin', '1962-01-01', 'Male', '8145796358', 'kurban@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6996d5ffc6377_1771492863.jpg', '16-02-2026', 'Madrash Membar', 'Active'),
(27, 'MM00007', 'Md Raju', 'Md Faruque Hossain', '1987-01-01', 'Male', '89065911616', 'mdraju@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6996d68e04020_1771493006.jpg', '16-02-2026', 'Madrash Membar', 'Active'),
(28, 'MM00008', 'Arfin Hossain', 'Jalaluddin', '1666-01-01', 'Male', '6665522589', 'arfin@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6996d713d5a48_1771493139.jpg', '16-02-2026', 'Madrash Membar', 'Active'),
(29, 'MM00009', 'Majifur Rahaman', 'Chand Mohammad', '1977-01-01', 'Male', '9800821516', 'majifur@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/6996d75e71ac6_1771493214.jpg', '18-02-2026', 'Madrash Membar', 'Active');

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(200) NOT NULL,
  `sender_id` varchar(200) NOT NULL,
  `sender_name` varchar(200) NOT NULL,
  `msg_to` varchar(200) NOT NULL,
  `subject` varchar(300) NOT NULL,
  `message` text NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `message`
--

INSERT INTO `message` (`id`, `sender_id`, `sender_name`, `msg_to`, `subject`, `message`, `date_time`) VALUES
(4, 'Cryptos?rid=782752', 'au JJJ', 'Loan=21319580', 'Hello', '<p>Good to see you</p>\r\n', '2017-05-01 18:46:57'),
(5, 'Loan=21319580', 'Admin', 'Cryptos?rid=782752', 'RE: Hello', '<p>Thanks<br />\r\n-------------------------</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Good to see you</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2017-05-01 18:48:27'),
(6, 'Cryptos?rid=782752', 'au JJJ', 'Loan=21319580', 'RE: RE: Hello', '<p>Thanks&nbsp; you<br />\r\n-------------------------</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thanks<br />\r\n-------------------------</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Good to see you</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2017-05-01 18:49:18');

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

--
-- Table structure for table `mywallet`
--

CREATE TABLE `mywallet` (
  `id` int(11) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `t_to` varchar(200) NOT NULL,
  `Amount` varchar(200) NOT NULL,
  `Desc` varchar(200) NOT NULL,
  `wtype` varchar(200) NOT NULL,
  `tdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mywallet`
--

INSERT INTO `mywallet` (`id`, `tid`, `t_to`, `Amount`, `Desc`, `wtype`, `tdate`) VALUES
(39, 'Loan=1907598678', 'NIL', '500', 'hkbvhk', 'credit', '2018-01-03 23:03:23'),
(55, 'Cryptos?rid=453536', 'NIL', '5000', 'transfer to aa HHJ', 'transfer', '2018-01-03 23:03:19'),
(57, 'Cryptos?rid=453536', 'NIL', '3000', 'reverse 3k back to you', 'transfer', '2018-01-03 23:03:14'),
(58, 'Cryptos?rid=453536', 'NIL', '5000', 'add payment', 'debit', '2018-01-03 23:03:08'),
(59, 'Cryptos?rid=453536', 'NIL', '2000', 'jjjjj', 'debit', '2018-01-03 23:03:02'),
(61, 'Loan=21319580', 'NIL', '1350', 'Loan Payment', 'credit', '2018-01-03 23:02:51'),
(64, 'Loan=21319580', 'Cryptos?rid=782752', '200', 'Transfer to JJJ', 'transfer', '2018-01-03 22:58:16'),
(65, 'Loan=21319580', 'Cryptos?rid=782752', '150', 'Transfer money', 'transfer', '2018-01-03 22:58:34'),
(66, 'Loan=21319580', 'NIL', '525', 'Loan due', 'credit', '2018-01-03 23:05:19'),
(67, 'Loan=21319580', 'NIL', '1050', 'Add Payment', 'debit', '2018-01-03 23:04:46'),
(68, 'Loan=21319580', 'Cryptos?rid=782752', '200', 'Transfer to Staff JJJ', 'transfer', '2018-01-05 15:39:58');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(20) NOT NULL,
  `Notice_id` varchar(200) NOT NULL,
  `notice_title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `Main_Notice` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `notice_image` varchar(200) NOT NULL,
  `notice_date` datetime NOT NULL,
  `teler` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `Notice_id`, `notice_title`, `Main_Notice`, `notice_image`, `notice_date`, `teler`) VALUES
(7, 'MASIN278NT709', 'Test Notice', 'Test NoticeTest NoticeTest NoticeTest NoticeTest NoticeTest NoticeTest NoticeTest NoticeTest NoticeTest NoticeTest Notice', '../image/Notice/MASIN278NT709DOB.png', '2025-05-07 05:05:03', 'Admin'),
(13, 'MASIN662NT356', 'Final Notice 02-06-2025', 'Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Final Notice 02-06-2025Fi', '../image/Notice/MASIN662NT356notice.png', '2025-06-02 11:39:18', 'Admin'),
(14, 'MASIN250NT453', 'মাদ্রাসার ছাদ ঢালাই', 'আগামী কাল 02/09/2025 এ মাদ্রাসার ছাদ ঢালাই হইবে । তাই আপনারা সবাই কিছু কিছু করে দান করলে সম্পূর্ণ ভাবে ছাদ টা ঢালাই হয়ে যাইবে । এবং 2 তালার কাজ ও তাড়াতাড়ি শুরু হয়ে যাবে । আর আপনাদের আগামীকাল আসার জন্য অনুরোধ থাকল এসে ছাদ ঢালাই এর কাজ নিজ চোখে দেখে যাব', '../image/Notice/MASIN250NT453WhatsApp Image 2025-09-01 at 1.01.03 PM.jpeg', '2025-09-01 07:31:19', 'Admin'),
(15, 'MASIN819NT107', '২৮তম বিরাট ধর্মিও জলসা!', 'Regd. No- S/IL/49287\r\n৭৮৬/৯২\r\nEstd.- 1997\r\nনন্দীশিক আহলে সুন্নত ইসলামিয়া মাদ্রাসার নতুন ঘর নির্মানের উন্নতিকল্পে দই রাত্রি ব্যাপী\r\nজাশনে দাস্তারে ক্বেরাত উপলক্ষে\r\n২৮তম বিরাট ধর্মীয় জালসা\r\nস্থান - নদীশিক মাদ্রাসা প্রাঙ্গন, পোঃ- সিঙ্গিয়া, থানা- চাঁচল, জেলা-', '../image/Notice/MASIN819NT107WhatsApp Image 2025-10-01 at 3.34.51 PM.jpeg', '2025-10-01 10:31:25', 'Admin');

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

--
-- Table structure for table `rank_master`
--

CREATE TABLE `rank_master` (
  `id` int(111) NOT NULL,
  `rank_id` varchar(255) NOT NULL,
  `rank_name` varchar(255) NOT NULL,
  `rank_code` varchar(255) NOT NULL,
  `crt_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rank_master`
--

INSERT INTO `rank_master` (`id`, `rank_id`, `rank_name`, `rank_code`, `crt_date`) VALUES
(22, '', 'Principal', 'Principal', '2026-03-27 18:57:27'),
(23, '', 'Teacher In Charge', 'T.I.C', '2026-03-27 19:01:23'),
(24, '', 'Class Teacher', 'C.S', '2026-03-27 19:02:17'),
(25, '', 'Clark', 'Clark', '2026-03-27 19:02:33');

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

--
-- Table structure for table `salary_master`
--

CREATE TABLE `salary_master` (
  `id` int(111) NOT NULL,
  `emp_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `dasignation` varchar(255) NOT NULL,
  `sallary` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salary_master`
--

INSERT INTO `salary_master` (`id`, `emp_id`, `name`, `dasignation`, `sallary`) VALUES
(1, 'EP00001', 'Admin', 'Admin', '1500'),
(3, 'EP00002', 'Sekandar Ali', 'Head Moulana', '7200'),
(4, 'EP00003', 'Elias Ali ', 'Moulana', '4570'),
(5, 'EP00004', 'Ahsan Ali ', 'Moulana', '3500'),
(6, 'EP00005', 'Momina', 'Hostel Cooker', '1800');

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

--
-- Table structure for table `salary_pay_report`
--

CREATE TABLE `salary_pay_report` (
  `id` int(111) NOT NULL,
  `emp_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `salary_month` varchar(255) NOT NULL,
  `salary_amount` varchar(255) NOT NULL,
  `fine` varchar(255) NOT NULL,
  `fine_description` varchar(255) NOT NULL,
  `apseent_money_cut` varchar(255) NOT NULL,
  `Salary_pay_aamount` varchar(255) NOT NULL,
  `pay_method` varchar(255) NOT NULL,
  `pay_year` varchar(255) NOT NULL,
  `payment_date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salary_pay_report`
--

INSERT INTO `salary_pay_report` (`id`, `emp_id`, `name`, `salary_month`, `salary_amount`, `fine`, `fine_description`, `apseent_money_cut`, `Salary_pay_aamount`, `pay_method`, `pay_year`, `payment_date`) VALUES
(10, 'EP00001', 'Admin', 'January 2026', '1500', '00', '00', '00', '1500', 'Cash', '2026', '2026-02-01'),
(11, 'EP00002', 'Sekandar Ali', 'January 2026', '7200', '00', '00', '00', '7200', 'Cash', '2026', '2026-02-01'),
(12, 'EP00003', 'Elias Ali ', 'January 2026', '4570', '00', '00', '00', '4570', 'Cash', '2026', '2026-02-01'),
(13, 'EP00004', 'Ahsan Ali ', 'January 2026', '3500', '00', '00', '00', '3500', 'Cash', '2026', '2026-02-01'),
(14, 'EP00005', 'Momina', 'January 2026', '1800', '00', '00', '00', '1800', 'Cash', '2026', '2026-02-01'),
(15, 'EP00001', 'Admin', 'February 2026', '1500', '00', '00', '00', '1500', 'Cash', '2026', '2026-03-26'),
(16, 'EP00002', 'Sekandar Ali', 'February 2026', '7200', '00', '00', '00', '7200', 'Cash', '2026', '2026-03-02'),
(17, 'EP00003', 'Elias Ali ', 'February 2026', '4570', '00', '00', '00', '4570', 'Cash', '2026', '2026-03-02'),
(18, 'EP00004', 'Ahsan Ali ', 'February 2026', '3500', '00', '00', '00', '3500', 'Cash', '2026', '2026-03-02'),
(19, 'EP00005', 'Momina', 'February 2026', '1800', '00', '00', '00', '1800', 'Cash', '2026', '2026-03-02');

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

--
-- Table structure for table `section_master`
--

CREATE TABLE `section_master` (
  `id` int(11) NOT NULL,
  `sectionname` varchar(50) NOT NULL,
  `seetpsec` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `section_master`
--

INSERT INTO `section_master` (`id`, `sectionname`, `seetpsec`) VALUES
(1, 'A', 50),
(2, 'B', 50),
(3, 'C', 50),
(4, 'D', 50);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` varchar(100) NOT NULL,
  `end_time` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `end_time`) VALUES
(1, 'maintenance_mode', 'off', '');

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

--
-- Table structure for table `statee_master`
--

CREATE TABLE `statee_master` (
  `id` int(111) NOT NULL,
  `state_nam` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statee_master`
--

INSERT INTO `statee_master` (`id`, `state_nam`) VALUES
(1, 'West Bengal'),
(2, 'Andhra Pradesh'),
(3, 'Arunachal Pradesh'),
(4, 'Assam'),
(5, 'Bihar'),
(6, 'Chhattisgarh'),
(7, 'Goa'),
(8, 'Gujarat'),
(9, 'Haryana'),
(10, 'Himachal Pradesh'),
(11, 'Jharkhand'),
(12, 'Karnataka'),
(13, 'Kerala'),
(14, 'Madhya Pradesh'),
(15, 'Maharashtra'),
(16, 'Manipur'),
(17, 'Meghalaya'),
(18, 'Mizoram'),
(19, 'Nagaland'),
(20, 'Odisha'),
(21, 'Punjab'),
(22, 'Rajasthan'),
(23, 'Sikkim'),
(24, 'Tamil Nadu'),
(25, 'Telangana'),
(26, 'Tripura'),
(27, 'Uttar Pradesh'),
(28, 'Uttarakhand'),
(30, 'Andaman and Nicobar Islands'),
(31, 'Chandigarh'),
(32, 'Dadra and Nagar Haveli and Daman and Diu'),
(33, 'Lakshadweep'),
(34, 'Delhi'),
(35, 'Puducherry');

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

--
-- Table structure for table `student_attendancee`
--

CREATE TABLE `student_attendancee` (
  `id` int(111) NOT NULL,
  `Student_id` varchar(255) NOT NULL,
  `curr_date` varchar(255) NOT NULL,
  `attendece_month` varchar(255) NOT NULL,
  `attendece_year` varchar(255) NOT NULL,
  `attendece` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_attendancee`
--

INSERT INTO `student_attendancee` (`id`, `Student_id`, `curr_date`, `attendece_month`, `attendece_year`, `attendece`) VALUES
(27, 'MASIN0S000001', '2025-06-02', '06', '2025', 'P'),
(28, 'MASIN0S000001', '2026-02-01', '02', '2026', 'H'),
(29, 'MASIN0S000003', '2026-02-01', '02', '2026', 'H'),
(30, 'MASIN0S000004', '2026-02-01', '02', '2026', 'H'),
(31, 'MASIN0S000008', '2026-02-01', '02', '2026', 'H'),
(32, 'MASIN0S000009', '2026-02-01', '02', '2026', 'H'),
(33, 'MASIN0S000010', '2026-02-01', '02', '2026', 'H'),
(34, 'MASIN0S000015', '2026-02-01', '02', '2026', 'H'),
(35, 'MASIN0S000019', '2026-02-01', '02', '2026', 'H'),
(36, 'MASIN0S000020', '2026-02-01', '02', '2026', 'H'),
(37, 'MASIN0S000001', '2026-02-02', '02', '2026', 'H'),
(38, 'MASIN0S000003', '2026-02-02', '02', '2026', 'H'),
(39, 'MASIN0S000004', '2026-02-02', '02', '2026', 'H'),
(40, 'MASIN0S000008', '2026-02-02', '02', '2026', 'H'),
(41, 'MASIN0S000009', '2026-02-02', '02', '2026', 'H'),
(42, 'MASIN0S000010', '2026-02-02', '02', '2026', 'H'),
(43, 'MASIN0S000015', '2026-02-02', '02', '2026', 'H'),
(44, 'MASIN0S000019', '2026-02-02', '02', '2026', 'H'),
(45, 'MASIN0S000020', '2026-02-02', '02', '2026', 'H'),
(46, 'MASIN0S000001', '2026-03-25', '03', '2026', 'P'),
(47, 'MASIN0S000003', '2026-03-25', '03', '2026', 'P'),
(48, 'MASIN0S000005', '2026-03-25', '03', '2026', 'P'),
(49, 'MASIN0S000006', '2026-03-25', '03', '2026', 'P'),
(50, 'MASIN0S000007', '2026-03-25', '03', '2026', 'P'),
(51, 'MASIN0S000002', '2026-03-25', '03', '2026', 'A'),
(52, 'MASIN0S000003', '2026-03-25', '03', '2026', 'A'),
(53, 'MASIN0S000004', '2026-03-25', '03', '2026', 'A');

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

--
-- Table structure for table `student_result`
--

CREATE TABLE `student_result` (
  `id` int(111) NOT NULL,
  `name` varchar(255) NOT NULL,
  `register_no` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `class_piriod` varchar(255) NOT NULL,
  `roll_no` varchar(255) NOT NULL,
  `exam_name` varchar(255) NOT NULL,
  `subject_name` varchar(255) NOT NULL,
  `marks` varchar(255) NOT NULL,
  `marksheetno` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_result`
--

INSERT INTO `student_result` (`id`, `name`, `register_no`, `class`, `class_piriod`, `roll_no`, `exam_name`, `subject_name`, `marks`, `marksheetno`) VALUES
(97, 'RAFIQUL ISLAM', 'MASIN0S000001', 'Dorja Najra ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Quran Majeed ( قرآن مجيد )', '48', 'MASIN2026/0001'),
(98, 'RAFIQUL ISLAM', 'MASIN0S000001', 'Dorja Najra ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Urdu ( الأردية )', '55', 'MASIN2026/0001'),
(99, 'RAFIQUL ISLAM', 'MASIN0S000001', 'Dorja Najra ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Quran Majeed ( قرآن مجيد )', '48', 'MASIN2026/0001'),
(100, 'RAFIQUL ISLAM', 'MASIN0S000001', 'Dorja Najra ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Urdu ( الأردية )', '63', 'MASIN2026/0001'),
(101, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'FarsikiPoili ( الفارسية )', '86', 'MASIN2026/0002'),
(102, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Tashilul Msadir ( تسهيل المصادر )', '60', 'MASIN2026/0002'),
(103, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Minhajul Arbiya Aowal ( منهاج العربية الأولى )', '70', 'MASIN2026/0002'),
(104, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Tamike Kaoayedd ( تاميكا كاويد )', '85', 'MASIN2026/0002'),
(105, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Rashule Ekhram ( رسول إكرام )', '70', 'MASIN2026/0002'),
(106, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Kanune Soriyat Duom ( الشريعة في القبة )', '88', 'MASIN2026/0002'),
(107, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Anoyare Soriyat ( الشريعة في أنور )', '75', 'MASIN2026/0002'),
(108, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', '1st test ', 'Maarfte Tajid ( تاجيد عبر )', '68', 'MASIN2026/0002'),
(109, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'FarsikiPoili ( الفارسية )', '90', 'MASIN2026/0002'),
(110, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Tashilul Msadir ( تسهيل المصادر )', '70', 'MASIN2026/0002'),
(111, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Minhajul Arbiya Aowal ( منهاج العربية الأولى )', '85', 'MASIN2026/0002'),
(112, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Tamike Kaoayedd ( تاميكا كاويد )', '88', 'MASIN2026/0002'),
(113, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Rashule Ekhram ( رسول إكرام )', '90', 'MASIN2026/0002'),
(114, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Kanune Soriyat Duom ( الشريعة في القبة )', '90', 'MASIN2026/0002'),
(115, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Anoyare Soriyat ( الشريعة في أنور )', '90', 'MASIN2026/0002'),
(116, 'RABIUL ISLAM', 'MASIN0S000002', 'Dorja Ibtedaiya ( الباب مفتوح )', '1st Year', '01', 'Final Exam', 'Maarfte Tajid ( تاجيد عبر )', '99', 'MASIN2026/0002');

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

--
-- Table structure for table `studen_admission_fee`
--

CREATE TABLE `studen_admission_fee` (
  `id` int(111) NOT NULL,
  `studeent_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `stetus` enum('SUCCESS','PENDING') NOT NULL DEFAULT 'PENDING',
  `UTR` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `SUbject_master`
--

CREATE TABLE `SUbject_master` (
  `id` int(111) NOT NULL,
  `Subject_id` varchar(255) NOT NULL,
  `Subject_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `class` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `SUbject_master`
--

INSERT INTO `SUbject_master` (`id`, `Subject_id`, `Subject_name`, `class`) VALUES
(84, '', 'Bangla', 'LKG 1'),
(85, '', 'English', 'LKG 1'),
(86, '', 'Math', 'LKG 1'),
(87, '', 'G.K', 'LKG 1'),
(88, '', 'Bangla', 'LKG 2'),
(89, '', 'English', 'LKG 2'),
(90, '', 'Math', 'LKG 2'),
(91, '', 'History', 'LKG 2'),
(92, '', 'Geography', 'LKG 2'),
(100, '', 'Bangla', 'One'),
(101, '', 'English', 'One'),
(102, '', 'Math', 'One'),
(103, '', 'History', 'One'),
(104, '', 'Geography', 'One'),
(105, '', 'G.K', 'One'),
(106, '', 'Bangla', 'Two'),
(107, '', 'English', 'Two'),
(108, '', 'Math', 'Two'),
(109, '', 'History', 'Two'),
(110, '', 'Geography', 'Two'),
(111, '', 'G.K', 'Two'),
(112, '', 'Bangla', 'Three'),
(113, '', 'English', 'Three'),
(114, '', 'Math', 'Three'),
(115, '', 'History', 'Three'),
(116, '', 'Geography', 'Three'),
(117, '', 'G.K', 'Three'),
(118, '', 'Bangla', 'Four'),
(119, '', 'English', 'Four'),
(120, '', 'Math', 'Four'),
(121, '', 'History', 'Four'),
(122, '', 'Geography', 'Four'),
(123, '', 'G.K', 'Four');

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

--
-- Table structure for table `systemset`
--

CREATE TABLE `systemset` (
  `sysid` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `footer` text NOT NULL,
  `abb` varchar(200) NOT NULL,
  `fax` text NOT NULL,
  `currency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `website` text NOT NULL,
  `mobile` text NOT NULL,
  `image` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `email` text NOT NULL,
  `Academic_Session` varchar(255) NOT NULL,
  `stamp` varchar(350) NOT NULL,
  `Session_Year` varchar(255) NOT NULL,
  `sms_charges` varchar(200) NOT NULL,
  `arabic_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `systemset`
--

INSERT INTO `systemset` (`sysid`, `title`, `name`, `footer`, `abb`, `fax`, `currency`, `website`, `mobile`, `image`, `address`, `email`, `Academic_Session`, `stamp`, `Session_Year`, `sms_charges`, `arabic_name`) VALUES
(1, 'RSK SCHOOL', 'RSK SCHOOL', 'RSK SCHOOL', 'RSK SCHOOL', '732123', '₹', 'https://www.webcrafttechnology.in/new-school', '6296949862 / 1234567890', 'img/ChatGPT Image Mar 28, 2026, 12_08_11 AM.png', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA (W.B) 732123', 'rskschoolofficial@gmail.com', '2026-2027', '../img/comatee_signature.png', '2026', '0', 'مدرسة أهل السنة الإسلامية ناديشيك');

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(20) NOT NULL,
  `txid` varchar(200) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `discription` varchar(255) NOT NULL,
  `trasectiontype` varchar(255) NOT NULL,
  `date_time` timestamp NOT NULL,
  `teller` varchar(255) NOT NULL,
  `Collector_Dposit_code` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`id`, `txid`, `amount`, `discription`, `trasectiontype`, `date_time`, `teller`, `Collector_Dposit_code`) VALUES
(33, 'TXN218516146', '3153271.00', 'Audit Report (01/01/2026) Auditor : Samad Ali', 'income', '2026-01-01 14:33:38', 'EP00001', ''),
(34, 'TXN828482156', '3089126.00', 'Audit Report (01/01/2026) Auditor : Samad Ali', 'expense', '2026-01-01 14:34:17', 'EP00001', ''),
(35, 'TXN582085081', '40970', 'Audit Report (01/02/2026) Auditor : Samad Ali', 'income', '2026-02-01 14:37:25', 'EP00001', ''),
(36, 'TXN774363420', '101340', 'Audit Report (01/02/2026) Auditor : Samad Ali', 'expense', '2026-02-01 14:38:18', 'EP00001', ''),
(37, 'TXN100712741', '38439', 'Audit Report (01/03/2026) Auditor : Samad Ali\n', 'income', '2026-03-01 10:15:46', 'EP00001', ''),
(42, 'TXN594986871', '25677', 'Audit Report (01/03/2026) Auditor: Samad Ali', 'expense', '2026-03-01 10:34:10', 'EP00001', '');

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

--
-- Table structure for table `twallet`
--

CREATE TABLE `twallet` (
  `id` int(20) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `Total` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `twallet`
--

INSERT INTO `twallet` (`id`, `tid`, `Total`) VALUES
(10, 'Loan=21319580', '1025'),
(12, 'Cryptos?rid=782752', '550');

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

--
-- Table structure for table `vip_membar`
--

CREATE TABLE `vip_membar` (
  `id` int(111) NOT NULL,
  `vipmid` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `d-o-b` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL DEFAULT 'Vip Membar',
  `stetus` enum('Active','Block') NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vip_membar`
--

INSERT INTO `vip_membar` (`id`, `vipmid`, `name`, `father_name`, `d-o-b`, `gender`, `phone`, `email`, `address`, `image`, `date`, `designation`, `stetus`) VALUES
(2, 'VIPM00001', 'Mustafijur Rahaman', 'Hafijuddin', '1994-01-01', 'Male', '9711140484', 'mustafijur@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/VIPM00001_6996d8392151b_1771493433.jpg', '30-07-2025', 'Vip Membar', 'Active'),
(3, 'VIPM00002', 'Rafiqul Islam', 'Md Sarif', '1990-02-20', 'Male', '7797149903', 'ri12873@gmail.com', 'VILL-NADISHIK, SINGIA, CHANCHAL, MALDA-732123', 'img/membar/VIPM00002_6996d87923ebe_1771493497.png', '16-02-2026', 'Vip Membar', 'Active');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aboutus`
--
ALTER TABLE `aboutus`
  ADD PRIMARY KEY (`abid`);

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

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

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`banaid`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

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

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

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

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

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

--
-- Indexes for table `systemset`
--
ALTER TABLE `systemset`
  ADD PRIMARY KEY (`sysid`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aboutus`
--
ALTER TABLE `aboutus`
  MODIFY `abid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Academic_Session`
--
ALTER TABLE `Academic_Session`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `backup`
--
ALTER TABLE `backup`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `banaid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `class_master`
--
ALTER TABLE `class_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `committe_members`
--
ALTER TABLE `committe_members`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250;

--
-- AUTO_INCREMENT for table `donate_culector`
--
ALTER TABLE `donate_culector`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `donate_request`
--
ALTER TABLE `donate_request`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `employee_attendancee`
--
ALTER TABLE `employee_attendancee`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `emp_permission`
--
ALTER TABLE `emp_permission`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;

--
-- AUTO_INCREMENT for table `emp_role`
--
ALTER TABLE `emp_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam`
--
ALTER TABLE `exam`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `examtimetabale`
--
ALTER TABLE `examtimetabale`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `exam_marks`
--
ALTER TABLE `exam_marks`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=158;

--
-- AUTO_INCREMENT for table `footer`
--
ALTER TABLE `footer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `hostel_donate_membar`
--
ALTER TABLE `hostel_donate_membar`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `Income`
--
ALTER TABLE `Income`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `loan_info`
--
ALTER TABLE `loan_info`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;

--
-- AUTO_INCREMENT for table `membar`
--
ALTER TABLE `membar`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `mywallet`
--
ALTER TABLE `mywallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `rank_master`
--
ALTER TABLE `rank_master`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `salary_master`
--
ALTER TABLE `salary_master`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `salary_pay_report`
--
ALTER TABLE `salary_pay_report`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `section_master`
--
ALTER TABLE `section_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `statee_master`
--
ALTER TABLE `statee_master`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `student_attendancee`
--
ALTER TABLE `student_attendancee`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `student_result`
--
ALTER TABLE `student_result`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;

--
-- AUTO_INCREMENT for table `studen_admission_fee`
--
ALTER TABLE `studen_admission_fee`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `SUbject_master`
--
ALTER TABLE `SUbject_master`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;

--
-- AUTO_INCREMENT for table `systemset`
--
ALTER TABLE `systemset`
  MODIFY `sysid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `twallet`
--
ALTER TABLE `twallet`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `vip_membar`
--
ALTER TABLE `vip_membar`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

