-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 01, 2026 at 06:54 PM -- Server version: 5.7.44 -- PHP Version: 8.1.34 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `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 `blood_collected_data` -- CREATE TABLE `blood_collected_data` ( `blood_collected_id` int(11) NOT NULL, `org_id` int(11) DEFAULT NULL, `camp_id` int(11) DEFAULT NULL, `blood_bank_id` int(11) DEFAULT NULL, `blood_bank_type` int(11) DEFAULT NULL, `blood_bank_name` varchar(500) DEFAULT NULL, `blood_bank_code` varchar(50) DEFAULT NULL, `booking_time` time DEFAULT NULL, `is_blood_bank_selected` int(1) DEFAULT '0', `arrival_time` time DEFAULT NULL, `closing_time` time DEFAULT NULL, `no_of_bag_booked` int(11) DEFAULT NULL, `blood_bag_code` varchar(50) DEFAULT NULL, `blood_bag_from` varchar(50) DEFAULT NULL, `blood_bag_to` varchar(50) DEFAULT NULL, `credit_card_due` int(11) DEFAULT '0', `refreshment_charge` decimal(10,2) DEFAULT '0.00', `iec_grant_paid` decimal(10,2) DEFAULT '0.00', `status` tinyint(1) DEFAULT '1', `is_deleted` tinyint(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 ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `blood_collected_data` -- INSERT INTO `blood_collected_data` (`blood_collected_id`, `org_id`, `camp_id`, `blood_bank_id`, `blood_bank_type`, `blood_bank_name`, `blood_bank_code`, `booking_time`, `is_blood_bank_selected`, `arrival_time`, `closing_time`, `no_of_bag_booked`, `blood_bag_code`, `blood_bag_from`, `blood_bag_to`, `credit_card_due`, `refreshment_charge`, `iec_grant_paid`, `status`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES (4, 1, 1, 1, NULL, 'Bllod Bank One', 'BBKOL0001', '10:00:00', 1, '10:00:00', '16:00:00', 20, 'BGTT5', '01', '20', 20, 4478.00, 1478.00, 1, 0, 1, '2026-04-01 11:05:30', 1, '2026-04-01 11:37:42'), (5, 1, 1, 2, NULL, 'Bllod Bank Two', 'BBKOL0002', '10:00:00', 0, NULL, NULL, 20, NULL, NULL, NULL, 0, 0.00, 0.00, 1, 0, 1, '2026-04-01 11:05:31', NULL, '2026-04-01 11:05:31'), (6, 1, 1, 3, NULL, 'Bllod Bank Three', 'BBKOL0003', '10:00:00', 0, NULL, NULL, 20, NULL, NULL, NULL, 0, 0.00, 0.00, 1, 0, 1, '2026-04-01 11:05:31', NULL, '2026-04-01 11:05:31'), (7, 1, 2, 2, NULL, 'Bllod Bank Two', 'BBKOL0002', '10:00:00', 1, '10:00:00', '16:00:00', 20, 'BFEE4', '01', '20', 10, 1523.00, 456.00, 1, 0, 1, '2026-04-01 11:26:19', 1, '2026-04-01 11:36:26'); -- -------------------------------------------------------- -- -- 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 `camp_details` -- CREATE TABLE `camp_details` ( `camp_id` int(11) NOT NULL, `org_id` int(11) NOT NULL, `exp_no_of_donors` int(11) NOT NULL, `camp_date` date NOT NULL, `camp_date_one` date NOT NULL, `camp_date_two` date NOT NULL, `camp_time` time DEFAULT NULL, `camp_venue` varchar(500) NOT NULL, `camp_venue_dist_id` int(11) NOT NULL, `camp_venue_dist_name` varchar(100) NOT NULL, `camp_venue_pin` int(11) NOT NULL, `venue_direction` varchar(255) NOT NULL, `camp_code` varchar(20) DEFAULT NULL, `local_contact_person_name` varchar(100) DEFAULT NULL, `local_contact_person_address` text, `local_contact_person_mobile` varchar(10) DEFAULT NULL, `gift_iems` varchar(500) DEFAULT NULL, `approx_gift_money` decimal(10,2) DEFAULT NULL, `refreshment_charge_paid` int(1) DEFAULT '0', `rcp_issued` int(11) DEFAULT NULL, `rcp_due` int(11) DEFAULT NULL, `credit_card_issued` int(1) DEFAULT '0', `cci_issued` int(11) DEFAULT NULL, `cci_due` int(11) DEFAULT NULL, `iec_charge_paid` int(1) DEFAULT '0', `iec_issued` int(11) DEFAULT NULL, `iec_due` int(11) DEFAULT NULL, `additional_remarks` text, `total_credit_card_due` int(11) DEFAULT NULL, `total_refreshment_charge` decimal(18,2) DEFAULT NULL, `total_iec_grant_paid` decimal(18,2) DEFAULT NULL, `reschedule_reason` text, `denied_reason` text, `cancelled_by` int(11) DEFAULT NULL, `cancel_by_other` varchar(255) DEFAULT NULL, `cancel_reason` text, `req_camp_date` date DEFAULT NULL, `request_cancel_postponed_reason` text, `status_id` int(11) NOT NULL COMMENT '1=Requested, 2=Confirmed, 3=Denied, 4=Cancelled, 5=Postponed, 6=Conducted,7=Request for Cancellation, 8= Request For Rescheduling', `is_deleted` int(11) NOT NULL 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 '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `camp_details` -- INSERT INTO `camp_details` (`camp_id`, `org_id`, `exp_no_of_donors`, `camp_date`, `camp_date_one`, `camp_date_two`, `camp_time`, `camp_venue`, `camp_venue_dist_id`, `camp_venue_dist_name`, `camp_venue_pin`, `venue_direction`, `camp_code`, `local_contact_person_name`, `local_contact_person_address`, `local_contact_person_mobile`, `gift_iems`, `approx_gift_money`, `refreshment_charge_paid`, `rcp_issued`, `rcp_due`, `credit_card_issued`, `cci_issued`, `cci_due`, `iec_charge_paid`, `iec_issued`, `iec_due`, `additional_remarks`, `total_credit_card_due`, `total_refreshment_charge`, `total_iec_grant_paid`, `reschedule_reason`, `denied_reason`, `cancelled_by`, `cancel_by_other`, `cancel_reason`, `req_camp_date`, `request_cancel_postponed_reason`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES (1, 1, 120, '2026-04-06', '2026-04-03', '2026-04-04', '10:00:00', 'Singur', 7, 'Hooghly', 712409, 'Singur Station', '2026-27/0001', 'Rishov Mal', 'Singur', '9007742088', 'Cooker', 849.00, 1, 10, 10, 0, 0, 20, 1, 10, 10, 'test', 20, 4478.00, 1478.00, 'test', 'test', NULL, NULL, NULL, NULL, NULL, 6, 0, 4, '2026-04-01 11:38:07', 1, '2026-04-01 06:08:10'), (2, 1, 100, '2026-04-01', '2026-04-02', '2026-04-03', '10:00:00', 'Kolkata', 12, 'Kolkata', 700091, 'Ambuja Neotia Ecocentre', '2026-27/0002', 'Rishov Mal', 'Ambuja Neotia Ecocentre', '9007742088', 'Umbrella', 152.00, 1, 10, 10, 0, 0, 20, 1, 5, 15, 'test', 10, 1523.00, 456.00, NULL, NULL, 2, NULL, 'demo', NULL, NULL, 6, 0, 1, '2026-04-01 11:36:24', 1, '2026-04-01 06:06:27'); -- -------------------------------------------------------- -- -- Table structure for table `donor_details` -- CREATE TABLE `donor_details` ( `donor_id` int(11) NOT NULL, `camp_id` int(11) NOT NULL, `sr_no` varchar(20) NOT NULL, `donor_name` varchar(100) NOT NULL, `age` int(11) NOT NULL, `gender` varchar(10) NOT NULL, `weight` int(11) NOT NULL, `blood_group` varchar(10) DEFAULT NULL, `blood_rh` varchar(20) DEFAULT NULL, `phone_no` varchar(10) NOT NULL, `whatsapp_no` varchar(10) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `donor_address` varchar(500) DEFAULT NULL, `donor_dist_id` int(11) DEFAULT NULL, `donor_dist_name` varchar(100) DEFAULT NULL, `donor_pincode` int(11) DEFAULT NULL, `camp_date` date NOT NULL, `camp_code` varchar(20) NOT NULL, `bag_no` varchar(10) NOT NULL, `blood_collected_id` int(11) NOT NULL, `is_credit_card_issued` int(1) DEFAULT '0', `credit_card_issued_date` date DEFAULT NULL, `is_group_card_issued` int(1) DEFAULT '0', `group_card_issued_date` date 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, `modified_by` int(11) DEFAULT NULL, `modified_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `donor_details` -- INSERT INTO `donor_details` (`donor_id`, `camp_id`, `sr_no`, `donor_name`, `age`, `gender`, `weight`, `blood_group`, `blood_rh`, `phone_no`, `whatsapp_no`, `email`, `donor_address`, `donor_dist_id`, `donor_dist_name`, `donor_pincode`, `camp_date`, `camp_code`, `bag_no`, `blood_collected_id`, `is_credit_card_issued`, `credit_card_issued_date`, `is_group_card_issued`, `group_card_issued_date`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES (1, 2, '1', 'Pallab Kar', 35, 'Male', 75, 'A', 'Rh-positive (+)', '9876543210', '9876543210', NULL, 'Kolkata', 12, 'Kolkata', 700091, '2026-04-01', '2026-27/0002', '6', 7, 0, NULL, 0, NULL, 1, 0, 1, '2026-04-01 06:05:03', NULL, '2026-04-01 06:05:03'), (2, 2, '2', 'Rishov Mal', 25, 'Male', 75, 'A', 'Rh-positive (+)', '9007742088', '9007742088', NULL, 'Singur', 7, 'Hooghly', 712409, '2026-04-01', '2026-27/0002', '5', 7, 0, NULL, 0, NULL, 1, 0, 1, '2026-04-01 06:05:04', NULL, '2026-04-01 06:05:04'), (3, 1, '1', 'Pallab Kar', 35, 'Male', 75, 'A', 'Rh-positive (+)', '9876543210', '9876543210', NULL, 'Kolkata', 12, 'Kolkata', 700091, '2026-04-06', '2026-27/0001', '6', 4, 0, NULL, 0, NULL, 1, 0, 1, '2026-04-01 06:07:07', NULL, '2026-04-01 06:07:07'), (4, 1, '2', 'Rishov Mal', 25, 'Male', 75, 'A', 'Rh-positive (+)', '9007742088', '9007742088', NULL, 'Singur', 7, 'Hooghly', 712409, '2026-04-06', '2026-27/0001', '5', 4, 0, NULL, 0, NULL, 1, 0, 1, '2026-04-01 06:07:08', NULL, '2026-04-01 06:07:08'); -- -------------------------------------------------------- -- -- 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_organization` -- CREATE TABLE `master_organization` ( `org_id` int(11) NOT NULL, `org_name` varchar(100) DEFAULT NULL, `org_alias` varchar(100) DEFAULT NULL, `org_code` varchar(50) DEFAULT NULL, `org_uoc` varchar(50) NOT NULL, `org_type` int(11) DEFAULT NULL, `org_email` varchar(100) DEFAULT NULL, `org_contract_no` varchar(10) DEFAULT NULL, `contract_person` varchar(100) DEFAULT NULL, `org_address` varchar(500) DEFAULT NULL, `org_dist_id` int(11) NOT NULL, `org_dist_name` varchar(100) NOT NULL, `org_address_pin` int(11) DEFAULT NULL, `is_past_org` enum('1','2') NOT NULL, `email_otp` varchar(255) DEFAULT NULL, `email_otp_expires_at` datetime DEFAULT NULL, `is_otp_verified` int(11) 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_organization` -- INSERT INTO `master_organization` (`org_id`, `org_name`, `org_alias`, `org_code`, `org_uoc`, `org_type`, `org_email`, `org_contract_no`, `contract_person`, `org_address`, `org_dist_id`, `org_dist_name`, `org_address_pin`, `is_past_org`, `email_otp`, `email_otp_expires_at`, `is_otp_verified`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES (1, 'Friends Club', 'FRIEND_CLUB', 'abc/001', 'ORG0000001', 1, 'friendsclub@nomail.com', '1234567891', 'Mr. S K Mukherjee', 'Shyamnagar, 24PGS(N), 743127.', 1, 'Alipurduar', 743127, '2', NULL, NULL, NULL, 1, 0, 0, '2026-04-01 11:13:25', 1, '2026-04-01 05:43:28'), (5, 'Via Vitae Solution', 'VIA_VITAE_SOLUTION', 'ORG0000002', 'ORG0000002', 2, 'contact@nomail.com', '9876543212', 'S Saha', 'Kolkata', 0, '', 700091, '2', NULL, NULL, NULL, 1, 0, 1, '2026-03-09 10:08:44', 1, '2026-03-06 00:15:55'), (6, 'City Club', 'CITY_CLUB', NULL, 'ORG0000003', 2, 'cityclub@gmail.com', '1234567890', 'A Saha', 'Kolkata', 0, '', 700064, '2', NULL, NULL, NULL, 1, 0, 1, '2026-03-31 11:40:18', 1, '2026-03-05 06:21:43'), (8, 'Indian Solutions', 'INDIAN_SOLUTIONS', '', 'ORG0000004', 2, 'rishov.official@gmail.com', '9007742088', 'Rishov Mal', 'Singur, Hooghly', 0, '', 712409, '1', NULL, NULL, NULL, 1, 0, 1, '2026-03-04 11:16:07', NULL, '2026-01-13 03:13:12'), (9, 'Singur Club', 'SINGUR_CLUB', '', 'ORG0000005', 2, 'rishov.rm2@gmail.com', '9007742088', 'Rishov Mal', 'Singur, Hooghly', 0, '', 712409, '1', NULL, NULL, NULL, 1, 0, 1, '2026-03-31 11:40:18', NULL, '2026-01-14 00:43:38'), (10, 'abc', 'ABC', '', 'ORG0000006', 2, 'abc@gmail.in', '0332441139', 'abc', 'abc', 0, '', 711106, '1', NULL, NULL, NULL, 0, 0, 1, '2026-03-04 11:36:00', NULL, '2026-01-14 04:12:59'), (32, 'Indian Solutions PVT LTD', 'INDIAN_SOLUTIONS_PVT_LTD', '', 'ORG0000007', 2, 'nirmalendu.khan@viavitae.co.in', '9007742088', 'Rishov Mal', 'Kolkata', 0, '', 712409, '1', '448570', '2026-01-16 10:53:35', 1, 0, 0, 1, '2026-03-04 13:12:37', 1, '2026-03-04 07:35:37'), (33, 'Rishov Mal', 'RISHOV_MAL', NULL, 'ORG0000008', 2, 'rishov.rm3@gmail.com', '9007742085', 'Rishov Mal', 'Kolkata', 24, 'Mumbai', 712409, '1', '657041', '2026-03-04 13:22:52', 1, 1, 0, 1, '2026-03-31 11:40:19', NULL, '2026-03-04 07:43:18'); -- -------------------------------------------------------- -- -- 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 `master_volunteer` -- CREATE TABLE `master_volunteer` ( `volunteer_id` int(11) NOT NULL, `volunteer_name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `contract_no` varchar(10) NOT NULL, `address` varchar(500) NOT NULL, `vol_dist_id` int(11) NOT NULL, `vol_dist_name` varchar(100) NOT NULL, `vol_address_pin` int(11) 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, `modified_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `master_volunteer` -- INSERT INTO `master_volunteer` (`volunteer_id`, `volunteer_name`, `email`, `contract_no`, `address`, `vol_dist_id`, `vol_dist_name`, `vol_address_pin`, `status_id`, `is_deleted`, `created_by`, `created_at`, `modified_by`, `modified_at`) VALUES (1, 'Voluntee r1', 'volunteer1@nomail.com', '9007742088', 'Singur, Hooghly, 712409', 0, '', 0, 1, 0, 1, '2026-01-09 13:04:29', 1, '2026-01-09 07:34:04'), (2, 'Voluntee r2', 'volunteer2@nomail.com', '9834567890', 'Singur, Hooghly, 712409', 0, '', 0, 1, 0, 1, '2026-01-12 06:21:16', 1, '2026-01-12 00:51:14'), (3, 'Rishov Mal', 'rishov.mal@viavitae.co.in', '9007742088', 'Singur, Hooghly', 0, '', 0, 0, 1, 1, '2026-01-15 05:55:50', 1, '2026-01-15 00:25:51'), (4, 'Saikat Modal', 'saikat.mondal@viavitae.co.in', '9876543210', 'Aamtala', 0, '', 0, 2, 1, 1, '2026-01-15 05:58:01', 1, '2026-01-15 00:28:01'), (8, 'Volunteer 3', 'volunteer@gmail.com', '9898986555', 'Kolkata', 0, '', 0, 2, 1, 1, '2026-01-09 12:26:04', 1, '2026-01-09 06:56:04'), (9, 'Nirmalendu Khan', 'example@gmail.com', '9854654684', 'Howrah', 0, '', 0, 2, 1, 1, '2026-01-09 12:25:57', 1, '2026-01-09 06:55:58'), (10, 'Rishov Mal', 'rishov.mal@viavitae.co.in', '9007742088', 'Singur, Hooghly', 0, '', 0, 1, 0, 1, '2026-01-15 05:57:34', 1, '2026-01-15 00:18:26'), (11, 'Voluntee rrrrr', 'vbg@gmail.com', '9834567890', 'AGARTALA', 0, '', 0, 0, 1, 1, '2026-01-12 06:25:08', 1, '2026-01-12 00:55:06'), (12, 'Ankur Biswas', 'example4@email.com', '8989898989', 'Arambagh', 0, '', 0, 0, 1, 1, '2026-01-13 10:14:59', 1, '2026-01-13 04:45:01'), (13, 'Saikat Modal', 'example@email.com', '8989898989', 'India', 0, '', 0, 0, 1, 1, '2026-01-15 06:52:20', 1, '2026-01-15 01:22:20'), (14, 'Ankur Biswas', 'example9@email.com', '9854654684', 'Arambagh', 0, '', 0, 1, 0, 1, '2026-01-15 01:18:50', NULL, '2026-01-15 01:18:50'), (15, 'Bhaskar Dey', 'example5@email.com', '9898986555', 'Nasibpur', 0, '', 0, 0, 1, 1, '2026-01-15 06:53:25', 1, '2026-01-15 01:23:25'), (16, 'Nirmalendu Khan', 'nirmalendu.khan@viavitae.co.in', '9834567890', 'Bidhannnagar', 24, 'Saltlake', 700064, 1, 0, 1, '2026-03-10 10:19:34', 1, '2026-03-10 04:49:35'), (17, 'Saikat Modal', 'saikat.mondal@nomail.com', '8989898989', 'Amtala', 10, 'Jhargram', 700091, 0, 1, 1, '2026-03-10 10:57:19', 1, '2026-03-10 05:27:20'); -- -------------------------------------------------------- -- -- 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 `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `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 `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 `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `role_id` int(11) NOT NULL DEFAULT '2', `org_id` int(11) NOT NULL, `volunteer_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `contract_no` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `role_id`, `org_id`, `volunteer_id`, `name`, `username`, `email`, `email_verified_at`, `contract_no`, `address`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 1, 0, 0, 'Admin', 'admin@nomail.com', 'admin@nomail.com', '2025-12-23 05:29:51', '', NULL, '$2y$12$i43msW9WNPblHPR8TxbYzOeQi.UVqx42msKREVt6oZ3UY6Zm0O3b2', NULL, '2025-12-23 05:29:51', '2026-01-13 04:55:47'), (2, 2, 0, 0, 'User', 'user@nomail.com', 'user@nomail.com', '2025-12-23 05:29:51', '', NULL, '$2y$12$zDYcrh0jvR9bElFLbaiOFOT08A99/WNIK/b0TOb8maoYTZpjzn3Ay', NULL, '2025-12-23 05:29:51', NULL), (3, 3, 0, 1, 'Volunteer1', 'volunteer1@nomail.com', 'volunteer1@nomail.com', '2025-12-23 05:29:51', '', NULL, '$2y$12$zDYcrh0jvR9bElFLbaiOFOT08A99/WNIK/b0TOb8maoYTZpjzn3Ay', NULL, '2025-12-23 05:29:51', NULL), (4, 4, 1, 0, 'Friends Club', 'friendsclub@nomail.com', 'friendsclub@nomail.com', '2025-12-23 05:29:51', '1234567891', NULL, '$2y$12$zDYcrh0jvR9bElFLbaiOFOT08A99/WNIK/b0TOb8maoYTZpjzn3Ay', NULL, '2025-12-23 05:29:51', '2026-03-09 06:59:59'), (5, 4, 5, 0, 'Via Vitae Solution', 'contact@nomail.com', 'contact@nomail.com', NULL, '9876543210', 'Kolkata', '$2y$12$ZIQAKsY9oQmnMPx.vBDIauCs47Fk/PCDpq1GKpGZPau/yGH66slyK', NULL, '2025-12-24 04:25:41', '2025-12-24 04:25:41'), (6, 4, 6, 0, 'City Club', 'cityclub@nomail.com', 'cityclub@nomail.com', NULL, '9876543211', 'Kolkata', '$2y$12$qwDWzU8jplkDCT9JUtgSYegpG3LLQdRdUfDkC1KbsyXhoDEAr1KQy', NULL, '2025-12-26 00:24:20', '2025-12-26 00:24:20'), (8, 3, 0, 11, 'Voluntee rrrrr', 'vbg@gmail.com', 'vbg@gmail.com', NULL, '9876543212', 'AGARTALA', '$2y$12$hLpDlVl3nQPcAMU03EWRu.bMOJVBXRIVzXgKq4oXARuoVQ/j6p/AG', NULL, '2026-01-12 00:53:51', '2026-01-12 00:53:51'), (10, 4, 8, 0, 'Indian Solutions', 'rishov.official@gmail.com', 'rishov.official@gmail.com', NULL, '9007742088', 'Singur, Hooghly', '$2y$12$oTfihDIlxFVzML4M2g5meecsgcVCQ9xds6Lkkzd.rmBICJ97qfFwi', NULL, '2026-01-13 03:13:13', '2026-01-13 03:13:13'), (12, 4, 9, 0, 'Singur Club', 'rishov.rm2@gmail.com', 'rishov.rm2@gmail.com', NULL, '9007742088', 'Singur, Hooghly', '$2y$12$tfdR/wZakENAJ46tbOwQouNuA5Ss/m7NS2uQ.aan5du7RAZzQgAFO', NULL, '2026-01-14 00:43:39', '2026-01-14 00:43:39'), (13, 4, 10, 0, 'abc', 'abc@gmail.in', 'abc@gmail.in', NULL, '0332441139', 'abc', '$2y$12$lqLhTNMOCgJlWUiSM/0jqOT9PO8dzUFDnEnLxPtbsUXpQhyvpOlvq', NULL, '2026-01-14 04:12:59', '2026-01-14 04:12:59'), (14, 3, 0, 10, 'Rishov Mal', 'rishov.mal@viavitae.co.in', 'rishov.mal@viavitae.co.in', NULL, '9007742088', 'Singur', '$2y$12$1BBeo8OawgdHY9bbRc.NNuyA4l5usjx6LPmF9dlACLYzZZ8rdqDDm', NULL, '2026-01-12 00:53:51', '2026-01-15 07:52:06'), (16, 3, 0, 14, 'Ankur Biswas', 'example9@email.com', 'example9@email.com', NULL, '9854654684', 'Arambagh', '$2y$12$6mWGIhAwLCah2CosgCYGkeTiV/LKiqNbDV3tlX5df93cY0JJ1PmdO', NULL, '2026-01-15 01:18:50', '2026-01-15 01:18:50'), (25, 4, 32, 0, 'Indian Solutions PVT LTD', 'rishov.rm@gmail.com', 'rishov.rm@gmail.com', NULL, '9007742088', 'Kolkata', '$2y$12$SaU9tJ7IBrIf92anggMF/uA1SUoWmsOdui8FCWvGVC8qox4bdTed2', NULL, '2026-01-16 05:13:52', '2026-01-16 05:13:52'), (26, 3, 0, 16, 'Nirmalendu Khan', 'nirmalendu.khan@viavitae.co.in', 'nirmalendu.khan@viavitae.co.in', NULL, '9834567890', 'Bidhannnagar', '$2y$12$KKBm8jbyIRjhwJxi3y7itu5D5Dw/rEvn0aY5XW.qDb6yT5pCJiit.', NULL, '2026-02-02 00:41:11', '2026-03-10 04:49:35'), (27, 4, 33, 0, 'Rishov Mal', 'rishov.rm3@gmail.com', 'rishov.rm3@gmail.com', NULL, '9007742085', 'Kolkata', '$2y$12$yce/x234p2JTPQjBO4b.k.w3xhm9hRNez5JOZHni9VrXD/K5k9iPe', NULL, '2026-03-04 07:43:18', '2026-03-04 07:43:18'); -- -------------------------------------------------------- -- -- 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 `blood_collected_data` -- ALTER TABLE `blood_collected_data` ADD PRIMARY KEY (`blood_collected_id`); -- -- Indexes for table `camp_bank_details` -- ALTER TABLE `camp_bank_details` ADD PRIMARY KEY (`camp_bank_id`); -- -- Indexes for table `camp_details` -- ALTER TABLE `camp_details` ADD PRIMARY KEY (`camp_id`); -- -- Indexes for table `donor_details` -- ALTER TABLE `donor_details` ADD PRIMARY KEY (`donor_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_organization` -- ALTER TABLE `master_organization` ADD PRIMARY KEY (`org_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 `master_volunteer` -- ALTER TABLE `master_volunteer` ADD PRIMARY KEY (`volunteer_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `report_log` -- ALTER TABLE `report_log` ADD PRIMARY KEY (`report_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`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 `blood_collected_data` -- ALTER TABLE `blood_collected_data` MODIFY `blood_collected_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- 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 `camp_details` -- ALTER TABLE `camp_details` MODIFY `camp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `donor_details` -- ALTER TABLE `donor_details` MODIFY `donor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- 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_organization` -- ALTER TABLE `master_organization` MODIFY `org_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- 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 `master_volunteer` -- ALTER TABLE `master_volunteer` MODIFY `volunteer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;