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

START TRANSACTION;



--
-- Database: `blood`
--

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

--
-- Table structure for table `abouts`
--

CREATE TABLE `abouts` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `bn_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_description` longtext COLLATE utf8mb4_unicode_ci,
  `status` 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;

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

--
-- Table structure for table `blood_groups`
--

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

INSERT INTO `blood_groups` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'A+', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(2, 'A-', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(3, 'B+', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(4, 'B-', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(5, 'AB+', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(6, 'AB-', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(7, 'O+', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(8, 'O-', '2024-11-29 13:38:28', '2024-11-29 13:38:28'),
(9, 'A+', '2024-11-29 13:38:43', '2024-11-29 13:38:43'),
(10, 'A-', '2024-11-29 13:38:43', '2024-11-29 13:38:43'),
(11, 'B+', '2024-11-29 13:38:43', '2024-11-29 13:38:43'),
(12, 'B-', '2024-11-29 13:38:43', '2024-11-29 13:38:43'),
(13, 'AB+', '2024-11-29 13:38:43', '2024-11-29 13:38:43'),
(14, 'AB-', '2024-11-29 13:38:43', '2024-11-29 13:38:43'),
(15, 'O+', '2024-11-29 13:38:43', '2024-11-29 13:38:43'),
(16, 'O-', '2024-11-29 13:38:43', '2024-11-29 13:38:43');

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

--
-- Table structure for table `blood_requests`
--

CREATE TABLE `blood_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `permission` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `division` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upzilla` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hospital` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `patientName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `patientPhone` int DEFAULT NULL,
  `referenceName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referencePhone` int DEFAULT NULL,
  `bloodGroup` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bagBlood` int DEFAULT NULL,
  `message` varchar(191) 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 `blood_requests`
--

INSERT INTO `blood_requests` (`id`, `user_id`, `permission`, `division`, `district`, `upzilla`, `hospital`, `patientName`, `patientPhone`, `referenceName`, `referencePhone`, `bloodGroup`, `bagBlood`, `message`, `created_at`, `updated_at`) VALUES
(1, 1, '0', '1', '2', '3', '6', 'monoj', 23454321, 'akash', 1234565432, 'a+', 1, 'test', '2024-11-28 14:08:32', '2024-11-28 14:08:32');

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

--
-- Table structure for table `blood_request_messages`
--

CREATE TABLE `blood_request_messages` (
  `id` bigint UNSIGNED NOT NULL,
  `blood_request_id` bigint UNSIGNED NOT NULL,
  `message` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) 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 `blood_request_messages`
--

INSERT INTO `blood_request_messages` (`id`, `blood_request_id`, `message`, `code`, `created_at`, `updated_at`) VALUES
(1, 1, 'Please help me!, My name is monoj need this a+ blood 1 bags Chittagong, Ibne Sina Hospital contact 23454321,1234565432, details http://localhost:8000/BE5UTVZLP7', 'BE5UTVZLP7', '2024-11-28 14:08:32', '2024-11-28 14:08:32');

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

--
-- Table structure for table `carousels`
--

CREATE TABLE `carousels` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) 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;

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `bn_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_description` longtext COLLATE utf8mb4_unicode_ci,
  `contact_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_map_link` text COLLATE utf8mb4_unicode_ci,
  `status` 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;

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

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

CREATE TABLE `countries` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numeric_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tld` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `native` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subregion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED 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 `countries`
--

INSERT INTO `countries` (`id`, `title`, `iso3`, `iso2`, `numeric_code`, `phone_code`, `capital`, `currency`, `currency_name`, `currency_symbol`, `tld`, `native`, `nationality`, `region`, `subregion`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Bangladesh', 'BGD', 'BD', '050', '880', 'Dhaka', 'BDT', 'Bangladeshi taka', '৳', '.bd', 'Bangladesh', 'Bangladeshi', 'Asia', 'Southern Asia', NULL, '2024-11-07 16:00:21', '2024-11-07 16:00:21');

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

--
-- Table structure for table `developers`
--

CREATE TABLE `developers` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SocialMediaLink` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `bn_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_Position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_Description` text COLLATE utf8mb4_unicode_ci,
  `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 `districts`
--

CREATE TABLE `districts` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED 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`, `division_id`, `title`, `title_bn`, `code`, `created_by`, `created_at`, `updated_at`) VALUES
(2, 1, 'Feni', 'ফেনী', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(3, 1, 'Brahmanbaria', 'ব্রাক্ষনবাড়ীয়া', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(4, 1, 'Rangamati', 'রাঙামাটি', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(5, 1, 'Noakhali', 'নোয়াখালী', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(6, 1, 'Chandpur', 'চাঁদপুর', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(7, 1, 'Lakshmipur', 'লক্ষীপুর', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(8, 1, 'Chattogram', 'চট্টগ্রাম', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(9, 1, 'Coxsbazar', 'কক্সবাজার', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(10, 1, 'Khagrachhari', 'খাগড়াছড়ি', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(11, 1, 'Bandarban', 'বান্দারবান', NULL, 1, '2024-01-16 01:28:59', '2024-01-16 01:28:59'),
(15, 12, 'Dinajpur', NULL, NULL, 1, '2024-11-29 13:44:53', '2024-11-29 13:44:53');

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

--
-- Table structure for table `divisions`
--

CREATE TABLE `divisions` (
  `id` bigint UNSIGNED NOT NULL,
  `country_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED 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 `divisions`
--

INSERT INTO `divisions` (`id`, `country_id`, `title`, `title_bn`, `code`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'Chittagong', 'চট্টগ্রাম', 'CHI', 1, '2024-01-10 10:43:15', '2024-01-10 10:43:32'),
(2, 1, 'Rajshahi', 'রাজশাহী', '5546', 1, '2024-01-13 04:29:09', '2024-01-15 23:34:46'),
(7, 1, 'Mymensingh', 'ময়মনসিংহ', '096', 1, '2024-01-15 13:22:50', '2024-01-15 13:22:50'),
(12, 1, 'Rangpur', NULL, 'RAN', 1, '2024-11-29 13:44:40', '2024-11-29 13:44:40'),
(13, 1, 'Dhaka', NULL, 'DK', 1, '2024-11-30 12:43:22', '2024-11-30 12:43:22');

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

--
-- Table structure for table `education`
--

CREATE TABLE `education` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `bn_text` longtext COLLATE utf8mb4_unicode_ci,
  `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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(191) 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 `food`
--

CREATE TABLE `food` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_text` varchar(191) 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;

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

--
-- Table structure for table `foudations_login`
--

CREATE TABLE `foudations_login` (
  `id` bigint UNSIGNED 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 `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `account_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `bn_description` longtext COLLATE utf8mb4_unicode_ci,
  `home_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_home_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_reference_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_reference_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` 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;

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

--
-- Table structure for table `healths`
--

CREATE TABLE `healths` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_text` varchar(191) 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;

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

--
-- Table structure for table `hospitalnames`
--

CREATE TABLE `hospitalnames` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `division_id` bigint UNSIGNED DEFAULT NULL,
  `district_id` bigint UNSIGNED DEFAULT NULL,
  `upazilla_id` bigint UNSIGNED DEFAULT NULL,
  `created_by` bigint 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 `languages`
--

CREATE TABLE `languages` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direction` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ltr' COMMENT 'ltr, rtl',
  `status` 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 `marquees`
--

CREATE TABLE `marquees` (
  `id` bigint UNSIGNED NOT NULL,
  `text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_text` varchar(191) 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;

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_12_14_105743_create_admins_table', 1),
(6, '2023_12_14_134441_create_countries_table', 1),
(7, '2023_12_14_140648_create_divisions_table', 1),
(8, '2023_12_14_141304_create_districts_table', 1),
(9, '2023_12_14_141832_create_upazillas_table', 1),
(10, '2023_12_14_142249_create_pourashavas_table', 1),
(11, '2023_12_14_142249_create_unions_table', 1),
(12, '2023_12_18_133756_create_pourashavas_wards_table', 1),
(13, '2023_12_18_133756_create_wards_table', 1),
(14, '2023_12_19_151208_create_pourashavas_villages_table', 1),
(75, '2023_12_19_151208_create_villages_table', 2),
(77, '2023_12_20_142652_create_languages_table', 2),
(78, '2023_12_23_180909_create_user_profiles_table', 2),
(79, '2023_12_24_061306_create_developers_table', 2),
(80, '2023_12_24_132953_create_blood_requests_table', 2),
(81, '2023_12_24_141338_add_access_location_to_admins_table', 2),
(82, '2023_12_25_142303_add_status_to_admins_table', 2),
(83, '2023_12_31_140137_create_permission_tables', 2),
(84, '2024_01_05_152458_create_foundation_contact_us_table', 2),
(85, '2024_01_13_074156_create_carousels_table', 2),
(86, '2024_01_16_092757_create_marquees_table', 2),
(87, '2024_01_16_102505_create_sponsors_table', 2),
(88, '2024_01_21_191908_create_food_table', 2),
(89, '2024_01_24_121026_create_healths_table', 2),
(91, '2024_10_28_192133_create_blood_request_messages_table', 2),
(92, '2024_10_29_171944_create_foudations_login_table', 2),
(93, '2024_11_01_174131_create_blood_groups_table', 2),
(94, '2024_11_01_192455_create_professions_table', 2),
(95, '2024_11_04_181527_create_education_table', 2),
(96, '2024_11_10_163914_create_abouts_table', 2),
(97, '2024_11_10_174908_create_privacies_table', 2),
(98, '2024_11_10_175100_create_trams_conditions_table', 2),
(99, '2024_11_10_190636_create_contact_us_table', 2),
(100, '2024_11_11_173250_create_galleries_table', 2),
(102, '2023_12_20_124318_create_foundations_table', 3),
(103, '2024_10_28_174713_create_hospital_names_table', 4),
(104, '2024_10_28_174713_create_hospitals_table', 4),
(105, '2024_12_01_175436_create_foundation_designations_table', 5);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\Admin', 1);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) 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;

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

--
-- Table structure for table `pourashavas`
--

CREATE TABLE `pourashavas` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `district_id` bigint UNSIGNED NOT NULL,
  `upazilla_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint 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 `pourashavas_villages`
--

CREATE TABLE `pourashavas_villages` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `district_id` bigint UNSIGNED NOT NULL,
  `upazilla_id` bigint UNSIGNED NOT NULL,
  `pourashava_id` bigint UNSIGNED NOT NULL,
  `pourashava_ward_id` bigint UNSIGNED DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'it should be village, place, colony',
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint 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 `pourashavas_wards`
--

CREATE TABLE `pourashavas_wards` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `district_id` bigint UNSIGNED NOT NULL,
  `upazilla_id` bigint UNSIGNED NOT NULL,
  `pourashava_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint 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 `privacies`
--

CREATE TABLE `privacies` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `bn_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_description` longtext COLLATE utf8mb4_unicode_ci,
  `status` 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;

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

--
-- Table structure for table `professions`
--

CREATE TABLE `professions` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED 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 `professions`
--

INSERT INTO `professions` (`id`, `title`, `title_bn`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Satff', NULL, NULL, '2024-11-29 13:43:05', '2024-11-29 13:43:05');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'admin', '2024-11-27 13:10:17', '2024-11-27 13:10:17');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sponsors`
--

CREATE TABLE `sponsors` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(191) 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;

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

--
-- Table structure for table `trams_conditions`
--

CREATE TABLE `trams_conditions` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `bn_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bn_description` longtext COLLATE utf8mb4_unicode_ci,
  `status` 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;

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

--
-- Table structure for table `unions`
--

CREATE TABLE `unions` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `district_id` bigint UNSIGNED NOT NULL,
  `upazilla_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED 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 `unions`
--

INSERT INTO `unions` (`id`, `division_id`, `district_id`, `upazilla_id`, `title`, `title_bn`, `code`, `created_by`, `created_at`, `updated_at`) VALUES
(5, 1, 2, 3, 'Pathan Nagar', 'পাঠাননগর', NULL, 1, '2024-01-17 04:45:58', '2024-01-17 04:46:34'),
(6, 1, 2, 3, 'Radhanagar', 'রাধানগর', NULL, 1, '2024-01-17 04:45:58', '2024-01-17 04:46:47'),
(7, 1, 2, 4, 'ধলিয়া', NULL, NULL, 1, '2024-01-17 04:51:18', '2024-01-17 04:51:18'),
(11, 12, 15, 13, 'Fulbari', NULL, NULL, 1, '2024-11-29 13:45:18', '2024-11-29 13:45:18');

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

--
-- Table structure for table `upazillas`
--

CREATE TABLE `upazillas` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `district_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED 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 `upazillas`
--

INSERT INTO `upazillas` (`id`, `division_id`, `district_id`, `title`, `title_bn`, `code`, `created_by`, `created_at`, `updated_at`) VALUES
(3, 1, 2, 'Chagalnaiya', 'ছাগলনাইয়া', '875', 1, '2024-01-16 13:12:43', '2024-01-16 13:25:06'),
(4, 1, 2, 'sadar', 'সদর', NULL, 1, '2024-01-16 13:12:43', '2024-01-16 13:12:43'),
(13, 12, 15, 'Fulbari', NULL, NULL, 1, '2024-11-29 13:45:06', '2024-11-29 13:45:06');

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

--
-- Table structure for table `user_profiles`
--

CREATE TABLE `user_profiles` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `Name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FatherName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MotherName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ProfileImage` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MaritalStatus` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AnotherPhone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BloodGroup` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Occupation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BirthplaceDivision` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BirthplaceDistrict` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BirthplaceUpzilla` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BirthplaceUnion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BirthplaceWard` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BirthplaceVillage` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PermanentDivision` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PermanentDistrict` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PermanentUpzilla` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PermanentUnion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PermanentWard` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PermanentVillage` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentDivision` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentDistrict` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentUpzilla` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentUnion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentWard` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentVillage` varchar(191) 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 `user_profiles`
--

INSERT INTO `user_profiles` (`id`, `user_id`, `Name`, `FatherName`, `MotherName`, `Gender`, `Email`, `ProfileImage`, `MaritalStatus`, `AnotherPhone`, `BloodGroup`, `Occupation`, `BirthplaceDivision`, `BirthplaceDistrict`, `BirthplaceUpzilla`, `BirthplaceUnion`, `BirthplaceWard`, `BirthplaceVillage`, `PermanentDivision`, `PermanentDistrict`, `PermanentUpzilla`, `PermanentUnion`, `PermanentWard`, `PermanentVillage`, `CurrentDivision`, `CurrentDistrict`, `CurrentUpzilla`, `CurrentUnion`, `CurrentWard`, `CurrentVillage`, `created_at`, `updated_at`) VALUES
(2, 1, 'monoj', 'dsfasd', 'asdfa', 'male', 'monoj@gmail.com', NULL, 'married', '+880123456789', 'none', 'none', '12', '15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-11-30 11:55:22', '2024-11-30 12:00:04');

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

--
-- Table structure for table `villages`
--

CREATE TABLE `villages` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `district_id` bigint UNSIGNED NOT NULL,
  `upazilla_id` bigint UNSIGNED NOT NULL,
  `union_id` bigint UNSIGNED NOT NULL,
  `ward_id` bigint UNSIGNED DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'it should be village, place, colony',
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint UNSIGNED 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 `villages`
--

INSERT INTO `villages` (`id`, `division_id`, `district_id`, `upazilla_id`, `union_id`, `ward_id`, `title`, `title_bn`, `code`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 3, 5, 1, 'Haripur', 'হরিপুর', '001', 1, '2024-01-22 12:57:15', '2024-01-22 12:57:15'),
(2, 1, 2, 3, 5, 1, 'Bathania', 'বাথানিয়া', '002', 1, '2024-01-22 12:57:16', '2024-01-22 12:57:16'),
(4, 12, 15, 13, 11, 12, 'uttor', NULL, NULL, 1, '2024-11-29 13:45:58', '2024-11-29 13:45:58');

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

--
-- Table structure for table `wards`
--

CREATE TABLE `wards` (
  `id` bigint UNSIGNED NOT NULL,
  `division_id` bigint UNSIGNED NOT NULL,
  `district_id` bigint UNSIGNED NOT NULL,
  `upazilla_id` bigint UNSIGNED NOT NULL,
  `union_id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint UNSIGNED 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 `wards`
--

INSERT INTO `wards` (`id`, `division_id`, `district_id`, `upazilla_id`, `union_id`, `title`, `title_bn`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 3, 5, '1', '১', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(2, 1, 2, 3, 5, '2', '২', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(3, 1, 2, 3, 5, '3', '৩', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(4, 1, 2, 3, 5, '4', '৪', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(5, 1, 2, 3, 5, '5', '৫', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(6, 1, 2, 3, 5, '6', '৬', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(7, 1, 2, 3, 5, '7', '৭', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(8, 1, 2, 3, 5, '8', '৮', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(9, 1, 2, 3, 5, '9', '৯', 1, '2024-01-17 05:20:39', '2024-01-17 05:20:39'),
(10, 1, 2, 3, 5, '10', '১০', 1, '2024-01-17 05:30:24', '2024-01-17 05:30:24'),
(12, 12, 15, 13, 11, '3', '3', 1, '2024-11-29 13:45:33', '2024-11-29 13:45:33');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `districts_title_unique` (`title`),
  ADD KEY `districts_division_id_foreign` (`division_id`),
  ADD KEY `districts_created_by_foreign` (`created_by`);

--
-- Indexes for table `divisions`
--
ALTER TABLE `divisions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `divisions_title_unique` (`title`),
  ADD KEY `divisions_country_id_foreign` (`country_id`),
  ADD KEY `divisions_created_by_foreign` (`created_by`);

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

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

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

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

--
-- Indexes for table `hospitalnames`
--
ALTER TABLE `hospitalnames`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `hospitalnames_title_unique` (`title`),
  ADD KEY `hospitalnames_division_id_foreign` (`division_id`),
  ADD KEY `hospitalnames_district_id_foreign` (`district_id`),
  ADD KEY `hospitalnames_upazilla_id_foreign` (`upazilla_id`),
  ADD KEY `hospitalnames_created_by_foreign` (`created_by`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `languages_title_unique` (`title`),
  ADD UNIQUE KEY `languages_code_unique` (`code`);

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `pourashavas`
--
ALTER TABLE `pourashavas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pourashavas_division_id_foreign` (`division_id`),
  ADD KEY `pourashavas_district_id_foreign` (`district_id`),
  ADD KEY `pourashavas_upazilla_id_foreign` (`upazilla_id`),
  ADD KEY `pourashavas_created_by_foreign` (`created_by`);

--
-- Indexes for table `pourashavas_villages`
--
ALTER TABLE `pourashavas_villages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pourashavas_villages_division_id_foreign` (`division_id`),
  ADD KEY `pourashavas_villages_district_id_foreign` (`district_id`),
  ADD KEY `pourashavas_villages_upazilla_id_foreign` (`upazilla_id`),
  ADD KEY `pourashavas_villages_pourashava_id_foreign` (`pourashava_id`),
  ADD KEY `pourashavas_villages_pourashava_ward_id_foreign` (`pourashava_ward_id`),
  ADD KEY `pourashavas_villages_created_by_foreign` (`created_by`);

--
-- Indexes for table `pourashavas_wards`
--
ALTER TABLE `pourashavas_wards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pourashavas_wards_division_id_foreign` (`division_id`),
  ADD KEY `pourashavas_wards_district_id_foreign` (`district_id`),
  ADD KEY `pourashavas_wards_upazilla_id_foreign` (`upazilla_id`),
  ADD KEY `pourashavas_wards_pourashava_id_foreign` (`pourashava_id`),
  ADD KEY `pourashavas_wards_created_by_foreign` (`created_by`);

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

--
-- Indexes for table `professions`
--
ALTER TABLE `professions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `professions_title_unique` (`title`),
  ADD KEY `professions_created_by_foreign` (`created_by`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

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

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

--
-- Indexes for table `unions`
--
ALTER TABLE `unions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `unions_division_id_foreign` (`division_id`),
  ADD KEY `unions_district_id_foreign` (`district_id`),
  ADD KEY `unions_upazilla_id_foreign` (`upazilla_id`),
  ADD KEY `unions_created_by_foreign` (`created_by`);

--
-- Indexes for table `upazillas`
--
ALTER TABLE `upazillas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `upazillas_division_id_foreign` (`division_id`),
  ADD KEY `upazillas_district_id_foreign` (`district_id`),
  ADD KEY `upazillas_created_by_foreign` (`created_by`);

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

--
-- Indexes for table `villages`
--
ALTER TABLE `villages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `villages_division_id_foreign` (`division_id`),
  ADD KEY `villages_district_id_foreign` (`district_id`),
  ADD KEY `villages_upazilla_id_foreign` (`upazilla_id`),
  ADD KEY `villages_union_id_foreign` (`union_id`),
  ADD KEY `villages_ward_id_foreign` (`ward_id`),
  ADD KEY `villages_created_by_foreign` (`created_by`);

--
-- Indexes for table `wards`
--
ALTER TABLE `wards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wards_division_id_foreign` (`division_id`),
  ADD KEY `wards_district_id_foreign` (`district_id`),
  ADD KEY `wards_upazilla_id_foreign` (`upazilla_id`),
  ADD KEY `wards_union_id_foreign` (`union_id`),
  ADD KEY `wards_created_by_foreign` (`created_by`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abouts`
--
ALTER TABLE `abouts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blood_groups`
--
ALTER TABLE `blood_groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `blood_requests`
--
ALTER TABLE `blood_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blood_request_messages`
--
ALTER TABLE `blood_request_messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `carousels`
--
ALTER TABLE `carousels`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `developers`
--
ALTER TABLE `developers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `divisions`
--
ALTER TABLE `divisions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `education`
--
ALTER TABLE `education`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `food`
--
ALTER TABLE `food`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `foudations_login`
--
ALTER TABLE `foudations_login`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `healths`
--
ALTER TABLE `healths`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hospitalnames`
--
ALTER TABLE `hospitalnames`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `marquees`
--
ALTER TABLE `marquees`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pourashavas`
--
ALTER TABLE `pourashavas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pourashavas_villages`
--
ALTER TABLE `pourashavas_villages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pourashavas_wards`
--
ALTER TABLE `pourashavas_wards`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `privacies`
--
ALTER TABLE `privacies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `professions`
--
ALTER TABLE `professions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sponsors`
--
ALTER TABLE `sponsors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trams_conditions`
--
ALTER TABLE `trams_conditions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `unions`
--
ALTER TABLE `unions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `upazillas`
--
ALTER TABLE `upazillas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `user_profiles`
--
ALTER TABLE `user_profiles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `villages`
--
ALTER TABLE `villages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `wards`
--
ALTER TABLE `wards`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blood_requests`
--
ALTER TABLE `blood_requests`
  ADD CONSTRAINT `blood_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `countries`
--
ALTER TABLE `countries`
  ADD CONSTRAINT `countries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `districts`
--
ALTER TABLE `districts`
  ADD CONSTRAINT `districts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `districts_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `divisions`
--
ALTER TABLE `divisions`
  ADD CONSTRAINT `divisions_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `divisions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL;

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

--
-- Constraints for table `hospitalnames`
--
ALTER TABLE `hospitalnames`
  ADD CONSTRAINT `hospitalnames_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `hospitalnames_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hospitalnames_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hospitalnames_upazilla_id_foreign` FOREIGN KEY (`upazilla_id`) REFERENCES `upazillas` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pourashavas`
--
ALTER TABLE `pourashavas`
  ADD CONSTRAINT `pourashavas_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pourashavas_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_upazilla_id_foreign` FOREIGN KEY (`upazilla_id`) REFERENCES `upazillas` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pourashavas_villages`
--
ALTER TABLE `pourashavas_villages`
  ADD CONSTRAINT `pourashavas_villages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pourashavas_villages_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_villages_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_villages_pourashava_id_foreign` FOREIGN KEY (`pourashava_id`) REFERENCES `pourashavas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_villages_pourashava_ward_id_foreign` FOREIGN KEY (`pourashava_ward_id`) REFERENCES `pourashavas_wards` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pourashavas_villages_upazilla_id_foreign` FOREIGN KEY (`upazilla_id`) REFERENCES `upazillas` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pourashavas_wards`
--
ALTER TABLE `pourashavas_wards`
  ADD CONSTRAINT `pourashavas_wards_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pourashavas_wards_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_wards_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_wards_pourashava_id_foreign` FOREIGN KEY (`pourashava_id`) REFERENCES `pourashavas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pourashavas_wards_upazilla_id_foreign` FOREIGN KEY (`upazilla_id`) REFERENCES `upazillas` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `professions`
--
ALTER TABLE `professions`
  ADD CONSTRAINT `professions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `unions`
--
ALTER TABLE `unions`
  ADD CONSTRAINT `unions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `unions_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `unions_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `unions_upazilla_id_foreign` FOREIGN KEY (`upazilla_id`) REFERENCES `upazillas` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `upazillas`
--
ALTER TABLE `upazillas`
  ADD CONSTRAINT `upazillas_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `upazillas_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `upazillas_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `villages`
--
ALTER TABLE `villages`
  ADD CONSTRAINT `villages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `villages_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `villages_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `villages_union_id_foreign` FOREIGN KEY (`union_id`) REFERENCES `unions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `villages_upazilla_id_foreign` FOREIGN KEY (`upazilla_id`) REFERENCES `upazillas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `villages_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `wards`
--
ALTER TABLE `wards`
  ADD CONSTRAINT `wards_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `wards_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wards_division_id_foreign` FOREIGN KEY (`division_id`) REFERENCES `divisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wards_union_id_foreign` FOREIGN KEY (`union_id`) REFERENCES `unions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wards_upazilla_id_foreign` FOREIGN KEY (`upazilla_id`) REFERENCES `upazillas` (`id`) ON DELETE CASCADE;
COMMIT;

