-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 28, 2025 at 06:49 PM
-- Server version: 5.7.23-23
-- PHP Version: 8.1.33

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: `rantooin_laravel`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci 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 `admins`
--

INSERT INTO `admins` (`id`, `name`, `email`, `password`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@admin.com', '$2y$12$oUlhYnF3k7DdIkuKYYo.cepXp.LQuB94CUdg1t6RVKVk8sotCZRKG', '2025-11-25 05:22:08', '2025-11-25 05:22:08');

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

--
-- Table structure for table `album_categories`
--

CREATE TABLE `album_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) 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;

--
-- Dumping data for table `album_categories`
--

INSERT INTO `album_categories` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Class Room', 1, '2025-11-26 07:14:30', '2025-11-26 07:14:30'),
(2, 'Culture', 1, '2025-11-26 07:14:37', '2025-11-26 07:14:37');

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('admin@gmail.com|49.36.221.237', 'i:1;', 1764243523),
('admin@gmail.com|49.36.221.237:timer', 'i:1764243523;', 1764243523);

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci 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 `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(1, 'Amit Kumar', 'amitchauhan20021992@gmail', 'test email live', 'test email live', '2025-11-26 07:50:35', '2025-11-26 07:50:35'),
(2, 'Amit Kumar', 'amitchauhan20021992@gmail.com', 'test email one live', 'test email one live', '2025-11-26 07:52:40', '2025-11-26 07:52:40'),
(3, 'Amit Kumar', 'amitchauhan20021992@gmail.com', 'test email one ll', 'test email one ll', '2025-11-26 07:53:36', '2025-11-26 07:53:36');

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `state_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(5) 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 `districts`
--

INSERT INTO `districts` (`id`, `state_id`, `name`, `short_name`, `created_at`, `updated_at`) VALUES
(1, 34, 'Lucknow', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(2, 34, 'Varanasi', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(3, 34, 'Prayagraj', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(4, 34, 'Kanpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(5, 34, 'Agra', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(6, 34, 'Gorakhpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(7, 34, 'Ayodhya', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(8, 34, 'Meerut', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(9, 5, 'Patna', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(10, 5, 'Gaya', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(11, 5, 'Muzaffarpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(12, 5, 'Bhagalpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(13, 20, 'Bhopal', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(14, 20, 'Indore', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(15, 20, 'Jabalpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(16, 20, 'Gwalior', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(17, 20, 'Ujjain', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(18, 29, 'Jaipur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(19, 29, 'Jodhpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(20, 29, 'Udaipur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(21, 29, 'Kota', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(22, 29, 'Ajmer', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(23, 21, 'Mumbai', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(24, 21, 'Pune', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(25, 21, 'Nashik', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(26, 21, 'Nagpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(27, 21, 'Aurangabad', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(28, 9, 'New Delhi', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(29, 12, 'Gurugram', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(30, 12, 'Faridabad', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(31, 12, 'Panipat', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(32, 28, 'Amritsar', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(33, 28, 'Ludhiana', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(34, 28, 'Jalandhar', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(35, 28, 'Patiala', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(36, 11, 'Ahmedabad', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(37, 11, 'Surat', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(38, 11, 'Vadodara', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(39, 11, 'Rajkot', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(40, 36, 'Kolkata', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(41, 36, 'Howrah', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(42, 36, 'Darjeeling', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(43, 31, 'Chennai', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(44, 31, 'Madurai', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(45, 31, 'Coimbatore', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(46, 31, 'Trichy', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(47, 16, 'Bengaluru', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(48, 16, 'Mysuru', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(49, 16, 'Mangaluru', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(50, 16, 'Hubballi', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(51, 17, 'Thiruvananthapuram', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(52, 17, 'Kochi', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(53, 17, 'Kozhikode', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(54, 32, 'Hyderabad', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(55, 32, 'Warangal', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(56, 2, 'Vijayawada', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(57, 2, 'Visakhapatnam', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(58, 26, 'Bhubaneswar', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(59, 26, 'Cuttack', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(60, 15, 'Ranchi', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(61, 15, 'Jamshedpur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(62, 7, 'Raipur', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(63, 7, 'Bhilai', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(64, 35, 'Dehradun', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(65, 35, 'Haridwar', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(66, 13, 'Shimla', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(67, 13, 'Dharamshala', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(68, 14, 'Srinagar', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(69, 14, 'Jammu', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(70, 4, 'Guwahati', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(71, 4, 'Dibrugarh', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29'),
(72, 10, 'Panaji', NULL, '2025-11-25 05:26:29', '2025-11-25 05:26:29');

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

--
-- Table structure for table `donates`
--

CREATE TABLE `donates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_no` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` enum('1','2','3') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `receipt_no` bigint(20) UNSIGNED NOT NULL,
  `donation_type_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receipt_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` tinyint(4) 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;

--
-- Dumping data for table `donates`
--

INSERT INTO `donates` (`id`, `name`, `email`, `mobile_no`, `amount`, `payment_method`, `address`, `receipt_no`, `donation_type_id`, `receipt_image`, `payment_status`, `created_at`, `updated_at`) VALUES
(1, 'Amit Kumar', 'amit@gmail.com', '9897550000', 51.00, '1', 'Behat, Saharanpur, Uttar Pradesh, 247662', 1, '1', NULL, 1, '2025-11-26 07:39:44', '2025-11-26 07:39:44');

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

--
-- Table structure for table `donation_categories`
--

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

INSERT INTO `donation_categories` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES
(1, 'कॉर्पोरेट सदस्य – ₹1,100,000/–', 'corporate', '2025-11-25 05:26:51', '2025-11-25 05:26:51'),
(2, 'संस्थापक सदस्य – ₹500,000/–', 'founder', '2025-11-25 05:26:51', '2025-11-25 05:26:51'),
(3, 'संरक्षक सदस्य – ₹250,000/–', 'patron', '2025-11-25 05:26:51', '2025-11-25 05:26:51'),
(4, 'आजीवन सदस्य – ₹100,000/–', 'lifetime', '2025-11-25 05:26:51', '2025-11-25 05:26:51'),
(5, 'विशेष सदस्य – ₹1,100/–', 'special', '2025-11-25 05:26:51', '2025-11-25 05:26:51'),
(6, 'कार्यकर्ता सदस्य – ₹51/–', 'worker', '2025-11-25 05:26:51', '2025-11-25 05:26:51'),
(7, 'अन्य दान / भुगतान', 'other', '2025-11-25 05:26:51', '2025-11-25 05:26:51');

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

--
-- Table structure for table `donation_types`
--

CREATE TABLE `donation_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci 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 `donation_types`
--

INSERT INTO `donation_types` (`id`, `type`, `created_at`, `updated_at`) VALUES
(1, 'One-Time', '2025-11-25 05:27:12', '2025-11-25 05:27:12'),
(2, 'Monthly', '2025-11-25 05:27:12', '2025-11-25 05:27:12'),
(3, 'Sponsor a Project', '2025-11-25 05:27:12', '2025-11-25 05:27:12');

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

--
-- 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 `government_departments`
--

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

INSERT INTO `government_departments` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Health', '2025-11-25 05:27:36', '2025-11-25 05:27:36'),
(2, 'Education', '2025-11-25 05:27:36', '2025-11-25 05:27:36'),
(3, 'Police', '2025-11-25 05:27:36', '2025-11-25 05:27:36'),
(4, 'Other', '2025-11-25 05:27:36', '2025-11-25 05:27:36');

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `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 `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, '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_11_12_113009_create_admins_table', 1),
(5, '2025_11_13_071426_add_fields_to_users_table', 1),
(6, '2025_11_13_094811_create_states_table', 1),
(7, '2025_11_13_094827_create_districts_table', 1),
(8, '2025_11_13_105533_create_government_departments_table', 1),
(9, '2025_11_13_110729_create_occupations_table', 1),
(10, '2025_11_13_113933_create_donation_categories_table', 1),
(11, '2025_11_17_045406_create_donates_table', 1),
(12, '2025_11_17_051904_create_donation_types_table', 1),
(13, '2025_11_17_101352_create_contacts_table', 1),
(14, '2025_11_19_061616_create_photos_table', 1),
(15, '2025_11_19_093026_create_videos_table', 1),
(16, '2025_11_20_072516_create_album_categories_table', 1);

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

--
-- Table structure for table `occupations`
--

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

INSERT INTO `occupations` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Government Job', '2025-11-25 05:25:38', '2025-11-25 05:25:38'),
(2, 'Private Job', '2025-11-25 05:25:38', '2025-11-25 05:25:38'),
(3, 'Business', '2025-11-25 05:25:38', '2025-11-25 05:25:38'),
(4, 'Agriculture', '2025-11-25 05:25:38', '2025-11-25 05:25:38'),
(5, 'Housewife', '2025-11-25 05:25:38', '2025-11-25 05:25:38'),
(6, 'Student', '2025-11-25 05:25:38', '2025-11-25 05:25:38'),
(7, 'Contract Workers', '2025-11-25 05:25:38', '2025-11-25 05:25:38'),
(8, 'Public Representative', '2025-11-25 05:25:38', '2025-11-25 05:25:38');

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

--
-- 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 `photos`
--

CREATE TABLE `photos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `album_category_id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `photos`
--

INSERT INTO `photos` (`id`, `album_category_id`, `image_path`, `original_name`, `created_at`, `updated_at`) VALUES
(25, 1, 'gallery/1764161976_01.jpg', '01.jpg', '2025-11-26 07:29:36', '2025-11-26 07:29:36'),
(26, 1, 'gallery/1764161976_02.jpg', '02.jpg', '2025-11-26 07:29:36', '2025-11-26 07:29:36');

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci 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
('hugRTBaRJJ18kXF7PnlqxkvaIJa7BbPRChICFVpf', 1, '49.36.221.132', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidkc1cmhsd25yTWl1WXdFNmIxeXEzNnY5ckxLZUJJOGd2aWdUd0lVYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDc6Imh0dHA6Ly90ZXN0LnBvbHltZXJ2aXNpb250ZWNoLmNvbS9hZG1pbi9wcm9maWxlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MjoibG9naW5fYWRtaW5fNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1764310526),
('MY4ppgV10UYmdiBFJQSl0aYExthtAy4bo7QDX1ms', NULL, '149.57.180.89', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUnduWXBiUGlaeUtRVU8zcFBqTjR0WTZ6Nmd4dmFVZ0s4dVYwR1h2cyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vdGVzdC5wb2x5bWVydmlzaW9udGVjaC5jb20vaW5kZXgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1764317444),
('SvDftfcbdH0rFM4KWCb3wDWyS0P80JsTo0mTVCoy', NULL, '23.27.145.45', 'Mozilla/5.0 (X11; Linux i686; rv:109.0) Gecko/20100101 Firefox/120.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVUdFMnZtaDF6THdSNHhZR0xneUN6a05BN2lnN2JzWm9ZR3lvWkNxTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vd3d3LnRlc3QucG9seW1lcnZpc2lvbnRlY2guY29tL2luZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1764333642);

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(5) 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 `states`
--

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

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `membership_no` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL 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,
  `aadhar_no` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `mobile_no` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` enum('1','2','3') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occupation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `govt_department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `office_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `pin_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nominee_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nominee_relation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nominee_mobile_no` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `donation_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `declaration` tinyint(1) NOT NULL DEFAULT '0',
  `profile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `membership_no`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `aadhar_no`, `father_name`, `dob`, `mobile_no`, `gender`, `occupation_id`, `govt_department_id`, `office_address`, `state_id`, `district_id`, `address`, `pin_code`, `nominee_name`, `nominee_relation`, `nominee_mobile_no`, `transaction_id`, `donation_category_id`, `declaration`, `profile_image`) VALUES
(1, 'MBR-81708500', 'Amit Kumar', 'amit@gmail.com', NULL, '$2y$12$uRmXxoq80Ooe2gJ6MzfpQet/iAYb8Cqg52VVQ0DH1wqP1XfYXAAw.', NULL, '2025-11-26 06:56:37', '2025-11-26 23:18:48', '123412341234', 'Rishipal Singh', '1992-02-20', '9897550000', '1', 2, 4, 'Behat, Saharanpur, Uttar Pradesh, 247662', 34, 8, 'Behat, Saharanpur, Uttar Pradesh, 247662', '247121', 'Sumit Kumar', 'Brother', '9897440000', 'iuhfdisauf98dsufioiofdsfds', 6, 1, 'profile_images/1764218928.jpg');

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `video_url` varchar(255) COLLATE utf8mb4_unicode_ci 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 `videos`
--

INSERT INTO `videos` (`id`, `video_url`, `created_at`, `updated_at`) VALUES
(1, 'https://www.youtube.com/embed/oYvSqay5n7s?si=62wR1dujVfQoTgMf', '2025-11-26 07:15:48', '2025-11-26 07:15:48'),
(2, 'https://www.youtube.com/embed/oYvSqay5n7s?si=62wR1dujVfQoTgMf', '2025-11-26 07:15:48', '2025-11-26 07:15:48');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

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

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `districts_state_id_foreign` (`state_id`);

--
-- Indexes for table `donates`
--
ALTER TABLE `donates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `donates_receipt_no_unique` (`receipt_no`);

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

--
-- Indexes for table `donation_types`
--
ALTER TABLE `donation_types`
  ADD PRIMARY KEY (`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 `government_departments`
--
ALTER TABLE `government_departments`
  ADD PRIMARY KEY (`id`);

--
-- 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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

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

--
-- 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 `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `users_membership_no_unique` (`membership_no`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `donation_types`
--
ALTER TABLE `donation_types`
  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 `government_departments`
--
ALTER TABLE `government_departments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  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=17;

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `districts`
--
ALTER TABLE `districts`
  ADD CONSTRAINT `districts_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;