-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 10, 2024 at 09:38 AM
-- Server version: 8.0.38
-- PHP Version: 8.1.28

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

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `blog_categories_xid` bigint UNSIGNED NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `blog_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_date` date DEFAULT NULL,
  `deleted_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 `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `blog_categories_xid`, `description`, `blog_image`, `publish_date`, `deleted_at`, `created_at`, `updated_at`) VALUES
(30, 'testing testing testing', 12, '<p>testing&nbsp;</p>', '1717697559.png', '2024-06-06', NULL, '2024-06-06 18:12:39', '2024-06-06 18:12:39');

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `deleted_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 `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `category_name`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Twitter’s FAQ', '0', '2023-06-06 01:16:18', '2023-06-02 05:04:35', '2023-06-06 01:16:18'),
(2, 'YouTube’s FAQsss', '0', '2023-06-07 08:07:36', '2023-06-02 05:43:11', '2023-06-07 08:07:36'),
(3, 'Twitter’s FAQss', '0', '2023-06-07 08:16:29', '2023-06-02 07:01:28', '2023-06-07 08:16:29'),
(4, 'sdfgh', '0', '2023-06-07 08:07:53', '2023-06-07 08:07:46', '2023-06-07 08:07:53'),
(5, 'Teaching', '0', '2023-06-09 10:26:41', '2023-06-07 08:18:31', '2023-06-09 10:26:41'),
(6, 'Category one', '0', '2023-06-07 08:18:40', '2023-06-07 08:18:32', '2023-06-07 08:18:40'),
(7, 'Teaching', '0', NULL, '2023-06-09 10:35:53', '2023-10-16 09:30:38'),
(8, 'Dancings', '0', '2024-06-07 06:29:35', '2023-06-10 18:40:06', '2024-06-07 06:29:35'),
(9, 'Testing', '0', '2023-06-12 10:00:15', '2023-06-12 10:00:09', '2023-06-12 10:00:15'),
(10, 'ghjk', '0', '2023-06-12 18:02:50', '2023-06-12 18:02:40', '2023-06-12 18:02:50'),
(11, 'Education', '0', NULL, '2023-06-28 10:40:28', '2024-06-07 06:30:08'),
(12, 'Testing', '0', '2024-06-07 06:29:49', '2023-08-24 06:49:30', '2024-06-07 06:29:49'),
(13, 'app development', '0', '2023-10-16 09:31:32', '2023-10-16 09:31:16', '2023-10-16 09:31:32'),
(14, 'Animals', '0', NULL, '2024-06-07 06:30:23', '2024-06-07 06:30:23'),
(15, 'Volunteer', '0', NULL, '2024-06-07 06:30:45', '2024-06-07 06:30:45');

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint UNSIGNED NOT NULL,
  `states_xid` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `deleted_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 `cities`
--

INSERT INTO `cities` (`id`, `states_xid`, `name`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Mumbai', '1', NULL, '2023-06-22 09:21:09', '2023-06-24 05:43:45'),
(2, 1, 'Pune', '1', NULL, '2023-06-22 09:22:31', '2023-06-22 09:49:02');

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

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

CREATE TABLE `contact_us` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_replay` int NOT NULL DEFAULT '0',
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contact_us_details`
--

CREATE TABLE `contact_us_details` (
  `id` bigint UNSIGNED NOT NULL,
  `contact_title_one` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_description_one` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_title_two` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_description_two` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_title_three` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_description_three` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_title_four` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_description_four` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `twitter` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `LinkedIn` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_email` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_phone` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_us_details`
--

INSERT INTO `contact_us_details` (`id`, `contact_title_one`, `contact_description_one`, `contact_title_two`, `contact_description_two`, `contact_title_three`, `contact_description_three`, `contact_title_four`, `contact_description_four`, `created_at`, `updated_at`, `twitter`, `LinkedIn`, `facebook`, `instagram`, `company_name`, `company_address`, `company_email`, `company_phone`, `company_number`) VALUES
(1, 'All applications', '<p>If you\'d like to apply for a program with us, you can always contact us by sending a message above. We aim to reply to your message within 1 or 2 business days by email.</p>', 'Whatsapp', '<p>+447709787925</p>', 'Working Hours', '<p>Consultation hours are Monday to Saturday, beginning at 9:00 am to 12:00 pm, and from 2:30 pm to 6:00 pm (UK Time Zone)&nbsp;</p>', 'Email', '<p><a href=\"mailto:info@leaninworld.com\">info@leaninworld.com</a></p>', NULL, '2024-05-21 12:12:22', NULL, NULL, 'https://www.facebook.com/profile.php?id=61558349405993', 'https://www.instagram.com/leaninworld_en/', NULL, NULL, 'info@leaninworld.com', '+ 447709787925', NULL);

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

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

CREATE TABLE `countries` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `discription` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `deleted_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 `countries`
--

INSERT INTO `countries` (`id`, `name`, `language`, `discription`, `country_code`, `image`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'China', 'Chinese', 'Ancient civilization merging with rapid progress, iconic landmarks, diverse landscapes, and rich.', 'CN', '1712620152.jpg', '1', '2024-05-02 16:50:40', '2023-07-13 09:55:43', '2024-05-02 16:50:40'),
(2, 'Bali', 'Bahasa Indonesia', 'Bali, famous as a tropical tourist destination, boasts stunning temple architecture, art, and music.', 'ID', '1714147422.jpg', '1', NULL, '2023-07-13 09:59:16', '2024-06-06 15:27:37'),
(3, 'Switzerland', 'English, Swiss, Spanish', 'Alpine beauty, precision craftsmanship, and multicultural charm make a haven for nature lovers.', 'CH', '1692964110.jpg', '1', '2024-05-02 16:49:59', '2023-07-13 10:00:40', '2024-05-02 16:49:59'),
(4, 'Russia', 'English', 'Vast expanse of diverse landscapes, historic legacy, and cultural , spanning from Europe to Asia.', 'RU', '1694178872.png', '1', '2024-05-02 16:49:55', '2023-07-13 10:03:07', '2024-05-02 16:49:55'),
(9, 'India', 'Hindi', 'Vast nation blending ancient traditions and modern innovation, diverse cultures, and iconic.', 'IN', '1693292797.png', '1', '2024-05-02 16:49:51', '2023-08-28 10:54:43', '2024-05-02 16:49:51'),
(10, 'Japan', 'Japanese,English,Nihongo', 'Japan, located in East Asia, is an island nation known for its rology, and stun.', 'JP', '1693303597.jpg', '0', '2023-08-29 10:07:04', '2023-08-29 10:06:37', '2023-08-29 10:07:04'),
(11, 'Brazil', 'Portuguese', 'Brazil is renowned for its diverse culture, Brazil is renowned for its diverses.', 'BR', '1694677667.jpg', '0', '2024-05-02 16:49:46', '2023-09-14 07:47:47', '2024-05-02 16:49:46'),
(12, 'South Africa', 'Zulu, Xhosa,English.', 'South Africa, officially known as the Republic of South Africa, is a diversssss.', 'ZA', '1694679863.png', '0', '2024-05-02 16:49:42', '2023-09-14 08:24:23', '2024-05-02 16:49:42'),
(13, 'Spain', 'Spanish', 'Spain, officially known as the Kingdom of Spain, is a vibrant and culturally ri.', 'ES', '1694684067.jpg', '0', '2024-05-02 16:50:13', '2023-09-14 09:34:27', '2024-05-02 16:50:13'),
(14, 'Argentina', 'Italian, German', 'Argentina is a vibrant and diverse country located in South America. Argentina .', 'AR', '1694684298.jpg', '0', '2024-05-02 16:50:05', '2023-09-14 09:38:18', '2024-05-02 16:50:05'),
(15, 'Netherlands', 'Dutch', 'The Netherlands, often simply referred to as \"Netherlands,\" is a country locatf.', 'NL', '1694684462.jpg', '0', '2024-05-02 16:50:09', '2023-09-14 09:41:02', '2024-05-02 16:50:09'),
(16, 'America', 'english', 'he United States of America consists of 50 states, a federal distrithjdsjkhuysf.', 'Am', '1697370938.jpg', '0', '2024-05-02 16:50:32', '2023-10-10 12:13:46', '2024-05-02 16:50:32'),
(17, 'England', 'english', 'kjjkjiijojsdsdsdsd', 'eg', '1697551809.jpg', '0', '2024-05-02 16:50:18', '2023-10-17 14:10:09', '2024-05-02 16:50:18'),
(18, 'Australia', 'English', 'Australia is a vast and diverse country known for its stunning landscapes', 'AU', '1697985719.jpg', '0', '2024-05-02 16:50:36', '2023-10-22 14:42:04', '2024-05-02 16:50:36'),
(23, 'Canada', 'english', 'testing testing', 'CA', '1714412584.jpg', '0', '2024-05-02 16:50:22', '2024-04-29 17:43:04', '2024-05-02 16:50:22'),
(24, 'Namibia', 'English', 'Aim to protect wildlife? Namibia offers close encounters with rare species.', 'NA', '1714492322.jpg', '0', NULL, '2024-04-30 15:17:08', '2024-04-30 15:52:02'),
(25, 'New Zealand', 'English', 'Join Lean In NZ to protect Auckland\'s beaches with our Coastline Conservation.', 'NZ', '1714490305.png', '0', NULL, '2024-04-30 15:18:25', '2024-06-06 15:27:54'),
(26, 'Ducimus consectetur', 'Natus est ea adipisc', 'Architecto repudiand', 'CA', '1714555518.jpg', '0', '2024-05-01 09:25:28', '2024-05-01 09:25:18', '2024-05-01 09:25:28'),
(27, 'india', 'india', 'indiai nda', 'in', '1717423463.jpg', '0', '2024-06-03 14:04:45', '2024-06-03 14:04:23', '2024-06-03 14:04:45');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 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 `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint UNSIGNED NOT NULL,
  `question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_xid` bigint UNSIGNED DEFAULT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `deleted_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 `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `country_xid`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(58, 'Are there age restrictions for volunteering?', 'Many volunteer opportunities are open to people of all ages, including children, teenagers, and adults. Some roles may have age restrictions or require parental consent for younger volunteers, for most programs 16 -17 S need parental consent ,18+ can freely join the program without any consent . It\'s essential to check with the program requirement for specific age-related guidelines.', NULL, '0', NULL, '2023-10-30 09:16:18', '2024-05-02 21:47:57'),
(60, 'Do applicant need a visa ?', 'All volunteers will require a visa to join our programs. All participants will need a visa; however, your destination country may be visa-free or offer a visa on arrival. Alternatively, you may need to arrange this in your home country prior to traveling. \r\n\r\nWe will share you with more details to you once your program fee paid and your volunteer place been fully confirmed by us .\r\n\r\nYour visa fee is not included in your Program Fee and will need to be paid at your own expense.', NULL, '0', NULL, '2024-06-06 18:06:55', '2024-06-06 18:06:55');

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

--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `iam_principal`
--

CREATE TABLE `iam_principal` (
  `id` bigint UNSIGNED NOT NULL,
  `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `programs_xid` bigint UNSIGNED DEFAULT NULL,
  `country_xid` bigint UNSIGNED DEFAULT NULL,
  `start_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` enum('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1= male, 2 = female, 3 = other',
  `date_of_birth` datetime NOT NULL,
  `address_line1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hear_about_us` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `motivation_to_join_program` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `any_comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `remember_token` varchar(100) CHARACTER SET utf8mb4 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 `iam_principal`
--

INSERT INTO `iam_principal` (`id`, `first_name`, `last_name`, `email`, `email_verified_at`, `password`, `programs_xid`, `country_xid`, `start_date`, `duration`, `phone_number`, `gender`, `date_of_birth`, `address_line1`, `city`, `country`, `state`, `post_code`, `lang_level`, `hear_about_us`, `motivation_to_join_program`, `any_comment`, `profile_photo`, `is_active`, `remember_token`, `created_at`, `updated_at`) VALUES
(328, 'Megha', 'Malore', 'megha@wdimails.com', NULL, '$2y$10$xjZ.5Z98osCMCZbdMc2Ubedtf5O5XWnguy8pfQAhQzZxp/nGzmW12', NULL, NULL, NULL, NULL, '7208331056', '2', '1998-03-15 00:00:00', 'Malad', 'Mumbai', 'India', 'Maharashtra', '400064', 'easy', 'Instagram', 'English improve', 'No any Requ', '328_1715756149.png', '1', NULL, '2024-05-15 06:47:25', '2024-05-27 07:36:19'),
(336, 'Aimee', 'Zhao', 'digempty@gmail.com', NULL, '$2y$10$5kCxm9Cpri1UMYY9s4bsROMOluvJGZhLt7nhFt2PC4Ha1LDUROtxO', NULL, NULL, NULL, NULL, '+447709787925', '3', '1990-05-13 00:00:00', '28 bisho proad', 'liverpool', 'united kingdom', 'null', 'L6 0BJ', 'medium', 'Instagram', 'NULL', 'NULL', '336_1717692950.png', '1', NULL, '2024-05-15 15:03:43', '2024-06-06 16:56:03'),
(352, 'Quinn', 'Emma', 'vyvaxyce@mailinator.com', NULL, '$2y$10$8rm5aWJC9DvoEkbxbi6I9ese0dx89r2oSgVedxK4VwTakaChIC48S', NULL, NULL, NULL, NULL, '7208331056', '1', '1997-03-06 00:00:00', 'Aut occaecat asperio', 'Gillian', 'Blaine', 'Lani', 'Jamal', 'easy', 'friends', 'Duis totam aut molli', 'Commodi deserunt rep', NULL, '0', NULL, '2024-06-12 17:26:54', '2024-06-12 17:26:54'),
(353, 'Quinn', 'Emma', 'maloremegha123@gmail.com', NULL, '$2y$10$VHdme5XV90.SgUjrbKwgfOBLVsjgqzlJXZLKbEEY2fsTD.DJaPmB.', NULL, NULL, NULL, NULL, '7208331056', '1', '1997-03-06 00:00:00', 'Aut occaecat asperio', 'Gillian', 'Blaine', 'Lani', 'Jamal', 'easy', 'friends', 'Duis totam aut molli', 'Commodi deserunt rep', NULL, '0', NULL, '2024-06-12 17:30:43', '2024-06-12 17:30:43'),
(354, 'Test', 'test', '522797022@qq.com', NULL, '$2y$10$6KMyVdkyMFm1HrzzaBLIXe9ODmGswoXZXcqJFVxN3UfaYe.86NXIe', NULL, NULL, NULL, NULL, '+447709787925', '2', '2000-06-09 00:00:00', '17 dieng testing', 'testing', 'testing', 'testing', 'testing', 'medium', 'Instagram', 'tedsting', 'testing', NULL, '0', NULL, '2024-06-17 21:48:09', '2024-06-17 21:48:09');

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

--
-- Table structure for table `iam_principal_groups`
--

CREATE TABLE `iam_principal_groups` (
  `id` bigint UNSIGNED NOT NULL,
  `programs_xid` bigint UNSIGNED NOT NULL,
  `week` int NOT NULL,
  `currency` enum('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 = usd, 2 = pound,3 = euro',
  `volunteer_with` enum('1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 = yes, 2 = no',
  `volunteer_group_count` int DEFAULT NULL COMMENT '1 = 2-7, 2 = 8-20 , 3 = 20+ , 4 = 0',
  `volunteer_group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_member_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_member_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date 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 `iam_principal_groups`
--

INSERT INTO `iam_principal_groups` (`id`, `programs_xid`, `week`, `currency`, `volunteer_with`, `volunteer_group_count`, `volunteer_group_name`, `group_member_name`, `group_member_email`, `start_date`, `created_at`, `updated_at`) VALUES
(1, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"harsha@wdimails.com\"]', '2023-11-17', '2023-11-19 10:59:28', '2023-11-19 10:59:28'),
(2, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"harsha@wdimails.com\"]', '2023-11-17', '2023-11-19 10:59:46', '2023-11-19 10:59:46'),
(3, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"harsha@wdimails.com\"]', '2023-11-17', '2023-11-19 11:08:18', '2023-11-19 11:08:18'),
(4, 70, 4, '2', '1', 1, 'Testing', '[\"niwaly\",\"megha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-17', '2023-11-19 11:45:44', '2023-11-19 11:45:44'),
(5, 70, 4, '2', '1', 1, 'Testing', '[\"niwaly\",\"megha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-17', '2023-11-19 11:45:50', '2023-11-19 11:45:50'),
(6, 70, 4, '2', '1', 1, 'Testing', '[\"niwaly\",\"megha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-17', '2023-11-19 11:46:24', '2023-11-19 11:46:24'),
(7, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 11:52:29', '2023-11-19 11:52:29'),
(8, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"niwaly\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-17', '2023-11-19 11:53:52', '2023-11-19 11:53:52'),
(9, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 11:54:46', '2023-11-19 11:54:46'),
(10, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 11:54:52', '2023-11-19 11:54:52'),
(11, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 11:59:25', '2023-11-19 11:59:25'),
(12, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 12:00:10', '2023-11-19 12:00:10'),
(13, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 12:02:18', '2023-11-19 12:02:18'),
(14, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 12:05:18', '2023-11-19 12:05:18'),
(15, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 12:05:40', '2023-11-19 12:05:40'),
(16, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 12:06:35', '2023-11-19 12:06:35'),
(17, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 12:08:16', '2023-11-19 12:08:16'),
(18, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-01', '2023-11-19 14:02:35', '2023-11-19 14:02:35'),
(19, 70, 4, '2', '1', 1, 'Form Aimme', '[\"megha\",\"meghas\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-26', '2023-11-19 14:09:17', '2023-11-19 14:09:17'),
(20, 70, 4, '2', '1', 1, 'Testing', '[\"meh\",\"harsha\"]', '[\"megha@wdimails.com\",\"harsha@wdimails.com\"]', '2023-12-10', '2023-11-19 14:17:11', '2023-11-19 14:17:11'),
(21, 70, 4, '2', '1', 1, 'Testing', '[\"meh\",\"harsha\"]', '[\"megha@wdimails.com\",\"harsha@wdimails.com\"]', '2023-12-10', '2023-11-19 14:17:21', '2023-11-19 14:17:21'),
(22, 70, 4, '2', '1', 1, 'Testing', '[\"meh\",\"harsha\"]', '[\"megha@wdimails.com\",\"harsha@wdimails.com\"]', '2023-12-10', '2023-11-19 14:19:41', '2023-11-19 14:19:41'),
(23, 70, 4, '2', '1', 1, 'Testing', '[\"meh\",\"harsha\"]', '[\"megha@wdimails.com\",\"harsha@wdimails.com\"]', '2023-12-10', '2023-11-19 14:23:23', '2023-11-19 14:23:23'),
(24, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2023-11-17', '2023-11-20 05:52:46', '2023-11-20 05:52:46'),
(25, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Meghas\"]', '[\"maloremegha123@gmail.com\",\"megha@wdimails.com\"]', '2023-11-01', '2023-11-20 05:54:33', '2023-11-20 05:54:33'),
(26, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 09:41:51', '2023-11-20 09:41:51'),
(27, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:25:18', '2023-11-20 10:25:18'),
(28, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:26:27', '2023-11-20 10:26:27'),
(29, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:27:15', '2023-11-20 10:27:15'),
(30, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:27:55', '2023-11-20 10:27:55'),
(31, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:28:59', '2023-11-20 10:28:59'),
(32, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:29:45', '2023-11-20 10:29:45'),
(33, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:34:32', '2023-11-20 10:34:32'),
(34, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:39:18', '2023-11-20 10:39:18'),
(35, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:40:27', '2023-11-20 10:40:27'),
(36, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:43:13', '2023-11-20 10:43:13'),
(37, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 10:50:30', '2023-11-20 10:50:30'),
(38, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:04:34', '2023-11-20 11:04:34'),
(39, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:06:30', '2023-11-20 11:06:30'),
(40, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:11:55', '2023-11-20 11:11:55'),
(41, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:12:21', '2023-11-20 11:12:21'),
(42, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:12:25', '2023-11-20 11:12:25'),
(43, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:12:57', '2023-11-20 11:12:57'),
(44, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:15:24', '2023-11-20 11:15:24'),
(45, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:16:20', '2023-11-20 11:16:20'),
(46, 70, 4, '2', '1', 1, 'Testing', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:16:41', '2023-11-20 11:16:41'),
(52, 70, 2, '2', '1', 1, 'Lean In Group', '[\"Megha\",\"Harsha\"]', '[\"megha@wdimails.com\",\"maloremegha123@gmail.com\"]', '2001-11-23', '2023-11-20 11:59:37', '2023-11-20 11:59:37'),
(53, 70, 1, '2', '1', 1, 'dddd', '[\"ddd\"]', '[\"dug@gmail.com\"]', '2010-12-23', '2023-11-21 21:34:11', '2023-11-21 21:34:11'),
(54, 132, 3, '2', '1', 1, 'Group 2', '[\"Megha\",\"Sneha\"]', '[\"megha@wdimails.com\",\"sneha@wdimails.com\"]', '2006-03-24', '2024-03-19 11:34:28', '2024-03-19 11:34:28'),
(55, 132, 3, '2', '1', 1, 'Group 2', '[\"Megha\",\"Sneha\"]', '[\"megha@wdimails.com\",\"sneha@wdimails.com\"]', '2006-03-24', '2024-03-19 11:34:37', '2024-03-19 11:34:37'),
(56, 132, 3, '2', '1', 1, 'Group 2', '[\"Megha\",\"Sneha\"]', '[\"megha@wdimails.com\",\"sneha@wdimails.com\"]', '2006-03-24', '2024-03-19 11:36:21', '2024-03-19 11:36:21'),
(57, 132, 3, '2', '1', 1, 'Lean In Group', '[\"Megha\"]', '[\"maloremegha123@gmail.com\"]', '2006-03-24', '2024-04-09 09:32:11', '2024-04-09 09:32:11'),
(58, 133, 2, '2', '1', 1, 'TEST', '[\"difmg\"]', '[\"aimeezhao@mail.com\"]', '2017-04-24', '2024-04-09 11:14:32', '2024-04-09 11:14:32'),
(59, 133, 2, '2', '1', 1, 'MEGHA', '[\"MEGHA\"]', '[\"megha@wdimails.com\"]', '2016-05-24', '2024-04-09 11:18:38', '2024-04-09 11:18:38'),
(60, 132, 3, '2', '1', 1, 'Lean Group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2006-03-24', '2024-04-13 10:49:13', '2024-04-13 10:49:13'),
(61, 132, 3, '2', '1', 1, 'Testing', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2008-03-24', '2024-04-13 10:58:34', '2024-04-13 10:58:34'),
(62, 132, 5, '1', '1', 1, 'no', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2006-03-24', '2024-04-13 11:09:06', '2024-04-13 11:09:06'),
(63, 132, 3, '1', '1', 1, 'Testing', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2006-03-24', '2024-04-16 13:54:30', '2024-04-16 13:54:30'),
(64, 133, 3, '2', '1', 1, 'group', '[\"aimeefamil\",\"dsad\"]', '[\"digempty@gmail.com\",\"522797022@qq.com\"]', '2016-05-24', '2024-04-21 20:58:18', '2024-04-21 20:58:18'),
(65, 135, 2, '1', '1', 1, 'lean', '[\"megha\"]', '[\"megha@wdimails.com\"]', '2026-05-24', '2024-05-01 14:47:46', '2024-05-01 14:47:46'),
(66, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:38:16', '2024-05-05 09:38:16'),
(67, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:44:03', '2024-05-05 09:44:03'),
(68, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:46:56', '2024-05-05 09:46:56'),
(69, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:47:37', '2024-05-05 09:47:37'),
(70, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:49:55', '2024-05-05 09:49:55'),
(71, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:50:57', '2024-05-05 09:50:57'),
(72, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:53:57', '2024-05-05 09:53:57'),
(73, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 09:58:12', '2024-05-05 09:58:12'),
(74, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-05 10:00:18', '2024-05-05 10:00:18'),
(75, 135, 2, '2', '1', 1, 'Testing', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-05 10:15:43', '2024-05-05 10:15:43'),
(76, 133, 2, '2', '1', 1, 'null dd', '[\"aie\"]', '[\"522797022@qq.com\"]', '2017-11-23', '2024-05-05 10:25:03', '2024-05-05 10:25:03'),
(77, 135, 1, '1', '1', 1, 'Testing', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-05 10:41:08', '2024-05-05 10:41:08'),
(78, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 09:40:33', '2024-05-07 09:40:33'),
(79, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 16:50:19', '2024-05-07 16:50:19'),
(80, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 16:54:47', '2024-05-07 16:54:47'),
(81, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 16:55:31', '2024-05-07 16:55:31'),
(82, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 16:56:31', '2024-05-07 16:56:31'),
(83, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 16:57:25', '2024-05-07 16:57:25'),
(84, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 16:57:52', '2024-05-07 16:57:52'),
(85, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:01:44', '2024-05-07 17:01:44'),
(86, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:04:09', '2024-05-07 17:04:09'),
(87, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:07:30', '2024-05-07 17:07:30'),
(88, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:09:01', '2024-05-07 17:09:01'),
(89, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:12:23', '2024-05-07 17:12:23'),
(90, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:16:13', '2024-05-07 17:16:13'),
(91, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:17:32', '2024-05-07 17:17:32'),
(92, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:21:29', '2024-05-07 17:21:29'),
(93, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:27:42', '2024-05-07 17:27:42'),
(94, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:29:53', '2024-05-07 17:29:53'),
(95, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:30:39', '2024-05-07 17:30:39'),
(96, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:32:32', '2024-05-07 17:32:32'),
(97, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:33:30', '2024-05-07 17:33:30'),
(98, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 17:36:49', '2024-05-07 17:36:49'),
(99, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:04:44', '2024-05-07 18:04:44'),
(100, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:08:39', '2024-05-07 18:08:39'),
(101, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:09:39', '2024-05-07 18:09:39'),
(102, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:10:51', '2024-05-07 18:10:51'),
(103, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:29:35', '2024-05-07 18:29:35'),
(104, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:32:11', '2024-05-07 18:32:11'),
(105, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:36:03', '2024-05-07 18:36:03'),
(106, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:36:23', '2024-05-07 18:36:23'),
(107, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-07 18:38:13', '2024-05-07 18:38:13'),
(108, 133, 2, '2', '1', 1, 'Lean In group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-13 10:08:57', '2024-05-13 10:08:57'),
(109, 133, 2, '2', '1', 1, 'Lean In group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-13 10:14:16', '2024-05-13 10:14:16'),
(110, 133, 2, '2', '1', 1, 'Lean In group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-13 10:14:38', '2024-05-13 10:14:38'),
(111, 135, 1, '2', '1', 1, 'Lean in group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-15 06:56:56', '2024-05-15 06:56:56'),
(112, 135, 2, '2', '1', 1, 'Lean in group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-15 06:58:39', '2024-05-15 06:58:39'),
(113, 135, 1, '2', '1', 1, 'Lean In Group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-15 07:04:47', '2024-05-15 07:04:47'),
(114, 135, 2, '1', '1', 1, 'Lean In group', '[\"Megha\"]', '[\"malore@wdimails.com\"]', '2017-11-23', '2024-05-15 07:08:50', '2024-05-15 07:08:50'),
(115, 135, 2, '1', '1', 1, 'Lean In group', '[\"Megha\"]', '[\"malore@wdimails.com\"]', '2017-11-23', '2024-05-15 07:09:33', '2024-05-15 07:09:33'),
(116, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-15 14:18:08', '2024-05-15 14:18:08'),
(117, 135, 1, '2', '1', 1, 'no group', '[\"g\"]', '[\"aimeezhao@mail.com\"]', '2017-11-23', '2024-05-15 14:22:44', '2024-05-15 14:22:44'),
(118, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-15 15:11:40', '2024-05-15 15:11:40'),
(119, 135, 1, '2', '1', 1, '123', '[\"chines\"]', '[\"aimeezhao@mail.com\"]', '2017-11-23', '2024-05-15 15:12:01', '2024-05-15 15:12:01'),
(120, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 07:54:11', '2024-05-16 07:54:11'),
(121, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 07:57:12', '2024-05-16 07:57:12'),
(122, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 07:57:54', '2024-05-16 07:57:54'),
(123, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 08:04:27', '2024-05-16 08:04:27'),
(124, 135, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 08:16:01', '2024-05-16 08:16:01'),
(125, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 09:20:12', '2024-05-16 09:20:12'),
(126, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 09:26:18', '2024-05-16 09:26:18'),
(127, 135, 1, '2', '1', 1, 'Lean In Group', '[\"Megha Malore\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-16 09:28:11', '2024-05-16 09:28:11'),
(128, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 09:33:54', '2024-05-16 09:33:54'),
(129, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 09:43:41', '2024-05-16 09:43:41'),
(130, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 10:35:41', '2024-05-16 10:35:41'),
(131, 135, 2, '1', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:04:22', '2024-05-16 11:04:22'),
(132, 135, 2, '1', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:16:27', '2024-05-16 11:16:27'),
(133, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:39:01', '2024-05-16 11:39:01'),
(134, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:39:17', '2024-05-16 11:39:17'),
(135, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:41:09', '2024-05-16 11:41:09'),
(136, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:44:33', '2024-05-16 11:44:33'),
(137, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:57:52', '2024-05-16 11:57:52'),
(138, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 11:59:42', '2024-05-16 11:59:42'),
(139, 135, 2, '1', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 12:01:39', '2024-05-16 12:01:39'),
(140, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 12:17:15', '2024-05-16 12:17:15'),
(141, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 12:21:44', '2024-05-16 12:21:44'),
(142, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 15:56:14', '2024-05-16 15:56:14'),
(143, 135, 1, '2', '2', 1, NULL, '[null]', '[null]', '2017-11-23', '2024-05-16 16:06:21', '2024-05-16 16:06:21'),
(144, 135, 2, '1', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 05:15:57', '2024-05-19 05:15:57'),
(145, 135, 2, '1', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 05:20:57', '2024-05-19 05:20:57'),
(146, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 05:27:07', '2024-05-19 05:27:07'),
(147, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 05:29:46', '2024-05-19 05:29:46'),
(148, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 05:38:40', '2024-05-19 05:38:40'),
(149, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 05:42:49', '2024-05-19 05:42:49'),
(150, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 05:45:53', '2024-05-19 05:45:53'),
(151, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 11:08:52', '2024-05-19 11:08:52'),
(152, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 11:25:05', '2024-05-19 11:25:05'),
(153, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 11:29:58', '2024-05-19 11:29:58'),
(154, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 11:47:46', '2024-05-19 11:47:46'),
(155, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 11:53:12', '2024-05-19 11:53:12'),
(156, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 11:56:59', '2024-05-19 11:56:59'),
(157, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 12:02:15', '2024-05-19 12:02:15'),
(158, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 12:10:49', '2024-05-19 12:10:49'),
(159, 133, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-19 17:06:05', '2024-05-19 17:06:05'),
(160, 133, 6, '1', '1', 1, 'Lean In Group', '[\"megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-19 17:28:21', '2024-05-19 17:28:21'),
(161, 133, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 09:28:42', '2024-05-20 09:28:42'),
(162, 133, 6, '3', '1', 1, 'Lean In Group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-20 09:42:27', '2024-05-20 09:42:27'),
(163, 133, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 09:46:41', '2024-05-20 09:46:41'),
(164, 133, 2, '2', '1', 1, 'Lean In Group', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-20 09:56:07', '2024-05-20 09:56:07'),
(165, 133, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 10:05:05', '2024-05-20 10:05:05'),
(166, 133, 8, '1', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 10:10:52', '2024-05-20 10:10:52'),
(167, 133, 8, '1', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 10:20:31', '2024-05-20 10:20:31'),
(168, 135, 1, '2', '2', 1, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 13:55:07', '2024-05-20 13:55:07'),
(169, 135, 1, '2', '1', 1, 'wechat', '[\"wexha\"]', '[\"aimeezhao@mail.com\"]', '2017-11-23', '2024-05-20 14:00:14', '2024-05-20 14:00:14'),
(170, 133, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 15:40:18', '2024-05-20 15:40:18'),
(171, 133, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 15:42:52', '2024-05-20 15:42:52'),
(172, 133, 8, '1', '1', 1, 'Lean In Ngoes', '[\"Megha\"]', '[\"megha@wdimails.com\"]', '2017-11-23', '2024-05-20 15:45:43', '2024-05-20 15:45:43'),
(173, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 15:48:38', '2024-05-20 15:48:38'),
(174, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-20 15:51:42', '2024-05-20 15:51:42'),
(175, 135, 1, '2', '1', 1, '111', '[\"ali ali\",\"ali bye\"]', '[\"digempty@gmail.com\",\"aimeezhao@mail.com\"]', '2017-11-23', '2024-05-20 15:56:25', '2024-05-20 15:56:25'),
(176, 133, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-05-27 07:40:39', '2024-05-27 07:40:39'),
(177, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-06-06 16:56:49', '2024-06-06 16:56:49'),
(178, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-06-06 16:57:47', '2024-06-06 16:57:47'),
(179, 135, 1, '2', '1', 1, 'testing', '[\"testing\"]', '[\"aimeezhao@mail.com\"]', '2017-11-23', '2024-06-06 16:58:11', '2024-06-06 16:58:11'),
(180, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-06-10 17:33:28', '2024-06-10 17:33:28'),
(181, 132, 2, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-06-11 10:11:15', '2024-06-11 10:11:15'),
(182, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-06-12 17:23:37', '2024-06-12 17:23:37'),
(183, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-06-12 17:55:12', '2024-06-12 17:55:12'),
(184, 135, 1, '2', '2', NULL, NULL, '[null]', '[null]', '2017-11-23', '2024-06-13 11:42:06', '2024-06-13 11:42:06');

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

--
-- Table structure for table `iam_principal_principal_group_links`
--

CREATE TABLE `iam_principal_principal_group_links` (
  `id` bigint UNSIGNED NOT NULL,
  `principal_xid` bigint UNSIGNED NOT NULL,
  `principal_group_xid` 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;

--
-- Dumping data for table `iam_principal_principal_group_links`
--

INSERT INTO `iam_principal_principal_group_links` (`id`, `principal_xid`, `principal_group_xid`, `created_at`, `updated_at`) VALUES
(1, 1, 2, '2023-07-19 12:29:39', '2023-07-19 12:29:39'),
(2, 1, 3, '2023-07-19 13:04:35', '2023-07-19 13:04:35'),
(3, 1, 4, '2023-07-19 13:09:22', '2023-07-19 13:09:22'),
(4, 1, 5, '2023-07-26 06:21:15', '2023-07-26 06:21:15'),
(5, 1, 6, '2023-07-26 10:55:23', '2023-07-26 10:55:23'),
(6, 1, 7, '2023-07-26 11:31:23', '2023-07-26 11:31:23'),
(7, 1, 8, '2023-07-26 11:32:25', '2023-07-26 11:32:25'),
(8, 1, 9, '2023-07-26 11:34:12', '2023-07-26 11:34:12'),
(9, 1, 10, '2023-07-26 11:40:18', '2023-07-26 11:40:18'),
(10, 1, 11, '2023-07-26 11:48:50', '2023-07-26 11:48:50'),
(11, 1, 12, '2023-07-26 11:49:47', '2023-07-26 11:49:47'),
(12, 1, 13, '2023-07-26 11:51:58', '2023-07-26 11:51:58'),
(13, 1, 14, '2023-07-26 11:54:53', '2023-07-26 11:54:53'),
(14, 1, 15, '2023-07-26 11:57:10', '2023-07-26 11:57:10'),
(15, 1, 16, '2023-07-26 12:17:29', '2023-07-26 12:17:29'),
(16, 115, 17, '2023-07-26 13:19:47', '2023-07-26 13:19:47'),
(17, 115, 18, '2023-07-26 13:29:59', '2023-07-26 13:29:59'),
(18, 115, 19, '2023-07-26 13:33:27', '2023-07-26 13:33:27'),
(19, 115, 20, '2023-07-26 13:37:09', '2023-07-26 13:37:09'),
(20, 115, 21, '2023-07-26 13:38:57', '2023-07-26 13:38:57'),
(21, 115, 22, '2023-07-26 13:44:24', '2023-07-26 13:44:24'),
(22, 115, 23, '2023-07-26 13:46:11', '2023-07-26 13:46:11'),
(23, 115, 24, '2023-07-26 13:53:42', '2023-07-26 13:53:42'),
(24, 115, 25, '2023-07-26 13:55:59', '2023-07-26 13:55:59'),
(25, 1, 26, '2023-07-26 17:50:49', '2023-07-26 17:50:49'),
(26, 1, 27, '2023-07-26 18:05:01', '2023-07-26 18:05:01'),
(27, 1, 28, '2023-07-26 18:08:23', '2023-07-26 18:08:23'),
(28, 1, 29, '2023-07-26 18:36:57', '2023-07-26 18:36:57'),
(29, 1, 30, '2023-07-26 18:39:19', '2023-07-26 18:39:19'),
(30, 1, 31, '2023-07-26 18:40:10', '2023-07-26 18:40:10'),
(31, 1, 32, '2023-07-27 07:02:57', '2023-07-27 07:02:57'),
(32, 1, 33, '2023-07-27 07:03:41', '2023-07-27 07:03:41'),
(33, 1, 34, '2023-07-27 07:04:05', '2023-07-27 07:04:05'),
(34, 1, 35, '2023-07-27 07:05:10', '2023-07-27 07:05:10'),
(35, 1, 36, '2023-07-27 07:05:28', '2023-07-27 07:05:28'),
(36, 1, 37, '2023-07-27 07:07:33', '2023-07-27 07:07:33'),
(37, 1, 38, '2023-07-27 07:11:07', '2023-07-27 07:11:07'),
(38, 1, 39, '2023-07-27 07:12:26', '2023-07-27 07:12:26'),
(39, 1, 40, '2023-07-27 07:12:40', '2023-07-27 07:12:40'),
(40, 1, 41, '2023-07-27 07:14:58', '2023-07-27 07:14:58'),
(41, 1, 42, '2023-07-27 07:24:55', '2023-07-27 07:24:55'),
(42, 1, 43, '2023-07-27 07:32:00', '2023-07-27 07:32:00'),
(43, 1, 44, '2023-07-27 07:46:12', '2023-07-27 07:46:12'),
(44, 1, 45, '2023-07-27 07:48:31', '2023-07-27 07:48:31'),
(45, 1, 46, '2023-07-27 07:52:56', '2023-07-27 07:52:56'),
(46, 1, 47, '2023-07-27 07:54:31', '2023-07-27 07:54:31'),
(47, 1, 48, '2023-07-28 12:36:26', '2023-07-28 12:36:26'),
(48, 1, 49, '2023-07-28 12:36:27', '2023-07-28 12:36:27'),
(49, 1, 50, '2023-07-30 17:26:15', '2023-07-30 17:26:15'),
(50, 1, 51, '2023-07-31 12:26:49', '2023-07-31 12:26:49'),
(51, 1, 52, '2023-07-31 12:28:41', '2023-07-31 12:28:41'),
(52, 1, 53, '2023-07-31 13:11:40', '2023-07-31 13:11:40'),
(53, 1, 54, '2023-07-31 13:19:42', '2023-07-31 13:19:42'),
(54, 1, 55, '2023-07-31 13:25:00', '2023-07-31 13:25:00'),
(55, 1, 56, '2023-07-31 13:27:09', '2023-07-31 13:27:09'),
(56, 1, 57, '2023-07-31 13:28:40', '2023-07-31 13:28:40'),
(57, 1, 58, '2023-07-31 13:52:29', '2023-07-31 13:52:29'),
(58, 1, 59, '2023-07-31 13:53:55', '2023-07-31 13:53:55'),
(59, 1, 60, '2023-07-31 14:42:52', '2023-07-31 14:42:52'),
(60, 1, 61, '2023-07-31 14:47:23', '2023-07-31 14:47:23'),
(61, 1, 62, '2023-08-01 00:20:20', '2023-08-01 00:20:20'),
(62, 1, 63, '2023-08-01 12:40:05', '2023-08-01 12:40:05'),
(63, 1, 64, '2023-08-01 12:40:36', '2023-08-01 12:40:36'),
(64, 147, 1, '2023-08-03 07:32:52', '2023-08-03 07:32:52'),
(65, 147, 2, '2023-08-03 07:33:08', '2023-08-03 07:33:08'),
(66, 147, 3, '2023-08-03 07:34:31', '2023-08-03 07:34:31'),
(67, 147, 1, '2023-08-03 08:00:14', '2023-08-03 08:00:14'),
(68, 147, 2, '2023-08-03 08:03:09', '2023-08-03 08:03:09'),
(69, 147, 3, '2023-08-03 08:08:09', '2023-08-03 08:08:09'),
(70, 1, 4, '2023-08-12 18:51:52', '2023-08-12 18:51:52'),
(71, 1, 5, '2023-08-12 18:54:40', '2023-08-12 18:54:40'),
(72, 1, 6, '2023-08-12 18:56:21', '2023-08-12 18:56:21'),
(73, 1, 7, '2023-08-12 18:59:55', '2023-08-12 18:59:55'),
(74, 1, 8, '2023-08-12 19:03:52', '2023-08-12 19:03:52'),
(75, 1, 9, '2023-08-12 19:20:25', '2023-08-12 19:20:25'),
(76, 16, 10, '2023-08-23 12:03:15', '2023-08-23 12:03:15'),
(77, 16, 11, '2023-08-23 12:04:52', '2023-08-23 12:04:52'),
(78, 17, 12, '2023-09-02 18:11:15', '2023-09-02 18:11:15'),
(79, 1, 13, '2023-09-12 14:15:33', '2023-09-12 14:15:33'),
(80, 1, 14, '2023-09-17 13:48:54', '2023-09-17 13:48:54'),
(81, 1, 15, '2023-09-17 17:23:09', '2023-09-17 17:23:09'),
(82, 1, 16, '2023-09-17 17:34:54', '2023-09-17 17:34:54'),
(83, 40, 17, '2023-09-22 10:52:45', '2023-09-22 10:52:45'),
(84, 40, 18, '2023-09-22 10:55:11', '2023-09-22 10:55:11'),
(85, 1, 19, '2023-09-24 19:28:46', '2023-09-24 19:28:46'),
(86, 1, 20, '2023-09-24 19:47:06', '2023-09-24 19:47:06'),
(87, 1, 21, '2023-09-24 19:50:55', '2023-09-24 19:50:55'),
(88, 1, 22, '2023-09-24 19:56:19', '2023-09-24 19:56:19'),
(89, 1, 23, '2023-09-26 07:05:01', '2023-09-26 07:05:01'),
(90, 1, 24, '2023-09-26 07:10:16', '2023-09-26 07:10:16'),
(91, 1, 25, '2023-09-26 07:13:18', '2023-09-26 07:13:18'),
(92, 1, 26, '2023-09-26 07:36:34', '2023-09-26 07:36:34'),
(93, 1, 27, '2023-09-26 08:13:05', '2023-09-26 08:13:05'),
(94, 1, 28, '2023-09-26 08:21:03', '2023-09-26 08:21:03'),
(95, 1, 29, '2023-09-26 08:31:24', '2023-09-26 08:31:24'),
(96, 1, 30, '2023-09-26 13:27:10', '2023-09-26 13:27:10'),
(97, 1, 31, '2023-09-26 13:33:31', '2023-09-26 13:33:31'),
(98, 1, 32, '2023-09-26 13:38:45', '2023-09-26 13:38:45'),
(99, 1, 33, '2023-09-26 13:54:59', '2023-09-26 13:54:59'),
(100, 1, 34, '2023-09-26 13:57:47', '2023-09-26 13:57:47'),
(101, 1, 35, '2023-10-03 09:31:28', '2023-10-03 09:31:28'),
(102, 1, 36, '2023-10-03 09:33:51', '2023-10-03 09:33:51'),
(103, 1, 37, '2023-10-03 10:57:20', '2023-10-03 10:57:20'),
(104, 1, 38, '2023-10-03 10:57:33', '2023-10-03 10:57:33'),
(105, 1, 39, '2023-10-03 10:57:33', '2023-10-03 10:57:33'),
(106, 1, 40, '2023-10-03 10:57:33', '2023-10-03 10:57:33'),
(107, 1, 41, '2023-10-03 10:57:34', '2023-10-03 10:57:34'),
(108, 1, 42, '2023-10-03 10:57:34', '2023-10-03 10:57:34'),
(109, 1, 43, '2023-10-03 10:57:34', '2023-10-03 10:57:34'),
(110, 1, 44, '2023-10-03 10:57:35', '2023-10-03 10:57:35'),
(111, 1, 45, '2023-10-03 10:57:46', '2023-10-03 10:57:46'),
(112, 1, 46, '2023-10-03 10:58:18', '2023-10-03 10:58:18'),
(113, 1, 47, '2023-10-03 10:58:56', '2023-10-03 10:58:56'),
(114, 1, 48, '2023-10-03 10:58:58', '2023-10-03 10:58:58'),
(115, 1, 49, '2023-10-03 11:02:52', '2023-10-03 11:02:52'),
(116, 1, 50, '2023-10-06 11:09:13', '2023-10-06 11:09:13'),
(117, 1, 51, '2023-10-06 11:29:58', '2023-10-06 11:29:58'),
(118, 1, 52, '2023-10-06 13:23:04', '2023-10-06 13:23:04'),
(119, 1, 53, '2023-10-07 17:51:38', '2023-10-07 17:51:38'),
(120, 1, 54, '2023-10-07 17:53:22', '2023-10-07 17:53:22'),
(121, 1, 55, '2023-10-07 17:59:37', '2023-10-07 17:59:37'),
(122, 1, 56, '2023-10-07 18:10:10', '2023-10-07 18:10:10'),
(123, 1, 57, '2023-10-07 18:29:36', '2023-10-07 18:29:36'),
(124, 1, 58, '2023-10-07 18:32:21', '2023-10-07 18:32:21'),
(125, 1, 59, '2023-10-07 18:34:36', '2023-10-07 18:34:36'),
(126, 1, 60, '2023-10-07 18:40:08', '2023-10-07 18:40:08'),
(127, 1, 61, '2023-10-07 18:47:15', '2023-10-07 18:47:15'),
(128, 1, 62, '2023-10-07 18:49:15', '2023-10-07 18:49:15'),
(129, 1, 63, '2023-10-08 15:28:40', '2023-10-08 15:28:40'),
(130, 134, 64, '2023-10-08 15:41:49', '2023-10-08 15:41:49'),
(131, 1, 65, '2023-10-08 15:44:58', '2023-10-08 15:44:58'),
(132, 1, 66, '2023-10-08 15:45:12', '2023-10-08 15:45:12'),
(133, 1, 67, '2023-10-08 15:47:32', '2023-10-08 15:47:32'),
(134, 134, 68, '2023-10-08 17:19:17', '2023-10-08 17:19:17'),
(135, 1, 69, '2023-10-08 17:20:20', '2023-10-08 17:20:20'),
(136, 1, 70, '2023-10-08 17:20:36', '2023-10-08 17:20:36'),
(137, 134, 71, '2023-10-08 17:23:56', '2023-10-08 17:23:56'),
(138, 1, 72, '2023-10-08 17:26:42', '2023-10-08 17:26:42'),
(139, 1, 73, '2023-10-08 17:27:00', '2023-10-08 17:27:00'),
(140, 1, 74, '2023-10-08 17:30:36', '2023-10-08 17:30:36'),
(141, 1, 75, '2023-10-08 17:33:05', '2023-10-08 17:33:05'),
(142, 1, 76, '2023-10-08 17:42:55', '2023-10-08 17:42:55'),
(143, 1, 77, '2023-10-08 17:48:56', '2023-10-08 17:48:56'),
(144, 1, 78, '2023-10-09 06:24:46', '2023-10-09 06:24:46'),
(145, 1, 79, '2023-10-09 06:25:03', '2023-10-09 06:25:03'),
(146, 1, 80, '2023-10-09 06:26:43', '2023-10-09 06:26:43'),
(147, 135, 81, '2023-10-09 06:36:14', '2023-10-09 06:36:14'),
(148, 1, 82, '2023-10-09 10:14:55', '2023-10-09 10:14:55'),
(149, 1, 83, '2023-10-09 10:42:22', '2023-10-09 10:42:22'),
(150, 1, 84, '2023-10-09 11:26:04', '2023-10-09 11:26:04'),
(151, 1, 85, '2023-10-09 11:30:13', '2023-10-09 11:30:13'),
(152, 1, 86, '2023-10-09 11:41:37', '2023-10-09 11:41:37'),
(153, 1, 87, '2023-10-09 11:42:19', '2023-10-09 11:42:19'),
(154, 1, 88, '2023-10-09 11:58:27', '2023-10-09 11:58:27'),
(155, 1, 89, '2023-10-09 12:27:10', '2023-10-09 12:27:10'),
(156, 1, 90, '2023-10-09 13:18:24', '2023-10-09 13:18:24'),
(157, 1, 91, '2023-10-09 13:18:34', '2023-10-09 13:18:34'),
(158, 1, 92, '2023-10-09 13:19:48', '2023-10-09 13:19:48'),
(159, 1, 93, '2023-10-09 13:22:41', '2023-10-09 13:22:41'),
(160, 1, 94, '2023-10-09 13:35:13', '2023-10-09 13:35:13'),
(161, 1, 95, '2023-10-09 13:36:53', '2023-10-09 13:36:53'),
(162, 1, 96, '2023-10-09 13:38:59', '2023-10-09 13:38:59'),
(163, 1, 97, '2023-10-09 13:40:20', '2023-10-09 13:40:20'),
(164, 1, 98, '2023-10-09 13:42:04', '2023-10-09 13:42:04'),
(165, 1, 99, '2023-10-09 13:43:02', '2023-10-09 13:43:02'),
(166, 1, 100, '2023-10-09 14:20:55', '2023-10-09 14:20:55'),
(167, 1, 101, '2023-10-09 14:22:14', '2023-10-09 14:22:14'),
(168, 1, 102, '2023-10-09 14:24:14', '2023-10-09 14:24:14'),
(169, 1, 103, '2023-10-09 14:26:25', '2023-10-09 14:26:25'),
(170, 1, 104, '2023-10-10 06:40:04', '2023-10-10 06:40:04'),
(171, 1, 105, '2023-10-10 06:52:33', '2023-10-10 06:52:33'),
(172, 1, 106, '2023-10-10 07:18:42', '2023-10-10 07:18:42'),
(173, 1, 107, '2023-10-10 09:26:55', '2023-10-10 09:26:55'),
(174, 138, 108, '2023-10-10 10:03:48', '2023-10-10 10:03:48'),
(175, 143, 109, '2023-10-10 17:58:29', '2023-10-10 17:58:29'),
(176, 143, 110, '2023-10-10 18:00:07', '2023-10-10 18:00:07'),
(177, 143, 111, '2023-10-10 18:00:31', '2023-10-10 18:00:31'),
(178, 143, 112, '2023-10-10 18:03:22', '2023-10-10 18:03:22'),
(179, 143, 113, '2023-10-10 18:03:58', '2023-10-10 18:03:58'),
(180, 143, 114, '2023-10-10 18:04:10', '2023-10-10 18:04:10'),
(181, 143, 115, '2023-10-10 18:07:36', '2023-10-10 18:07:36'),
(182, 143, 116, '2023-10-10 18:12:26', '2023-10-10 18:12:26'),
(183, 143, 117, '2023-10-10 18:13:28', '2023-10-10 18:13:28'),
(184, 143, 118, '2023-10-10 18:17:40', '2023-10-10 18:17:40'),
(185, 143, 119, '2023-10-10 18:19:13', '2023-10-10 18:19:13'),
(186, 143, 120, '2023-10-10 18:21:09', '2023-10-10 18:21:09'),
(187, 143, 121, '2023-10-10 18:25:48', '2023-10-10 18:25:48'),
(188, 143, 122, '2023-10-10 18:26:34', '2023-10-10 18:26:34'),
(189, 143, 123, '2023-10-10 18:28:20', '2023-10-10 18:28:20'),
(190, 143, 124, '2023-10-10 18:31:43', '2023-10-10 18:31:43'),
(191, 143, 125, '2023-10-10 18:39:46', '2023-10-10 18:39:46'),
(192, 143, 126, '2023-10-10 18:41:08', '2023-10-10 18:41:08'),
(193, 143, 127, '2023-10-10 18:44:39', '2023-10-10 18:44:39'),
(194, 143, 128, '2023-10-10 18:46:23', '2023-10-10 18:46:23'),
(195, 143, 129, '2023-10-10 18:47:11', '2023-10-10 18:47:11'),
(196, 143, 130, '2023-10-10 19:02:05', '2023-10-10 19:02:05'),
(197, 143, 131, '2023-10-12 07:24:48', '2023-10-12 07:24:48'),
(198, 143, 132, '2023-10-12 07:26:43', '2023-10-12 07:26:43'),
(199, 143, 133, '2023-10-14 15:48:06', '2023-10-14 15:48:06'),
(200, 145, 134, '2023-10-14 17:06:13', '2023-10-14 17:06:13'),
(201, 148, 135, '2023-10-14 17:31:44', '2023-10-14 17:31:44'),
(202, 148, 136, '2023-10-14 17:37:47', '2023-10-14 17:37:47'),
(203, 1, 137, '2023-10-19 08:13:01', '2023-10-19 08:13:01'),
(204, 1, 138, '2023-10-19 08:25:24', '2023-10-19 08:25:24'),
(205, 160, 139, '2023-10-19 09:54:40', '2023-10-19 09:54:40'),
(206, 160, 140, '2023-10-19 09:55:26', '2023-10-19 09:55:26'),
(207, 160, 141, '2023-10-19 09:56:42', '2023-10-19 09:56:42'),
(208, 160, 142, '2023-10-19 09:58:50', '2023-10-19 09:58:50'),
(209, 160, 143, '2023-10-19 09:58:51', '2023-10-19 09:58:51'),
(210, 160, 144, '2023-10-19 10:03:12', '2023-10-19 10:03:12'),
(211, 161, 145, '2023-10-19 10:24:21', '2023-10-19 10:24:21'),
(212, 143, 146, '2023-10-19 11:08:26', '2023-10-19 11:08:26'),
(213, 143, 147, '2023-10-19 11:13:35', '2023-10-19 11:13:35'),
(214, 143, 148, '2023-10-19 13:21:12', '2023-10-19 13:21:12'),
(215, 1, 149, '2023-10-20 09:53:02', '2023-10-20 09:53:02'),
(216, 1, 150, '2023-10-20 09:58:56', '2023-10-20 09:58:56'),
(217, 1, 151, '2023-10-20 09:59:24', '2023-10-20 09:59:24'),
(218, 1, 152, '2023-10-20 10:17:40', '2023-10-20 10:17:40'),
(219, 1, 153, '2023-10-20 10:18:12', '2023-10-20 10:18:12'),
(220, 1, 154, '2023-10-20 10:20:23', '2023-10-20 10:20:23'),
(221, 1, 155, '2023-10-20 10:20:48', '2023-10-20 10:20:48'),
(222, 1, 156, '2023-10-20 10:24:26', '2023-10-20 10:24:26'),
(223, 1, 157, '2023-10-20 10:36:01', '2023-10-20 10:36:01'),
(224, 1, 158, '2023-10-20 10:38:51', '2023-10-20 10:38:51'),
(225, 1, 159, '2023-10-20 10:41:21', '2023-10-20 10:41:21'),
(226, 1, 160, '2023-10-20 10:45:58', '2023-10-20 10:45:58'),
(227, 1, 161, '2023-10-20 10:50:23', '2023-10-20 10:50:23'),
(228, 1, 162, '2023-10-20 10:50:25', '2023-10-20 10:50:25'),
(229, 1, 163, '2023-10-20 10:50:25', '2023-10-20 10:50:25'),
(230, 1, 164, '2023-10-20 10:50:50', '2023-10-20 10:50:50'),
(231, 1, 165, '2023-10-20 10:51:34', '2023-10-20 10:51:34'),
(232, 1, 166, '2023-10-20 10:54:27', '2023-10-20 10:54:27'),
(233, 1, 167, '2023-10-20 10:54:42', '2023-10-20 10:54:42'),
(234, 1, 168, '2023-10-20 10:55:50', '2023-10-20 10:55:50'),
(235, 1, 169, '2023-10-20 11:09:06', '2023-10-20 11:09:06'),
(236, 1, 170, '2023-10-20 11:10:47', '2023-10-20 11:10:47'),
(237, 1, 171, '2023-10-20 11:13:04', '2023-10-20 11:13:04'),
(238, 1, 172, '2023-10-20 11:19:26', '2023-10-20 11:19:26'),
(239, 1, 173, '2023-10-20 11:19:45', '2023-10-20 11:19:45'),
(240, 1, 174, '2023-10-20 11:25:07', '2023-10-20 11:25:07'),
(241, 1, 175, '2023-10-20 11:41:39', '2023-10-20 11:41:39'),
(242, 1, 176, '2023-10-20 11:58:55', '2023-10-20 11:58:55'),
(243, 1, 177, '2023-10-20 12:00:59', '2023-10-20 12:00:59'),
(244, 1, 178, '2023-10-20 12:02:07', '2023-10-20 12:02:07'),
(245, 1, 179, '2023-10-23 08:52:56', '2023-10-23 08:52:56'),
(246, 1, 180, '2023-10-23 09:17:04', '2023-10-23 09:17:04'),
(247, 1, 181, '2023-10-24 07:55:02', '2023-10-24 07:55:02'),
(248, 1, 182, '2023-10-24 07:56:31', '2023-10-24 07:56:31'),
(249, 1, 183, '2023-10-24 07:56:58', '2023-10-24 07:56:58'),
(250, 1, 184, '2023-10-24 08:00:57', '2023-10-24 08:00:57'),
(251, 1, 185, '2023-10-24 08:06:08', '2023-10-24 08:06:08'),
(252, 1, 186, '2023-10-24 08:06:30', '2023-10-24 08:06:30'),
(253, 1, 187, '2023-10-24 08:09:50', '2023-10-24 08:09:50'),
(254, 1, 188, '2023-10-24 08:10:38', '2023-10-24 08:10:38'),
(255, 1, 189, '2023-10-24 08:10:54', '2023-10-24 08:10:54'),
(256, 1, 190, '2023-10-24 09:14:07', '2023-10-24 09:14:07'),
(257, 1, 191, '2023-10-31 08:17:04', '2023-10-31 08:17:04'),
(258, 1, 192, '2023-10-31 08:23:03', '2023-10-31 08:23:03'),
(259, 167, 193, '2023-11-02 12:00:55', '2023-11-02 12:00:55'),
(260, 1, 194, '2023-11-17 11:57:45', '2023-11-17 11:57:45'),
(261, 1, 195, '2023-11-17 13:48:15', '2023-11-17 13:48:15'),
(262, 1, 3, '2023-11-19 11:08:19', '2023-11-19 11:08:19'),
(263, 1, 6, '2023-11-19 11:46:24', '2023-11-19 11:46:24'),
(264, 1, 7, '2023-11-19 11:52:29', '2023-11-19 11:52:29'),
(265, 1, 8, '2023-11-19 11:53:53', '2023-11-19 11:53:53'),
(266, 1, 17, '2023-11-19 12:08:16', '2023-11-19 12:08:16'),
(267, 1, 18, '2023-11-19 14:02:35', '2023-11-19 14:02:35'),
(268, 1, 19, '2023-11-19 14:09:17', '2023-11-19 14:09:17'),
(269, 1, 20, '2023-11-19 14:17:11', '2023-11-19 14:17:11'),
(270, 1, 21, '2023-11-19 14:17:21', '2023-11-19 14:17:21'),
(271, 1, 22, '2023-11-19 14:19:42', '2023-11-19 14:19:42'),
(272, 1, 23, '2023-11-19 14:23:23', '2023-11-19 14:23:23'),
(273, 1, 24, '2023-11-20 05:52:46', '2023-11-20 05:52:46'),
(274, 1, 25, '2023-11-20 05:54:34', '2023-11-20 05:54:34'),
(279, 167, 53, '2023-11-21 21:34:12', '2023-11-21 21:34:12'),
(282, 170, 58, '2024-04-09 11:14:32', '2024-04-09 11:14:32'),
(283, 170, 59, '2024-04-09 11:18:38', '2024-04-09 11:18:38'),
(288, 244, 64, '2024-04-21 20:58:19', '2024-04-21 20:58:19'),
(291, 170, 76, '2024-05-05 10:25:06', '2024-05-05 10:25:06'),
(296, 328, 111, '2024-05-15 06:56:56', '2024-05-15 06:56:56'),
(297, 328, 112, '2024-05-15 06:58:39', '2024-05-15 06:58:39'),
(298, 328, 113, '2024-05-15 07:04:47', '2024-05-15 07:04:47'),
(299, 328, 114, '2024-05-15 07:08:50', '2024-05-15 07:08:50'),
(300, 328, 115, '2024-05-15 07:09:33', '2024-05-15 07:09:33'),
(301, 170, 117, '2024-05-15 14:22:44', '2024-05-15 14:22:44'),
(302, 336, 119, '2024-05-15 15:12:01', '2024-05-15 15:12:01'),
(303, 328, 127, '2024-05-16 09:28:11', '2024-05-16 09:28:11'),
(304, 328, 160, '2024-05-19 17:28:22', '2024-05-19 17:28:22'),
(305, 328, 162, '2024-05-20 09:42:27', '2024-05-20 09:42:27'),
(306, 328, 164, '2024-05-20 09:56:07', '2024-05-20 09:56:07'),
(307, 170, 169, '2024-05-20 14:00:14', '2024-05-20 14:00:14'),
(308, 328, 172, '2024-05-20 15:45:43', '2024-05-20 15:45:43'),
(309, 170, 175, '2024-05-20 15:56:25', '2024-05-20 15:56:25'),
(310, 336, 179, '2024-06-06 16:58:11', '2024-06-06 16:58:11');

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

--
-- Table structure for table `latest_updates`
--

CREATE TABLE `latest_updates` (
  `id` int NOT NULL,
  `description` text,
  `usd_price` decimal(10,0) DEFAULT NULL,
  `volunteers_hours` varchar(500) DEFAULT NULL,
  `participation_in_project` varchar(500) NOT NULL,
  `wildlife_conversation_project` varchar(500) NOT NULL,
  `volunteering_countries` varchar(500) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `latest_updates`
--

INSERT INTO `latest_updates` (`id`, `description`, `usd_price`, `volunteers_hours`, `participation_in_project`, `wildlife_conversation_project`, `volunteering_countries`, `created_at`, `updated_at`) VALUES
(1, 'Summer applications fully open now !', 139, '180k', '480K', '8', '8', NULL, '2024-06-17 22:03:05');

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

--
-- Table structure for table `mail_templates`
--

CREATE TABLE `mail_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `program_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 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 `mail_templates`
--

INSERT INTO `mail_templates` (`id`, `program_title`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Admin Otp', '<p>Dear,<strong>{{$name}}</strong></p><p>You are receiving this email because you requested a one-time password (OTP) for accessing Your Dashboard. Please use the OTP below to complete your authentication:</p><p>Your otp :<strong>{{$otp}}</strong></p><p>Please ensure that you do not share this OTP with anyone. It is valid for a single use and should be entered within 2 minutes of receiving this email.</p><p>&nbsp;</p><p>LeanInworld</p><p>+447709787925</p>', NULL, '2024-04-21 20:36:15'),
(3, 'Admin Contact Us', '<p>Dear <strong>{{$name}}</strong>,</p><p>Thank you for contacting us. We appreciate your inquiry and will do our best to assist you. Your query has been received, and here is a response to your questions and concerns:</p><p><strong>{{$title}}</strong></p><p><strong>{{$body}}</strong></p><p>If you require further assistance or have additional questions, please do not hesitate to contact us again. We are here to help.</p><p>Thank you for choosing Lean In World needs. We value your business and look forward to serving you.</p><p><br><br>&nbsp;</p><p>LeanInworld</p><p>+447709787925</p>', NULL, '2024-04-21 20:37:40'),
(4, 'Request Document', '<p>Hi,</p><p>We kindly <strong>request you</strong> to provide the required English level certificate .</p><p><strong>Thank you!</strong></p><p>&nbsp;</p><p>&nbsp;</p><p><strong>Leaninworld</strong></p><p><strong>1234567890</strong></p>', NULL, '2023-12-19 11:28:35'),
(5, 'Successful Registration: Welcome to Lean In!', '<p>Dear <strong>{{$first_name}} {{$last_name}}</strong>,</p><p>We are delighted to inform you that your registration with lean In World has been successfully completed! Welcome to our community.</p><p>Here are the details of your registration:</p><p>Thank you for choosing to be a part of our platform. With your new account, you can now enjoy all the benefits and features we have to offers</p><p>To get started, simply sign in with your username and password. If you have any questions or need assistance, please do not hesitate to contact.</p><p>We take your privacy seriously, and your information is secure with us. You can review our privacy policy for more details.</p><p>Once again, thank you for joining us. We look forward to providing you with a fantastic experience.</p><p><br>&nbsp;</p><p>Warm regards,<br>&nbsp;Lean In World&nbsp;</p><p>&nbsp;</p>', NULL, '2024-04-21 20:45:14'),
(6, 'User Contact', '<p>Dear <strong>{{$name}}</strong>,</p><p>Thank you for reaching out to our company. We appreciate your interest and would be delighted to assist you with your inquiry/request.</p><p>We understand that you are seeking assistance from us. To better understand your requirements and provide you with tailored solutions, we would like to schedule a call or meeting. Please let us know your availability and preferred mode of communication , phone call, video conference. We will make the necessary arrangements accordingly, or you could drop us a mail to info@leaninworld.com.</p><p>Alternatively, if you have any specific questions or would like to provide further details prior to the meeting, please feel free to share them with us. We are here to assist you every step of the way.</p><p>Thank you once again for considering our programs. We look forward to connecting with you soon .</p><p><br>&nbsp;</p><p>Warm regards,</p><p>Leaninworld</p>', NULL, '2024-04-21 20:45:36'),
(7, 'New Enquiry to Admin Notification', '<p>Hello Admin,</p><p>You have received a new contact on your website. Here are the details:</p><p><strong>Name:</strong> {{$name}}</p><p><strong>Email:</strong> {{$email}}</p><p><strong>Subject:</strong> {{$title}}</p><p><strong>Message:</strong> {{$message}}</p><p>Please take appropriate action and respond to the contact as soon as possible.</p><p><br><br>&nbsp;</p><p>Best regards,</p><p>Your Website Team</p>', NULL, '2023-11-07 07:19:50'),
(8, 'Newsletter', '<p>We are excited to inform you about our upcoming program and the latest content that we have prepared just for you!</p><p><strong>Program Name</strong>: {{$program_title}}</p><p><strong>Program Start Dates</strong>: {{$start_date}}</p><p>You don\'t want to miss this. Get ready for an exciting journey with us!</p><p>Stay tuned for more updates. We will be sending you the latest newsletter soon.<br><br><br>Warm regards,</p><p>LeanInworld</p><p>+447709787925</p>', NULL, '2024-04-21 20:46:26'),
(9, 'Password Reset', '<p>Dear,</p><p>We received a request to reset the password for your account at Lean In world. To complete the password reset process, please follow the instructions below:</p><p>1. Click on the following link to reset your password: <a href=\"https://leaninworld.com/password_reset/{{$token}}\">https://leaninworld.com/password_reset/{{$token}}</a></p><p><strong>Important:</strong> This password reset link is valid for 5 Minutes from the time of this email. After that, you will need to submit another password reset request.</p><p>If you did not request a password reset or believe this email was sent to you in error, please disregard it. Your account\'s security is important to us.</p><p>If you have any questions or encounter any issues, please contact</p><p>&nbsp;</p><p>Thank you for using Lean In world.</p><p>&nbsp;</p><p>LeanInworld</p><p>+447709787925</p>', NULL, '2024-05-29 18:16:15');

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

--
-- Table structure for table `manage_admins`
--

CREATE TABLE `manage_admins` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pin` int DEFAULT NULL,
  `is_admin` int NOT NULL DEFAULT '0' COMMENT '0: admin, 1: sub_admin',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '0: inactive, 1: active',
  `otp` int DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `expire_at` timestamp NULL DEFAULT NULL,
  `deleted_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 `manage_admins`
--

INSERT INTO `manage_admins` (`id`, `name`, `email`, `password`, `pin`, `is_admin`, `status`, `otp`, `last_login`, `expire_at`, `deleted_at`, `created_at`, `updated_at`) VALUES
(4, 'Megha Malore', 'megha@wdimails.com', '$2y$10$WjUZMfwWq618qYNrXp.RXOAX4EVQana6yTc6nVzX9pH0/UvbUUWHm', 1234, 0, 1, 2326, '2024-07-08 05:41:45', '2024-07-08 11:12:47', NULL, NULL, '2024-07-08 05:41:45'),
(8, 'Aimee Zaho', 'digempty@gmail.com', '$2y$10$YIrcOiXodSXMs8eZPBS9/ejWSwF9RVETrBpHJsL6i47vAaKtPUAcu', 1234, 0, 1, 1489, '2024-06-17 22:01:33', '2024-06-18 03:33:18', NULL, '2023-09-29 13:47:47', '2024-06-17 22:01:33'),
(19, 'Priyanka Joshi', 'priyanka.joshi@wdipl.com', '$2y$10$mOrpSXMPe2rfKfSrN2cUReBaoBsC1n9yNqzY1h7iThUp6Dc29V3DG', 1234, 1, 1, 3539, '2024-02-21 05:43:35', '2024-02-21 11:15:02', '2024-02-29 11:45:49', '2024-02-21 05:39:54', '2024-02-29 11:45:49'),
(24, 'Aimee Zhao', 'digempty@gmail.com', '$2y$10$5dChdiidftY6PjBk8yaQj.QyR.2NQFEfPfWPgEVzChaxrfWwb.3Nm', 1234, 1, 1, NULL, NULL, NULL, NULL, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(25, 'Lorry', 'aimeezhao@mail.com', '$2y$10$Nd9sAJKbiL1v8gtq5k0FKuAkPEeTjishP.l5dxlOFQthlQCkAnnFm', 1234, 1, 1, 8581, '2024-06-06 18:16:50', '2024-06-06 23:48:34', '2024-06-10 16:36:05', '2024-06-06 18:15:59', '2024-06-10 16:36:05');

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

--
-- Table structure for table `manage_admin_manage_module_links`
--

CREATE TABLE `manage_admin_manage_module_links` (
  `id` bigint UNSIGNED NOT NULL,
  `sub_admin_xid` bigint UNSIGNED NOT NULL,
  `manage_modules_xid` 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;

--
-- Dumping data for table `manage_admin_manage_module_links`
--

INSERT INTO `manage_admin_manage_module_links` (`id`, `sub_admin_xid`, `manage_modules_xid`, `created_at`, `updated_at`) VALUES
(243, 8, 1, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(244, 8, 4, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(245, 8, 5, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(246, 8, 12, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(247, 8, 13, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(248, 8, 14, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(249, 8, 48, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(250, 8, 49, '2023-10-21 12:03:51', '2023-10-21 12:03:51'),
(287, 19, 1, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(288, 19, 4, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(289, 19, 5, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(290, 19, 12, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(291, 19, 13, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(292, 19, 14, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(293, 19, 48, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(294, 19, 49, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(295, 19, 52, '2024-02-21 05:39:54', '2024-02-21 05:39:54'),
(450, 24, 1, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(451, 24, 4, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(452, 24, 5, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(453, 24, 12, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(454, 24, 13, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(455, 24, 14, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(456, 24, 48, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(457, 24, 49, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(458, 24, 52, '2024-06-03 14:09:54', '2024-06-03 14:09:54'),
(459, 25, 1, '2024-06-06 18:15:59', '2024-06-06 18:15:59'),
(460, 25, 4, '2024-06-06 18:15:59', '2024-06-06 18:15:59'),
(461, 25, 5, '2024-06-06 18:15:59', '2024-06-06 18:15:59'),
(462, 25, 12, '2024-06-06 18:15:59', '2024-06-06 18:15:59'),
(463, 25, 13, '2024-06-06 18:15:59', '2024-06-06 18:15:59');

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

--
-- Table structure for table `manage_home_videos`
--

CREATE TABLE `manage_home_videos` (
  `id` bigint UNSIGNED NOT NULL,
  `video_url` varchar(255) CHARACTER SET utf8mb4 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 `manage_home_videos`
--

INSERT INTO `manage_home_videos` (`id`, `video_url`, `created_at`, `updated_at`) VALUES
(1, 'assets/uploads/home_video/202407080556_65560-515098344_small(1).mp4', NULL, '2024-07-08 05:56:26');

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

--
-- Table structure for table `manage_modules`
--

CREATE TABLE `manage_modules` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 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 `manage_modules`
--

INSERT INTO `manage_modules` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Manage Programs', 'manage-programs', '2023-08-14 11:24:12', '2023-09-06 13:04:20'),
(4, 'Manage Countries / Destinations', 'manage-countries-destinations', '2023-08-14 11:35:02', '2023-08-14 11:35:02'),
(5, 'Manage Payments', 'manage-payments', '2023-08-16 06:47:04', '2023-10-13 10:28:47'),
(12, 'Manage Website Contact Us', 'manage-website-contact-us', '2023-08-16 06:48:21', '2023-08-16 06:48:21'),
(13, 'Manage Module', 'manage-module', '2023-08-16 06:48:51', '2023-08-16 06:48:51'),
(14, 'Manage CMS - Website Content', 'manage-cms-website-content', '2023-08-16 06:49:25', '2023-08-16 06:49:25'),
(48, 'User Ratings', 'user-ratings', '2023-10-13 10:55:56', '2023-10-13 10:55:56'),
(49, 'News Letter Users', 'news-letter-users', '2023-10-13 10:56:30', '2023-10-13 10:56:30'),
(52, 'Manage Template', 'manage-template', '2023-11-23 08:28:00', '2023-11-23 08:28:00');

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

--
-- Table structure for table `message_boards`
--

CREATE TABLE `message_boards` (
  `id` bigint UNSIGNED NOT NULL,
  `programs_xid` bigint UNSIGNED NOT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_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 `message_boards`
--

INSERT INTO `message_boards` (`id`, `programs_xid`, `message`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 2, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vestibulum placerat felis, eu fermentum turpis dapibus at. Nullam sed lorem massa. Aliquam erat volutpat. In ultrices dolor vel justo feugiat, non euismod velit finibus. Phasellus eleifend fringilla turpis, nec pulvinar elit congue vel. Mauris eleifend ligula non libero fringilla dictum. Vestibulum elementum posuere mi, vitae molestie lectus. Duis eu enim sem. Etiam vel erat quis erat malesuada congue. Nullam ac risus quis lectus consectetur interdum. Sed at scelerisque lacus, ut ullamcorper orci. Integer vestibulum, neque eu vestibulum congue, libero arcu aliquet ex, eu finibus justo dui at dolor. Proin iaculis varius est, ac interdum ipsum consectetur at.\"\r\n\r\nThis text is commonly used as a placeholder or filler text in design and typesetting industries. It does not have any specific meaning and is used to demonstrate the visual effects of different fonts, layouts, and designs without being distracted by the actual content', NULL, '2023-06-17 19:48:02', '2023-06-22 10:43:40');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 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
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_06_01_143313_create_privacy_policies_table', 1),
(6, '2023_06_02_090937_create_faq_categories_table', 2),
(7, '2023_06_02_094408_create_blog_categories_table', 3),
(8, '2023_06_02_143805_create_blogs_table', 4),
(24, '2023_06_12_183239_create_program_images_table', 15),
(26, '2023_06_13_134228_create_states_table', 17),
(30, '2023_06_17_183247_create_message_boards_table', 20),
(33, '2023_06_13_134322_create_cities_table', 23),
(36, '2023_06_03_174718_create_faqs_table', 26),
(44, '2023_06_27_103211_create_testimonials_table', 30),
(46, '2023_06_12_183212_create_program_currency_amounts_table', 32),
(53, '2023_06_12_064453_create_programs_table', 36),
(56, '2023_07_13_070118_create_iam_principal_principal_group_links_table', 39),
(57, '2023_06_13_134130_create_countries_table', 40),
(58, '2023_07_16_150733_create_program_accomadations_table', 41),
(64, '2023_07_24_140054_create_volunteer_profile_documents_table', 46),
(68, '2014_10_12_000000_create_users_table', 48),
(72, '2023_07_24_135954_create_payment_transaction_masters_table', 50),
(73, '2023_08_14_081419_create_manage_modules_table', 51),
(76, '2023_08_03_183719_create_manage_admins_table', 52),
(79, '2023_08_23_063742_add_trip_brochure_programs_table', 54),
(80, '2014_10_12_100000_create_password_reset_tokens_table', 55),
(83, '2023_09_26_064039_add_column_to_payment_transaction_masters', 57),
(84, '2023_08_22_131553_create_news_letters_table', 58),
(86, '2023_09_11_071715_create_user_ratings_table', 59),
(88, '2023_11_03_060648_create_mail_templates_table', 61),
(90, '2023_07_13_070332_create_iam_principal_groups_table', 63),
(91, '2023_11_23_100614_add_new_column_to_programs_table', 64),
(93, '2023_12_02_180825_add_new_column_to_max_volunteer_week_chag_leavel', 65),
(94, '2023_06_20_070120_create_contact_us_table', 66),
(95, '2024_04_15_074157_create_manage_home_videos_table', 67),
(97, '2024_05_21_073456_create_terms_condtions_table', 68);

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

--
-- Table structure for table `news_letters`
--

CREATE TABLE `news_letters` (
  `id` bigint UNSIGNED NOT NULL,
  `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_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 `news_letters`
--

INSERT INTO `news_letters` (`id`, `first_name`, `email`, `deleted_at`, `created_at`, `updated_at`) VALUES
(91, 'Megha', 'megha@wdimails.com', NULL, '2024-06-04 13:50:56', '2024-06-04 13:50:56'),
(92, 'run testing', 'digempty@gmail.com', NULL, '2024-06-06 18:14:53', '2024-06-06 18:14:53');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--

INSERT INTO `password_reset_tokens` (`email`, `token`, `expires_at`, `created_at`) VALUES
('digempty@gmail.com', 'XnNy0WxSPSTRG5kyTNQU21gwqA4hnv2ytLUQCceB4qrHkhRJ2iT8I68HLbcGVkDu', '2024-02-14 07:19:20', '2024-02-14 07:14:20'),
('durga.jaiswar@wdimails.com', 'xUFxXNwl1NgDLCUHLE5pl6kpobLxMj4Qr6IdaShSG3qNShqfGjx2nMCTRfRxc6B1', '2023-10-17 07:12:03', '2023-10-17 07:07:03'),
('durga@gmail.com', 'tgtZvEcoYMrReQdCdQiMLEnDmXDs01bQJX07xfszcL7Jda04SWJlGXpcIYsskCxl', '2023-09-25 08:22:53', '2023-09-25 08:17:53'),
('ganesh@gmail.com', 'qkUPQIwZGqzcdDhlNixHVRwBlDWZ74U4zEAlbEv0tb9xHQBoEDaPz3jIAymFZ47a', '2023-09-25 12:16:38', '2023-09-25 12:11:38'),
('gawaderavindra70@gmail.com', 'PkBz1qBkcXdtbDRFny9tvhQ7qd8kOFXsj7gT1lWtd8vLALyHEeFDHiaYkeqHuIlD', '2023-09-18 07:10:19', '2023-09-18 07:05:19'),
('gawaderavindra91@gmail.com', '2Yb4tCIiVjpTtIsDeceezpY525C2Mzthtel8IUuU5mrxhcMKp5c5jknvEazzdspz', '2023-09-18 07:11:32', '2023-09-18 07:06:32'),
('r@gmail.com', 'aFIjpUvD3w4CKT6Cuv3LS6Psd0Dhd1xXWMxZDCG0Hy5rdp98Mvg3bXf0DpAN6pjO', '2023-09-25 09:51:24', '2023-09-25 09:46:24'),
('sneha@wdimails.com', 'U4ZUrzfGKj9N6lD86ZjQW3j7DmozbZJbcinAvLkI5VG7IY5xhDnwipFY2PqGgm9X', '2023-09-29 10:42:58', '2023-09-29 10:37:58');

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

--
-- Table structure for table `payment_transaction_masters`
--

CREATE TABLE `payment_transaction_masters` (
  `id` bigint UNSIGNED NOT NULL,
  `programs_xid` bigint UNSIGNED DEFAULT NULL,
  `principal_xid` bigint UNSIGNED NOT NULL,
  `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` enum('1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 = registration_payment, 2 = program_payment',
  `currency` enum('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 = usd, 2 = pound,3 = euro',
  `duration` int DEFAULT NULL,
  `amount` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `privacy_policies`
--

CREATE TABLE `privacy_policies` (
  `id` bigint UNSIGNED NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `deleted_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 `privacy_policies`
--

INSERT INTO `privacy_policies` (`id`, `description`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '<p>This privacy policy explains how Lean In World uses and protects any information you provide when using this website.</p><p>Lean In World is committed to ensuring your privacy is protected. If we ask you to provide certain information by which you can be identified when using this website, you can be assured that it will only be used in accordance with this privacy statement. Lean In World may update this policy periodically by updating this page, so please check this page frequently to ensure you are happy with any changes.</p><h3><strong>Information We Collect</strong></h3><p>We may collect the following information:</p><ul><li>Name</li><li>Contact information, including email address and telephone number .</li><li>Your postcode and interests</li><li>Travel preferences</li><li>Special needs, disabilities, and dietary requirements.</li></ul><p><strong>Collection Methods</strong></p><p>Information is collected during requests for information and general communication through telephone, internet.</p><h4><strong>How We Use the Information</strong></h4><p>We require this information to understand your needs and provide you with a better service, specifically for the following reasons:</p><ul><li>Internal record keeping</li><li>Improving our products and services</li><li>Periodically sending promotional emails about new products, special offers, or other information we think you may find interesting using the email address you have provided</li><li>Occasionally contacting you for market research purposes via email, phone, fax, or mail</li><li>Disclosing your information to our partner organizations and suppliers, which may be outside the UK/EEA, due to the nature of our business</li></ul><p><strong>Security</strong></p><p>We are committed to ensuring your information is secure. To prevent unauthorized access or disclosure, we have implemented suitable physical, electronic, and managerial procedures to safeguard and secure the information we collect online.</p><h3><strong>Controlling Your Personal Information</strong></h3><p>You may choose to restrict the collection or use of your personal information in the following ways:</p><ul><li>If you have previously agreed to us using your personal information for direct marketing purposes, you may change your mind at any time by writing to or emailing us at info@leaninworld.com</li></ul><p>We never sell, distribute, or lease your personal information to third parties unless we have your permission or are required by law to do so. We may use your personal information to send you promotional information about third parties which we think you may find interesting if you tell us that you wish this to happen.</p><p>You may request details of personal information which we hold about you under the Data Protection Act 1998. A small fee will be payable. If you would like a copy of the information held on you, please request it from info@leaninworld.com.</p><p>If you believe that any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible. We will promptly correct any information found to be incorrect.</p><h3><strong>General Data Protection Regulation (GDPR)</strong></h3><p>You may request details of personal information which we hold about you under the GDPR. If you would like a copy of the information held on you, please request it from info@leaninworld.com.</p><p>Your rights under the GDPR include:</p><ul><li>The right to be informed</li><li>The right of access</li><li>The right to rectification</li><li>The right to erasure</li><li>The right to restrict processing</li><li>The right to data portability</li><li>The right to object</li><li>Rights in relation to automated decision-making and profiling</li></ul><p>For further information about data protection, you can visit the Information Commissioner’s Office (ICO) at ico.org.uk. The ICO is the UK’s independent authority set up to uphold information rights in the public interest and data privacy for individuals. We comply with all ICO regulatory and statutory requirements. You have the right to make a complaint to the ICO regarding the handling of your data.</p><p>If you believe that any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible. We will promptly correct any information found to be incorrect.</p><p> </p>', '0', NULL, '2023-06-01 12:37:56', '2024-06-03 14:16:14');

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

--
-- Table structure for table `programs`
--

CREATE TABLE `programs` (
  `id` bigint UNSIGNED NOT NULL,
  `program_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `volunteer_weeks` int NOT NULL,
  `volunteer_weeks_max` int NOT NULL,
  `challenge_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `trip_brochure` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age_rules` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_xid` bigint UNSIGNED NOT NULL,
  `program_title_two` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `charges_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_notice` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_gain` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `safety_instructions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT '1 = Active, 0 = Inactive',
  `deleted_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 `programs`
--

INSERT INTO `programs` (`id`, `program_title`, `start_date`, `end_date`, `volunteer_weeks`, `volunteer_weeks_max`, `challenge_level`, `thumbnail`, `trip_brochure`, `age_rules`, `country_xid`, `program_title_two`, `description`, `location_info`, `charges_details`, `payment_notice`, `project_information`, `personal_gain`, `safety_instructions`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(3, 'Environmental Protection Project', '\"2023-07-09\"', '2023-07-23 00:00:00', 2, 0, 'Hard', 'assets/uploads/program_images/thumbnail/202309081357_tailand-img.png', NULL, '28', 2, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'In addition, the convertible credits earned by online schools', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 0, NULL, '2023-07-14 10:24:58', '2024-03-19 08:23:36'),
(9, 'Labore quis voluptas', '1975-02-01', '1991-11-10 00:00:00', 4, 0, '', 'assets/uploads/program_images/thumbnail/202309081357_tailand-img.png', NULL, '28', 9, 'Veritatis consectetu', '<p>New Zealand Auckland Environmental Protection Project New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Perspiciatis necess', '<p>Quaerat duis in maxi</p>', '<p>Do quos aut laborum</p>', '<p>Qui aute cum error f</p>', '<p>Enim debitis alias qAut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecte</p>', '<p>Aut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecteAut dolores consecte</p>', 0, NULL, '2023-07-16 17:06:00', '2023-10-15 14:56:04'),
(10, 'New Zealand Auckland Environmental Protection Project1', '2023-07-02', '2023-07-16 00:00:00', 3, 0, '', 'assets/uploads/program_images/thumbnail/202308291456_mutualfund2.jpg', NULL, '22', 2, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>New Zealand Auckland Environmental Protection Project New Zealand Auckland Environmental Protection Project New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 0, NULL, '2023-07-16 17:15:38', '2023-10-18 08:07:30'),
(14, 'New Zealand Auckland Environmental Protection Project', '2023-08-02', '2023-08-09 00:00:00', 1, 0, '', 'assets/uploads/program_images/thumbnail/202309081357_tailand-img.png', NULL, '28', 3, 'New Zealand Auckland Environmental Protection Project', '<p>Lorem&nbsp; ipsum lorem ipsum</p>', 'ying abroad and those who want to graduate early to find a job.', '<p>Lorem ipsum</p>', '<p>lorem ipsum for textis</p>', '<p>lorem isphjghfghj</p>', '<p>dnfdjfnsmjks fjdjfkdslf jnkdsfkd.</p>', '<p>fsdfn,dsnfd.fm fndslkfd.kf</p>', 0, NULL, '2023-08-01 00:27:45', '2023-10-15 14:56:04'),
(21, 'UK G5 universities 2023 spring/summer online study', '2023-08-20', '2023-09-17 00:00:00', 5, 0, '', 'assets/uploads/program_images/thumbnail/202308290641_pro-img1.png', 'assets/uploads/program_images/program_brochure/202308290641_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 2, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 0, NULL, '2023-08-29 06:41:26', '2023-10-15 14:56:04'),
(22, 'New Zealand Auckland Environmental Protection Project', '2023-08-06', '2023-08-20 00:00:00', 3, 0, '', 'assets/uploads/program_images/thumbnail/202308290654_uk-img.png', 'assets/uploads/program_images/program_brochure/202308290654_202308230808_Get_Started_With_Smallpdf(1).pdf', '28', 4, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection Project&nbsp;New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>New Zealand Auckland Environmental Protection Project&nbsp;New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection Project&nbsp;New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection Project&nbsp;New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection Project&nbsp;New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection Project&nbsp;New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 0, NULL, '2023-08-29 06:54:05', '2023-10-15 14:56:04'),
(23, 'UK G5 universities 2023 spring/summer online study', '2023-08-06', '2023-08-27 00:00:00', 4, 0, '', 'assets/uploads/program_images/thumbnail/202308290725_nepal-img.png', 'assets/uploads/program_images/program_brochure/202308290705_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 9, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 0, NULL, '2023-08-29 07:05:10', '2023-10-15 14:56:04'),
(24, 'UK G5 universities 2023 spring/summer online study1', '2023-09-03', '2023-09-17 00:00:00', 3, 0, '', 'assets/uploads/program_images/thumbnail/202309040939_1_S81O15rjKfG-BFdnNC6-GQ.jpg', 'assets/uploads/program_images/program_brochure/202309040939_206-2064011_download-pdf-icon-svg-clipart-png-download-pdf.png', '28', 3, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided</p>', '<p>Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided</p>', '<p>Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided</p>', '<p>Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided</p>', '<p>Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided</p>', 0, NULL, '2023-09-04 09:39:22', '2023-10-18 08:04:30'),
(26, 'Spain Volunteers Program', '2023-10-01', '2023-10-29 00:00:00', 4, 0, '', 'assets/uploads/program_images/thumbnail/202309211205_volunteer-abroad-in-spain-ivhq-barcelona-youth-support.jpg', 'assets/uploads/program_images/program_brochure/202309211205_invoice(20).pdf', '28', 13, 'Make a Difference in Beautiful Spain', '<p>Are you ready for a life-changing experience in the heart of Spain? The Spain Volunteers Program offers you the opportunity to immerse yourself in Spanish culture, contribute to meaningful projects, and create lasting memories.</p>', 'Explore Spain\'s enchanting cities, picturesque villages, and stunning landscapes.', '<p>Choose from a variety of volunteer projects, including environmental conservation, community development, education, and more.</p>', '<p>Choose from a variety of volunteer projects, including environmental conservation, community development, education, and more.</p>', '<p>Choose from a variety of volunteer projects, including environmental conservation, community development, education, and more.</p>', '<p>Choose from a variety of volunteer projects, including environmental conservation, community development, education, and more.</p>', '<p>Choose from a variety of volunteer projects, including environmental conservation, community development, education, and more.</p>', 0, NULL, '2023-09-21 12:05:39', '2023-10-30 06:18:50'),
(27, 'Community Engagement and Cultural Exchange.', '2023-11-05', '2023-11-25 00:00:00', 3, 0, '', 'assets/uploads/program_images/thumbnail/202309241831_volunteer-2048x1233.jpg', 'assets/uploads/program_images/program_brochure/202309241831_202308230808_Get_Started_With_Smallpdf(1).pdf', '22', 13, 'The best way to find yourself is to lose yourself in the service of others.', '<p>Are you passionate about making a positive impact while immersing yourself in the vibrant culture of Spain? Join our Volunteer in Spain program and embark on a rewarding journey to contribute to the local community while experiencing the rich traditions, delicious cuisine, and warm hospitality of Spain.</p>', 'Madrid, Spain', '<p>Spain is known for its passionate culture and diverse heritage. During your stay, you&#39;ll have the chance to learn Spanish, partake in cooking classes to master paella and tapas, and discover the art of flamenco dancing. Weekend excursions to historical landmarks and picturesque landscapes will enrich your experience</p>', '<p>Spain is known for its passionate culture and diverse heritage. During your stay, you&#39;ll have the chance to learn Spanish, partake in cooking classes to master paella and tapas, and discover the art of flamenco dancing. Weekend excursions to historical landmarks and picturesque landscapes will enrich your experience</p>', '<p>Spain is known for its passionate culture and diverse heritage. During your stay, you&#39;ll have the chance to learn Spanish, partake in cooking classes to master paella and tapas, and discover the art of flamenco dancing. Weekend excursions to historical landmarks and picturesque landscapes will enrich your experience</p>\r\n\r\n<ul>\r\n	<li>Enthusiasm for volunteering and cultural exchange.</li>\r\n	<li>Basic proficiency in English or Spanish (depending on the project).</li>\r\n	<li>Openness to new experiences and a desire to make a positive impact.</li>\r\n</ul>', '<p>Spain is known for its passionate culture and diverse heritage. During your stay, you&#39;ll have the chance to learn Spanish, partake in cooking classes to master paella and tapas, and discover the art of flamenco dancing. Weekend excursions to historical landmarks and picturesque landscapes will enrich your experience</p>\r\n\r\n<ul>\r\n	<li>Enthusiasm for volunteering and cultural exchange.</li>\r\n	<li>Basic proficiency in English or Spanish (depending on the project).</li>\r\n</ul>\r\n\r\n<ol>\r\n	<li><em>Openness to new experiences and a desire to make a positive impact.<br />\r\n	and picturesque landscapes will enrich your experience</em></li>\r\n	<li>Openness to new experiences and a desire to make a positive impact.<br />\r\n	and picturesque landscapes will enrich your experience</li>\r\n</ol>', '<h2><strong>Spain is known for its passionate</strong></h2>\r\n\r\n<p><strong>Spain is known for its passionate</strong><br />\r\n<br />\r\nSpain is known for its passionate culture and diverse heritage. During your stay, you&#39;ll have the chance to learn Spanish, partake in cooking classes to master paella and tapas, and discover the art of flamenco dancing. Weekend excursions to historical landmarks and picturesque landscapes will enrich your experience</p>\r\n\r\n<ul>\r\n	<li>Enthusiasm for volunteering and cultural exchange.</li>\r\n	<li>Basic proficiency in English or Spanish (depending on the project).</li>\r\n	<li>Openness to new experiences and a desire to make a positive impact.</li>\r\n</ul>', 0, NULL, '2023-09-24 18:31:16', '2024-02-15 03:59:27'),
(30, 'UK G5 universities 2023 spring/summer online study', '2023-10-08', '2023-10-30 00:00:00', 4, 0, '', 'assets/uploads/program_images/thumbnail/202310150941_th(13).jpg', 'assets/uploads/program_images/program_brochure/202310150941_202308230808_Get_Started_With_Smallpdf(1).pdf', '21', 16, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 0, NULL, '2023-10-15 09:41:04', '2023-10-30 06:18:50'),
(31, 'America program', '2023-11-05', '2023-11-25 00:00:00', 3, 0, '', 'assets/uploads/program_images/thumbnail/202310150948_volunteering-in-a-foreign-country1.webp', NULL, '20', 16, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 0, NULL, '2023-10-15 09:48:41', '2024-02-15 03:59:27'),
(32, 'UK G5 universities 2023 spring/summer online study', '2023-11-12', '2023-11-25 00:00:00', 2, 0, '', 'assets/uploads/program_images/thumbnail/202310151006_pexels-edgar-colomba-2240293.jpg', 'assets/uploads/program_images/program_brochure/202310191001_Get_Started_With_Smallpdf(1).pdf', '22', 16, 'New Zealand Auckland Environmental Protection Project', '<p>&nbsp;</p><p>Volunteering in America offers a wide range of opportunities to contribute to your community and make a positive impact. The specific volunteer descriptions can vary greatly depending on the organization, cause, and location. However, I can provide a general overview of what volunteering in America might involve</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>&nbsp;</p><p>Volunteering in America offers a wide range of opportunities to contribute to your community and make a positive impact. The specific volunteer descriptions can vary greatly depending on the organization, cause, and location. However, I can provide a general overview of what volunteering in America might involve</p>', '<p>Volunteering in America offers a wide range of opportunities to contribute to your community and make a positive impact. The specific volunteer descriptions can vary greatly depending on the organization, cause, and location. However, I can provide a general overview of what volunteering in America might involve</p>', '<p>Volunteering in America offers a wide range of opportunities to contribute to your community and make a positive impact. The specific volunteer descriptions can vary greatly depending on the organization, cause, and location. However, I can provide a general overview of what volunteering in America might involve</p>', '<p>Volunteering in America offers a wide range of opportunities to contribute to your community and make a positive impact. The specific volunteer descriptions can vary greatly depending on the organization, cause, and location. However, I can provide a general overview of what volunteering in America might involve</p>', '<p>Volunteering in America offers a wide range of opportunities to contribute to your community and make a positive impact. The specific volunteer descriptions can vary greatly depending on the organization, cause, and location. However, I can provide a general overview of what volunteering in America might involve</p>', 0, NULL, '2023-10-15 10:06:11', '2024-02-15 03:59:27'),
(34, 'UK G5 universities 2023 spring/summer online', '2023-11-12', '2023-11-18 00:00:00', 1, 0, '', 'assets/uploads/program_images/thumbnail/202310151447_1_S81O15rjKfG-BFdnNC6-GQ.jpg', 'assets/uploads/program_images/program_brochure/202310151447_202308230808_Get_Started_With_Smallpdf(1).pdf', '21', 15, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection ProjectNew Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>New Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection Project</p>', '<p>New Zealand Auckland Environmental Protection Project</p>', '<p><i>New Zealand Auckland Environmental Protection Project</i></p>', 0, NULL, '2023-10-15 14:47:44', '2024-02-15 03:59:27'),
(43, 'UK G5 universities 2023 spring/summer online study k', '\"2023-10-01\"', '2023-10-04 00:00:00', 1, 2, 'Hard', 'assets/uploads/program_images/thumbnail/202310180939_images(4).jfif', 'assets/uploads/program_images/program_brochure/202310181024_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 17, 'title two', '<p>Lorem ipsum\" is a Latin text commonly used as a placeholder in the printing and typesetting industry. It\'s used when the actual text is not yet available or is not the primary focus of a design or layout. It allows</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>Lorem ipsum\" is a Latin text commonly used as a placeholder in the printing and typesetting industry. It\'s used when the actual text is not yet available or is not the primary focus of a design or layout. It allows</p>', '<p>Lorem ipsum\" is a Latin text commonly used as a placeholder in the printing and typesetting industry. It\'s used when the actual text is not yet available or is not the primary focus of a design or layout. It allowsLorem ipsum\" is a Latin text commonly used as a placeholder in the printing and typesetting industry.&nbsp;</p>', '<p>Lorem ipsum\" is a Latin text commonly used as a placeholder in the printing and typesetting industry. It\'s used when the actual text is not yet available or is not the primary focus of a design or layout. It allows</p>', '<p>Lorem ipsum\" is a Latin text commonly used as a placeholder in the printing and typesetting industry. It\'s used when the actual text is not yet available or is not the primary focus of a design or layout. It allows</p>', '<p>Lorem ipsum\" is a Latin text commonly used as a placeholder in the printing and typesetting industry. It\'s used when the actual text is not yet available or is not the primary focus of a design or layout. It allows</p>', 0, NULL, '2023-10-18 09:39:28', '2023-12-21 07:14:04'),
(56, 'indias popularity kt', '\"2023-10-24\"', '2023-10-30 00:00:00', 1, 0, 'hard', 'assets/uploads/program_images/thumbnail/202310240703_1697349242_pexels-pixabay-220453.jpg', 'assets/uploads/program_images/program_brochure/202310240703_dummy.pdf', '30', 15, 'gfytytytyty', '<p>iuhgughuigeh</p>', 'fiueiuhfiehief', '<p>efkhiuhehuiuieuih</p>', '<p>iheughugsdbuv</p>', '<p>uhuiehufvgufeuyug</p>', '<p>iuhugeyvgyugefu</p>', '<p>hyufeyuyug</p>', 0, NULL, '2023-10-24 07:03:33', '2023-12-21 06:57:11'),
(58, 'testing', '2023-10-24', '2023-10-26 00:00:00', 1, 0, '', 'assets/uploads/program_images/thumbnail/202310241021_photo-1494790108377-be9c29b29330.jpg', 'assets/uploads/program_images/program_brochure/202310241021_sample.pdf', '30', 9, 'gfytytytyty', '<p>vdfiv hidhi</p>', 'vdfbd', '<p>fbdbdb</p>', '<p>bdfbdfbdf</p>', '<p>ddbdbdb</p>', '<p>dbdbdfbr</p>', '<p>berbfebvd</p>', 0, NULL, '2023-10-24 10:21:06', '2023-10-26 06:18:12'),
(69, 'America', '\"06-11-2023,07-11-2023,08-11-2023\"', NULL, 1, 3, 'Hard', 'assets/uploads/program_images/thumbnail/202311070943_volunteer-2048x1233.jpg', 'assets/uploads/program_images/program_brochure/202311070943_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 16, 'testing two', '<p>\"Lorem ipsum\" is a commonly used placeholder text in the printing and typesetting industry. It\'s often used to demonstrate the visual form of a document or text without using meaningful content</p>', 'In addition, the convertible.', '<p>\"Lorem ipsum\" is a commonly used placeholder text in the printing and typesetting industry. It\'s often used to demonstrate the visual form of a document or text without using meaningful content</p>', '<p>\"Lorem ipsum\" is a commonly used placeholder text in the printing and typesetting industry. It\'s often used to demonstrate the visual form of a document or text without using meaningful content</p>', '<p>\"Lorem ipsum\" is a commonly used placeholder text in the printing and typesetting industry. It\'s often used to demonstrate the visual form of a document or text without using meaningful content</p>', '<p>\"Lorem ipsum\" is a commonly used placeholder text in the printing and typesetting industry. It\'s often used to demonstrate the visual form of a document or text without using meaningful content</p>', '<p>\"Lorem ipsum\" is a commonly used placeholder text in the printing and typesetting industry. It\'s often used to demonstrate the visual form of a document or text without using meaningful content</p>', 0, NULL, '2023-11-07 09:43:50', '2024-05-03 10:55:19'),
(70, 'Discover España', '\"01-11-2023,17-11-2023,26-11-2023,10-12-2023,24-01-2024\"', NULL, 4, 0, '', 'assets/uploads/program_images/thumbnail/202311160638_maxresdefault.jpg', 'assets/uploads/program_images/program_brochure/202311160637_202308290705_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 13, 'New Zealand Auckland Environmental Protection Project', '<p>Welcome to Discover España, an immersive cultural experience that takes you on a journey through the vibrant and diverse landscapes of Spain. From the historic streets of Barcelona to the sun-soaked beaches of Costa del Sol,</p>', 'Barcelona - Marvel at the architectural wonders of Gaudí', '<p>Our carefully selected hotels are centrally located, allowing you to easily explore the surrounding areas. Each accommodation is equipped with modern amenities to ensure a pleasant and relaxing stay.</p>', '<p>Our carefully selected hotels are centrally located, allowing you to easily explore the surrounding areas. Each accommodation is equipped with modern amenities to ensure a pleasant and relaxing stay.</p>', '<p>Our carefully selected hotels are centrally located, allowing you to easily explore the surrounding areas. Each accommodation is equipped with modern amenities to ensure a pleasant and relaxing stay.</p>', '<p>Our carefully selected hotels are centrally located, allowing you to easily explore the surrounding areas. Each accommodation is equipped with modern amenities to ensure a pleasant and relaxing stay.</p>', '<p>Our carefully selected hotels are centrally located, allowing you to easily explore the surrounding areas. Each accommodation is equipped with modern amenities to ensure a pleasant and relaxing stay.</p>', 0, NULL, '2023-11-16 06:37:35', '2024-02-15 03:59:27'),
(86, 'program for Canadaaa', '[\"04-12-2023\"]', NULL, 3, 5, 'Comfortable', 'assets/uploads/program_images/thumbnail/202312200708_1629399.png', 'assets/uploads/program_images/program_brochure/202312200708_Bathroom-Renovations-Transforming-Your-Space-One-Tile-at-a-Time-1200x675(1).png', '25', 9, 'testing two', '<p>Description</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>charges details</p>', '<p>Progrma reqie</p>', '<p>Progrma reqie</p>', '<p>Progrma reqie</p>', '<p>Progrma reqie</p>', 0, NULL, '2023-12-20 07:08:59', '2024-02-15 03:59:27'),
(100, 'program for other countries', '[\"03-12-2023\"]', NULL, 3, 5, 'Comfortable', 'assets/uploads/program_images/thumbnail/202312201122_1_S81O15rjKfG-BFdnNC6-GQ.jpg', 'assets/uploads/program_images/program_brochure/202312201122_202308290705_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 2, 'testing two', '<p>discription</p>', 'Malad West', '<p>chages details</p>', '<p>Program requirement</p>', '<p>program schedule</p>', '<p>accodamatuin envirment</p>', '<p>roles respos</p>', 0, NULL, '2023-12-20 11:22:51', '2024-02-15 03:59:27'),
(104, 'program title for one', '\"03-12-2023,10-12-2023\"', NULL, 2, 4, 'Comfortable', 'assets/uploads/program_images/thumbnail/202312210722_Bathroom-Renovations-Transforming-Your-Space-One-Tile-at-a-Time-1200x675.png', 'assets/uploads/program_images/program_brochure/202312201211_202308290705_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 11, 'testing two', '<p>testing twotesting twotesting twotesting twotesting two</p>', 'malad west', '<p>testing twotesting twotesting twotesting twotesting two</p>', '<p>testing twotesting twotesting twotesting twotesting two</p>', '<p>testing twotesting twotesting twotesting twotesting two</p>', '<p>testing twotesting twotesting twotesting twotesting two</p>', '<p>testing twotesting twotesting twotesting twotesting two</p>', 0, NULL, '2023-12-20 12:11:45', '2024-04-09 10:51:55'),
(105, 'UK G5 universities 2023 spring/summer online study', '\"18-04-2024,19-04-2024\"', NULL, 3, 5, 'Comfortable', 'assets/uploads/program_images/thumbnail/202402201307_volunteer-abroad-in-spain-ivhq-barcelona-youth-support.jpg', 'assets/uploads/program_images/program_brochure/202402201307_202308290705_202308230808_Get_Started_With_Smallpdf(1).pdf', '25', 17, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection Project</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>No charges details</p>', '<p>Program requrement</p>', '<p>progrma schedule</p>', '<p>acco env</p>', '<p>Noes as a roles&nbsp;</p>', 0, NULL, '2024-02-20 13:07:48', '2024-05-03 10:55:14'),
(131, 'Canada Program', '\"22-02-2024,14-03-2024,19-04-2024,10-05-2024\"', NULL, 2, 5, 'Hard', 'assets/uploads/program_images/thumbnail/202403190617_328042274fc568e1e86734b6224d4818.jpg', 'assets/uploads/program_images/program_brochure/202403190617_《宅二三》采访提纲李友武.pdf', '40', 2, 'Canada Program Two', '<p>Canada Program discription</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>nod</p>', '<p>nod</p>', '<p>nod</p>', '<p>nod</p>', '<p>dno</p>', 0, NULL, '2024-02-21 07:19:51', '2024-05-03 10:55:13'),
(132, 'Namibia Wildlife Nursery', '\"09-06-2024,23-06-2024,14-07-2024,07-07-2024,21-07-2024,04-08-2024,11-08-2024,25-08-2024,18-08-2024,01-09-2024,08-09-2024,15-09-2024,22-09-2024,29-09-2024\"', NULL, 2, 8, 'Morderate', 'assets/uploads/program_images/thumbnail/202406051804_WX20240603-154644@.png', 'assets/uploads/program_images/program_brochure/202403191000_202308290705_202308230808_Get_Started_With_Smallpdf(1).pdf', '18', 24, 'Namibia Wildlife Nursery', '<p>No one can resist baby animals. The small animal conservation project in Namibia will give you more opportunities to interact with small animals. Your daily duties at the sanctuary involve creating nutritious meals for a diverse group of animals, especially small animals . This includes cutting meat and vegetables to meet specific dietary guidelines, ensuring each baby animals receives a meal tailored to its needs.</p><p>You might also participate in enclosure maintenance and feed magnificent carnivores such as cheetahs, lions, leopards, caracals, and African wild dogs.</p>', 'Windhoek', '<p>〓Cost Includes〓</p><ul><li>Welcome tour and training</li><li>Mandatory Volunteer Uniform</li><li>Accommodation including bed linen and towels</li><li>Breakfast, lunch, afternoon tea and dinner</li><li>Training and supervision by coordinators and team leaders</li><li>All activities In the project</li><li>Airport transfers and pre/post-program accommodation in Windhoek</li><li>Pick-up in Windhoek and transfer to project location and back to Windhoek.</li></ul><p>〓Cost Excludes〓</p><ul><li>Flights</li><li>Travel insurance</li><li>Pocket money</li><li>Drinks and other refreshments of your choice</li><li>Wi-Fi fee &nbsp;(£2.5/ $3 per week)</li></ul>', '<ul><li>Independent volunteers must be 18+.</li><li>A medium to high fitness level is needed.</li><li>Adequate volunteer travel insurance is required.</li><li>All volunteers must be fluent in English.</li><li>Vaccinations</li><li><strong>Recommended Vaccinations:</strong><ul><li>COVID-19 (double dose)</li><li>Hepatitis A</li><li>Tetanus</li><li>Typhoid</li><li>Polio</li><li>Rabies Malaria Prophylaxis: Our work area is &nbsp;malaria-free; but it\'s advisable for travel to northern Namibia or neighboring countries.</li></ul></li></ul>', '<ul><li>7:00</li><li>Pack backpacks and breakfast and go to the morning meeting.</li><li>8:00 – 8:30</li><li>Morning meeting, Group coordinators manage the day’s activities, e.g., animal walks, food prep,farm work, feeding tours, horse riding, etc.</li><li>After that, the volunteers start with the differentactivities: food preparations, the morning feeding tour, cleaning the enclosures, farm work, and animal walks.</li><li>13:00 : Lunch</li><li>15:00 : Afternoon meeting with refreshments.</li><li>15:00 –18:00</li><li>Preparations for the afternoon feeding tour, farm work and animal walks.</li><li>19:00: &nbsp;Dinner and time to socialize, free time.</li><li>20:00</li><li>Volunteers arrive for overnight stays with animals (If available)</li><li>Saturday:Morning volunteer activities, Saturday Afternoon Fun Activity, Traditional Braai Night</li><li>Sunday: Food prep and animal feeding, leisure time, animal<br>feeding</li></ul>', '<ul><li>Volunteers stay in the volunteer village, located about eight hundred meters from the farm buildings. The accommodation is a wooden cottage that you share with up to 3 other participants (same gender).</li><li>If you arrive with a boyfriend/girlfriend as a couple, we cannot guarantee that we will have accommodation available just for you. So, if the places are all taken, you may have separate accommodation.</li><li>Towels and bed linen provided; there are also a limited number of mosquito nets.</li><li>Laundry is done for you except for underwear and socks.</li></ul>', '<ul><li><strong>Willingness to Get Involved:</strong> Active participation and teamwork are essential.</li><li><strong>Sense of Responsibility:</strong> Demonstrates commitment and accountability.</li><li><strong>Passion for Animals:</strong> A deep love for animals and dedication to their well-being.</li><li><strong>Flexibility with Schedule:</strong> Ready to assist at night as needed due to working with wild animals.</li><li><strong>Serious Commitment:</strong> &nbsp;This program is not suitable for those seeking a \"party holiday.</li></ul>', 1, NULL, '2024-03-19 10:00:11', '2024-06-05 18:04:25'),
(133, 'Namibia Wildlife Care', '\"09-06-2024,23-06-2024,14-07-2024,07-07-2024,21-07-2024,04-08-2024,11-08-2024,25-08-2024,18-08-2024,01-09-2024,08-09-2024,15-09-2024,22-09-2024,29-09-2024\"', NULL, 2, 8, 'Morderate', 'assets/uploads/program_images/thumbnail/202404301600_20151127010716_86560.jpg', 'assets/uploads/program_images/program_brochure/202404301636_Don\'tStop(1).webp', '18', 24, 'Namibia Wildlife Care', '<p>Embark on an adventure reminiscent of \'The Lion King\' with this hands-on project. Are you ready to feed a hungry crowd? Your daily duties at the sanctuary involve creating nutritious meals for a diverse group of animals. This includes cutting meat and vegetables to meet specific dietary guidelines, ensuring each animal receives a meal tailored to its needs, this project more focus on meat preparation, Carnivore feeding, and enclosure cleaning.</p><p>You\'ll also participate in enclosure maintenance and feed magnificent carnivores such as cheetahs, lions, leopards, caracals, and African wild dogs.</p><p>&nbsp;</p><p>&nbsp;</p>', 'Windhoek', '<p>〓Cost Includes〓</p><ul><li>Welcome tour and training</li><li>Mandatory Volunteer Uniform</li><li>Accommodation including bed linen and towels</li><li>Breakfast, lunch, afternoon tea and dinner</li><li>Training and supervision by coordinators and team leaders</li><li>All activities In the project</li><li>Airport transfers and pre/post-program accommodation in Windhoek</li><li>Pick-up in Windhoek and transfer to project location and back to Windhoek.</li></ul><p>〓Cost Excludes〓</p><ul><li>Flights</li><li>Travel insurance</li><li>Pocket money</li><li>Drinks and other refreshments of your choice</li><li>Wi-Fi fee &nbsp;(£2.5/ $3 per week)</li></ul>', '<ul><li>Independent volunteers must be 18+.</li><li>A medium to high fitness level is needed.</li><li>Adequate volunteer travel insurance is required.</li><li>All volunteers must be fluent in English.</li><li>Vaccinations</li><li><strong>Recommended Vaccinations:</strong><ul><li>COVID-19 (double dose)</li><li>Hepatitis A</li><li>Tetanus</li><li>Typhoid</li><li>Polio</li><li>Rabies Malaria Prophylaxis: Our work area is &nbsp;malaria-free; but it\'s advisable for travel to northern Namibia or neighboring countries.</li></ul></li></ul>', '<ul><li>7:00</li><li>Pack backpacks and breakfast and go to the morning meeting.</li><li>8:00 – 8:30</li><li>Morning meeting, Group coordinators manage the day’s activities, e.g., animal walks, food prep,farm work, feeding tours, horse riding, etc.</li><li>After that, the volunteers start with the differentactivities: food preparations, the morning feeding tour, cleaning the enclosures, farm work, and animal walks.</li><li>13:00 : Lunch</li><li>15:00 : Afternoon meeting with refreshments.</li><li>15:00 –18:00</li><li>Preparations for the afternoon feeding tour, farm work and animal walks.</li><li>19:00: &nbsp;Dinner and time to socialize, free time.</li><li>20:00</li><li>Volunteers arrive for overnight stays with animals (If available)</li><li>Saturday:Morning volunteer activities, Saturday Afternoon Fun Activity, Traditional Braai Night</li><li>Sunday: Food prep and animal feeding, leisure time, animal<br>feeding</li></ul>', '<ul><li>Volunteers stay in the volunteer village, located about eight hundred meters from the farm buildings. The accommodation is a wooden cottage that you share with up to 3 other participants (same gender).</li><li>If you arrive with a boyfriend/girlfriend as a couple, we cannot guarantee that we will have accommodation available just for you. So, if the places are all taken, you may have separate accommodation.</li><li>Towels and bed linen provided; there are also a limited number of mosquito nets.</li><li>Laundry is done for you except for underwear and socks.</li></ul>', '<ul><li><strong>Willingness to Get Involved:</strong> Active participation and teamwork are essential.</li><li><strong>Sense of Responsibility:</strong> Demonstrates commitment and accountability.</li><li><strong>Passion for Animals:</strong> A deep love for animals and dedication to their well-being.</li><li><strong>Flexibility with Schedule:</strong> Ready to assist at night as needed due to working with wild animals.</li><li><strong>Serious Commitment:</strong> &nbsp;This program is not suitable for those seeking a \"party holiday.</li></ul>', 1, NULL, '2024-03-19 13:14:14', '2024-06-03 13:59:50');
INSERT INTO `programs` (`id`, `program_title`, `start_date`, `end_date`, `volunteer_weeks`, `volunteer_weeks_max`, `challenge_level`, `thumbnail`, `trip_brochure`, `age_rules`, `country_xid`, `program_title_two`, `description`, `location_info`, `charges_details`, `payment_notice`, `project_information`, `personal_gain`, `safety_instructions`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(135, 'Teaching in Ubud', '\"14-04-2024,28-04-2024,12-05-2024,26-05-2024,09-06-2024,23-06-2024,14-07-2024,28-07-2024,11-08-2024,25-08-2024,08-09-2024,22-09-2024\"', NULL, 1, 4, 'Easy', 'assets/uploads/program_images/thumbnail/202404261627_1694523219139.jpeg', NULL, '16', 2, 'Teaching in Ubud', '<p>Eager to volunteer as a teacher in Ubud, Bali? English is widely spoken here as a second language, largely driven by the thriving tourism industry. That\'s why there\'s a crucial need to teach English to children, helping them develop language skills essential for future careers in tourism.&nbsp;</p><p>Children are grouped into classes based on their English proficiency, giving volunteers the flexibility to choose classes that match their own English levels for teaching.</p><p>Join us in making a real impact in the lives of Balinese children while immersing yourself in the vibrant culture of Bali.&nbsp;</p>', 'A peaceful town near Ubud ,take 15 minites drive to Ubud, easily access to  sightseeings.', '<p>〓Cost Includes〓</p><ul><li>Airport pickup fee (from Denpasar International Airport)</li><li>Accommodation and meals</li><li>Full program and activity arrangement</li><li>Transportation expenses related to volunteer activities during the volunteer period</li></ul><p>〓Cost Excludes〓</p><ul><li>Passport and visa fees</li><li>Airport drop-off fee</li><li>Round-trip transportation expenses from the place of departure to the project location, flight etc.</li><li>Out-of-program transportation expenses and personal expenses such as shopping during activities</li></ul>', '<ul><li>If you\'re planning to volunteer in Bali for less than 30 days, you can get a visa on arrival when you arrive. If you need more time, you can extend it for another 30 days.</li><li>If you\'re under 16, you have to have a parent or guardian with you for the program. And if you\'re 16 or 17 when your program starts, you need parental consent to join. A consent form will be required by our team.</li><li>Travel insurance is mandatory.</li></ul>', '<ul><li>Sunday: Arrival at DPS Airport, where LeanIn staff will be responsible for airport pickup.</li><li>Monday: Morning teaching training session, introducing project details and arrangements. Volunteers will be grouped based on their English proficiency. The afternoon is free for volunteers to familiarize themselves with the base and surrounding area.</li><li>Tuesday: Morning visit to local schools for teaching support. Volunteers need to prepare teaching materials and can incorporate games, music, etc., for interactive sessions with children. The afternoon is free for leisure activities.</li><li>Wednesday: Morning continues with teaching support at local schools, fostering communication with children. The afternoon is free for leisure activities.</li><li>Thursday: Morning teaching session at the school, spending half a day with students. Afternoon is free for leisure activities, such as visiting rice terraces, swings, etc.</li><li>Friday: Half-day teaching session in the morning, followed by the presentation of NGO volunteer certificates. The afternoon is free for leisure activities, including visiting Monkey Forest, etc.</li><li>Saturday: Departure from the project site before noon, if joined for more than a week can continue to stay at the same volunteer house.</li></ul>', '<ul><li>2-3 people per room, with air conditioning, WiFi, and hot water.</li><li>Situated in a beautiful town surrounded by tropical rainforest, banana, coffee, and palm trees, volunteers begin their day in a beautiful natural environment with fresh air.</li><li>The volunteer program runs from every Sunday to the following Saturday.</li></ul>', '<ul><li>Support local teachers in daily tasks as a volunteer.</li><li>Develop daily lesson plans covering various subjects for children, including basic English, General Knowledge, Mathematics, Arts, and Crafts.</li><li>Engage children with stories to broaden their understanding of different places and share new information regularly.</li><li>Focus on creating an energetic and enjoyable learning environment for children to enhance their learning experience.</li><li>Demonstrate genuine care for the children, giving individual attention to each one and encouraging their progress.</li></ul><p>&nbsp;</p>', 1, NULL, '2024-04-26 16:27:14', '2024-06-06 15:43:24'),
(136, 'Testingg', '[\"10-06-2024,11-06-2024,12-06-2024\"]', NULL, 3, 8, 'Comfortable', 'assets/uploads/program_images/thumbnail/202406041345_69-1717420766.png', 'assets/uploads/program_images/program_brochure/202406041345_Get_Started_With_Smallpdf(2).pdf', '30', 2, 'Bali programe', '<p>Bali programe Description</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>Changes details</p>', '<p>program requrement</p>', '<p>Program Schedule</p>', '<p>Accomodation Environment</p>', '<p>Roles &amp; Responsibilities</p>', 0, '2024-06-04 13:51:54', '2024-06-04 13:45:19', '2024-06-04 13:51:54'),
(137, 'Testingg', '[\"10-06-2024,11-06-2024,12-06-2024\"]', NULL, 3, 8, 'Comfortable', 'assets/uploads/program_images/thumbnail/202406041345_69-1717420766.png', 'assets/uploads/program_images/program_brochure/202406041345_Get_Started_With_Smallpdf(2).pdf', '30', 2, 'Bali programe', '<p>Bali programe Description</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>Changes details</p>', '<p>program requrement</p>', '<p>Program Schedule</p>', '<p>Accomodation Environment</p>', '<p>Roles &amp; Responsibilities</p>', 0, '2024-06-04 13:51:37', '2024-06-04 13:45:53', '2024-06-04 13:51:37'),
(138, 'Testingg', '[\"10-06-2024,11-06-2024,12-06-2024\"]', NULL, 3, 8, 'Comfortable', 'assets/uploads/program_images/thumbnail/202406041347_69-1717420766.png', 'assets/uploads/program_images/program_brochure/202406041347_Get_Started_With_Smallpdf(2).pdf', '30', 2, 'Bali programe', '<p>Bali programe Description</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>Changes details</p>', '<p>program requrement</p>', '<p>Program Schedule</p>', '<p>Accomodation Environment</p>', '<p>Roles &amp; Responsibilities</p>', 0, '2024-06-04 13:51:22', '2024-06-04 13:47:40', '2024-06-04 13:51:22'),
(139, 'Testing', '\"02-06-2024,05-06-2024,18-06-2024\"', NULL, 3, 5, 'Comfortable', 'assets/uploads/program_images/thumbnail/202406051035_1_S81O15rjKfG-BFdnNC6-GQ.jpg', 'assets/uploads/program_images/program_brochure/202406041355_Get_Started_With_Smallpdf(2).pdf', '30', 24, 'Internet online teaching', '<p>Internet online teaching</p>', 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park. 3-4 people/room, shower, mosquito net, fan, WIFI, mobile phone, restaurant, rest area are all provided', '<p>Internet online teaching</p>', '<p>Internet online teaching</p>', '<p>Internet online teaching</p>', '<p>Internet online teaching</p>', '<p>Internet online teaching</p>', 1, '2024-06-06 15:31:07', '2024-06-04 13:55:19', '2024-06-06 15:31:07'),
(140, 'UK G5 universities 2023 spring/summer online study', '[\"10-06-2024,11-06-2024,12-06-2024\"]', NULL, 3, 4, 'Comfortable', 'assets/uploads/program_images/thumbnail/202406041402_3-1716966990.png', 'assets/uploads/program_images/program_brochure/202406041402_Get_Started_With_Smallpdf(2).pdf', '28', 24, 'New Zealand Auckland Environmental Protection Project', '<p>New Zealand Auckland Environmental Protection Project</p>', 'Amet aliquid maiore', '<p>Amet aliquid maiore</p>', '<p>Amet aliquid maiore</p>', '<p>Amet aliquid maiore</p>', '<p>Amet aliquid maiore</p>', '<p>Amet aliquid maiore</p>', 1, '2024-06-05 06:46:26', '2024-06-04 14:02:23', '2024-06-05 06:46:26'),
(141, 'Sit quas sit et ten', '[\"05-06-2024\"]', NULL, 5, 6, 'Irure est omnis labo', 'assets/uploads/program_images/thumbnail/202406050649_1_S81O15rjKfG-BFdnNC6-GQ.jpg', NULL, '23', 25, 'Sunt aliquip corpori', '<p>discription</p>', 'Voluptatum molestiae', '<p>test</p>', '<p>test</p>', '<p>test</p>', '<p>test</p>', '<p>test</p>', 1, '2024-06-05 06:49:57', '2024-06-05 06:49:32', '2024-06-05 06:49:57'),
(142, 'testing', '\"16-06-2024\"', NULL, 1, 3, 'tt', 'assets/uploads/program_images/thumbnail/202406061532_WX20240603-144336@2x.png', 'assets/uploads/program_images/program_brochure/202406061532_WX20240603-144422@2x.png', '16', 25, 'title 2', '<p>testing&nbsp;</p>', 'testing', '<p>testing&nbsp;</p><p>&nbsp;</p><p>testing&nbsp;</p>', '<p>testing&nbsp;</p>', '<p>testing&nbsp;</p>', '<p>testing&nbsp;</p>', '<p>testing&nbsp;</p>', 1, '2024-06-10 17:20:07', '2024-06-06 15:32:47', '2024-06-10 17:20:07'),
(143, 'testing 11', '[\"27-06-2024\"]', NULL, 1, 1, 'testing 11', 'assets/uploads/program_images/thumbnail/202406131139_11111.png', NULL, '18', 25, 'testing 11', '<p>testing 11 testing 11 testing 11&nbsp;</p>', 'testing 11', '<p>testing 11&nbsp;</p>', '<p>testing 11&nbsp;</p>', '<p>testing 11&nbsp;</p>', '<p>testing 11&nbsp;</p>', '<p>testing 11&nbsp;</p>', 1, '2024-06-13 11:40:38', '2024-06-13 11:39:57', '2024-06-13 11:40:38');

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

--
-- Table structure for table `program_accomadations`
--

CREATE TABLE `program_accomadations` (
  `id` bigint UNSIGNED NOT NULL,
  `programs_xid` bigint UNSIGNED NOT NULL,
  `accomadation` varchar(255) CHARACTER SET utf8mb4 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 `program_accomadations`
--

INSERT INTO `program_accomadations` (`id`, `programs_xid`, `accomadation`, `created_at`, `updated_at`) VALUES
(122, 21, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-08-29 06:41:29', '2023-08-29 06:41:29'),
(123, 21, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-08-29 06:41:29', '2023-08-29 06:41:29'),
(124, 22, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-08-29 06:54:06', '2023-08-29 06:54:06'),
(125, 22, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-08-29 06:54:06', '2023-08-29 06:54:06'),
(144, 23, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-08-29 15:01:00', '2023-08-29 15:01:00'),
(145, 23, 'Lean In House is located on a scenic hill just 15 minutes from the', '2023-08-29 15:01:00', '2023-08-29 15:01:00'),
(146, 23, 'Lean In House is located on a scenic hill just 15 minutes from the', '2023-08-29 15:01:00', '2023-08-29 15:01:00'),
(147, 10, 'Environmental Protection Project', '2023-08-29 15:01:17', '2023-08-29 15:01:17'),
(148, 10, 'Environmental Protection Project', '2023-08-29 15:01:17', '2023-08-29 15:01:17'),
(149, 10, 'Environmental Protection Project', '2023-08-29 15:01:17', '2023-08-29 15:01:17'),
(228, 26, 'Engage in projects that align with your passion and skills.', '2023-09-21 12:06:20', '2023-09-21 12:06:20'),
(229, 26, 'Engage in projects that align with your passion and skills.', '2023-09-21 12:06:20', '2023-09-21 12:06:20'),
(245, 27, 'Enjoy comfortable and authentic Spanish homestays .', '2023-09-26 07:59:03', '2023-09-26 07:59:03'),
(246, 27, 'with local families, providing you with a genuine glimpse into everyday Spanish life.', '2023-09-26 07:59:03', '2023-09-26 07:59:03'),
(247, 27, 'This arrangement promotes cultural exchange and language learning opportunities.', '2023-09-26 07:59:03', '2023-09-26 07:59:03'),
(266, 9, 'Labore quis voluptas', '2023-10-12 08:06:43', '2023-10-12 08:06:43'),
(275, 30, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-10-15 09:43:30', '2023-10-15 09:43:30'),
(276, 30, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-10-15 09:43:30', '2023-10-15 09:43:30'),
(297, 24, 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park.', '2023-10-18 08:03:44', '2023-10-18 08:03:44'),
(298, 24, 'Lean In House is located on a scenic hill just 15 minutes from the base - the National Park.', '2023-10-18 08:03:44', '2023-10-18 08:03:44'),
(331, 31, 'New Zealand Auckland Environmental Protection Project', '2023-10-20 09:56:28', '2023-10-20 09:56:28'),
(352, 32, 'New Zealand Auckland Environmental Protection Project', '2023-10-26 08:30:25', '2023-10-26 08:30:25'),
(353, 32, 'New Zealand Auckland Environmental Protection Project', '2023-10-26 08:30:25', '2023-10-26 08:30:25'),
(354, 34, 'New Zealand Auckland Environmental Protection Project', '2023-10-26 09:20:15', '2023-10-26 09:20:15'),
(389, 70, 'During your stay, you will be hosted in comfortable and charming accommodations that capture the essence of Spanish hospitality.', '2023-11-16 11:10:51', '2023-11-16 11:10:51'),
(390, 70, 'Our carefully selected hotels are centrally located, allowing you to easily explore the surrounding areas. Each accommodation is equipped with modern amenities to ensure a pleasant and relaxing stay.', '2023-11-16 11:10:51', '2023-11-16 11:10:51'),
(417, 56, 'no', '2023-12-21 06:57:11', '2023-12-21 06:57:11'),
(418, 69, 'Labore quis voluptas', '2023-12-21 07:13:33', '2023-12-21 07:13:33'),
(419, 69, 'Labore quis voluptas', '2023-12-21 07:13:33', '2023-12-21 07:13:33'),
(420, 43, 'Lean In House is located on a scenic hill just 15 minutes from the base', '2023-12-21 07:14:04', '2023-12-21 07:14:04'),
(422, 104, 'Labore quis voluptas', '2024-02-19 17:43:42', '2024-02-19 17:43:42'),
(482, 105, 'New Zealand Auckland Environmental Protection Project', '2024-04-08 23:53:41', '2024-04-08 23:53:41'),
(483, 105, 'adding bullet point', '2024-04-08 23:53:41', '2024-04-08 23:53:41'),
(703, 133, 'Accommodation', '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(704, 133, 'Three Meals Per Day', '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(705, 133, 'Work Uniform', '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(706, 133, 'Airport pick up', '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(707, 133, 'In-country Orientation', '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(708, 133, 'Pre-depature training', '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(709, 133, '7/24 in-country support', '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(724, 131, 'Labore quis voluptas', '2024-06-03 14:35:56', '2024-06-03 14:35:56'),
(725, 131, 'Labore quis vo', '2024-06-03 14:35:56', '2024-06-03 14:35:56'),
(761, 136, 'Labore quis voluptas', '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(762, 136, 'Labore quis voluptas', '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(763, 136, 'Labore quis voluptas', '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(764, 137, 'Labore quis voluptas', '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(765, 137, 'Labore quis voluptas', '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(766, 137, 'Labore quis voluptas', '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(767, 138, 'Labore quis voluptas', '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(768, 138, 'Labore quis voluptas', '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(769, 138, 'Labore quis voluptas', '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(772, 140, 'Amet aliquid maiore', '2024-06-04 14:02:23', '2024-06-04 14:02:23'),
(773, 140, 'Amet aliquid maiore', '2024-06-04 14:02:23', '2024-06-04 14:02:23'),
(774, 141, 'Commodi at quas est', '2024-06-05 06:49:32', '2024-06-05 06:49:32'),
(777, 139, 'Internet online teaching', '2024-06-05 10:40:04', '2024-06-05 10:40:04'),
(778, 139, 'Internet online teaching', '2024-06-05 10:40:04', '2024-06-05 10:40:04'),
(811, 135, 'Accomodation', '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(812, 135, 'Three Meals', '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(813, 135, '7/24 in-country support', '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(814, 135, 'Airport pick up', '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(815, 135, 'In-country Orientation', '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(816, 135, 'Pre-depature training', '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(817, 142, 'testing', '2024-06-06 15:44:07', '2024-06-06 15:44:07'),
(818, 142, 'testing', '2024-06-06 15:44:07', '2024-06-06 15:44:07'),
(819, 132, 'Accommodation', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(820, 132, 'Three Meals Per Day', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(821, 132, 'Work Uniform', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(822, 132, 'Airport pick up', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(823, 132, 'In-country Orientation', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(824, 132, 'Pre-depature training', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(825, 132, '7/24 in-country support', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(826, 143, 'testing 11', '2024-06-13 11:39:57', '2024-06-13 11:39:57'),
(827, 143, 'testing 11 q', '2024-06-13 11:39:57', '2024-06-13 11:39:57');

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

--
-- Table structure for table `program_currency_amounts`
--

CREATE TABLE `program_currency_amounts` (
  `id` bigint UNSIGNED NOT NULL,
  `programs_xid` bigint UNSIGNED NOT NULL,
  `week` int NOT NULL,
  `usd_price` decimal(8,2) DEFAULT NULL,
  `gbp_price` decimal(8,2) DEFAULT NULL,
  `euro_price` decimal(8,2) 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 `program_currency_amounts`
--

INSERT INTO `program_currency_amounts` (`id`, `programs_xid`, `week`, `usd_price`, `gbp_price`, `euro_price`, `created_at`, `updated_at`) VALUES
(323, 14, 1, 100.00, NULL, NULL, '2023-08-24 10:21:18', '2023-08-24 10:21:18'),
(324, 14, 2, NULL, NULL, NULL, '2023-08-24 10:21:18', '2023-08-24 10:21:18'),
(329, 21, 1, 100.00, NULL, NULL, '2023-08-29 06:41:26', '2023-08-29 06:41:26'),
(330, 21, 2, 100.00, NULL, NULL, '2023-08-29 06:41:26', '2023-08-29 06:41:26'),
(331, 21, 3, 100.00, NULL, NULL, '2023-08-29 06:41:26', '2023-08-29 06:41:26'),
(332, 21, 4, 100.00, NULL, NULL, '2023-08-29 06:41:26', '2023-08-29 06:41:26'),
(333, 21, 5, 100.00, NULL, NULL, '2023-08-29 06:41:26', '2023-08-29 06:41:26'),
(334, 22, 1, 200.00, NULL, NULL, '2023-08-29 06:54:05', '2023-08-29 06:54:05'),
(335, 22, 2, 200.00, NULL, NULL, '2023-08-29 06:54:05', '2023-08-29 06:54:05'),
(336, 22, 3, 200.00, NULL, NULL, '2023-08-29 06:54:05', '2023-08-29 06:54:05'),
(374, 23, 1, 200.00, NULL, NULL, '2023-08-29 15:01:00', '2023-08-29 15:01:00'),
(375, 23, 2, 200.00, NULL, NULL, '2023-08-29 15:01:00', '2023-08-29 15:01:00'),
(376, 23, 3, 200.00, NULL, NULL, '2023-08-29 15:01:00', '2023-08-29 15:01:00'),
(377, 23, 4, 200.00, NULL, NULL, '2023-08-29 15:01:00', '2023-08-29 15:01:00'),
(464, 26, 1, 900.00, NULL, NULL, '2023-09-21 12:06:20', '2023-09-21 12:06:20'),
(465, 26, 2, 600.00, NULL, NULL, '2023-09-21 12:06:20', '2023-09-21 12:06:20'),
(466, 26, 3, 700.00, NULL, NULL, '2023-09-21 12:06:20', '2023-09-21 12:06:20'),
(467, 26, 4, 800.00, NULL, NULL, '2023-09-21 12:06:20', '2023-09-21 12:06:20'),
(483, 27, 1, 300.00, NULL, NULL, '2023-09-26 07:59:03', '2023-09-26 07:59:03'),
(484, 27, 2, 600.00, NULL, NULL, '2023-09-26 07:59:03', '2023-09-26 07:59:03'),
(485, 27, 3, 1200.00, NULL, NULL, '2023-09-26 07:59:03', '2023-09-26 07:59:03'),
(540, 9, 1, 100.00, NULL, NULL, '2023-10-12 08:06:43', '2023-10-12 08:06:43'),
(541, 9, 2, 400.00, NULL, NULL, '2023-10-12 08:06:43', '2023-10-12 08:06:43'),
(542, 9, 3, 700.00, NULL, NULL, '2023-10-12 08:06:43', '2023-10-12 08:06:43'),
(555, 30, 1, 100.00, NULL, NULL, '2023-10-15 09:43:30', '2023-10-15 09:43:30'),
(556, 30, 2, 200.00, NULL, NULL, '2023-10-15 09:43:30', '2023-10-15 09:43:30'),
(557, 30, 3, 900.00, NULL, NULL, '2023-10-15 09:43:30', '2023-10-15 09:43:30'),
(558, 30, 4, 500.00, NULL, NULL, '2023-10-15 09:43:30', '2023-10-15 09:43:30'),
(627, 31, 1, 100.00, NULL, NULL, '2023-10-20 09:56:28', '2023-10-20 09:56:28'),
(628, 31, 2, 200.00, NULL, NULL, '2023-10-20 09:56:28', '2023-10-20 09:56:28'),
(629, 31, 3, 300.00, NULL, NULL, '2023-10-20 09:56:28', '2023-10-20 09:56:28'),
(656, 58, 1, 800.00, NULL, NULL, '2023-10-24 10:21:06', '2023-10-24 10:21:06'),
(659, 32, 1, 100.00, NULL, NULL, '2023-10-26 08:30:25', '2023-10-26 08:30:25'),
(660, 32, 2, 200.00, NULL, NULL, '2023-10-26 08:30:25', '2023-10-26 08:30:25'),
(661, 34, 1, 200.00, NULL, NULL, '2023-10-26 09:20:15', '2023-10-26 09:20:15'),
(718, 70, 1, 100.00, NULL, NULL, '2023-11-16 11:10:51', '2023-11-16 11:10:51'),
(719, 70, 2, 900.00, NULL, NULL, '2023-11-16 11:10:51', '2023-11-16 11:10:51'),
(720, 70, 3, 200.00, NULL, NULL, '2023-11-16 11:10:51', '2023-11-16 11:10:51'),
(721, 70, 4, 800.00, NULL, NULL, '2023-11-16 11:10:51', '2023-11-16 11:10:51'),
(767, 56, 1, 900.00, NULL, NULL, '2023-12-21 06:57:11', '2023-12-21 06:57:11'),
(768, 69, 1, 900.00, NULL, NULL, '2023-12-21 07:13:33', '2023-12-21 07:13:33'),
(769, 69, 2, 200.00, NULL, NULL, '2023-12-21 07:13:33', '2023-12-21 07:13:33'),
(770, 69, 3, 900.00, NULL, NULL, '2023-12-21 07:13:33', '2023-12-21 07:13:33'),
(771, 43, 1, 100.00, NULL, NULL, '2023-12-21 07:14:04', '2023-12-21 07:14:04'),
(772, 43, 2, 200.00, NULL, NULL, '2023-12-21 07:14:04', '2023-12-21 07:14:04'),
(776, 104, 2, 200.00, NULL, NULL, '2024-02-19 17:43:42', '2024-02-19 17:43:42'),
(777, 104, 3, 300.00, NULL, NULL, '2024-02-19 17:43:42', '2024-02-19 17:43:42'),
(778, 104, 4, 900.00, NULL, NULL, '2024-02-19 17:43:42', '2024-02-19 17:43:42'),
(803, 3, 1, 500.00, NULL, NULL, '2024-03-19 08:23:36', '2024-03-19 08:23:36'),
(804, 3, 2, 800.00, NULL, NULL, '2024-03-19 08:23:36', '2024-03-19 08:23:36'),
(899, 105, 3, 400.00, NULL, NULL, '2024-04-08 23:53:41', '2024-04-08 23:53:41'),
(900, 105, 4, 500.00, NULL, NULL, '2024-04-08 23:53:41', '2024-04-08 23:53:41'),
(901, 105, 5, 600.00, NULL, NULL, '2024-04-08 23:53:41', '2024-04-08 23:53:41'),
(1120, 133, 2, 1200.00, NULL, NULL, '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(1121, 133, 3, 1780.00, NULL, NULL, '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(1122, 133, 4, 2350.00, NULL, NULL, '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(1123, 133, 5, 2900.00, NULL, NULL, '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(1124, 133, 6, 3450.00, NULL, NULL, '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(1125, 133, 7, 4000.00, NULL, NULL, '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(1126, 133, 8, 4550.00, NULL, NULL, '2024-06-03 14:32:06', '2024-06-03 14:32:06'),
(1141, 131, 3, 100.00, NULL, NULL, '2024-06-03 14:35:56', '2024-06-03 14:35:56'),
(1142, 131, 4, 200.00, NULL, NULL, '2024-06-03 14:35:56', '2024-06-03 14:35:56'),
(1143, 131, 2, 50.00, NULL, NULL, '2024-06-03 14:35:56', '2024-06-03 14:35:56'),
(1144, 131, 5, 500.00, NULL, NULL, '2024-06-03 14:35:56', '2024-06-03 14:35:56'),
(1180, 136, 3, 900.00, NULL, NULL, '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(1181, 136, 4, 300.00, NULL, NULL, '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(1182, 136, 5, 400.00, NULL, NULL, '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(1183, 136, 6, 500.00, NULL, NULL, '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(1184, 136, 7, 700.00, NULL, NULL, '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(1185, 136, 8, 800.00, NULL, NULL, '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(1186, 137, 3, 900.00, NULL, NULL, '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(1187, 137, 4, 300.00, NULL, NULL, '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(1188, 137, 5, 400.00, NULL, NULL, '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(1189, 137, 6, 500.00, NULL, NULL, '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(1190, 137, 7, 700.00, NULL, NULL, '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(1191, 137, 8, 800.00, NULL, NULL, '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(1192, 138, 3, 900.00, NULL, NULL, '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(1193, 138, 4, 300.00, NULL, NULL, '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(1194, 138, 5, 400.00, NULL, NULL, '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(1195, 138, 6, 500.00, NULL, NULL, '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(1196, 138, 7, 700.00, NULL, NULL, '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(1197, 138, 8, 800.00, NULL, NULL, '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(1201, 140, 3, 200.00, NULL, NULL, '2024-06-04 14:02:23', '2024-06-04 14:02:23'),
(1202, 140, 4, 300.00, NULL, NULL, '2024-06-04 14:02:23', '2024-06-04 14:02:23'),
(1203, 141, 500, 5.00, NULL, NULL, '2024-06-05 06:49:32', '2024-06-05 06:49:32'),
(1204, 141, 600, 6.00, NULL, NULL, '2024-06-05 06:49:32', '2024-06-05 06:49:32'),
(1208, 139, 3, 900.00, NULL, NULL, '2024-06-05 10:40:04', '2024-06-05 10:40:04'),
(1209, 139, 4, 800.00, NULL, NULL, '2024-06-05 10:40:04', '2024-06-05 10:40:04'),
(1210, 139, 4, 500.00, NULL, NULL, '2024-06-05 10:40:04', '2024-06-05 10:40:04'),
(1242, 135, 1, 300.00, NULL, NULL, '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(1243, 135, 2, 580.00, NULL, NULL, '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(1244, 135, 3, 860.00, NULL, NULL, '2024-06-06 15:43:24', '2024-06-06 15:43:24'),
(1245, 142, 1, 220.00, NULL, NULL, '2024-06-06 15:44:07', '2024-06-06 15:44:07'),
(1246, 142, 2, 300.00, NULL, NULL, '2024-06-06 15:44:07', '2024-06-06 15:44:07'),
(1247, 142, 3, 400.00, NULL, NULL, '2024-06-06 15:44:07', '2024-06-06 15:44:07'),
(1248, 132, 2, 1200.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1249, 132, 3, 1780.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1250, 132, 4, 2350.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1251, 132, 5, 2900.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1252, 132, 6, 3450.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1253, 132, 7, 4000.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1254, 132, 8, 4550.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1255, 132, 9, 200.00, NULL, NULL, '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(1256, 143, 1, 100.00, NULL, NULL, '2024-06-13 11:39:57', '2024-06-13 11:39:57');

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

--
-- Table structure for table `program_images`
--

CREATE TABLE `program_images` (
  `id` bigint UNSIGNED NOT NULL,
  `programs_xid` bigint UNSIGNED NOT NULL,
  `images` varchar(255) CHARACTER SET utf8mb4 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 `program_images`
--

INSERT INTO `program_images` (`id`, `programs_xid`, `images`, `created_at`, `updated_at`) VALUES
(9, 3, 'assets/uploads/program_images/202307141024_singapor-img.png', '2023-07-14 10:24:58', '2023-07-14 10:24:58'),
(10, 3, 'assets/uploads/program_images/202307141024_nepal-img (1).png', '2023-07-14 10:24:59', '2023-07-14 10:24:59'),
(11, 3, 'assets/uploads/program_images/202307141024_rabit-img.png', '2023-07-14 10:24:59', '2023-07-14 10:24:59'),
(12, 3, 'assets/uploads/program_images/202307141024_nepal-img.png', '2023-07-14 10:25:00', '2023-07-14 10:25:00'),
(13, 3, 'assets/uploads/program_images/202307141025_uk-img.png', '2023-07-14 10:25:00', '2023-07-14 10:25:00'),
(20, 10, 'assets/uploads/program_images/202307161715_nepal-img (1).png', '2023-07-16 17:15:39', '2023-07-16 17:15:39'),
(21, 10, 'assets/uploads/program_images/202307161715_rabit-img.png', '2023-07-16 17:15:40', '2023-07-16 17:15:40'),
(22, 10, 'assets/uploads/program_images/202307161715_nepal-img.png', '2023-07-16 17:15:41', '2023-07-16 17:15:41'),
(23, 10, 'assets/uploads/program_images/202307161715_uk-img.png', '2023-07-16 17:15:41', '2023-07-16 17:15:41'),
(24, 10, 'assets/uploads/program_images/202307161715_pro-img1.png', '2023-07-16 17:15:41', '2023-07-16 17:15:41'),
(33, 14, 'assets/uploads/program_images/202308010027_1_S81O15rjKfG-BFdnNC6-GQ.jpg', '2023-08-01 00:27:47', '2023-08-01 00:27:47'),
(34, 14, 'assets/uploads/program_images/202308010027_download (1).jfif', '2023-08-01 00:27:47', '2023-08-01 00:27:47'),
(35, 14, 'assets/uploads/program_images/202308010027_download.jfif', '2023-08-01 00:27:47', '2023-08-01 00:27:47'),
(60, 3, 'assets/uploads/program_images/202308021108_1_S81O15rjKfG-BFdnNC6-GQ.jpg', '2023-08-02 11:08:43', '2023-08-02 11:08:43'),
(69, 21, 'assets/uploads/program_images/202308290641_nepal-img (1).png', '2023-08-29 06:41:27', '2023-08-29 06:41:27'),
(70, 21, 'assets/uploads/program_images/202308290641_rabit-img.png', '2023-08-29 06:41:27', '2023-08-29 06:41:27'),
(71, 21, 'assets/uploads/program_images/202308290641_nepal-img.png', '2023-08-29 06:41:29', '2023-08-29 06:41:29'),
(72, 21, 'assets/uploads/program_images/202308290641_uk-img.png', '2023-08-29 06:41:29', '2023-08-29 06:41:29'),
(73, 21, 'assets/uploads/program_images/202308290641_pro-img1.png', '2023-08-29 06:41:29', '2023-08-29 06:41:29'),
(74, 22, 'assets/uploads/program_images/202308290654_rabit-img.png', '2023-08-29 06:54:05', '2023-08-29 06:54:05'),
(75, 22, 'assets/uploads/program_images/202308290654_nepal-img.png', '2023-08-29 06:54:06', '2023-08-29 06:54:06'),
(76, 22, 'assets/uploads/program_images/202308290654_uk-img.png', '2023-08-29 06:54:06', '2023-08-29 06:54:06'),
(77, 22, 'assets/uploads/program_images/202308290654_pro-img1.png', '2023-08-29 06:54:06', '2023-08-29 06:54:06'),
(78, 23, 'assets/uploads/program_images/202308290705_nepal-img (1).png', '2023-08-29 07:05:11', '2023-08-29 07:05:11'),
(79, 23, 'assets/uploads/program_images/202308290705_rabit-img.png', '2023-08-29 07:05:11', '2023-08-29 07:05:11'),
(80, 23, 'assets/uploads/program_images/202308290705_nepal-img.png', '2023-08-29 07:05:13', '2023-08-29 07:05:13'),
(81, 23, 'assets/uploads/program_images/202308290705_uk-img.png', '2023-08-29 07:05:13', '2023-08-29 07:05:13'),
(85, 24, 'assets/uploads/program_images/202309040939_Hero-feature_textbooks_literacy_photo_ti_to_tito_iStock_92106570.webp', '2023-09-04 09:39:23', '2023-09-04 09:39:23'),
(86, 24, 'assets/uploads/program_images/202309040939_images (1).jfif', '2023-09-04 09:39:23', '2023-09-04 09:39:23'),
(87, 24, 'assets/uploads/program_images/202309040939_images (2).jfif', '2023-09-04 09:39:23', '2023-09-04 09:39:23'),
(113, 26, 'assets/uploads/program_images/202309211205_th (10).jpg', '2023-09-21 12:05:39', '2023-09-21 12:05:39'),
(114, 26, 'assets/uploads/program_images/202309211205_th (11).jpg', '2023-09-21 12:05:39', '2023-09-21 12:05:39'),
(117, 26, 'assets/uploads/program_images/202309211205_volunteer-abroad-in-spain-ivhq-barcelona-youth-support.jpg', '2023-09-21 12:05:39', '2023-09-21 12:05:39'),
(118, 27, 'assets/uploads/program_images/[REDACTED].jpg', '2023-09-24 18:31:16', '2023-09-24 18:31:16'),
(119, 27, 'assets/uploads/program_images/202309241842_volunteering-in-a-foreign-country1.webp', '2023-09-24 18:42:16', '2023-09-24 18:42:16'),
(129, 9, 'assets/uploads/program_images/202310101134_513_albufera..jpg', '2023-10-10 11:34:26', '2023-10-10 11:34:26'),
(130, 9, 'assets/uploads/program_images/[REDACTED].jpg', '2023-10-10 11:34:26', '2023-10-10 11:34:26'),
(135, 30, 'assets/uploads/program_images/202310150941_th (10).jpg', '2023-10-15 09:41:04', '2023-10-15 09:41:04'),
(136, 30, 'assets/uploads/program_images/202310150941_th (11).jpg', '2023-10-15 09:41:04', '2023-10-15 09:41:04'),
(138, 31, 'assets/uploads/program_images/202310150948_volunteer-abroad-in-spain-ivhq-barcelona-youth-support.jpg', '2023-10-15 09:48:41', '2023-10-15 09:48:41'),
(139, 31, 'assets/uploads/program_images/202310150948_volunteering-in-a-foreign-country1.webp', '2023-10-15 09:48:41', '2023-10-15 09:48:41'),
(140, 32, 'assets/uploads/program_images/202310151006_volunteer-2048x1233.jpg', '2023-10-15 10:06:11', '2023-10-15 10:06:11'),
(141, 32, 'assets/uploads/program_images/202310151006_volunteer-abroad-in-spain-ivhq-barcelona-youth-support.jpg', '2023-10-15 10:06:11', '2023-10-15 10:06:11'),
(144, 34, 'assets/uploads/program_images/202310151447_download (1).jfif', '2023-10-15 14:47:44', '2023-10-15 14:47:44'),
(145, 34, 'assets/uploads/program_images/202310151447_download.jfif', '2023-10-15 14:47:44', '2023-10-15 14:47:44'),
(155, 43, 'assets/uploads/program_images/202310180939_images (5).jfif', '2023-10-18 09:39:28', '2023-10-18 09:39:28'),
(165, 31, 'assets/uploads/program_images/202310200949_1.png', '2023-10-20 09:49:28', '2023-10-20 09:49:28'),
(166, 31, 'assets/uploads/program_images/202310200949_2.png', '2023-10-20 09:49:29', '2023-10-20 09:49:29'),
(167, 31, 'assets/uploads/program_images/202310200949_3.png', '2023-10-20 09:49:29', '2023-10-20 09:49:29'),
(168, 31, 'assets/uploads/program_images/202310200949_4.png', '2023-10-20 09:49:30', '2023-10-20 09:49:30'),
(169, 31, 'assets/uploads/program_images/202310200949_adminlogin.png', '2023-10-20 09:49:30', '2023-10-20 09:49:30'),
(170, 31, 'assets/uploads/program_images/202310200956_screencast-bpconcjcammlapcogcnnelfmaeghhagj-2023.10.17-12_46_20.webm', '2023-10-20 09:56:28', '2023-10-20 09:56:28'),
(180, 56, 'assets/uploads/program_images/202310240703_istockphoto-1399565382-1024x1024.jpg', '2023-10-24 07:03:33', '2023-10-24 07:03:33'),
(182, 32, 'assets/uploads/program_images/202310260830_mutualfund2.jpg', '2023-10-26 08:30:25', '2023-10-26 08:30:25'),
(199, 69, 'assets/uploads/program_images/202311070943_volunteer-abroad-in-spain-ivhq-barcelona-youth-support.jpg', '2023-11-07 09:43:50', '2023-11-07 09:43:50'),
(200, 69, 'assets/uploads/program_images/202311070943_volunteering-in-a-foreign-country1.webp', '2023-11-07 09:43:50', '2023-11-07 09:43:50'),
(201, 70, 'assets/uploads/program_images/202311160637_volunteer-2048x1233.jpg', '2023-11-16 06:37:36', '2023-11-16 06:37:36'),
(202, 70, 'assets/uploads/program_images/[REDACTED].jpg', '2023-11-16 11:10:51', '2023-11-16 11:10:51'),
(204, 104, 'assets/uploads/program_images/202312201211_Top-E-Commerce-7-1200x675.png', '2023-12-20 12:11:45', '2023-12-20 12:11:45'),
(205, 104, 'assets/uploads/program_images/202312201211_Bathroom-Renovations-Transforming-Your-Space-One-Tile-at-a-Time-1200x675 (1).png', '2023-12-20 12:11:45', '2023-12-20 12:11:45'),
(206, 105, 'assets/uploads/program_images/202402201307_volunteer-2048x1233.jpg', '2024-02-20 13:07:48', '2024-02-20 13:07:48'),
(218, 135, 'assets/uploads/program_images/202404261627_4-4.JPG', '2024-04-26 16:27:14', '2024-04-26 16:27:14'),
(219, 135, 'assets/uploads/program_images/202404261740_1692353633615.jpeg', '2024-04-26 17:40:19', '2024-04-26 17:40:19'),
(220, 133, 'assets/uploads/program_images/202404301558_20151127010631_50959.jpg', '2024-04-30 15:58:38', '2024-04-30 15:58:38'),
(221, 133, 'assets/uploads/program_images/202404301558_20151127010728_64560.jpg', '2024-04-30 15:58:38', '2024-04-30 15:58:38'),
(224, 136, 'assets/uploads/program_images/202406041345_75-1717077147.png', '2024-06-04 13:45:19', '2024-06-04 13:45:19'),
(225, 137, 'assets/uploads/program_images/202406041345_75-1717077147.png', '2024-06-04 13:45:53', '2024-06-04 13:45:53'),
(226, 138, 'assets/uploads/program_images/202406041347_75-1717077147.png', '2024-06-04 13:47:40', '2024-06-04 13:47:40'),
(227, 139, 'assets/uploads/program_images/202406041355_europe-flag-icon.jpeg', '2024-06-04 13:55:19', '2024-06-04 13:55:19'),
(228, 140, 'assets/uploads/program_images/202406041402_IMG-20240507-WA0004.jpg', '2024-06-04 14:02:23', '2024-06-04 14:02:23'),
(229, 141, 'assets/uploads/program_images/[REDACTED].jpg', '2024-06-05 06:49:32', '2024-06-05 06:49:32'),
(230, 141, 'assets/uploads/program_images/202406050649_mutualfund1.webp', '2024-06-05 06:49:32', '2024-06-05 06:49:32'),
(231, 141, 'assets/uploads/program_images/202406050649_mutualfund2.jpg', '2024-06-05 06:49:32', '2024-06-05 06:49:32'),
(232, 139, 'assets/uploads/program_images/202406051040_Hero-feature_textbooks_literacy_photo_ti_to_tito_iStock_92106570.webp', '2024-06-05 10:40:04', '2024-06-05 10:40:04'),
(233, 139, 'assets/uploads/program_images/202406051040_images (1).jfif', '2024-06-05 10:40:04', '2024-06-05 10:40:04'),
(234, 142, 'assets/uploads/program_images/202406061532_WX20240603-144306@2x.png', '2024-06-06 15:32:47', '2024-06-06 15:32:47'),
(235, 132, 'assets/uploads/program_images/202406101720_IMG_5038.JPG', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(236, 132, 'assets/uploads/program_images/202406101720_IMG_5239.JPG', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(237, 132, 'assets/uploads/program_images/202406101720_WX20240603-144322@2x.png', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(238, 132, 'assets/uploads/program_images/202406101720_WX20240603-144306@2x.png', '2024-06-10 17:20:50', '2024-06-10 17:20:50'),
(239, 143, 'assets/uploads/program_images/202406131139_WX20240607-161049@2x.png', '2024-06-13 11:39:57', '2024-06-13 11:39:57');

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

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

CREATE TABLE `states` (
  `id` bigint UNSIGNED NOT NULL,
  `country_xid` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 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 `states`
--

INSERT INTO `states` (`id`, `country_xid`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'Maharashtra', '2023-06-22 09:21:09', '2023-06-22 09:21:09');

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

--
-- Table structure for table `terms_condtions`
--

CREATE TABLE `terms_condtions` (
  `id` bigint UNSIGNED NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `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 `terms_condtions`
--

INSERT INTO `terms_condtions` (`id`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '<p>Before signing up for a Lean In project, please read this agreement carefully. By selecting the option to register, you agree to have fully understood and accepted all the terms and conditions of this agreement. Lean In World reserves the right to update and modify the terms of this agreement at any time, and volunteers are assumed to accept such updates and modifications.</p><h3>1. Definitions</h3><p>1.1 In this agreement, \"projects\" refer to any expeditions, volunteer projects, and other activities arranged by Lean In globally; \"services\" refer to various services provided by Lean In to participants.</p><p>1.2 The titles in this agreement are for convenience only and should not affect the interpretation.</p><p>1.3 \"Applicant\"  and \"Participant\" refers to the customer who has applied to participate in a volunteer program.</p><h3>2. Application Process</h3><ul><li>Applications can be submitted via our website. Submitting an application does not ensure acceptance, as it is dependent on availability and suitability.</li><li>To apply for a Lean In program, a 139 GBP Registration Fee is required, which serves as a non-refundable deposit for the trip. Once the registration fee is paid, you will have lifelong access to apply for other programs without an additional registration fee.</li><li>After an application is completed and submitted to Lean In, we will coordinate with our partner organizations to determine the suitability and availability of your selected program. If we are unable to offer you a place in the program, you will be notified via email or telephone, typically within 2 working days, and your initial payment will be fully refunded.</li><li>The individual making the application (the “lead name”) must be 16 years old or older and accept the terms &amp; conditions on behalf of all those involved. Some programs accept volunteers under 16 if they have a guardian accompanying them.</li><li>Applications are made with the understanding that Lean In uses partner organizations around the world as suppliers for its programs.</li></ul><h3>3. Registration Fee</h3><p><strong>3.1 Payment Confirmation and Acceptance</strong></p><ul><li>Payment of the Registration Fee confirms a volunteer’s place in one of our volunteer programs, subject to acceptance and availability. Registration fees are not transferable to other persons and cannot be used towards payment for any other fees.</li></ul><p><strong>3.2 Finality of Payments</strong></p><ul><li>All payments are final. No \"cooling off period\" is offered. If the applied program is not confirmed by Lean In, you will receive a full refund.</li></ul><p><strong>3.3 Transaction and Banking Fees</strong></p><ul><li>All registration fee payments attract a non-refundable 5% transaction fee to cover international banking fees. International wire transfer payments from the UK, Europe, and America do not incur any bank service fee. Wires from other countries will attract a 35 USD bank service charge.</li></ul><h3>4. Program Fee</h3><p><strong>4.1 Program Fee Payment</strong></p><ul><li>To participate in a volunteer program, you must pay the full Program Fee as specified on the Lean In website. Lean In reserves the right to change Program Fees at any time, with any updates being announced on the Lean In website. These changes will not affect participants who have already registered unless they modify their program details after the new fees are in effect.</li></ul><p><strong>4.2 Payment Deadline</strong></p><ul><li>Program fees must be paid no later than 20 days before the volunteer program starts. If you fail to make this payment, you may lose your placement, and the Registration Fee will not be refunded. All Program Fees and payments for additional services incur a non-refundable 5% transaction fee to cover international banking costs. International wire transfers will also incur a minimum fee of 35 USD.</li></ul><p><strong>4.3 Accommodation</strong></p><ul><li>The Program Fee includes accommodation for the entire duration of the volunteer program. If a volunteer decides to arrange their own lodging, no compensation or refund will be provided.</li></ul><h3>5. Changes and Cancellations</h3><p><strong>5.1 Change and Cancellation by Applicant</strong></p><ul><li><strong>5.1.1 Alterations and Cancellations</strong><ul><li>Alterations to your booking depend on availability, and we can\'t guarantee success. There may be additional costs imposed by suppliers for specific aspects of our programs. By requesting a change, you will also be liable for these costs. Changes cannot be requested less than 30 days before your program start date or once your trip has commenced. In such circumstances, it would be considered a cancellation. Lean In will do its best to ensure changes are made with minimal disruption.</li></ul></li><li><strong>5.1.2 Cancellations</strong><ul><li>Cancellations must be made in writing by email to info@leaninworld.com.</li><li>If you wish to cancel a booking, our cancellation policy for standard Lean In programs is as follows:<ul><li>Notification of at least 30 days prior to the program start date: loss of your 139 GBP Registration Fee.</li><li>Notification less than or equal to 30 days prior to the program start date or at any time during your program: loss of 100% of the Program Fee and Registration Fee.</li></ul></li><li>Please note that your original 139 GBP Registration Fee is non-refundable.</li></ul></li></ul><p><strong>5.2 Change and Cancellation by Lean In</strong></p><ul><li>Lean In reserves the right to cancel or significantly modify your booking at any time. A “significant change” generally refers to a change of more than 24 hours in departure or return times, a change of departure point, or a major re-routing of the itinerary, but does not include changes to partner organizations, transport, or specified accommodation. If a significant change occurs, we will notify you as soon as possible and offer either a replacement program or a full refund of the Program Fee, minus the Registration Fee (the Registration Fee will be fully creditable for future use). Lean In will provide such a refund if a program is canceled due to insufficient numbers.</li><li>Alterations or cancellations may occur due to unavoidable, unusual, and unforeseen circumstances beyond our control or events considered “force majeure.” In these cases, any Program Fee paid will be refunded if the cancellation happens 61 days or more before the trip start date. If the cancellation occurs within 60 days or less, the Program Fees will be credited and can be used for another trip with us or to defer the scheduled start date. Since payments have already been made in advance to local teams preparing to host you, we cannot provide cash refunds for cancellations occurring 60 days or less before the scheduled trip date. However, the fees paid will be fully protected to reschedule your trip with us.</li><li>“Force majeure” refers to any event that Lean In or the service provider could not foresee or prevent, even with all due care. Examples include, but are not limited to, war, threat of war, riots, civil unrest, industrial disputes, terrorist activities, pandemics, computer or system failures, natural or nuclear disasters, fires, acts of God, and similar events. Minor changes to programs may be made as necessary; these include, but are not limited to, changes in named accommodation or pick-up times.</li></ul><h3>6. Participant Standards</h3><ul><li>Lean In may require a DBS check and an English Certificate before your program start date for some professional programs. If you come from an English-speaking country, you will not be asked for an English certificate. Failure to submit these documents within the specified time frame will result in the cancellation of your program without a refund.</li></ul><h3>7. Participant Obligations</h3><p><strong>7.1 Material and Mental Needs</strong></p><ul><li>When participating in Lean In projects, participants will have various material and mental needs. Participants must recognize that the food, hygiene, and accommodation standards in the project country may be lower than those in their home country.</li></ul><p><strong>7.2 Travel Arrangements and Insurance</strong></p><ul><li>Participants are responsible for arranging their own travel plans, including insurance and daily expenses, as Lean In does not cover these. Participants must ensure their travel safety and purchase insurance to cover potential issues such as luggage loss, flight delays, or emergency medical situations during travel. Insurance must cover the entire duration of the Lean In project. If a participant refuses to purchase insurance, their booking may be unilaterally canceled by Lean In without any refund.</li></ul><p><strong>7.3 Submission of Required Information</strong></p><ul><li>Participants must submit all required information (including but not limited to: arrival and departure flight information, insurance information, passport information, emergency contact details, and proof of English proficiency). Failure to provide complete or accurate information may result in Lean In unilaterally canceling the participant’s application without any refund. Required information and documents will be provided during the application process.</li></ul><p><strong>7.4 Dietary Information</strong></p><ul><li>Participants must ensure the accuracy of dietary information provided to Lean In. Lean In is not responsible for any medical conditions arising from participant negligence.</li></ul><p><strong>7.5 Project Selection</strong></p><ul><li>Lean In offers projects with varying levels of challenge. Participants should select projects that are suitable for their condition. Once a project is selected, participants accept all services associated with that project.</li></ul><p><strong>7.6 Risk Consultation</strong></p><ul><li>Some Lean In project locations are remote. If participants believe that participating in volunteer services poses risks, they should consult a doctor in advance for appropriate advice or consult Lean In staff to choose a suitable project.</li></ul><p><strong>7.7 Accommodation Standards</strong></p><ul><li>Project locations are arranged in relatively underdeveloped areas. Accommodation conditions, transportation, safety measures, hygiene conditions, communication equipment, infrastructure development, and medical facilities may be below the standards of the participant’s home country.</li></ul><p><strong>7.8 Fitness for Participation</strong></p><ul><li>Lean In reserves the right to ask volunteers to leave the volunteer camp if they are physically or emotionally unfit.</li></ul><p><strong>7.9 Medical Compliance</strong></p><ul><li>Lean In is not responsible for any medical issues that arise if participants do not follow medical advice or do not take prescribed medication during volunteer activities.</li></ul><p><strong>7.10 Withdrawal from Project</strong></p><ul><li>Participants acknowledge and agree that Lean In reserves the right to accept or reject any participant’s withdrawal from a project at any time. If a volunteer withdraws on their own, no project fees will be refunded.</li></ul><p><strong>7.11 Liability for Damages</strong></p><ul><li>Lean In is not responsible for any damage to property or adverse social impact caused by participants in the project country. Participants must bear their own responsibilities.</li></ul><p><strong>7.12 Visa and Travel Documents</strong></p><ul><li>Participants are responsible for obtaining and carrying the necessary visas or entry permits for travel. Please consult the relevant country’s embassy or consulate before travel. We are not obligated or responsible for assisting participants in verifying related processes. Participants must ensure they carry all necessary documents for international travel, including but not limited to passports, visas, and work permits (if necessary). For participants opting for a visa on arrival, we are not responsible for any refusal of entry or visa denial and the resulting losses or consequences. Participants who are denied entry due to passport or visa issues or other travel document problems are solely responsible for the resulting losses or consequences.</li></ul><p><strong>7.13 Visa Validity</strong></p><ul><li>Lean In is not responsible for any country’s refusal to allow participants entry. All participants must ensure they have obtained a valid visa by contacting the relevant embassy before travel.</li></ul><p><strong>7.14 Compliance with Local Laws</strong></p><ul><li>Participants must comply with the laws and regulations of the relevant country. If these laws are violated, Lean In project leaders have the right to remove the participant from the volunteer project.</li></ul><p><strong>7.15 Respect for Local Laws and Culture</strong></p><ul><li>Participants must respect and comply with local laws and cultures at all times. They should regulate their behavior and maintain a polite attitude. Each participant has the obligation to uphold the image of Lean In and the Chinese community. Participants should follow all arrangements made by project leaders in each country.</li></ul><p><strong>7.16 Emergency Contacts</strong></p><ul><li>Participants acknowledge and agree that Lean In reserves the right to contact their emergency contacts.</li></ul><p><strong>7.17 Use of Images</strong></p><ul><li>Participants agree that Lean In has the right to use videos or photos taken of them or featuring their likeness for promotional purposes.</li></ul><h3>8. Personal Risks</h3><p>The volunteer acknowledges and accepts the responsibilities and risks associated with their choice to travel to, temporarily reside in, and provide volunteer services in a foreign country. Such travel and volunteer work can be hazardous and involves a certain degree of risk, including inherently dangerous activities and personal perils, both foreseen and unforeseen. All of these risks are fully accepted and solely assumed by the volunteer. Therefore, Lean In, including any and all of its employees, managers, directors, shareholders, host families, and Independent Local Teams (together, the “Lean In Related Parties”), is not liable and disclaims all liability, to the maximum extent permitted by law, for any loss or harm the volunteer or their associates may suffer, including but not limited to loss caused directly or indirectly by:</p><ul><li>Personal injury;</li><li>Emotional injury;</li><li>Death;</li><li>Illness, disease, or pandemic;</li><li>Damage to or loss of property;</li><li>Natural disasters;</li><li>Hostage situations; or</li><li>War or terrorism.</li></ul><p>In the event of a suspected or potential outbreak of any infectious disease in the program, among close contacts, or in locations recently attended by the volunteer, the volunteer agrees to undertake any required testing at their own cost. Should the volunteer refuse to undertake such testing, the Independent Local Team is entitled to dismiss the volunteer from the program, remove them from their accommodation at any time without refund, and implement other measures to protect the health of other volunteers and the local community.</p><h3>9. Governing Law</h3><ul><li>These terms are governed by the laws of England and Wales.</li></ul><h3>10. General</h3><ul><li>All communications related to this contract, unless specified otherwise, must be written in English by the lead name on the application and emailed from the applicant\'s registered email address with us.</li></ul><p> </p><p> </p>', '0', NULL, '2024-06-06 18:00:41');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `discription` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_xid` bigint UNSIGNED NOT NULL,
  `is_active` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '0 = Active, 1 = Inactive',
  `deleted_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 `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `discription`, `image`, `country_xid`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Tin Wood', '<p>This summer is unique. The enthusiasm, adorability, and eagerness to learn of the children in Bali deeply touched us. We enjoyed the entire process of volunteer teaching, laughing, and being joyful just like them, and were deeply moved. Love knows no borders; we helped plant the seeds of English in their hearts, and their smiles made our youth shine brilliantly and beautifully.&nbsp;</p>', 'assets/uploads/testimonial/202405022159_WX20240502-225941@2x.png', 2, '0', NULL, '2023-06-27 12:10:46', '2024-05-02 22:02:13'),
(2, 'Faith Li', '<p>In just two weeks, I dined with the natives, shared watermelon with monkeys, swam in a lake with crocodiles, and lived under the same blue sky with elephants and humble villagers. I still remember the clear eyes of the local little girl. My trip ended with reluctance, and as I was leaving, a young boy said to me \'see you again.\' I quickly got into the car, thinking to myself, \'I will come back to see you all.</p>', 'assets/uploads/testimonial/202405022201_20151130143701_53645.jpg', 24, '0', NULL, '2023-06-27 17:51:11', '2024-05-02 22:01:09'),
(16, 'Testingddddd', 'Testing Testing TestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTesting TestingTestingTestingTestingTestingTesting TestingTestingTesting TestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTestingTesting', 'assets/uploads/testimonial/202406070800_69-1717420766.png', 2, '0', '2024-06-10 17:30:43', '2024-06-07 08:00:15', '2024-06-10 17:30:43'),
(17, 'testing', 'testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testikng testing testing testing testing testing testing testing testing testing testing', 'assets/uploads/testimonial/202406101730_WX20240603-144422@2x.png', 25, '0', NULL, '2024-06-10 17:30:07', '2024-06-10 17:30:07'),
(18, 'testing bb', 'testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb testing bb t', 'assets/uploads/testimonial/202406101731_WX20240607-155851@2x.png', 25, '0', NULL, '2024-06-10 17:31:11', '2024-06-10 17:31:11');

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

--
-- Table structure for table `user_ratings`
--

CREATE TABLE `user_ratings` (
  `id` bigint UNSIGNED NOT NULL,
  `principal_xid` bigint UNSIGNED NOT NULL,
  `rating` enum('1','2','3','4','5') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 = Bad, 2 = Not Good,3 = Average,4= Good, 5 = Amazing',
  `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_ratings`
--

INSERT INTO `user_ratings` (`id`, `principal_xid`, `rating`, `created_at`, `updated_at`) VALUES
(1, 1, '3', NULL, NULL),
(2, 143, '4', NULL, NULL),
(3, 43, '4', NULL, NULL);

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

--
-- Table structure for table `volunteer_profile_documents`
--

CREATE TABLE `volunteer_profile_documents` (
  `id` bigint UNSIGNED NOT NULL,
  `principal_xid` bigint UNSIGNED NOT NULL,
  `profile_documents` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type` varchar(255) CHARACTER SET utf8mb4 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 `volunteer_profile_documents`
--

INSERT INTO `volunteer_profile_documents` (`id`, `principal_xid`, `profile_documents`, `document_type`, `created_at`, `updated_at`) VALUES
(296, 336, 'assets/uploads/profile_images/user_documents/336_1717692963_0.png', 'png', '2024-06-06 16:56:03', '2024-06-06 16:56:03');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blogs_blog_categories_xid_foreign` (`blog_categories_xid`);

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

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_states_xid_foreign` (`states_xid`);

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

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

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  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 `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `faqs_country_xid_foreign` (`country_xid`) USING BTREE;

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

--
-- Indexes for table `iam_principal`
--
ALTER TABLE `iam_principal`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `iam_principal_email_unique` (`email`),
  ADD KEY `iam_principal_programs_xid_foreign` (`programs_xid`),
  ADD KEY `iam_principal_country_xid_foreign` (`country_xid`);

--
-- Indexes for table `iam_principal_groups`
--
ALTER TABLE `iam_principal_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `iam_principal_groups_programs_xid_foreign` (`programs_xid`);

--
-- Indexes for table `iam_principal_principal_group_links`
--
ALTER TABLE `iam_principal_principal_group_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `iam_principal_principal_group_links_principal_xid_foreign` (`principal_xid`),
  ADD KEY `iam_principal_principal_group_links_principal_group_xid_foreign` (`principal_group_xid`);

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

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

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

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

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

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

--
-- Indexes for table `message_boards`
--
ALTER TABLE `message_boards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `message_boards_programs_xid_foreign` (`programs_xid`);

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

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

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

--
-- Indexes for table `payment_transaction_masters`
--
ALTER TABLE `payment_transaction_masters`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_transaction_masters_programs_xid_foreign` (`programs_xid`),
  ADD KEY `payment_transaction_masters_principal_xid_foreign` (`principal_xid`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

--
-- Indexes for table `programs`
--
ALTER TABLE `programs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `programs_country_xid_foreign` (`country_xid`);

--
-- Indexes for table `program_accomadations`
--
ALTER TABLE `program_accomadations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `program_accomadations_programs_xid_foreign` (`programs_xid`);

--
-- Indexes for table `program_currency_amounts`
--
ALTER TABLE `program_currency_amounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `program_currency_amounts_programs_xid_foreign` (`programs_xid`);

--
-- Indexes for table `program_images`
--
ALTER TABLE `program_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `program_images_programs_xid_foreign` (`programs_xid`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `states_country_xid_foreign` (`country_xid`);

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

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `testimonials_country_xid_foreign` (`country_xid`);

--
-- Indexes for table `user_ratings`
--
ALTER TABLE `user_ratings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_ratings_principal_xid_foreign` (`principal_xid`);

--
-- Indexes for table `volunteer_profile_documents`
--
ALTER TABLE `volunteer_profile_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `volunteer_profile_documents_principal_xid_foreign` (`principal_xid`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `latest_updates`
--
ALTER TABLE `latest_updates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blogs`
--
ALTER TABLE `blogs`
  ADD CONSTRAINT `blogs_blog_categories_xid_foreign` FOREIGN KEY (`blog_categories_xid`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_states_xid_foreign` FOREIGN KEY (`states_xid`) REFERENCES `states` (`id`);

--
-- Constraints for table `iam_principal`
--
ALTER TABLE `iam_principal`
  ADD CONSTRAINT `iam_principal_country_xid_foreign` FOREIGN KEY (`country_xid`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `iam_principal_programs_xid_foreign` FOREIGN KEY (`programs_xid`) REFERENCES `programs` (`id`);
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 */;
