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

START TRANSACTION;



--
-- Database: `avbddemo_appdb`
--

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser_version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform_version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remote_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_mobile` int(11) DEFAULT NULL,
  `is_desktop` int(11) DEFAULT NULL,
  `is_tablet` int(11) DEFAULT NULL,
  `post_data` json DEFAULT NULL,
  `auth_datetime` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `url`, `method`, `ip_address`, `device`, `browser`, `browser_version`, `platform`, `platform_version`, `remote_address`, `is_mobile`, `is_desktop`, `is_tablet`, `post_data`, `auth_datetime`, `created_at`, `updated_at`) VALUES
(1, 1, 'login.post', 'http://localhost/avbd_webapp/public/login', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"username\": \"admin@nomail.com\"}', '2026-04-01 04:26:05', '2026-04-01 04:26:05', '2026-04-01 04:26:05'),
(2, 3, 'login.post', 'http://localhost/avbd_webapp/public/login', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"username\": \"volunteer1@nomail.com\"}', '2026-04-01 04:30:48', '2026-04-01 04:30:48', '2026-04-01 04:30:48'),
(3, 4, 'login.post', 'http://localhost/avbd_webapp/public/login', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"username\": \"friendsclub@nomail.com\"}', '2026-04-01 04:33:22', '2026-04-01 04:33:22', '2026-04-01 04:33:22'),
(4, 4, 'camp-request-save', 'http://localhost/avbd_webapp/public/camp-request-save', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"org_code\": \"abc/001\", \"camp_date\": \"2026-04-02\", \"camp_time\": \"10:00\", \"camp_venue\": \"Singur\", \"is_past_org\": \"1\", \"org_address\": \"Shyamnagar, 24PGS(N), 743127.\", \"camp_date_one\": \"2026-04-03\", \"camp_date_two\": \"2026-04-04\", \"camp_venue_pin\": \"712409\", \"org_address_pin\": \"743127\", \"venue_direction\": \"Singur Station\", \"exp_no_of_donors\": \"120\", \"camp_venue_dist_id\": \"7\", \"camp_venue_dist_name\": null, \"local_contact_person_name\": \"Rishov Mal\", \"local_contact_person_mobile\": \"9007742088\", \"local_contact_person_address\": \"Singur\"}', '2026-04-01 04:46:15', '2026-04-01 04:46:15', '2026-04-01 04:46:15'),
(5, 4, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 04:47:34', '2026-04-01 04:47:34', '2026-04-01 04:47:34'),
(6, 1, 'login.post', 'http://localhost/avbd_webapp/public/login', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"username\": \"admin@nomail.com\"}', '2026-04-01 04:47:54', '2026-04-01 04:47:54', '2026-04-01 04:47:54'),
(7, 1, 'camp-confirm', 'http://localhost/avbd_webapp/public/camp-confirm', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 04:53:25', '2026-04-01 04:53:25', '2026-04-01 04:53:25'),
(8, 1, 'camp-confirm', 'http://localhost/avbd_webapp/public/camp-confirm', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 04:53:51', '2026-04-01 04:53:51', '2026-04-01 04:53:51'),
(9, 1, 'camp-denied', 'http://localhost/avbd_webapp/public/camp-denied', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\", \"denied_reason\": \"test\"}', '2026-04-01 04:54:25', '2026-04-01 04:54:25', '2026-04-01 04:54:25'),
(10, 1, 'camp-confirm', 'http://localhost/avbd_webapp/public/camp-confirm', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 04:54:53', '2026-04-01 04:54:53', '2026-04-01 04:54:53'),
(11, 1, 'camp-confirm', 'http://localhost/avbd_webapp/public/camp-confirm', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 04:59:52', '2026-04-01 04:59:52', '2026-04-01 04:59:52'),
(12, 1, 'camp-confirm', 'http://localhost/avbd_webapp/public/camp-confirm', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 05:02:12', '2026-04-01 05:02:12', '2026-04-01 05:02:12'),
(13, 1, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 05:03:02', '2026-04-01 05:03:02', '2026-04-01 05:03:02'),
(14, 1, 'blood-bank-detail', 'http://localhost/avbd_webapp/public/blood-bank-detail', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"blood_bank_id\": null}', '2026-04-01 05:04:46', '2026-04-01 05:04:46', '2026-04-01 05:04:46'),
(15, 1, 'add-blood-collected-details', 'http://localhost/avbd_webapp/public/add-blood-collected-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"camp_id\": \"1\", \"blood_collected_id\": [\"0\", \"0\", \"0\"], \"avbdbloodbankcodeadd\": [\"1\", \"2\", \"3\"], \"avbdbloodbanknameadd\": [\"Bllod Bank One\", \"Bllod Bank Two\", \"Bllod Bank Three\"], \"avbdbloodbookingtime\": [\"10:00\", \"10:00\", \"10:00\"], \"avbdbloodnoofcollected\": [\"20\", \"20\", \"20\"], \"avbdisbloodbankselected\": {\"0\": \"on\", \"1\": \"on\", \"-1\": \"1\"}, \"avbdisbloodbankselectedchecked\": [\"1\", \"1\", \"1\"]}', '2026-04-01 05:05:02', '2026-04-01 05:05:02', '2026-04-01 05:05:02'),
(16, 1, 'update-additional-remark', 'http://localhost/avbd_webapp/public/update-additional-remark', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\", \"additional_remarks\": \"test\"}', '2026-04-01 05:27:47', '2026-04-01 05:27:47', '2026-04-01 05:27:47'),
(17, 1, 'update-volunteer-details', 'http://localhost/avbd_webapp/public/update-volunteer-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"camp_id\": \"1\", \"volunteername\": [\"1\"]}', '2026-04-01 05:28:01', '2026-04-01 05:28:01', '2026-04-01 05:28:01'),
(18, 1, 'login.post', 'http://localhost/avbd_webapp/public/login', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"username\": \"admin@nomail.com\"}', '2026-04-01 05:28:18', '2026-04-01 05:28:18', '2026-04-01 05:28:18'),
(19, 1, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 05:34:59', '2026-04-01 05:34:59', '2026-04-01 05:34:59'),
(20, 1, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 05:35:18', '2026-04-01 05:35:18', '2026-04-01 05:35:18'),
(21, 1, 'add-blood-collected-details', 'http://localhost/avbd_webapp/public/add-blood-collected-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"camp_id\": \"1\", \"blood_collected_id\": [\"1\", \"2\", \"3\", \"0\"], \"avbdbloodbankcodeadd\": [\"1\", \"2\", \"3\", null], \"avbdbloodbanknameadd\": [\"Bllod Bank One\", \"Bllod Bank Two\", \"Bllod Bank Three\", null], \"avbdbloodbookingtime\": [\"10:00:00\", \"10:00:00\", \"10:00:00\", null], \"avbdbloodnoofcollected\": [\"20\", \"20\", \"20\", null], \"avbdisbloodbankselected\": [\"0\"], \"avbdisbloodbankselectedchecked\": [\"1\", \"0\", \"0\", \"0\"]}', '2026-04-01 05:35:31', '2026-04-01 05:35:31', '2026-04-01 05:35:31'),
(22, 1, 'camp-postponed', 'http://localhost/avbd_webapp/public/camp-postponed', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\", \"camp_date\": \"2026-04-06\", \"reschedule_reason\": \"test\"}', '2026-04-01 05:36:02', '2026-04-01 05:36:02', '2026-04-01 05:36:02'),
(23, 1, 'camp-request-save', 'http://localhost/avbd_webapp/public/camp-request-save', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"org_code\": \"abc/001\", \"camp_date\": \"2026-04-01\", \"camp_time\": \"10:00\", \"camp_venue\": \"Kolkata\", \"is_past_org\": \"2\", \"org_address\": \"Shyamnagar, 24PGS(N), 743127.\", \"camp_date_one\": \"2026-04-02\", \"camp_date_two\": \"2026-04-03\", \"camp_venue_pin\": \"700091\", \"org_address_pin\": \"743127\", \"venue_direction\": \"Ambuja Neotia Ecocentre\", \"exp_no_of_donors\": \"100\", \"camp_venue_dist_id\": \"12\", \"camp_venue_dist_name\": null, \"local_contact_person_name\": \"Rishov Mal\", \"local_contact_person_mobile\": \"9007742088\", \"local_contact_person_address\": \"Ambuja Neotia Ecocentre\"}', '2026-04-01 05:43:28', '2026-04-01 05:43:28', '2026-04-01 05:43:28'),
(24, 1, 'camp-confirm', 'http://localhost/avbd_webapp/public/camp-confirm', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"2\"}', '2026-04-01 05:44:59', '2026-04-01 05:44:59', '2026-04-01 05:44:59'),
(25, 1, 'camp-cancelled', 'http://localhost/avbd_webapp/public/camp-cancelled', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"2\", \"cancelled_by\": \"2\", \"cancel_reason\": \"demo\", \"cancel_by_other\": null}', '2026-04-01 05:54:20', '2026-04-01 05:54:20', '2026-04-01 05:54:20'),
(26, 1, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 05:54:49', '2026-04-01 05:54:49', '2026-04-01 05:54:49'),
(27, 1, 'camp-conducted', 'http://localhost/avbd_webapp/public/camp-conducted', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 05:55:05', '2026-04-01 05:55:05', '2026-04-01 05:55:05'),
(28, 1, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"2\"}', '2026-04-01 05:56:03', '2026-04-01 05:56:03', '2026-04-01 05:56:03'),
(29, 1, 'add-blood-collected-details', 'http://localhost/avbd_webapp/public/add-blood-collected-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"camp_id\": \"2\", \"blood_collected_id\": [\"0\"], \"avbdbloodbankcodeadd\": [\"2\"], \"avbdbloodbanknameadd\": [\"Bllod Bank Two\"], \"avbdbloodbookingtime\": [\"10:00\"], \"avbdbloodnoofcollected\": [\"20\"], \"avbdisbloodbankselected\": {\"-1\": \"1\"}, \"avbdisbloodbankselectedchecked\": [\"1\"]}', '2026-04-01 05:56:19', '2026-04-01 05:56:19', '2026-04-01 05:56:19'),
(30, 1, 'update-volunteer-details', 'http://localhost/avbd_webapp/public/update-volunteer-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"camp_id\": \"2\", \"volunteername\": [\"1\"]}', '2026-04-01 05:56:34', '2026-04-01 05:56:34', '2026-04-01 05:56:34'),
(31, 1, 'camp-conducted', 'http://localhost/avbd_webapp/public/camp-conducted', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"2\"}', '2026-04-01 06:01:34', '2026-04-01 06:01:34', '2026-04-01 06:01:34'),
(32, 1, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"2\"}', '2026-04-01 06:01:56', '2026-04-01 06:01:56', '2026-04-01 06:01:56'),
(33, 1, 'upload-donor-details', 'http://localhost/avbd_webapp/public/upload-donor-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"2\", \"donor_file\": {}}', '2026-04-01 06:05:04', '2026-04-01 06:05:04', '2026-04-01 06:05:04'),
(34, 1, 'update-camp-details', 'http://localhost/avbd_webapp/public/update-camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"2\", \"cci_due\": \"20\", \"iec_due\": \"15\", \"rcp_due\": \"10\", \"gift_iems\": \"Umbrella\", \"cci_issued\": \"0\", \"iec_issued\": \"5\", \"rcp_issued\": \"10\", \"iec_charge_paid\": \"1\", \"approx_gift_money\": \"152\", \"additional_remarks\": \"test\", \"credit_card_issued\": \"0\", \"refreshment_charge_paid\": \"1\"}', '2026-04-01 06:05:44', '2026-04-01 06:05:44', '2026-04-01 06:05:44'),
(35, 1, 'update-blood-collected-details', 'http://localhost/avbd_webapp/public/update-blood-collected-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"camp_id\": \"2\", \"avbdbloodbagto\": [\"20\"], \"avbdarrivaltime\": [\"10:00\"], \"avbdbookingtime\": [\"10:00:00\"], \"avbdclosingtime\": [\"16:00\"], \"avbdbloodbagcode\": [\"BFEE4\"], \"avbdbloodbagfrom\": [\"01\"], \"avbdiecgrantpaid\": [\"456\"], \"avbdbloodbankcode\": [\"BBKOL0002\"], \"avbdbloodbankname\": [\"Bllod Bank Two\"], \"avbdcreditcarddue\": [\"10\"], \"blood_collected_id\": [\"7\"], \"blood_collected_type\": [null], \"avbdrefreshmentcharge\": [\"1523\"], \"avbdbloodnoofcollected\": [\"20\"]}', '2026-04-01 06:06:27', '2026-04-01 06:06:27', '2026-04-01 06:06:27'),
(36, 1, 'camp-details', 'http://localhost/avbd_webapp/public/camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\"}', '2026-04-01 06:06:46', '2026-04-01 06:06:46', '2026-04-01 06:06:46'),
(37, 1, 'upload-donor-details', 'http://localhost/avbd_webapp/public/upload-donor-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\", \"donor_file\": {}}', '2026-04-01 06:07:08', '2026-04-01 06:07:08', '2026-04-01 06:07:08'),
(38, 1, 'update-blood-collected-details', 'http://localhost/avbd_webapp/public/update-blood-collected-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"org_id\": \"1\", \"camp_id\": \"1\", \"avbdbloodbagto\": [\"20\"], \"avbdarrivaltime\": [\"10:00\"], \"avbdbookingtime\": [\"10:00:00\"], \"avbdclosingtime\": [\"16:00\"], \"avbdbloodbagcode\": [\"BGTT5\"], \"avbdbloodbagfrom\": [\"01\"], \"avbdiecgrantpaid\": [\"1478\"], \"avbdbloodbankcode\": [\"BBKOL0001\"], \"avbdbloodbankname\": [\"Bllod Bank One\"], \"avbdcreditcarddue\": [\"20\"], \"blood_collected_id\": [\"4\"], \"blood_collected_type\": [null], \"avbdrefreshmentcharge\": [\"4478\"], \"avbdbloodnoofcollected\": [\"20\"]}', '2026-04-01 06:07:42', '2026-04-01 06:07:42', '2026-04-01 06:07:42'),
(39, 1, 'update-camp-details', 'http://localhost/avbd_webapp/public/update-camp-details', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"camp_id\": \"1\", \"cci_due\": \"20\", \"iec_due\": \"10\", \"rcp_due\": \"10\", \"gift_iems\": \"Cooker\", \"cci_issued\": \"0\", \"iec_issued\": \"10\", \"rcp_issued\": \"10\", \"iec_charge_paid\": \"1\", \"approx_gift_money\": \"849\", \"additional_remarks\": \"test\", \"credit_card_issued\": \"0\", \"refreshment_charge_paid\": \"1\"}', '2026-04-01 06:08:11', '2026-04-01 06:08:11', '2026-04-01 06:08:11'),
(40, 1, 'bank-details-save', 'http://localhost/avbd_webapp/public/bank-details-save', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"bank_id\": \"2\", \"camp_id\": \"2\", \"ifsc_code\": \"BARB0SINGUR\", \"account_no\": \"9846516387\", \"branch_name\": \"Singur\", \"camp_bank_id\": \"0\", \"bank_account_name\": \"Rishov Mal\", \"bank_account_type\": \"1\"}', '2026-04-01 06:08:58', '2026-04-01 06:08:58', '2026-04-01 06:08:58'),
(41, 1, 'bank-details-save', 'http://localhost/avbd_webapp/public/bank-details-save', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"bank_id\": \"2\", \"camp_id\": \"1\", \"ifsc_code\": \"BARB0SINGUR\", \"account_no\": \"9846516387\", \"branch_name\": \"Singur\", \"camp_bank_id\": \"0\", \"bank_account_name\": \"Rishov Mal\", \"bank_account_type\": \"1\"}', '2026-04-01 06:20:54', '2026-04-01 06:20:54', '2026-04-01 06:20:54'),
(42, 1, 'report-generate-for-1-BB-Bill-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:21:40', '2026-04-01 06:21:40', '2026-04-01 06:21:40'),
(43, 1, 'report-generate-for-1-BB-Bill-Ref', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-Ref', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:21:46', '2026-04-01 06:21:46', '2026-04-01 06:21:46'),
(44, 1, 'report-generate-for-2-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-2-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:21:52', '2026-04-01 06:21:52', '2026-04-01 06:21:52'),
(45, 1, 'report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:22:14', '2026-04-01 06:22:14', '2026-04-01 06:22:14'),
(46, 1, 'report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:19', '2026-04-01 06:22:19', '2026-04-01 06:22:19'),
(47, 1, 'report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:23', '2026-04-01 06:22:23', '2026-04-01 06:22:23'),
(48, 1, 'report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:26', '2026-04-01 06:22:26', '2026-04-01 06:22:26'),
(49, 1, 'report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'http://localhost/avbd_webapp/public/report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:29', '2026-04-01 06:22:29', '2026-04-01 06:22:29'),
(50, 1, 'report-generate-for-3D-Rpt-District-Wise-Donors', 'http://localhost/avbd_webapp/public/report-generate-for-3D-Rpt-District-Wise-Donors', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:33', '2026-04-01 06:22:33', '2026-04-01 06:22:33'),
(51, 1, 'report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:36', '2026-04-01 06:22:36', '2026-04-01 06:22:36'),
(52, 1, 'report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:39', '2026-04-01 06:22:39', '2026-04-01 06:22:39'),
(53, 1, 'report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'http://localhost/avbd_webapp/public/report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:42', '2026-04-01 06:22:42', '2026-04-01 06:22:42'),
(54, 1, 'report-generate-for-3H-Rpt-Org-Pay-Due', 'http://localhost/avbd_webapp/public/report-generate-for-3H-Rpt-Org-Pay-Due', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:46', '2026-04-01 06:22:46', '2026-04-01 06:22:46'),
(55, 1, 'report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'http://localhost/avbd_webapp/public/report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:49', '2026-04-01 06:22:49', '2026-04-01 06:22:49'),
(56, 1, 'report-generate-for-3J-Rpt-Payment-rec-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3J-Rpt-Payment-rec-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:53', '2026-04-01 06:22:53', '2026-04-01 06:22:53'),
(57, 1, 'report-generate-for-3K-Payment-Due-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3K-Payment-Due-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:56', '2026-04-01 06:22:56', '2026-04-01 06:22:56'),
(58, 1, 'report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:22:59', '2026-04-01 06:22:59', '2026-04-01 06:22:59'),
(59, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"1\"}', '2026-04-01 06:23:09', '2026-04-01 06:23:09', '2026-04-01 06:23:09'),
(60, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"2\"}', '2026-04-01 06:23:20', '2026-04-01 06:23:20', '2026-04-01 06:23:20'),
(61, 1, 'report-generate-for-1-BB-Bill-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:29:29', '2026-04-01 06:29:29', '2026-04-01 06:29:29'),
(62, 1, 'report-generate-for-1-BB-Bill-Ref', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-Ref', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:29:34', '2026-04-01 06:29:34', '2026-04-01 06:29:34'),
(63, 1, 'report-generate-for-2-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-2-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:29:39', '2026-04-01 06:29:39', '2026-04-01 06:29:39'),
(64, 1, 'report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:29:44', '2026-04-01 06:29:44', '2026-04-01 06:29:44'),
(65, 1, 'report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:29:48', '2026-04-01 06:29:48', '2026-04-01 06:29:48'),
(66, 1, 'report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:29:50', '2026-04-01 06:29:50', '2026-04-01 06:29:50'),
(67, 1, 'report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:29:52', '2026-04-01 06:29:52', '2026-04-01 06:29:52'),
(68, 1, 'report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'http://localhost/avbd_webapp/public/report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:29:55', '2026-04-01 06:29:55', '2026-04-01 06:29:55'),
(69, 1, 'report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:29:57', '2026-04-01 06:29:57', '2026-04-01 06:29:57'),
(70, 1, 'report-generate-for-3D-Rpt-District-Wise-Donors', 'http://localhost/avbd_webapp/public/report-generate-for-3D-Rpt-District-Wise-Donors', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:00', '2026-04-01 06:30:00', '2026-04-01 06:30:00'),
(71, 1, 'report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:03', '2026-04-01 06:30:03', '2026-04-01 06:30:03'),
(72, 1, 'report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'http://localhost/avbd_webapp/public/report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:12', '2026-04-01 06:30:12', '2026-04-01 06:30:12'),
(73, 1, 'report-generate-for-3H-Rpt-Org-Pay-Due', 'http://localhost/avbd_webapp/public/report-generate-for-3H-Rpt-Org-Pay-Due', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:16', '2026-04-01 06:30:16', '2026-04-01 06:30:16'),
(74, 1, 'report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'http://localhost/avbd_webapp/public/report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:19', '2026-04-01 06:30:19', '2026-04-01 06:30:19'),
(75, 1, 'report-generate-for-3J-Rpt-Payment-rec-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3J-Rpt-Payment-rec-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:22', '2026-04-01 06:30:22', '2026-04-01 06:30:22'),
(76, 1, 'report-generate-for-3K-Payment-Due-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3K-Payment-Due-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:24', '2026-04-01 06:30:24', '2026-04-01 06:30:24'),
(77, 1, 'report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:30:28', '2026-04-01 06:30:28', '2026-04-01 06:30:28'),
(78, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"1\"}', '2026-04-01 06:30:33', '2026-04-01 06:30:33', '2026-04-01 06:30:33'),
(79, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"2\"}', '2026-04-01 06:30:44', '2026-04-01 06:30:44', '2026-04-01 06:30:44'),
(80, 1, 'report-generate-for-1-BB-Bill-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:37:25', '2026-04-01 06:37:25', '2026-04-01 06:37:25'),
(81, 1, 'report-generate-for-1-BB-Bill-Ref', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-Ref', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:37:35', '2026-04-01 06:37:35', '2026-04-01 06:37:35'),
(82, 1, 'report-generate-for-2-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-2-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:37:44', '2026-04-01 06:37:44', '2026-04-01 06:37:44'),
(83, 1, 'report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 06:37:51', '2026-04-01 06:37:51', '2026-04-01 06:37:51'),
(84, 1, 'report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:37:56', '2026-04-01 06:37:56', '2026-04-01 06:37:56'),
(85, 1, 'report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:01', '2026-04-01 06:38:01', '2026-04-01 06:38:01'),
(86, 1, 'report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:07', '2026-04-01 06:38:07', '2026-04-01 06:38:07'),
(87, 1, 'report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'http://localhost/avbd_webapp/public/report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:12', '2026-04-01 06:38:12', '2026-04-01 06:38:12'),
(88, 1, 'report-generate-for-3D-Rpt-District-Wise-Donors', 'http://localhost/avbd_webapp/public/report-generate-for-3D-Rpt-District-Wise-Donors', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:17', '2026-04-01 06:38:17', '2026-04-01 06:38:17'),
(89, 1, 'report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:22', '2026-04-01 06:38:22', '2026-04-01 06:38:22'),
(90, 1, 'report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:27', '2026-04-01 06:38:27', '2026-04-01 06:38:27'),
(91, 1, 'report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'http://localhost/avbd_webapp/public/report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:32', '2026-04-01 06:38:32', '2026-04-01 06:38:32'),
(92, 1, 'report-generate-for-3H-Rpt-Org-Pay-Due', 'http://localhost/avbd_webapp/public/report-generate-for-3H-Rpt-Org-Pay-Due', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:37', '2026-04-01 06:38:37', '2026-04-01 06:38:37'),
(93, 1, 'report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'http://localhost/avbd_webapp/public/report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:42', '2026-04-01 06:38:42', '2026-04-01 06:38:42'),
(94, 1, 'report-generate-for-3J-Rpt-Payment-rec-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3J-Rpt-Payment-rec-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:45', '2026-04-01 06:38:45', '2026-04-01 06:38:45'),
(95, 1, 'report-generate-for-3K-Payment-Due-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3K-Payment-Due-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:51', '2026-04-01 06:38:51', '2026-04-01 06:38:51'),
(96, 1, 'report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 06:38:59', '2026-04-01 06:38:59', '2026-04-01 06:38:59'),
(97, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"1\"}', '2026-04-01 06:39:06', '2026-04-01 06:39:06', '2026-04-01 06:39:06'),
(98, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"2\"}', '2026-04-01 06:39:17', '2026-04-01 06:39:17', '2026-04-01 06:39:17'),
(99, 1, 'login.post', 'http://localhost/avbd_webapp/public/login', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"username\": \"admin@nomail.com\"}', '2026-04-01 07:00:10', '2026-04-01 07:00:10', '2026-04-01 07:00:10'),
(100, 1, 'report-generate-for-1-BB-Bill-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:00:53', '2026-04-01 07:00:53', '2026-04-01 07:00:53'),
(101, 1, 'report-generate-for-1-BB-Bill-Ref', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-Ref', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:01:13', '2026-04-01 07:01:13', '2026-04-01 07:01:13'),
(102, 1, 'report-generate-for-2-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-2-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:01:18', '2026-04-01 07:01:18', '2026-04-01 07:01:18'),
(103, 1, 'report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:01:23', '2026-04-01 07:01:23', '2026-04-01 07:01:23'),
(104, 1, 'report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:01:46', '2026-04-01 07:01:46', '2026-04-01 07:01:46'),
(105, 1, 'report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:04:56', '2026-04-01 07:04:56', '2026-04-01 07:04:56'),
(106, 1, 'report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:05:10', '2026-04-01 07:05:10', '2026-04-01 07:05:10'),
(107, 1, 'report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'http://localhost/avbd_webapp/public/report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:05:15', '2026-04-01 07:05:15', '2026-04-01 07:05:15'),
(108, 1, 'report-generate-for-3D-Rpt-District-Wise-Donors', 'http://localhost/avbd_webapp/public/report-generate-for-3D-Rpt-District-Wise-Donors', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:05:33', '2026-04-01 07:05:33', '2026-04-01 07:05:33'),
(109, 1, 'report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:05:44', '2026-04-01 07:05:44', '2026-04-01 07:05:44'),
(110, 1, 'report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:06:05', '2026-04-01 07:06:05', '2026-04-01 07:06:05'),
(111, 1, 'report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'http://localhost/avbd_webapp/public/report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:06:16', '2026-04-01 07:06:16', '2026-04-01 07:06:16'),
(112, 1, 'report-generate-for-3H-Rpt-Org-Pay-Due', 'http://localhost/avbd_webapp/public/report-generate-for-3H-Rpt-Org-Pay-Due', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:06:33', '2026-04-01 07:06:33', '2026-04-01 07:06:33'),
(113, 1, 'report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'http://localhost/avbd_webapp/public/report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:15:12', '2026-04-01 07:15:12', '2026-04-01 07:15:12'),
(114, 1, 'report-generate-for-3H-Rpt-Org-Pay-Due', 'http://localhost/avbd_webapp/public/report-generate-for-3H-Rpt-Org-Pay-Due', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:17:32', '2026-04-01 07:17:32', '2026-04-01 07:17:32'),
(115, 1, 'report-generate-for-3H-Rpt-Org-Pay-Due', 'http://localhost/avbd_webapp/public/report-generate-for-3H-Rpt-Org-Pay-Due', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:18:16', '2026-04-01 07:18:16', '2026-04-01 07:18:16'),
(116, 1, 'report-generate-for-1-BB-Bill-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:31:21', '2026-04-01 07:31:21', '2026-04-01 07:31:21'),
(117, 1, 'report-generate-for-1-BB-Bill-Ref', 'http://localhost/avbd_webapp/public/report-generate-for-1-BB-Bill-Ref', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:31:26', '2026-04-01 07:31:26', '2026-04-01 07:31:26'),
(118, 1, 'report-generate-for-2-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-2-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:31:32', '2026-04-01 07:31:32', '2026-04-01 07:31:32'),
(119, 1, 'report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Refreshement-and-IEC-Received-Bill-Amount', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\"}', '2026-04-01 07:31:38', '2026-04-01 07:31:38', '2026-04-01 07:31:38'),
(120, 1, 'report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-2A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:31:43', '2026-04-01 07:31:43', '2026-04-01 07:31:43'),
(121, 1, 'report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3A-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:31:47', '2026-04-01 07:31:47', '2026-04-01 07:31:47'),
(122, 1, 'report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3B-Rpt-Month-Wise-Detail-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:31:51', '2026-04-01 07:31:51', '2026-04-01 07:31:51'),
(123, 1, 'report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'http://localhost/avbd_webapp/public/report-generate-for-3C-Qry-District-Wise-Camp-Analysis', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:31:55', '2026-04-01 07:31:55', '2026-04-01 07:31:55'),
(124, 1, 'report-generate-for-3D-Rpt-District-Wise-Donors', 'http://localhost/avbd_webapp/public/report-generate-for-3D-Rpt-District-Wise-Donors', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:31:59', '2026-04-01 07:31:59', '2026-04-01 07:31:59'),
(125, 1, 'report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3E-Rpt-BB-Wise-Camp-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:03', '2026-04-01 07:32:03', '2026-04-01 07:32:03'),
(126, 1, 'report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'http://localhost/avbd_webapp/public/report-generate-for-3F-Qry-Donor-BB-Month-Wise', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:07', '2026-04-01 07:32:07', '2026-04-01 07:32:07'),
(127, 1, 'report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'http://localhost/avbd_webapp/public/report-generate-for-3G-Rpt-Monthly-Summary-Executive-Meeting', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:12', '2026-04-01 07:32:12', '2026-04-01 07:32:12'),
(128, 1, 'report-generate-for-3H-Rpt-Org-Pay-Due', 'http://localhost/avbd_webapp/public/report-generate-for-3H-Rpt-Org-Pay-Due', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:16', '2026-04-01 07:32:16', '2026-04-01 07:32:16'),
(129, 1, 'report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'http://localhost/avbd_webapp/public/report-generate-for-3I-Rpt-Qrg-Payment-Disbursed', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:20', '2026-04-01 07:32:20', '2026-04-01 07:32:20'),
(130, 1, 'report-generate-for-3J-Rpt-Payment-rec-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3J-Rpt-Payment-rec-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:24', '2026-04-01 07:32:24', '2026-04-01 07:32:24'),
(131, 1, 'report-generate-for-3K-Payment-Due-From-BB', 'http://localhost/avbd_webapp/public/report-generate-for-3K-Payment-Due-From-BB', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:29', '2026-04-01 07:32:29', '2026-04-01 07:32:29'),
(132, 1, 'report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'http://localhost/avbd_webapp/public/report-generate-for-3M-Rpt-Payment-Received-BB-for-OWN-Camp', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_financial_year\": \"2026-27\"}', '2026-04-01 07:32:33', '2026-04-01 07:32:33', '2026-04-01 07:32:33'),
(133, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"1\"}', '2026-04-01 07:32:39', '2026-04-01 07:32:39', '2026-04-01 07:32:39'),
(134, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"3\"}', '2026-04-01 07:32:52', '2026-04-01 07:32:52', '2026-04-01 07:32:52'),
(135, 1, 'report-generate-for-4-BB-Bill-Ref-IEC', 'http://localhost/avbd_webapp/public/report-generate-for-4-BB-Bill-Ref-IEC', 'POST', '::1', 'WebKit', 'Chrome', '146.0.0.0', 'Windows', '10.0', NULL, 0, 1, 0, '{\"report_year\": \"2026\", \"report_month\": \"4\", \"blood_bank_id\": \"2\"}', '2026-04-01 07:34:44', '2026-04-01 07:34:44', '2026-04-01 07:34:44');

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

--
-- Table structure for table `camp_bank_details`
--

CREATE TABLE `camp_bank_details` (
  `camp_bank_id` int(11) NOT NULL,
  `camp_id` int(11) DEFAULT NULL,
  `org_id` int(11) DEFAULT NULL,
  `bank_id` int(11) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `branch_name` varchar(255) DEFAULT NULL,
  `bank_account_name` varchar(255) DEFAULT NULL,
  `account_no` varchar(255) DEFAULT NULL,
  `ifsc_code` varchar(255) DEFAULT NULL,
  `bank_account_type` int(1) DEFAULT NULL COMMENT '1 = Savings, 2 = Current',
  `status_id` int(1) NOT NULL DEFAULT '1',
  `is_deleted` int(1) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_by` int(11) DEFAULT NULL,
  `modified_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `camp_bank_details`
--

INSERT INTO `camp_bank_details` (`camp_bank_id`, `camp_id`, `org_id`, `bank_id`, `bank_name`, `branch_name`, `bank_account_name`, `account_no`, `ifsc_code`, `bank_account_type`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES
(1, 2, 1, 2, 'Bank of Baroda', 'Singur', 'Rishov Mal', '9846516387', 'BARB0SINGUR', 1, 1, 0, 1, '2026-04-01 11:38:57', NULL, '2026-04-01 11:38:57'),
(2, 1, 1, 2, 'Bank of Baroda', 'Singur', 'Rishov Mal', '9846516387', 'BARB0SINGUR', 1, 1, 0, 1, '2026-04-01 11:50:53', NULL, '2026-04-01 11:50:53');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `log_authentication`
--

CREATE TABLE `log_authentication` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `browser` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `browser_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `system` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `system_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remote_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `auth_datetime` timestamp NULL DEFAULT NULL,
  `status_id` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `master_bank`
--

CREATE TABLE `master_bank` (
  `bank_id` int(11) NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `bank_alias` varchar(100) NOT NULL,
  `status_id` int(11) NOT NULL DEFAULT '1' COMMENT '1=Active [Default], 2=Inactive',
  `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '0 [Default], 1',
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_by` int(11) NOT NULL,
  `modified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `master_bank`
--

INSERT INTO `master_bank` (`bank_id`, `bank_name`, `bank_alias`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES
(1, 'State Bank of India', 'SBI', 1, 0, 1, '2026-01-07 08:57:28', 1, '2026-01-07 08:51:53'),
(2, 'Bank of Baroda', 'BOB', 1, 0, 1, '2026-01-07 08:57:28', 1, '2026-01-07 08:51:53'),
(3, 'Bank of India', 'BOI', 1, 0, 1, '2026-01-07 08:57:28', 1, '2026-01-07 08:51:53'),
(4, 'Bank of Maharashtra', 'MAHB', 1, 0, 1, '2026-01-07 08:57:28', 1, '2026-01-07 08:51:53'),
(5, 'Canara Bank', 'CANARA', 1, 0, 1, '2026-01-07 08:57:29', 1, '2026-01-07 08:51:53'),
(6, 'Central Bank of India', 'CBI', 1, 0, 1, '2026-01-07 08:57:29', 1, '2026-01-07 08:51:53'),
(7, 'Indian Bank', 'INDIAN', 1, 0, 1, '2026-01-07 08:57:29', 1, '2026-01-07 08:51:53'),
(8, 'Indian Overseas Bank', 'IOB', 1, 0, 1, '2026-01-07 08:57:29', 1, '2026-01-07 08:51:53'),
(9, 'Punjab & Sind Bank', 'PSB', 1, 0, 1, '2026-01-07 08:57:29', 1, '2026-01-07 08:51:53'),
(10, 'Punjab National Bank', 'PNB', 1, 0, 1, '2026-01-07 08:57:29', 1, '2026-01-07 08:51:53'),
(11, 'UCO Bank', 'UCO', 1, 0, 1, '2026-01-07 08:57:29', 1, '2026-01-07 08:51:53'),
(12, 'Union Bank of India', 'UBI', 1, 0, 1, '2026-01-07 08:57:30', 1, '2026-01-07 08:51:53'),
(13, 'HDFC Bank', 'HDFC', 1, 0, 1, '2026-01-07 08:57:30', 1, '2026-01-07 08:51:53'),
(14, 'ICICI Bank', 'ICICI', 1, 0, 1, '2026-01-07 08:57:30', 1, '2026-01-07 08:51:53'),
(15, 'Axis Bank', 'AXIS', 1, 0, 1, '2026-01-07 08:57:30', 1, '2026-01-07 08:51:53'),
(16, 'Kotak Mahindra Bank', 'KOTAK', 1, 0, 1, '2026-01-07 08:57:30', 1, '2026-01-07 08:51:53'),
(17, 'IndusInd Bank', 'INDUSIND', 1, 0, 1, '2026-01-07 08:57:30', 1, '2026-01-07 08:51:53'),
(18, 'IDFC First Bank', 'IDFC', 1, 0, 1, '2026-01-07 08:57:31', 1, '2026-01-07 08:51:53'),
(19, 'Yes Bank', 'YES', 1, 0, 1, '2026-01-07 08:57:31', 1, '2026-01-07 08:51:53'),
(20, 'Federal Bank', 'FEDERAL', 1, 0, 1, '2026-01-07 08:57:31', 1, '2026-01-07 08:51:53'),
(21, 'South Indian Bank', 'SIB', 1, 0, 1, '2026-01-07 08:57:31', 1, '2026-01-07 08:51:53'),
(22, 'Karnataka Bank', 'KBL', 1, 0, 1, '2026-01-07 08:57:31', 1, '2026-01-07 08:51:53'),
(23, 'Karur Vysya Bank', 'KVB', 1, 0, 1, '2026-01-07 08:57:31', 1, '2026-01-07 08:51:53'),
(24, 'DCB Bank', 'DCB', 1, 0, 1, '2026-01-07 08:57:32', 1, '2026-01-07 08:51:53'),
(25, 'City Union Bank', 'CUB', 1, 0, 1, '2026-01-07 08:57:32', 1, '2026-01-07 08:51:53'),
(26, 'Tamilnad Mercantile Bank', 'TMB', 1, 0, 1, '2026-01-07 08:57:32', 1, '2026-01-07 08:51:53'),
(27, 'RBL Bank', 'RBL', 1, 0, 1, '2026-01-07 09:00:06', 1, '2026-01-07 08:51:53'),
(28, 'CSB Bank', 'CSB', 1, 0, 1, '2026-01-07 09:00:06', 1, '2026-01-07 08:51:53'),
(29, 'Bandhan Bank', 'BANDHAN', 1, 0, 1, '2026-01-07 08:57:32', 1, '2026-01-07 08:51:53'),
(30, 'IDBI Bank', 'IDBI', 1, 0, 1, '2026-01-07 08:57:32', 1, '2026-01-07 08:51:53'),
(31, 'Jammu & Kashmir Bank', 'JKB', 1, 0, 1, '2026-01-07 08:57:33', 1, '2026-01-07 08:51:53'),
(32, 'Standard Chartered Bank', 'SCB', 1, 0, 1, '2026-01-07 09:00:36', 1, '2026-01-07 08:51:53'),
(33, 'HSBC Bank', 'HSBC', 1, 0, 1, '2026-01-07 09:00:36', 1, '2026-01-07 08:51:53'),
(34, 'DBS Bank India', 'DBS', 1, 0, 1, '2026-01-07 09:00:36', 1, '2026-01-07 08:51:53'),
(35, 'Deutsche Bank India', 'DEUTSCHE', 1, 0, 1, '2026-01-07 09:00:37', 1, '2026-01-07 08:51:53'),
(36, 'Barclays Bank India', 'BARCLAYS', 1, 0, 1, '2026-01-07 09:00:37', 1, '2026-01-07 08:51:53'),
(37, 'Bank of America India', 'BOFA', 1, 0, 1, '2026-01-07 09:00:37', 1, '2026-01-07 08:51:53'),
(38, 'JP Morgan Chase Bank', 'JPM', 1, 0, 1, '2026-01-07 09:00:37', 1, '2026-01-07 08:51:53'),
(39, 'BNP Paribas India', 'BNP', 1, 0, 1, '2026-01-07 09:00:37', 1, '2026-01-07 08:51:53'),
(40, 'Credit Agricole India', 'CREDIT_AG', 1, 0, 1, '2026-01-07 09:00:37', 1, '2026-01-07 08:51:53'),
(41, 'Mizuho Bank India', 'MIZUHO', 1, 0, 1, '2026-01-07 09:00:38', 1, '2026-01-07 08:51:53'),
(42, 'MUFG Bank India', 'MUFG', 1, 0, 1, '2026-01-07 09:00:38', 1, '2026-01-07 08:51:53'),
(43, 'Shinhan Bank India', 'SHINHAN', 1, 0, 1, '2026-01-07 09:00:38', 1, '2026-01-07 08:51:53'),
(44, 'Qatar National Bank India', 'QNB', 1, 0, 1, '2026-01-07 09:00:38', 1, '2026-01-07 08:51:53'),
(45, 'Industrial & Commercial Bank of China', 'ICBC', 1, 0, 1, '2026-01-07 09:00:38', 1, '2026-01-07 08:51:53'),
(46, 'JSC VTB Bank India', 'VTB', 1, 0, 1, '2026-01-07 09:00:38', 1, '2026-01-07 08:51:53'),
(47, 'AU Small Finance Bank', 'AU', 1, 0, 1, '2026-01-07 09:00:39', 1, '2026-01-07 08:51:53'),
(48, 'Ujjivan Small Finance Bank', 'UJJIVAN', 1, 0, 1, '2026-01-07 09:00:39', 1, '2026-01-07 08:51:53'),
(49, 'Jana Small Finance Bank', 'JANA', 1, 0, 1, '2026-01-07 09:00:39', 1, '2026-01-07 08:51:53'),
(50, 'Equitas Small Finance Bank', 'EQUITAS', 1, 0, 1, '2026-01-07 09:00:39', 1, '2026-01-07 08:51:53'),
(51, 'Utkarsh Small Finance Bank', 'UTKARSH', 1, 0, 1, '2026-01-07 09:00:39', 1, '2026-01-07 08:51:53'),
(52, 'Suryoday Small Finance Bank', 'SURYO', 1, 0, 1, '2026-01-07 09:00:39', 1, '2026-01-07 08:51:53'),
(53, 'ESAF Small Finance Bank', 'ESAF', 1, 0, 1, '2026-01-07 09:00:40', 1, '2026-01-07 08:51:53'),
(54, 'Fincare Small Finance Bank', 'FINCARE', 1, 0, 1, '2026-01-07 09:00:40', 1, '2026-01-07 08:51:53'),
(55, 'North East Small Finance Bank', 'NESFB', 1, 0, 1, '2026-01-07 09:00:40', 1, '2026-01-07 08:51:53'),
(56, 'Capital Small Finance Bank', 'CAPITAL', 1, 0, 1, '2026-01-07 09:00:40', 1, '2026-01-07 08:51:53'),
(57, 'Shivalik Small Finance Bank', 'SHIVALIK', 1, 0, 1, '2026-01-07 09:00:40', 1, '2026-01-07 08:51:53'),
(58, 'Airtel Payments Bank', 'AIRTEL', 1, 0, 1, '2026-01-07 09:00:40', 1, '2026-01-07 08:51:53'),
(59, 'India Post Payments Bank', 'IPPB', 1, 0, 1, '2026-01-07 09:00:41', 1, '2026-01-07 08:51:53'),
(60, 'Paytm Payments Bank', 'PAYTM', 1, 0, 1, '2026-01-07 09:00:41', 1, '2026-01-07 08:51:53'),
(61, 'Fino Payments Bank', 'FINO', 1, 0, 1, '2026-01-07 09:00:41', 1, '2026-01-07 08:51:53'),
(62, 'Jio Payments Bank', 'JIO', 1, 0, 1, '2026-01-07 09:00:41', 1, '2026-01-07 08:51:53'),
(63, 'NSDL Payments Bank', 'NSDL', 1, 0, 1, '2026-01-07 09:00:41', 1, '2026-01-07 08:51:53');

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

--
-- Table structure for table `master_blood_blank`
--

CREATE TABLE `master_blood_blank` (
  `blood_bank_id` int(11) NOT NULL,
  `blood_bank_code` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  `blood_bank_name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `blood_bank_email` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  `blood_bank_contact_no` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
  `blood_bank_address` text CHARACTER SET utf8mb4,
  `status` int(1) NOT NULL DEFAULT '1',
  `is_deleted` int(1) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_by` int(11) DEFAULT NULL,
  `modified_date` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `master_blood_blank`
--

INSERT INTO `master_blood_blank` (`blood_bank_id`, `blood_bank_code`, `blood_bank_name`, `blood_bank_email`, `blood_bank_contact_no`, `blood_bank_address`, `status`, `is_deleted`, `created_by`, `created_date`, `modified_by`, `modified_date`) VALUES
(1, 'BBKOL0001', 'Bllod Bank One', 'bllodbank1.kolkata@gmail.com', '7894561230', 'Kolkata, 700001', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(2, 'BBKOL0002', 'Bllod Bank Two', 'bllodbank2.kolkata@gmail.com', '7894561230', 'Kolkata, 700002', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(3, 'BBKOL0003', 'Bllod Bank Three', 'bllodbank3.kolkata@gmail.com', '7894561230', 'Kolkata, 700003', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(4, 'BBKOL0004', 'Bllod Bank Four', 'bllodbank4.kolkata@gmail.com', '7894561230', 'Kolkata, 700004', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(5, 'BBKOL0005', 'Bllod Bank Five', 'bllodbank5.kolkata@gmail.com', '7894561230', 'Kolkata, 700005', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(6, 'BBKOL0006', 'Bllod Bank Six', 'bllodbank6.kolkata@gmail.com', '7894561230', 'Kolkata, 700006', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(7, 'BBKOL0007', 'Bllod Bank Seven', 'bllodbank7.kolkata@gmail.com', '7894561230', 'Kolkata, 700007', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(8, 'BBKOL0008', 'Bllod Bank Eight', 'bllodbank8.kolkata@gmail.com', '7894561230', 'Kolkata, 700008', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(9, 'BBKOL0009', 'Bllod Bank Nine', 'bllodbank.kolkata@gmail.com', '7894561230', 'Kolkata, 700009', 1, 0, 1, '2026-03-02 12:54:09', NULL, '2026-03-02 12:54:09'),
(10, 'BBKOL0010', 'Bllod Bank Ten', 'bllodbank10.kolkata@gmail.com', '7894561230', 'Kolkata, 700010', 1, 0, 1, '2026-03-02 12:54:09', 1, '2026-03-02 13:20:40'),
(11, 'BBKOL00111', 'Blood Bank Eleven q', 'email@nomail.co.in', '9876543211', 'Kolkata, 700011', 0, 1, 1, '2026-03-09 05:33:20', 1, '2026-03-09 05:37:46');

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

--
-- Table structure for table `master_camp_status`
--

CREATE TABLE `master_camp_status` (
  `camp_status_id` int(11) NOT NULL,
  `camp_status_name` varchar(100) NOT NULL,
  `camp_status_alias` varchar(100) NOT NULL,
  `camp_status_colour` varchar(10) DEFAULT NULL,
  `camp_status_text_colour` varchar(10) DEFAULT NULL,
  `status_id` int(11) NOT NULL DEFAULT '1' COMMENT '1=Active [Default], 2=Inactive',
  `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '0 [Default], 1',
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_by` int(11) DEFAULT NULL,
  `modified_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `master_camp_status`
--

INSERT INTO `master_camp_status` (`camp_status_id`, `camp_status_name`, `camp_status_alias`, `camp_status_colour`, `camp_status_text_colour`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES
(1, 'Requested', 'Req', 'ffff00', '000', 1, 0, 0, '2026-01-14 09:41:31', NULL, NULL),
(2, 'Confirmed', 'Cnf', 'ff9900', 'fff', 1, 0, 0, '2026-01-14 09:42:50', NULL, NULL),
(3, 'Denied', 'Den', 'b30000', 'fff', 1, 0, 0, '2026-01-14 09:42:50', NULL, NULL),
(4, 'Cancelled', 'Can', 'ff0000', 'fff', 1, 0, 0, '2026-01-14 09:42:50', NULL, NULL),
(5, 'Reschedule', 'Res', '0033cc', 'fff', 1, 0, 0, '2026-03-05 05:44:00', NULL, NULL),
(6, 'Conducted', 'Con', '00cc00', 'fff', 1, 0, 0, '2026-01-14 09:42:50', NULL, NULL),
(7, 'Request For Cancellation', 'ReqCan', 'ff3300', 'fff', 1, 0, 0, '2026-01-14 09:42:50', NULL, NULL),
(8, 'Request for Rescheduling', 'ReqRes', '0066ff', 'fff', 1, 0, 0, '2026-03-05 08:50:53', NULL, NULL);

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

--
-- Table structure for table `master_districts`
--

CREATE TABLE `master_districts` (
  `dist_id` int(11) NOT NULL,
  `dist_name` varchar(100) NOT NULL,
  `dist_alias` varchar(100) DEFAULT NULL,
  `status_id` int(11) NOT NULL DEFAULT '1' COMMENT '1=Active [Default], 2=Inactive',
  `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '0 [Default], 1',
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_by` int(11) DEFAULT NULL,
  `modified_at` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `master_districts`
--

INSERT INTO `master_districts` (`dist_id`, `dist_name`, `dist_alias`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES
(1, 'Alipurduar', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(2, 'Bankura', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(3, 'Birbhum', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(4, 'Cooch Behar', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(5, 'Dakshin Dinajpur', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(6, 'Darjeeling', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(7, 'Hooghly', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(8, 'Howrah', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(9, 'Jalpaiguri', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(10, 'Jhargram', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(11, 'Kalimpong', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(12, 'Kolkata', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(13, 'Malda', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(14, 'Murshidabad', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(15, 'Nadia', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(16, 'North 24 Parganas', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(17, 'Paschim Bardhaman', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(18, 'Paschim Medinipur', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(19, 'Purba Bardhaman', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(20, 'Purba Medinipur', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(21, 'Purulia', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(22, 'South 24 Parganas', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(23, 'Uttar Dinajpur', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL),
(24, 'Others', NULL, 1, 0, 1, '2026-03-04 10:50:57', NULL, NULL);

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

--
-- Table structure for table `master_org_bank`
--

CREATE TABLE `master_org_bank` (
  `org_bank_id` int(11) NOT NULL,
  `org_id` int(11) NOT NULL,
  `bank_id` int(11) NOT NULL,
  `org_bank_name` varchar(100) NOT NULL,
  `org_bank_branch` varchar(100) NOT NULL,
  `org_bank_ac_name` varchar(100) NOT NULL,
  `org_bank_ac_no` varchar(20) NOT NULL,
  `org_bank_ifsc` varchar(20) NOT NULL,
  `org_bank_type` varchar(15) NOT NULL COMMENT 'Savings A/C, Current A/C',
  `email` varchar(100) NOT NULL,
  `contract_no` varchar(10) NOT NULL,
  `address` varchar(500) NOT NULL,
  `status_id` int(11) NOT NULL DEFAULT '1' COMMENT '1=Active [Default], 2=Inactive',
  `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '0 [Default], 1',
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `master_org_bank`
--

INSERT INTO `master_org_bank` (`org_bank_id`, `org_id`, `bank_id`, `org_bank_name`, `org_bank_branch`, `org_bank_ac_name`, `org_bank_ac_no`, `org_bank_ifsc`, `org_bank_type`, `email`, `contract_no`, `address`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `updated_at`) VALUES
(1, 1, 1, 'State Bank of India', 'Kolkata', 'Frinds Club', '12345678901', 'SBIN0000001', 'Savings A/C', 'f@nomail.com', '1234567890', 'Kolkata', 1, 0, 0, '2025-12-24 08:45:37', NULL, NULL);

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

--
-- Table structure for table `master_report_type`
--

CREATE TABLE `master_report_type` (
  `report_type_id` int(11) NOT NULL,
  `report_type_name` varchar(255) NOT NULL,
  `report_type_alias_name` varchar(255) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `is_deleted` int(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modfied_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `master_report_type`
--

INSERT INTO `master_report_type` (`report_type_id`, `report_type_name`, `report_type_alias_name`, `status`, `is_deleted`, `created_at`, `modfied_at`) VALUES
(1, '1 BB Bill IEC', '1_BB_Bill_IEC', 1, 0, '2026-03-26 12:55:34', NULL),
(2, '1 BB Bill Ref', '1_BB_Bill_Ref', 1, 0, '2026-03-26 12:55:34', NULL),
(3, '2 BB Bill Ref IEC', '2_BB_Bill_Ref_IEC', 1, 0, '2026-03-26 12:55:34', NULL),
(4, '2A Refreshement and IEC Received Bill Amount', '2A Refreshement and IEC Received Bill Amount', 1, 0, '2026-03-26 12:55:34', NULL),
(5, '2A Rpt Month Wise Detail Camp', '2A_Rpt_Month_Wise_Detail_Camp', 1, 0, '2026-03-26 12:55:34', NULL),
(6, '3A Rpt Month Wise Detail Camp', '3A_Rpt_Month_Wise_Detail_Camp', 1, 0, '2026-03-26 12:55:34', NULL),
(7, '3B Rpt Month Wise Detail Camp', '3B_Rpt_Month_Wise_Detail_Camp', 1, 0, '2026-03-26 12:55:34', NULL),
(8, '3C Qry District Wise Camp Analysis', '3C_Qry_District_Wise_Camp_Analysis', 1, 0, '2026-03-26 12:55:34', NULL),
(9, '3D Rpt District Wise Donors', '3D_Rpt_District_Wise_Donors', 1, 0, '2026-03-26 12:55:34', NULL),
(10, '3E Rpt BB Wise Camp Month Wise', '3E_Rpt_BB_Wise_Camp_Month_Wise', 1, 0, '2026-03-26 12:55:34', NULL),
(11, '3F Qry Donor BB Month Wise', '3F_Qry_Donor_BB_Month_Wise', 1, 0, '2026-03-26 12:55:34', NULL),
(12, '3G Rpt Monthly Summary Executive Meeting', '3G_Rpt_Monthly_Summary_Executive_Meeting', 1, 0, '2026-03-26 12:55:34', NULL),
(13, '3H Rpt Org Pay Due', '3H_Rpt_Org_Pay_Due', 1, 0, '2026-03-26 12:55:34', NULL),
(14, '3I Rpt Qrg Payment Disbursed', '3I_Rpt_Qrg_Payment_Disbursed', 1, 0, '2026-03-26 12:55:34', NULL),
(15, '3J Rpt Payment Rec From BB', '3J_Rpt_Payment_rec_From_BB', 1, 0, '2026-03-26 12:55:34', NULL),
(16, '3K Payment Due From BB', '3K_Payment_Due_From_BB', 1, 0, '2026-03-26 12:55:34', NULL),
(17, '3L Rpt Spot Pay Received From BB', '3L_Rpt_Spot_Pay_received_From_BB', 1, 0, '2026-03-26 12:55:34', NULL),
(18, '3M Rpt Payment Received BB for OWN Camp', '3M_Rpt_Payment_Received_BB_for_OWN_Camp', 1, 0, '2026-03-26 12:55:34', NULL),
(19, '4 BB Bill Ref IEC', '4_BB_Bill_Ref_IEC', 1, 0, '2026-03-26 12:55:34', NULL);

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

--
-- Table structure for table `master_roles`
--

CREATE TABLE `master_roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `master_roles`
--

INSERT INTO `master_roles` (`id`, `name`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 1, '2025-12-23 10:56:25', NULL),
(2, 'User', 1, '2025-12-23 10:57:37', NULL),
(3, 'Volunteer', 1, '2025-12-23 10:57:37', NULL),
(4, 'Organization', 1, '2025-12-23 10:57:37', NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2025_07_21_065327_create_log_authentication_table', 1),
(6, '2025_12_23_103255_create_roles_table', 1),
(7, '2026_01_06_071516_create_audit_logs_table', 2);

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

--
-- Table structure for table `report_log`
--

CREATE TABLE `report_log` (
  `report_id` int(11) NOT NULL,
  `report_type_id` int(11) NOT NULL,
  `ref_no` varchar(20) DEFAULT NULL,
  `date` date NOT NULL,
  `blood_bank_id` int(11) DEFAULT NULL,
  `report_month` int(2) DEFAULT NULL,
  `report_year` int(4) DEFAULT NULL,
  `report_financial_year` varchar(10) DEFAULT NULL,
  `report_file_name` varchar(255) NOT NULL,
  `report_file_path` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `is_deleted` int(1) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report_log`
--

INSERT INTO `report_log` (`report_id`, `report_type_id`, `ref_no`, `date`, `blood_bank_id`, `report_month`, `report_year`, `report_financial_year`, `report_file_name`, `report_file_path`, `status`, `is_deleted`, `created_by`, `created_date`, `modified_date`) VALUES
(1, 1, 'A3AD 0426 01', '2026-04-01', NULL, 4, 2026, NULL, '1_BB_Bill_IEC_April_2026.pdf', 'uploads/Report/1_BB_Bill_IEC/1_BB_Bill_IEC_April_2026.pdf', 1, 0, 1, '2026-04-01 13:01:21', '2026-04-01 13:01:21'),
(2, 2, 'A3AD 0426 01', '2026-04-01', NULL, 4, 2026, NULL, '1_BB_Bill_Ref_April_2026.pdf', 'uploads/Report/1_BB_Bill_Ref/1_BB_Bill_Ref_April_2026.pdf', 1, 0, 1, '2026-04-01 13:01:26', '2026-04-01 13:01:26'),
(3, 3, 'A3AD 0426 02', '2026-04-01', NULL, 4, 2026, NULL, '2_BB_Bill_Ref_IEC_April_2026.pdf', 'uploads/Report/2_BB_Bill_Ref_IEC/2_BB_Bill_Ref_IEC_April_2026.pdf', 1, 0, 1, '2026-04-01 13:01:32', '2026-04-01 13:01:32'),
(4, 4, 'A3AD 0426 02', '2026-04-01', NULL, 4, 2026, NULL, '2A_Refreshement_and_IEC_Received_Bill_Amount_April_2026.pdf', 'uploads/Report/2A_Refreshement_and_IEC_Received_Bill_Amount/2A_Refreshement_and_IEC_Received_Bill_Amount_April_2026.pdf', 1, 0, 1, '2026-04-01 13:01:37', '2026-04-01 13:01:37'),
(5, 5, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '2A_Rpt_Month_Wise_Detail_Camp_2026_27.pdf', 'uploads/Report/2A_Rpt_Month_Wise_Detail_Camp/2A_Rpt_Month_Wise_Detail_Camp_2026_27.pdf', 1, 0, 1, '2026-04-01 13:01:42', '2026-04-01 13:01:42'),
(6, 6, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3A_Rpt_Month_Wise_Detail_Camp_2026_27.pdf', 'uploads/Report/3A_Rpt_Month_Wise_Detail_Camp/3A_Rpt_Month_Wise_Detail_Camp_2026_27.pdf', 1, 0, 1, '2026-04-01 13:01:47', '2026-04-01 13:01:47'),
(7, 7, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3B_Rpt_Month_Wise_Detail_Camp_2026_27.pdf', 'uploads/Report/3B_Rpt_Month_Wise_Detail_Camp/3B_Rpt_Month_Wise_Detail_Camp_2026_27.pdf', 1, 0, 1, '2026-04-01 13:01:51', '2026-04-01 13:01:51'),
(8, 8, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3C_Qry_District_Wise_Camp_Analysis_2026_27.pdf', 'uploads/Report/3C_Qry_District_Wise_Camp_Analysis/3C_Qry_District_Wise_Camp_Analysis_2026_27.pdf', 1, 0, 1, '2026-04-01 13:01:55', '2026-04-01 13:01:55'),
(9, 9, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3D_Rpt_District_Wise_Donors_2026_27.pdf', 'uploads/Report/3D_Rpt_District_Wise_Donors/3D_Rpt_District_Wise_Donors_2026_27.pdf', 1, 0, 1, '2026-04-01 13:01:59', '2026-04-01 13:01:59'),
(10, 10, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3E_Rpt_BB_Wise_Camp_Month_Wise_2026_27.pdf', 'uploads/Report/3E_Rpt_BB_Wise_Camp_Month_Wise/3E_Rpt_BB_Wise_Camp_Month_Wise_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:03', '2026-04-01 13:02:03'),
(11, 11, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3F_Qry_Donor_BB_Month_Wise_2026_27.pdf', 'uploads/Report/3F_Qry_Donor_BB_Month_Wise/3F_Qry_Donor_BB_Month_Wise_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:07', '2026-04-01 13:02:07'),
(12, 12, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3G_Rpt_Monthly_Summary_Executive_Meeting_2026_27.pdf', 'uploads/Report/3G_Rpt_Monthly_Summary_Executive_Meeting/3G_Rpt_Monthly_Summary_Executive_Meeting_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:12', '2026-04-01 13:02:12'),
(13, 13, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3H_Rpt_Org_Pay_Due_2026_27.pdf', 'uploads/Report/3H_Rpt_Org_Pay_Due/3H_Rpt_Org_Pay_Due_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:16', '2026-04-01 13:02:16'),
(14, 14, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3I_Rpt_Qrg_Payment_Disbursed_2026_27.pdf', 'uploads/Report/3I_Rpt_Qrg_Payment_Disbursed/3I_Rpt_Qrg_Payment_Disbursed_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:20', '2026-04-01 13:02:20'),
(15, 15, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3J_Rpt_Payment_rec_From_BB_2026_27.pdf', 'uploads/Report/3J_Rpt_Payment_rec_From_BB/3J_Rpt_Payment_rec_From_BB_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:24', '2026-04-01 13:02:24'),
(16, 16, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3K_Payment_Due_From_BB_2026_27.pdf', 'uploads/Report/3K_Payment_Due_From_BB/3K_Payment_Due_From_BB_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:28', '2026-04-01 13:02:28'),
(17, 18, NULL, '2026-04-01', NULL, NULL, NULL, '2026-27', '3M_Rpt_Payment_Received_BB_for_OWN_Camp_2026_27.pdf', 'uploads/Report/3M_Rpt_Payment_Received_BB_for_OWN_Camp/3M_Rpt_Payment_Received_BB_for_OWN_Camp_2026_27.pdf', 1, 0, 1, '2026-04-01 13:02:33', '2026-04-01 13:02:33'),
(18, 19, 'A3AD 0426 04', '2026-04-01', 1, 4, 2026, NULL, '4_BB_Bill_Ref_IEC_BBKOL0001_April_2026.pdf', 'uploads/Report/4_BB_Bill_Ref_IEC/4_BB_Bill_Ref_IEC_BBKOL0001_April_2026.pdf', 1, 0, 1, '2026-04-01 13:02:39', '2026-04-01 13:02:39'),
(19, 19, 'A3AD 0426 04', '2026-04-01', 2, 4, 2026, NULL, '4_BB_Bill_Ref_IEC_BBKOL0002_April_2026.pdf', 'uploads/Report/4_BB_Bill_Ref_IEC/4_BB_Bill_Ref_IEC_BBKOL0002_April_2026.pdf', 1, 0, 1, '2026-04-01 13:04:44', '2026-04-01 13:04:44');

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

--
-- Table structure for table `volunteer_map_data`
--

CREATE TABLE `volunteer_map_data` (
  `volunteer_map_id` int(11) NOT NULL,
  `org_id` int(11) DEFAULT NULL,
  `camp_id` int(11) DEFAULT NULL,
  `volunteer_id` int(11) DEFAULT NULL,
  `volunteer_name` varchar(255) DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `is_deleted` int(1) DEFAULT '0',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `modified_by` int(11) DEFAULT NULL,
  `modified_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `volunteer_map_data`
--

INSERT INTO `volunteer_map_data` (`volunteer_map_id`, `org_id`, `camp_id`, `volunteer_id`, `volunteer_name`, `status`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES
(1, 1, 1, 1, 'Voluntee r1', 1, 0, 1, '2026-04-01 10:58:01', NULL, '2026-04-01 10:58:01'),
(2, 1, 2, 1, 'Voluntee r1', 1, 0, 1, '2026-04-01 11:26:34', NULL, '2026-04-01 11:26:34');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `camp_bank_details`
--
ALTER TABLE `camp_bank_details`
  ADD PRIMARY KEY (`camp_bank_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Indexes for table `master_bank`
--
ALTER TABLE `master_bank`
  ADD PRIMARY KEY (`bank_id`);

--
-- Indexes for table `master_blood_blank`
--
ALTER TABLE `master_blood_blank`
  ADD PRIMARY KEY (`blood_bank_id`);

--
-- Indexes for table `master_camp_status`
--
ALTER TABLE `master_camp_status`
  ADD PRIMARY KEY (`camp_status_id`);

--
-- Indexes for table `master_districts`
--
ALTER TABLE `master_districts`
  ADD PRIMARY KEY (`dist_id`);

--
-- Indexes for table `master_org_bank`
--
ALTER TABLE `master_org_bank`
  ADD PRIMARY KEY (`org_bank_id`);

--
-- Indexes for table `master_report_type`
--
ALTER TABLE `master_report_type`
  ADD PRIMARY KEY (`report_type_id`),
  ADD UNIQUE KEY `report_type_name` (`report_type_name`);

--
-- Indexes for table `master_roles`
--
ALTER TABLE `master_roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mater_roles_name_unique` (`name`);

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

--
-- Indexes for table `report_log`
--
ALTER TABLE `report_log`
  ADD PRIMARY KEY (`report_id`);

--
-- Indexes for table `volunteer_map_data`
--
ALTER TABLE `volunteer_map_data`
  ADD PRIMARY KEY (`volunteer_map_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;

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

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

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

--
-- AUTO_INCREMENT for table `master_bank`
--
ALTER TABLE `master_bank`
  MODIFY `bank_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `master_blood_blank`
--
ALTER TABLE `master_blood_blank`
  MODIFY `blood_bank_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `master_camp_status`
--
ALTER TABLE `master_camp_status`
  MODIFY `camp_status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `master_districts`
--
ALTER TABLE `master_districts`
  MODIFY `dist_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

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

--
-- AUTO_INCREMENT for table `master_report_type`
--
ALTER TABLE `master_report_type`
  MODIFY `report_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `master_roles`
--
ALTER TABLE `master_roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `report_log`
--
ALTER TABLE `report_log`
  MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `volunteer_map_data`
--
ALTER TABLE `volunteer_map_data`
  MODIFY `volunteer_map_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

