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

START TRANSACTION;



--
-- Database: `membership-system`
--

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

--
-- Table structure for table `blacklisted_workers`
--

CREATE TABLE `blacklisted_workers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `incident_date` date DEFAULT NULL,
  `reason` text NOT NULL,
  `proof` text DEFAULT NULL,
  `proof_file_path` text DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `reported_by` bigint(20) UNSIGNED NOT NULL,
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `is_public` tinyint(1) NOT NULL DEFAULT 0,
  `reviewed_by` bigint(20) UNSIGNED DEFAULT NULL,
  `reviewed_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;

--
-- Dumping data for table `blacklisted_workers`
--

INSERT INTO `blacklisted_workers` (`id`, `name`, `email`, `phone`, `address`, `position`, `incident_date`, `reason`, `proof`, `proof_file_path`, `company_name`, `reported_by`, `approved`, `status`, `is_public`, `reviewed_by`, `reviewed_at`, `created_at`, `updated_at`) VALUES
(1, 'Puspa Bajracharyasaman', 'umesh@gmail.com', '9701859791', 'Lalitpur', 'Security', '2082-06-08', 'violation of rule', 'due to the misbehaviour', '[\"blacklist_proofs\\/1758090911_35MKOZaipg.jpg\"]', 'kantiur security', 2, 0, 'pending', 0, NULL, NULL, '2025-09-17 00:50:11', '2025-09-17 00:50:11');

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

--
-- Table structure for table `executive_committees`
--

CREATE TABLE `executive_committees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `post_id` bigint(20) UNSIGNED NOT NULL,
  `year` year(4) NOT 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 `executive_committees`
--

INSERT INTO `executive_committees` (`id`, `name`, `post_id`, `year`, `created_at`, `updated_at`) VALUES
(2, 'umesh maharjan', 1, '2082', '2025-09-19 01:41:38', '2025-09-19 01:41:38'),
(3, 'Sudip Kumar Thapa', 2, '2025', '2025-09-19 01:48:55', '2025-09-19 01:48:55');

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

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

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

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `member_cancellations`
--

CREATE TABLE `member_cancellations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `reason` text NOT NULL,
  `cancelled_by` bigint(20) UNSIGNED 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 `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED NOT NULL,
  `receiver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `message` text NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `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 `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_04_28_065042_add_role_to_users_table', 1),
(5, '2025_04_28_074810_add_status_to_users_table', 1),
(6, '2025_04_28_084652_add_expiry_date_to_users_table', 1),
(7, '2025_04_28_093922_create_members_table', 1),
(8, '2025_04_28_095511_add_company_fields_to_users_table', 1),
(9, '2025_06_03_115805_create_member_cancellations_table', 1),
(10, '2025_06_04_054226_create_user_documents_table', 1),
(11, '2025_06_09_052440_add_profile_image_to_users_table', 1),
(12, '2025_06_09_070425_add_member_type_to_users_table', 1),
(13, '2025_06_09_101930_create_blacklisted_workers_table', 1),
(14, '2025_06_11_053620_create_reasons_table', 1),
(15, '2025_06_15_063303_create_messages_table', 1),
(16, '2025_06_22_052316_create_pages_table', 1),
(17, '2025_06_22_054916_add_image_to_pages_table', 1),
(18, '2025_09_17_052626_add_gender_to_users_table', 2),
(19, '2025_09_17_061839_add_comments_to_users_table', 3),
(20, '2025_09_18_065808_create_security_compays_table', 4),
(21, '2025_09_18_065808_create_security_companies_table', 5),
(22, '2025_09_18_092121_add_company_type_to_security_companies_table', 5),
(23, '2025_09_19_060932_create_posts_table', 6),
(24, '2025_09_19_062820_create_executive_committees_table', 7),
(25, '2025_09_19_073516_create_suchanas_table', 8);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `content` longtext NOT 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 `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `image`, `content`, `created_at`, `updated_at`) VALUES
(1, 'About US', 'about-us', NULL, '<p>सिक्युरिटी उद्यमी संघमा तपाईंलाई स्वागत छ, जुन क्षेत्रीय सुरक्षा व्यवसायका पेशेवरहरूको हितलाई अगाडि बढाउन समर्पित एक प्रमुख संस्था हो। हाम्रो मिशन सदस्यहरूलाई सुरक्षा उद्योगभित्र विश्वास, व्यावसायिकता, र नवप्रवर्तनमार्फत सशक्त बनाउनु हो।<br><br>हाम्रो सुरक्षित सदस्यता पोर्टलमार्फत, तपाईं सजिलै लगइन वा दर्ता गरेर आफ्नो व्यक्तिगत ड्यासबोर्डमा पहुँच पाउन सक्नुहुन्छ। आफ्नो संस्थाको प्रोफाइल व्यवस्थापन गर्नुहोस्, आफ्नो गतिविधिहरू ट्र्याक गर्नुहोस्, उद्योगका साथीहरूसँग जडान हुनुहोस्, र नवीनतम प्रवृत्ति र नियमहरूबारे अपडेट रहनुहोस्। हामी तपाईंलाई आत्मविश्वासका साथ नेतृत्व गर्न र संरक्षणका उच्चतम मापदण्डहरू कायम राख्न आवश्यक उपकरण र स्रोतहरू प्रदान गर्छौं।<br><br>हामीसँग जोडिनुहोस् र सुरक्षा सेवाहरूमा उत्कृष्टता र सहकार्यमा प्रतिबद्ध विश्वसनीय नेटवर्कको हिस्सा बन्नुहोस्।<br><br><i>(Empowering Trust, Enabling Protection. Welcome to the Security Entrepreneurs Association, the premier organization dedicated to advancing the interests of security business professionals across the region. Our mission is to empower members by fostering trust, professionalism, and innovation within the security industry. Through our secure membership portal, you can easily log in or register to access your personalized dashboard. Manage your organization’s profile, track your activities, connect with industry peers, and stay updated on the latest trends and regulations. We provide the tools and resources you need to lead with confidence and uphold the highest standards of protection. Join us to be part of a trusted network committed to excellence and collaboration in security services.)</i></p>', '2025-09-22 23:35:46', '2025-09-22 23:35:46'),
(2, 'Contact Us', 'contact-us', NULL, '<p><strong>सिक्युरिटी उद्यमी संघमा तपाईंलाई स्वागत छ।</strong><br>हामी क्षेत्रीय सुरक्षा व्यवसायका पेशेवरहरूको हित र सशक्तीकरणका लागि समर्पित प्रमुख संस्था हौं। यदि तपाईंलाई कुनै जिज्ञासा, सुझाव, वा सदस्यता सम्बन्धी जानकारी आवश्यक छ भने हामीसँग सम्पर्क गर्न सक्नुहुन्छ।</p><p>📍 <strong>स्थान:</strong> कालिमाटी, काठमाडौं, नेपाल<br>📧 <strong>इमेल:</strong> info@exsecuritycouncil.org<br>📞 <strong>फोन:</strong> +977-1-2020172</p><h3>किन सम्पर्क गर्ने?</h3><p>सदस्यता दर्ता र लगइन सहयोग</p><p>आफ्नो संगठन प्रोफाइल वा गतिविधि व्यवस्थापनसम्बन्धी प्रश्न</p><p>उद्योग सम्बन्धी नवीनतम प्रवृत्ति र नियमहरूको जानकारी</p><p>&nbsp;</p>', '2025-09-22 23:38:16', '2025-09-22 23:38:16');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT 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 `posts`
--

INSERT INTO `posts` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'अध्यक्ष', NULL, NULL),
(2, 'वरिष्ठ उपाध्यक्ष', NULL, NULL),
(3, 'उपाध्यक्ष', NULL, NULL),
(4, 'महासचिव', NULL, NULL),
(5, 'सचिव', NULL, NULL),
(6, 'कोषाध्यक्ष', NULL, NULL),
(7, 'सह–कोषाध्यक्ष', NULL, NULL),
(8, 'सदस्य', NULL, NULL),
(9, 'सल्लाहकार', NULL, NULL);

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

--
-- Table structure for table `reasons`
--

CREATE TABLE `reasons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reasonable_type` varchar(255) NOT NULL,
  `reasonable_id` bigint(20) UNSIGNED NOT NULL,
  `reason` text NOT 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 `security_companies`
--

CREATE TABLE `security_companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `authorized_person` varchar(255) DEFAULT NULL,
  `company_type` enum('security','non-security') NOT NULL DEFAULT 'security',
  `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 `security_companies`
--

INSERT INTO `security_companies` (`id`, `name`, `email`, `phone`, `address`, `authorized_person`, `company_type`, `created_at`, `updated_at`) VALUES
(2, 'नवदुर्गा सेक्युरिटी  सप्लाइ सर्भिस प्रा. लि.', 'globalconnection7@gmail.com', '9701859791', 'कोटेश्वर-३२, काठमाडौं', 'Sudip Kumar Thapa', 'security', '2025-09-18 05:11:44', '2025-09-23 00:22:59'),
(3, 'गोरखा सुप्रिम सेक्युरिटी सर्भिस प्रा.लि.', 'umesh@gmail.com', '9701859791', 'एकान्तकुना-१३, ललितपुर', 'Sudip Kumar Thapa', 'security', '2025-09-18 05:11:58', '2025-09-23 00:24:21');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('16GxInfMRc9yX0jjqsQ2lVpfxNOCQWdGR8phDTxk', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSHRlTnlrNXpCVHJXNGNFWEVzQW5iWUE4QTNoTjV2QTQ5T2tRTTBEeCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758698708),
('2nxzTH2snsJw6cqMop1ObbKt20tRLF11XFwQYZ10', 2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiblJlS3Y2dW16MGxFdUdqcW9abTljcUdWUUNwWjcwdXRuVnZzaVVHOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjI7fQ==', 1758608862);

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

--
-- Table structure for table `suchanas`
--

CREATE TABLE `suchanas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext DEFAULT NULL,
  `date` date DEFAULT NULL,
  `attachment` varchar(255) 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 `suchanas`
--

INSERT INTO `suchanas` (`id`, `title`, `content`, `date`, `attachment`, `created_at`, `updated_at`) VALUES
(1, 'वार्षिक साधारण सभा २०७९ मिति २०७९/१२/१५ शनिबार', 'सुभचेतनासहित सूचित गरिन्छ कि नेपाल युवा समाज, काठमाडौंको वार्षिक साधारण सभा २०७९ मिति २०७९/१२/१५ शनिबार, बिहान ११:०० बजे, सामुदायिक हल, पुल्चोक, ललितपुर मा आयोजना गरिने भएको छ।\r\n\r\nसभामा निम्न विषयहरू छलफल गरिने छन्:\r\n\r\nवार्षिक प्रतिवेदन प्रस्तुत।\r\n\r\nआर्थिक प्रतिवेदन र कोषाध्यक्षको रिपोर्ट।\r\n\r\nआगामी वर्षको योजना तथा कार्यक्रम।\r\n\r\nनयाँ कार्यसमिति निर्वाचन।\r\n\r\nकार्यसमिति सदस्यहरु:\r\n\r\nपद	नाम\r\nअध्यक्ष	रामकृष्ण श्रेष्ठ\r\nवरिष्ठ उपाध्यक्ष	वर्षा उपाध्याय\r\nउपाध्यक्ष	मोहन भट्टराई\r\nमहासचिव	सिता अधिकारी\r\nसचिव	दीपक श्रेष्ठ\r\nकोषाध्यक्ष	हरि भट्ट\r\nसह–कोषाध्यक्ष	निर्मला श्रेष्ठ\r\nसदस्य	१० जना सदस्यहरु\r\nसल्लाहकार	कमल सापकोटा\r\n\r\nउपस्थित सबै सदस्यको उपस्थितिले सभा सफल र प्रभावकारी बनाउने अपेक्षा राखिन्छ।\r\n\r\nतिथि: २०७९/१२/०१\r\nस्थान: नेपाल युवा समाज, काठमाडौं', '2025-09-26', 'attachments/l3yuz6dSbiA8oRa1i4OaK9RmdeFXfi2liUt5Ora5.jpg', '2025-09-19 02:31:00', '2025-09-19 04:50:14'),
(2, 'सुभचेतनासहित सूचित गरिन्छ कि महासचिवको अध्यक्षतामा कार्यसमिति बैठक', 'सुभचेतनासहित सूचित गरिन्छ कि महासचिवको अध्यक्षतामा कार्यसमिति बैठक आयोजना गरिने भएको छ।\r\n\r\nबैठक मिति र समय:\r\n\r\nमिति: २०७९/१२/२०\r\n\r\nसमय: बिहान १०:०० बजे\r\n\r\nस्थान: कार्यालय सभा कक्ष, इभरेष्ट सोलार इनर्जी, काठमाडौँ\r\n\r\nबैठकका मुख्य एजेन्डा:\r\n\r\nनयाँ प्रोजेक्ट योजना प्रस्तुति।\r\n\r\nवित्तीय स्थिति र कोषाध्यक्षको प्रतिवेदन।\r\n\r\nआगामी वर्षका लक्ष्य र कार्यक्रम।\r\n\r\nसदस्यता अपडेट र नयाँ सदस्यको स्वीकृति।\r\n\r\nअन्य विविध विषयहरू।\r\n\r\nकार्यसमिति सदस्य उपस्थितिमा:\r\n\r\nपद	नाम\r\nअध्यक्ष	भीमराज पोखरेल\r\nवरिष्ठ उपाध्यक्ष	गीता श्रेष्ठ\r\nउपाध्यक्ष	रमेश अधिकारी\r\nमहासचिव	सन्तोष कार्की\r\nसचिव	निर्मला भट्ट', '2025-09-26', 'attachments/CaELohYyObDhDpoMLC4kzND0imETjXulnq8inOc8.jpg', '2025-09-19 02:32:13', '2025-09-19 05:05:42');

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

--
-- Table structure for table `user_documents`
--

CREATE TABLE `user_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `document_path` varchar(255) NOT 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 `user_documents`
--

INSERT INTO `user_documents` (`id`, `user_id`, `type`, `document_path`, `created_at`, `updated_at`) VALUES
(1, 1, 'all_document', 'user_documents/pwG75MKRigidsfyd4zGAz3jXIc3r7DKPzVqHUkrz.jpg', '2025-09-17 00:35:20', '2025-09-17 00:35:20'),
(2, 1, 'all_document', 'user_documents/0Dn6Qe8yChYBpWX1n4qKisGlIPbw6J0TMrNM9bTm.jpg', '2025-09-17 00:35:20', '2025-09-17 00:35:20'),
(3, 1, 'all_document', 'user_documents/HkaiHVadeho2c1OZxE7Ve5ExhQdDKGauW4yMf98y.jpg', '2025-09-17 00:35:20', '2025-09-17 00:35:20'),
(4, 2, 'citizenship', 'user_documents/Co4p83z4K1e7AsWOB9B0ErRRJAxoHy40R1qhLMnb.jpg', '2025-09-17 00:39:35', '2025-09-17 00:39:35'),
(5, 2, 'pan_registration', 'user_documents/6zsC6QQ2nJJif9PY9USDj2s4xw9UowWzwyb2K4eA.jpg', '2025-09-17 00:39:35', '2025-09-17 00:39:35'),
(6, 2, 'shram_ijajat_patra', 'user_documents/ZMMh7AT1wPsqnyZCIYPqgeUzqa9BpgF6psFz6c5T.jpg', '2025-09-17 00:39:35', '2025-09-17 00:39:35'),
(7, 3, 'all_document', 'user_documents/XtmKkkkg18RBbWpABcRXhv1BznnrNpPjkkEp01cJ.jpg', '2025-09-17 04:04:00', '2025-09-17 04:04:00'),
(8, 3, 'all_document', 'user_documents/WH0l5QEYaIyQjWMo6Jxz3CxOxZn7PmJxCsTO5VXp.jpg', '2025-09-17 04:04:00', '2025-09-17 04:04:00'),
(9, 3, 'all_document', 'user_documents/aMk7Z7f9Yhpzz9bjQZ5JlAReLV0pPZdF6I5RWzu5.jpg', '2025-09-17 04:04:00', '2025-09-17 04:04:00');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `executive_committees`
--
ALTER TABLE `executive_committees`
  ADD PRIMARY KEY (`id`),
  ADD KEY `executive_committees_post_id_foreign` (`post_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 `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `member_cancellations`
--
ALTER TABLE `member_cancellations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `member_cancellations_user_id_foreign` (`user_id`),
  ADD KEY `member_cancellations_cancelled_by_foreign` (`cancelled_by`);

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

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`);

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

--
-- Indexes for table `reasons`
--
ALTER TABLE `reasons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reasons_reasonable_type_reasonable_id_index` (`reasonable_type`,`reasonable_id`);

--
-- Indexes for table `security_companies`
--
ALTER TABLE `security_companies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `security_companies_email_unique` (`email`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `user_documents`
--
ALTER TABLE `user_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_documents_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `executive_committees`
--
ALTER TABLE `executive_committees`
  ADD CONSTRAINT `executive_committees_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `member_cancellations`
--
ALTER TABLE `member_cancellations`
  ADD CONSTRAINT `member_cancellations_cancelled_by_foreign` FOREIGN KEY (`cancelled_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `member_cancellations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_documents`
--
ALTER TABLE `user_documents`
  ADD CONSTRAINT `user_documents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

