-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `gender` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_id` tinyint DEFAULT NULL,
  `join_date` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiry_date` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` bigint NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `name`, `mobile`, `email`, `address`, `gender`, `dob`, `location`, `image_path`, `plan_id`, `join_date`, `expiry_date`, `created_at`, `updated_at`, `status`, `deleted_at`) VALUES
(1, 'fsfs', '9539233231', 'sfsf@gmail.com', 'fsfsf', 'male', '2025-05-01', NULL, '', NULL, '2025-05-03', NULL, '2025-05-03 10:19:10', '2025-05-03 10:19:10', 1, NULL),
(2, 'Deepu GR', '9809849941', 'mail2deepus@gmail.com', 'Aswathy, koonayil', 'male', '2025-05-01', 'Paravur', '', 0, '2025-05-03', NULL, '2025-05-03 10:28:24', '2025-05-03 10:57:31', 1, NULL);

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

--
-- 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
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_05_14_154923_create_amenities_table', 2),
(5, '2024_05_14_193832_alter_table_amenities_change_column_icon_nullable', 3),
(6, '2024_05_14_200222_alter_table_amenities_modify_slug_to_have_null', 4),
(7, '2024_05_14_211241_create_locations_table', 5),
(8, '2024_05_14_211520_create_countries_table', 5),
(9, '2024_05_14_211618_create_states_table', 5),
(10, '2024_05_14_211645_create_cities_table', 5),
(11, '2024_05_15_164754_create_conveyances_table', 6),
(12, '2024_05_15_192421_create_activities_table', 7),
(13, '2024_05_15_192502_create_attractions_table', 7),
(14, '2024_05_15_193327_alter_table_activities_change_description_to_nullable', 8),
(15, '2024_05_15_193457_alter_table_attractions_change_description_image_path_to_nullable', 8),
(16, '2024_05_17_214713_create_table_hotel_settings', 9),
(17, '2024_05_17_215113_rename_table_table_hotel_settings_to_hotel_settings', 10),
(18, '2024_05_20_134211_create_hotels_table', 11),
(19, '2024_05_20_134232_create_hotel_images_table', 11),
(20, '2024_05_20_134248_create_hotel_amenities_table', 11),
(21, '2024_05_20_134259_create_hotel_attractions_table', 11),
(22, '2024_05_20_134407_create_hotel_access_points_table', 11),
(23, '2024_05_20_134431_create_hotel_contacts_table', 11),
(24, '2024_05_20_142549_create_hotel_activities_table', 12),
(25, '2024_05_28_103822_create_rooms_table', 13),
(26, '2024_05_28_114608_create_room_settings_table', 13),
(27, '2024_05_28_172921_create_room_images_table', 14),
(28, '2024_05_28_173019_alter_rooms_table_add_column_hotel_id_after_id', 15),
(29, '2024_05_28_173459_alter_table_add_column_kids_extra_bed_charge_rename_column_exra_bded_charge', 16),
(30, '2024_05_28_194958_alter_table_add_column_cancellation_policy_to_rooms_table', 17),
(31, '2024_05_28_200236_alter_table_change_non_required_to_nullable_on_rooms_table', 18),
(32, '2024_05_28_202636_create_room_amenities-table', 19),
(33, '2024_05_28_202959_alter_room_amenities_change_hotel_id_to_room_id_in_room_amenities_table', 20),
(34, '2024_05_28_203253_alter_room_amenities_change_hotel_id_to_room_id_in_room_amenities_table', 21),
(35, '2024_05_28_204556_alter_table_rooms_make_updated_by_nullable', 22),
(36, '2024_05_28_204725_alter_table_roo_images_make_updated_by_nullable', 22),
(37, '2024_05_29_125844_create_room_prices_table', 23),
(38, '2024_05_29_135823_room_price_user_groups', 23),
(39, '2024_05_29_143523_alter_room_prices_table_add_column_sell_percentage_b2g', 24),
(40, '2024_05_29_145121_alter_table_room_price_user_groups_table_change_column_sell_percentage', 25),
(41, '2024_05_29_161114_alter_table_room_prices_add_column_name_after_room_id', 26),
(42, '2024_05_29_213428_create_packages_table', 27),
(43, '2024_05_29_214213_package_amenities', 28),
(44, '2024_05_29_214850_alter_packages_table_add_createdby_and_timestamps_column', 29),
(45, '2024_05_29_225339_alter_conveyances_remove_name_seats_column', 30),
(46, '2024_05_29_230323_create_conveyance_types_table', 31),
(47, '2024_05_29_230523_alter_conveyances_drop_column_allow_attachment', 32),
(48, '2024_05_31_105024_alter_hotels_table_change_hotel_group_to_nullable', 33),
(49, '2024_05_31_111934_alter_hotels_table_add_column_star_rating_after_longitude_rename_column_star_rating_to_review_rating', 34),
(50, '2024_05_31_113938_alter_table_hotels_remove_column_review_rating', 35),
(51, '2024_05_31_114046_alter_table_hotels_add_column_star_rating_and_review_rating', 36),
(52, '2024_05_31_130002_alter_table_rooms_change_column_meal_type_to_nullable', 37),
(53, '2024_05_31_232256_drop_packages_table', 38),
(54, '2024_05_31_235058_create_packages_table', 39),
(55, '2024_05_31_235420_create_package_locations_table', 40),
(56, '2024_06_05_101831_create_system_settings_table', 41),
(57, '2024_06_05_105916_alter_packages_table_add_columns_countries_states_cities_after_package_type', 42),
(58, '2024_07_14_225043_create_routing_table', 43),
(59, '2024_08_01_084632_update_main_image_in_rooms_table', 44),
(60, '2024_08_01_113610_add_fees_to_attractions_table', 44),
(61, '2024_08_01_130414_add_city_to_conveyances_table', 45),
(62, '2024_08_05_084432_update_activities_table', 46),
(63, '2024_08_05_112357_update_packages_table', 47),
(64, '2024_08_05_112435_create_packages_days', 47),
(65, '2024_08_05_112559_create_packages_attractions', 47),
(66, '2024_08_05_112605_create_packages_hotels', 47),
(67, '2024_08_05_112624_create_packages_conveyance', 47),
(68, '2024_08_05_131551_add_new_fields_users_table', 47),
(69, '2024_08_06_080556_alter_users_table', 48),
(70, '2024_08_06_100254_create_customers_table', 49),
(71, '2024_08_07_060357_alter_users_table', 50),
(72, '2024_08_07_060833_rename_table_packages_day_to_packages_itinerary', 50),
(73, '2024_08_07_064143_alter_table_add_day_rename_column_packages_itinerary_id', 50),
(74, '2024_08_07_065004_alter_table_packages_conveyance_rename_column_day_column_packages_itinerary_id', 50),
(75, '2024_08_07_065124_alter_table_packages_hotels_rename_column_day_column_packages_itinerary_id', 50),
(76, '2024_08_07_081757_add_deleted_at_to_users_table', 51),
(77, '2024_08_07_083226_add_deleted_at_to_customers_table', 51),
(78, '2024_08_08_064228_alter_table_users_table', 52),
(79, '2024_08_08_071904_alter_table_users_table', 53),
(80, '2024_08_08_101449_alter_table_customers_table', 54),
(81, '2024_08_09_051504_alter_table_add_room_price_id_to_packages_hotels_table_after_room_id', 55),
(82, '2024_08_09_071020_alter_table_packages_itinerary_table', 55),
(83, '2024_08_09_071253_alter_table_hotels_table', 55),
(84, '2024_08_09_130641_modify_room_price_id_in_packages_hotels_table', 56),
(85, '2024_08_12_063641_create_user_types_table', 57),
(86, '2024_08_12_090940_create_timezones_table', 57),
(87, '2024_08_12_093330_create_settings_table', 57),
(88, '2024_08_13_053134_drop_settings_table', 58),
(89, '2024_08_13_053404_create_settings_table', 58),
(90, '2024_08_13_095650_alter_table_hotels_table', 59),
(91, '2024_08_16_113651_alter_table_routing_table', 60),
(92, '2024_08_16_114140_alter_table_packages_table', 60),
(93, '2024_08_16_114414_alter_table_packages_attractions_table', 60),
(94, '2024_08_16_114632_alter_table_packages_conveyance_table', 60),
(95, '2024_08_16_114803_alter_table_packages_hotels_table', 60),
(96, '2024_08_16_114940_alter_table_packages_itinerary_table', 60),
(97, '2024_08_19_093335_alter_table_packages_hotel_to_nullable', 61),
(98, '2024_08_20_102721_alter_table_attractions_table', 62),
(99, '2024_08_21_052336_alter_table_hotels_table', 63),
(100, '2024_08_21_123318_alter_table_packages_add_type_column', 64),
(101, '2024_08_22_120323_alter_table_packages_add_additional_columns', 65),
(102, '2024_08_22_121155_alter_table_packages_hotels_add_additional_columns', 65),
(103, '2024_08_23_074045_alter_table_packages_hotels_change_kids', 66),
(104, '2024_08_23_090847_alter_table_packages_add_pickup_drop_notes', 67),
(105, '2024_08_26_070108_alter_table_hotels_table', 68),
(106, '2024_08_26_070705_alter_table_hotel_access_points_table', 68),
(107, '2024_08_26_072614_alter_table_hotel_activities_table', 68),
(108, '2024_08_26_073046_alter_table_hotel_amenities_table', 68),
(109, '2024_08_26_073410_alter_table_hotel_attractions_table', 68),
(110, '2024_08_26_073651_alter_table_hotel_contacts_table', 68),
(111, '2024_08_26_073926_alter_table_hotel_images_table', 68),
(112, '2024_08_26_074130_alter_table_rooms_table', 68),
(113, '2024_08_26_114313_alter_table_packages_table', 69),
(114, '2024_08_27_075451_alter_table_packages_add_comment_status', 70),
(115, '2024_08_29_055325_alter_table_activities_table', 71),
(116, '2024_08_29_124118_alter_table_packages_hotels_add_discount_rate_column', 72),
(117, '2024_09_02_115153_create_tokens_table', 73),
(118, '2024_09_03_064325_alter_table_tokens_table', 73),
(119, '2024_09_10_052637_alter_table_hotels_table', 74),
(120, '2024_09_10_064403_alter_table_rooms_table', 75),
(121, '2024_09_12_051915_alter_table_activities_table', 76),
(122, '2024_09_18_060550_alter_table_hotels_table', 77),
(123, '2024_09_18_141817_create_hotel_meal_types_table', 77),
(124, '2024_09_19_053744_alter_table_hotels_table', 78),
(125, '2024_09_19_091635_alter_table_room_prices_table', 79),
(126, '2024_09_19_104841_alter_table_attractions_table', 80),
(127, '2024_09_19_065210_create_table_customer_packages', 81),
(128, '2024_09_19_113513_alter_table_packages_add_comment_package_types', 81),
(129, '2024_09_19_130222_alter_table_packages_add_daterange', 81),
(130, '2024_09_20_074046_alter_table_cusomer_package_add_daterange', 82),
(131, '2024_09_23_070216_alter_table_cities_table', 83),
(132, '2024_09_23_100500_add_extra_fields_to_activities_table', 84),
(133, '2024_09_23_101603_add_extra_fields_to_attractions_table', 84),
(134, '2024_09_23_125627_create_restaurants_table', 85),
(135, '2024_09_25_072438_add_youtube_link_and_image_to_locations_table', 86),
(136, '2024_09_25_090534_add_default_selling_price_to_rooms_table', 87),
(137, '2024_09_25_095147_alter_table_hotels_table', 88),
(138, '2024_09_25_121400_alter_table_attractions_table', 88),
(139, '2024_09_26_041705_alter_table_activities_table', 88),
(140, '2024_09_26_045032_alter_table_conveyances_table', 88),
(141, '2024_09_26_113418_alter_table_conveyances_table', 89),
(142, '2024_09_27_054517_alter_table_rooms_table', 90),
(143, '2024_09_27_062857_alter_table_restaurants_table', 91),
(144, '2024_09_26_123331_remove_fields_from_room_price_table', 92),
(145, '2024_09_30_071836_create_room_prices_meal_types_table', 92),
(146, '2024_10_03_100609_alter_table_customer_package_add_status', 93),
(147, '2024_10_03_100635_create_tabale_customer_package_comments', 93),
(148, '2024_10_03_114718_alter_table_packages_parent_package_id', 93),
(149, '2024_10_03_130201_alter_table_routing_table', 94),
(150, '2024_09_30_125952_create_room_prices_dates_table', 95),
(151, '2024_10_01_125425_remove_extra_fields_from_room_prices_meal_types_table', 95),
(152, '2024_10_01_125758_add_extra_fields_to_room_prices_table', 95),
(153, '2024_10_07_085053_alter_table_hotel_settings_table', 96),
(154, '2024_10_08_070902_alter_table_conveyances_table', 97),
(155, '2024_10_08_113224_alter_table_attractions_table', 98),
(156, '2024_10_08_113533_alter_table_activities_table', 98),
(157, '2024_10_09_063920_alter_table_attractions_table', 99),
(158, '2024_10_09_071714_alter_table_activities_table', 100),
(159, '2024_10_09_114104_alter_table_routing_ad_extra_feilds', 101),
(160, '2024_10_10_052126_creat_table_routing_dates', 102),
(161, '2024_10_10_071944_add_double_occupancy_and_kids_without_bed_to_room_prices_meal_types_table', 103),
(162, '2024_10_10_121217_alter_table_routing_add_table_parent_routing_id', 104),
(163, '2024_10_10_044644_alter_table_routing_table', 105),
(164, '2024_10_14_061516_alter_table_hotel_settings_table', 106),
(165, '2024_10_15_051432_alter_table_packages_conveyance_table', 107),
(166, '2024_10_17_051238_alter_table_routing_table', 108),
(167, '2024_10_17_084941_alter_table_packages_table', 109),
(168, '2024_10_17_071613_add_meal_type_id_to_packages_hotels_table', 110),
(169, '2024_10_25_100411_alter_table_packages_table', 111),
(170, '2024_11_04_062115_create_modules_table', 112),
(171, '2024_11_04_124612_create_modules_permissions_table', 113),
(172, '2024_11_14_062733_add_franchise_id_to_usercontroller_table', 114),
(173, '2024_11_21_095810_create_seasons_table', 115),
(174, '2024_11_21_124740_create_seasons_dates_table', 115),
(175, '2024_11_22_053723_modify_city_id_in_seasons_table', 116),
(176, '2024_11_22_121656_add_what_we_provide_and_instructions_to_activities_table', 117),
(177, '2024_11_25_084017_add_buying_price_to_module_permissions_table', 118),
(178, '2024_11_26_081012_alter_room_prices_remove_name_and_dates_add_season_id', 119),
(179, '2024_11_26_093845_alter_routing_remove_name_and_dates_add_season_id', 119),
(180, '2024_11_27_062346_add_currency_code_to_countries_table', 120),
(181, '2024_11_27_120121_add_currency_to_room_prices_table', 121),
(182, '2024_11_28_044650_add_currency_to_activities_table', 122),
(183, '2024_11_28_071513_add_currency_to_attractions_table', 122),
(184, '2024_11_28_085101_add_currency_to_hotels_table', 123),
(185, '2024_11_26_153318_create_content_managment_systems_table', 124),
(186, '2024_11_29_065759_change_city_id_column_type_in_seasons_table', 125),
(187, '2024_11_29_071338_add_b2b_agent_to_conveyances_table', 125),
(188, '2024_12_02_092015_alter_packages_table', 126),
(189, '2024_12_02_130802_create_transactions_table', 127),
(190, '2024_12_03_090005_add_enq_id_to_transactions_table_later', 127),
(191, '2024_12_04_054257_update_transactions_table', 128),
(192, '2024_12_04_075846_add_inclusions_exclusions_air_itinerary_to_packages_table', 129),
(193, '2024_12_05_060123_alter_table_countries_table', 130),
(194, '2024_12_05_065510_alter_table_customers_table', 131),
(195, '2024_12_05_060358_alter_routing_table_remove_and_add_season_id', 132),
(196, '2024_12_09_134220_update_air_itenary_field_in_packages_table', 133),
(197, '2024_12_10_091253_alter_packages_table_add_package_validity', 134),
(198, '2024_12_06_065902_alter_table_customer_packages_table', 135),
(199, '2024_12_11_130603_update_add_air_itinerary_fields', 136),
(200, '2024_12_19_065133_add_addons_to_packages_attractions_table', 137),
(201, '2024_12_27_113516_alter_packages_hotel_add_count_feilds', 138),
(202, '2025_01_06_125258_make_email_nullable_in_customers_table', 139),
(203, '2025_01_14_071546_create_packages_currency_table', 140),
(204, '2025_01_16_091641_create_franchise_table', 141),
(205, '2025_01_22_062947_alter_packages_itenerary_table', 142),
(206, '2025_01_23_130947_alter_customer_package_comments_table', 143),
(207, '2025_01_23_131157_alter_customer_packages_table', 143),
(208, '2025_01_23_152423_alter_transaction_table', 144),
(209, '2025_01_23_153534_alter_customer_packages_change_type_table', 144),
(210, '2025_01_23_153758_alter_customer_package_comments_change_type_table', 144),
(211, '2025_01_24_105703_rename_status_in_transactions_table', 145),
(212, '2025_01_27_181633_add_confirm_at_to_customer_packages_table', 146),
(213, '2025_01_28_114854_create_followup_table', 147),
(214, '2025_01_28_143922_alter_amount_in_transactions_table', 148),
(215, '2025_01_29_154320_alter_customer_packages_table', 149),
(216, '2025_01_30_135842_alter_transactions_table', 150),
(217, '2025_02_03_175425_customer_packages_table', 151),
(218, '2025_02_03_183653_customer_package_comments_table', 152),
(219, '2025_02_03_184135_rename_column_in_customer_package_comments_table', 152),
(220, '2025_02_07_103123_create_packages_categories_table', 153),
(221, '2025_02_07_194334_create_packages_metadata', 154),
(222, '2025_02_10_165252_alter_enquiry_table', 155),
(223, '2025_02_12_123929_create_package_tags_table', 156),
(224, '2025_02_12_141401_remove_tags_for_website_from_packages_metadata', 156),
(225, '2025_02_14_141233_create_api_keys_table', 157),
(226, '2025_02_18_165505_alter_followups_table', 158),
(227, '2025_02_19_190845_drop_followup_logs_table', 159),
(228, '2025_02_19_191825_create_followup_logs_table', 159),
(229, '2025_02_21_095551_add_columns_to_followup_logs_table', 160),
(230, '2025_02_21_102450_add_mobile_to_followup_table', 161),
(231, '2025_02_25_214348_add_operations_field_to_enquiry_table', 162),
(232, '2025_02_26_151822_create_billing_table', 163),
(233, '2025_02_28_171015_add_meta_fields_to_routing_table', 164),
(234, '2025_03_03_170637_create_currency_conversion_table', 165),
(235, '2025_03_05_174831_create_packages_summary', 166),
(236, '2025_03_07_094904_drop_packages_summary_table', 167),
(237, '2025_03_07_095312_create_packages_summary', 168),
(238, '2025_03_07_150212_create_otps', 169),
(239, '2025_03_12_120406_add_alternate_name_and_masking_to_hotels_table', 170),
(240, '2025_03_12_185051_alter_table_packages_metadata', 171),
(241, '2025_03_18_084131_add_date_of_birth_to_customers_table', 172),
(242, '2025_03_24_152917_add_sort_order_to_rooms_table', 173),
(243, '2025_03_25_111840_add_cc_email_to_users_table', 174),
(244, '2025_03_25_142108_rename_date_of_birth_to_dob_in_customers_table', 175),
(245, '2025_03_25_133902_add_address_to_franchise_table', 176),
(246, '2025_04_03_123920_add_discount_to_enquiry_table', 177),
(247, '2025_04_04_160718_add_discount_to_packages_metadata_table', 178),
(248, '2025_04_08_142157_add_account_detail_to_franchise_table', 179);

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint UNSIGNED NOT NULL,
  `module_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `module_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Hotels', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(2, 'Rooms', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(3, 'Rooms Prices', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(4, 'Routing', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(5, 'Packages', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(6, 'Enquiries', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(7, 'Customers', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(8, 'B2B Partners', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(9, 'Franchise', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(10, 'Seasons', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(11, 'Billing', '1', '2025-02-27 16:07:05', '2025-02-27 16:07:05'),
(12, 'Attractions', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(13, 'Activities', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(14, 'CMS', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(15, 'API Key Management', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(16, 'Categories', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(17, 'Amenities', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(18, 'Locations', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(19, 'Countries', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(20, 'Cities', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(21, 'Restaurants', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(22, 'Conveyance Providers', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(23, 'Conveyance Types', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(24, 'Meal Type', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(25, 'Property Type', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(26, 'Hotel Groups', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(27, 'Hotel Star Rating', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(28, 'Room Bed Type', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(29, 'Room Type', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(30, 'Room Occupancy', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(31, 'General Transactions', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(32, 'General Followup', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(33, 'System User', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(34, 'Sales Report', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(35, 'Revenue Report', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(36, 'Enquiries Report', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(37, 'Credit & Debit Report', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(38, 'Followups Report', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06'),
(39, 'Incentive Report', '1', '2025-02-27 16:07:06', '2025-02-27 16:07:06');

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

--
-- Table structure for table `modules_permissions`
--

CREATE TABLE `modules_permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `module_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `user_type_id` bigint UNSIGNED NOT NULL,
  `user_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `add` bigint UNSIGNED NOT NULL DEFAULT '0',
  `edit` bigint UNSIGNED NOT NULL DEFAULT '0',
  `view` bigint UNSIGNED NOT NULL DEFAULT '0',
  `buying_price` bigint NOT NULL DEFAULT '0',
  `delete` bigint UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `modules_permissions`
--

INSERT INTO `modules_permissions` (`id`, `module_id`, `user_id`, `user_type_id`, `user_type_name`, `add`, `edit`, `view`, `buying_price`, `delete`, `created_at`, `updated_at`) VALUES
(203, 1, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(204, 2, 3, 1, 'SuperAdmin', 1, 1, 0, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(205, 3, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(206, 4, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(207, 5, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(208, 6, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(209, 7, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(210, 8, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(211, 9, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(212, 10, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(213, 11, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(214, 12, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(215, 13, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(216, 14, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(217, 15, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(218, 16, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(219, 17, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(220, 18, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(221, 19, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(222, 20, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(223, 21, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(224, 22, 3, 1, 'SuperAdmin', 1, 1, 1, 0, 1, '2024-11-20 09:05:46', '2024-11-20 09:05:46'),
(259, 5, 3, 2, 'Admin', 1, 0, 1, 0, 0, '2024-11-21 10:04:08', '2024-11-21 10:04:08'),
(260, 1, 3, 2, 'Admin', 0, 1, 1, 0, 1, '2024-11-21 10:04:08', '2024-11-21 10:04:08'),
(261, 22, 3, 2, 'Admin', 0, 1, 1, 0, 0, '2024-11-21 10:04:08', '2024-11-21 10:04:08'),
(262, 23, 3, 2, 'Admin', 0, 1, 1, 0, 0, '2024-11-21 10:04:08', '2024-11-21 10:04:08'),
(263, 21, 3, 2, 'Admin', 0, 0, 1, 0, 0, '2024-11-21 10:04:08', '2024-11-21 10:04:08'),
(264, 24, 3, 2, 'Admin', 0, 0, 1, 0, 0, '2024-11-21 10:04:08', '2024-11-21 10:04:08'),
(421, 1, 3, 5, 'Hotel Users', 1, 1, 1, 0, 1, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(422, 2, 3, 5, 'Hotel Users', 1, 1, 1, 0, 1, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(423, 3, 3, 5, 'Hotel Users', 1, 1, 1, 0, 1, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(424, 6, 3, 5, 'Hotel Users', 1, 1, 1, 0, 1, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(425, 13, 3, 5, 'Hotel Users', 1, 1, 1, 0, 1, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(426, 21, 3, 5, 'Hotel Users', 1, 0, 0, 0, 0, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(427, 24, 3, 5, 'Hotel Users', 1, 0, 0, 0, 0, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(428, 9, 3, 5, 'Hotel Users', 0, 1, 0, 0, 1, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(429, 10, 3, 5, 'Hotel Users', 0, 1, 1, 0, 1, '2024-12-07 18:03:00', '2024-12-07 18:03:00'),
(539, 1, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(540, 2, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(541, 3, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(542, 4, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(543, 5, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(544, 6, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(545, 7, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(546, 8, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(547, 9, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(548, 10, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(549, 11, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(550, 12, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(551, 13, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(552, 14, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(553, 15, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(554, 16, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(555, 17, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(556, 18, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(557, 19, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(558, 20, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(559, 21, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(560, 22, 3, 8, 'Account Manager', 1, 1, 1, 1, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(561, 23, 3, 8, 'Account Manager', 1, 1, 1, 0, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(562, 24, 3, 8, 'Account Manager', 1, 1, 1, 0, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(563, 25, 3, 8, 'Account Manager', 1, 1, 1, 0, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(564, 26, 3, 8, 'Account Manager', 1, 1, 1, 0, 1, '2025-01-22 05:57:28', '2025-01-22 05:57:28'),
(614, 1, 3, 7, 'Franchise Admin', 1, 1, 1, 0, 1, '2025-02-13 17:35:23', '2025-02-13 17:35:23'),
(615, 4, 3, 7, 'Franchise Admin', 1, 1, 1, 0, 1, '2025-02-13 17:35:23', '2025-02-13 17:35:23'),
(616, 5, 3, 7, 'Franchise Admin', 1, 1, 1, 0, 1, '2025-02-13 17:35:23', '2025-02-13 17:35:23'),
(617, 11, 3, 7, 'Franchise Admin', 1, 1, 1, 0, 1, '2025-02-13 17:35:23', '2025-02-13 17:35:23'),
(618, 28, 3, 7, 'Franchise Admin', 1, 1, 1, 0, 1, '2025-02-13 17:35:23', '2025-02-13 17:35:23'),
(619, 6, 3, 7, 'Franchise Admin', 0, 1, 1, 0, 1, '2025-02-13 17:35:23', '2025-02-13 17:35:23'),
(1086, 1, 3, 4, 'B2B Users', 1, 1, 1, 1, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1087, 2, 3, 4, 'B2B Users', 1, 1, 1, 1, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1088, 3, 3, 4, 'B2B Users', 1, 1, 1, 1, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1089, 6, 3, 4, 'B2B Users', 1, 1, 1, 0, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1090, 9, 3, 4, 'B2B Users', 1, 1, 1, 0, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1091, 18, 3, 4, 'B2B Users', 1, 1, 1, 1, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1092, 19, 3, 4, 'B2B Users', 1, 1, 1, 1, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1093, 22, 3, 4, 'B2B Users', 1, 0, 1, 0, 0, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1094, 23, 3, 4, 'B2B Users', 1, 0, 0, 0, 0, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1095, 28, 3, 4, 'B2B Users', 1, 1, 1, 1, 1, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1096, 4, 3, 4, 'B2B Users', 0, 1, 1, 0, 0, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1097, 5, 3, 4, 'B2B Users', 0, 0, 1, 0, 0, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1098, 14, 3, 4, 'B2B Users', 0, 0, 1, 1, 0, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1099, 15, 3, 4, 'B2B Users', 0, 0, 1, 1, 0, '2025-02-17 13:14:34', '2025-02-17 13:14:34'),
(1800, 1, 3, 3, 'Corporate Users', 1, 1, 1, 1, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1801, 3, 3, 3, 'Corporate Users', 1, 1, 1, 0, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1802, 4, 3, 3, 'Corporate Users', 1, 1, 1, 1, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1803, 5, 3, 3, 'Corporate Users', 1, 1, 1, 0, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1804, 6, 3, 3, 'Corporate Users', 1, 1, 1, 0, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1805, 14, 3, 3, 'Corporate Users', 1, 1, 1, 0, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1806, 16, 3, 3, 'Corporate Users', 1, 1, 1, 0, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1807, 26, 3, 3, 'Corporate Users', 1, 1, 1, 1, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1808, 28, 3, 3, 'Corporate Users', 1, 1, 1, 1, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1809, 30, 3, 3, 'Corporate Users', 1, 0, 1, 0, 0, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1810, 31, 3, 3, 'Corporate Users', 1, 0, 1, 0, 0, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1811, 33, 3, 3, 'Corporate Users', 1, 1, 1, 1, 1, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1812, 2, 3, 3, 'Corporate Users', 0, 0, 1, 1, 0, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(1813, 29, 3, 3, 'Corporate Users', 0, 0, 1, 0, 0, '2025-02-19 13:34:55', '2025-02-19 13:34:55'),
(2280, 4, 3, 6, 'CSE', 1, 1, 1, 1, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2281, 5, 3, 6, 'CSE', 1, 1, 1, 1, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2282, 6, 3, 6, 'CSE', 1, 1, 1, 1, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2283, 11, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2284, 12, 3, 6, 'CSE', 1, 1, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2285, 13, 3, 6, 'CSE', 1, 1, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2286, 14, 3, 6, 'CSE', 1, 1, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2287, 16, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2288, 17, 3, 6, 'CSE', 1, 1, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2289, 18, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2290, 19, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2291, 20, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2292, 21, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2293, 22, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2294, 23, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2295, 24, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2296, 25, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2297, 26, 3, 6, 'CSE', 1, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2298, 27, 3, 6, 'CSE', 1, 1, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2299, 28, 3, 6, 'CSE', 1, 1, 1, 1, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2300, 33, 3, 6, 'CSE', 1, 1, 1, 0, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2301, 34, 3, 6, 'CSE', 1, 1, 1, 0, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2302, 35, 3, 6, 'CSE', 1, 1, 1, 0, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2303, 37, 3, 6, 'CSE', 1, 1, 1, 0, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2304, 8, 3, 6, 'CSE', 0, 1, 1, 1, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2305, 10, 3, 6, 'CSE', 0, 1, 1, 0, 1, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2306, 15, 3, 6, 'CSE', 0, 1, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2307, 1, 3, 6, 'CSE', 0, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2308, 2, 3, 6, 'CSE', 0, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2309, 9, 3, 6, 'CSE', 0, 0, 1, 0, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2310, 30, 3, 6, 'CSE', 0, 0, 1, 1, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56'),
(2311, 31, 3, 6, 'CSE', 0, 0, 1, 1, 0, '2025-03-17 10:29:56', '2025-03-17 10:29:56');

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

--
-- 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,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint NOT NULL,
  `member_id` int DEFAULT NULL,
  `invoice_number` varchar(50) DEFAULT NULL,
  `amount` varchar(15) DEFAULT NULL,
  `discount` varchar(5) DEFAULT NULL,
  `tax` varchar(10) DEFAULT NULL,
  `paid_on` date DEFAULT NULL,
  `status` tinyint DEFAULT '1',
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `member_id`, `invoice_number`, `amount`, `discount`, `tax`, `paid_on`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, '5768', '5768', NULL, NULL, '2025-05-04', 1, '2025-05-04 17:13:15', '2025-05-04 17:13:15', NULL),
(2, 2, '2222', '333', NULL, NULL, '2025-05-04', 1, '2025-05-04 17:13:59', '2025-05-04 17:13:59', NULL);

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` int NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `duration_months` varchar(10) DEFAULT NULL,
  `price` varchar(10) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('HFZuRB2buuzhPfoD7sqbXqYAJ2fCShGNy52iW4iU', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVGIxZ21jdzBQbHB0aDZvSVk3Snd2aWlHdjY0Sm91RklQcXdIeEhDMyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1MzoiaHR0cDovL2xvY2FsaG9zdDo4MDAwL2FkbWluL3BhY2thZ2VzL2l0ZW5hcnkvY3JlYXRlLzQiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMzoiaHR0cDovL2xvY2FsaG9zdDo4MDAwL2FkbWluL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1718099208),
('Mzuwh45Tr1IjEoF4FeBWnbqzSzWSUnNo5NukbZFP', 2, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiOENXcm1ZTW9LNGgzdnk1a3RoTlJVak9jRmxlWHFlZHIwV3lxYXM2RSI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjUzOiJodHRwOi8vbG9jYWxob3N0OjgwMDAvYWRtaW4vcGFja2FnZXMvaXRlbmFyeS9jcmVhdGUvNCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjI7fQ==', 1717773830);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `soption` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svalue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `soption`, `svalue`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'name', 'Tripifyme', NULL, '2024-08-13 14:31:59', '2024-08-13 18:49:44'),
(2, 'phone', '9876543210', NULL, '2024-08-13 14:31:59', '2024-08-13 14:31:59'),
(3, 'email', 'anu.rajeev@subhosting.net', NULL, '2024-08-13 14:31:59', '2025-04-10 11:59:23'),
(4, 'address', 'Address', NULL, '2024-08-13 14:31:59', '2024-08-13 18:49:44'),
(5, 'timezone', '27', NULL, '2024-08-13 14:31:59', '2024-08-13 18:49:44'),
(6, 'logo', '', NULL, '2024-08-13 14:31:59', '2024-08-13 14:31:59'),
(7, 'invoiceserial', 'QA', NULL, '2025-04-04 12:24:08', '2025-04-04 14:01:57');

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

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `settings_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `settings_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `other_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `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 `system_settings`
--

INSERT INTO `system_settings` (`id`, `name`, `settings_key`, `settings_value`, `other_attributes`, `created_at`, `updated_at`) VALUES
(1, 'Railway Station', 'pick_up_drop_off', 'Railway Station', NULL, NULL, NULL),
(2, 'Bus Station', 'pick_up_drop_off', 'Bus Station', NULL, NULL, NULL),
(3, 'Auto/Taxi Stand', 'pick_up_drop_off', 'Auto/Taxi Stand', NULL, NULL, NULL),
(4, 'Air Port', 'pick_up_drop_off', 'Air Port', NULL, NULL, NULL),
(5, 'Landmark', 'pick_up_drop_off', 'Landmark', NULL, NULL, NULL),
(6, 'Other', 'pick_up_drop_off', 'Other', NULL, NULL, NULL);

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

--
-- Table structure for table `timezones`
--

CREATE TABLE `timezones` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abbreviation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offset` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diff_from_gmt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `timezones`
--

INSERT INTO `timezones` (`id`, `name`, `abbreviation`, `offset`, `diff_from_gmt`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Pacific/Midway', 'SST', '-11:00', 'GMT -11:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(2, 'Pacific/Pago_Pago', 'SST', '-11:00', 'GMT -11:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(3, 'Pacific/Honolulu', 'HST', '-10:00', 'GMT -10:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(4, 'America/Juneau', 'AKST', '-09:00', 'GMT -09:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(5, 'America/Los_Angeles', 'PST', '-08:00', 'GMT -08:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(6, 'America/Tijuana', 'PST', '-08:00', 'GMT -08:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(7, 'America/Denver', 'MST', '-07:00', 'GMT -07:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(8, 'America/Phoenix', 'MST', '-07:00', 'GMT -07:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(9, 'America/Chicago', 'CST', '-06:00', 'GMT -06:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(10, 'America/Mexico_City', 'CST', '-06:00', 'GMT -06:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(11, 'America/New_York', 'EST', '-05:00', 'GMT -05:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(12, 'America/Bogota', 'COT', '-05:00', 'GMT -05:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(13, 'America/Caracas', 'VET', '-04:00', 'GMT -04:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(14, 'America/Santiago', 'CLT', '-03:00', 'GMT -03:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(15, 'America/Argentina/Buenos_Aires', 'ART', '-03:00', 'GMT -03:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(16, 'Atlantic/Azores', 'AZOT', '-01:00', 'GMT -01:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(17, 'Europe/London', 'GMT', '+00:00', 'GMT', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(18, 'Europe/Paris', 'CET', '+01:00', 'GMT +01:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(19, 'Europe/Bucharest', 'EET', '+02:00', 'GMT +02:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(20, 'Africa/Johannesburg', 'SAST', '+02:00', 'GMT +02:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(21, 'Asia/Jerusalem', 'IST', '+02:00', 'GMT +02:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(22, 'Asia/Riyadh', 'AST', '+03:00', 'GMT +03:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(23, 'Asia/Baghdad', 'AST', '+03:00', 'GMT +03:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(24, 'Asia/Dubai', 'GST', '+04:00', 'GMT +04:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(25, 'Asia/Kabul', 'AFT', '+04:30', 'GMT +04:30', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(26, 'Asia/Karachi', 'PKT', '+05:00', 'GMT +05:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(27, 'Asia/Kolkata', 'IST', '+05:30', 'GMT +05:30', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(28, 'Asia/Kathmandu', 'NPT', '+05:45', 'GMT +05:45', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(29, 'Asia/Dhaka', 'BST', '+06:00', 'GMT +06:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(30, 'Asia/Jakarta', 'WIB', '+07:00', 'GMT +07:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(31, 'Asia/Shanghai', 'CST', '+08:00', 'GMT +08:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(32, 'Asia/Tokyo', 'JST', '+09:00', 'GMT +09:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(33, 'Australia/Sydney', 'AEDT', '+10:00', 'GMT +10:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11'),
(34, 'Pacific/Auckland', 'NZDT', '+13:00', 'GMT +13:00', NULL, '2024-08-13 11:17:11', '2024-08-13 11:17:11');

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

--
-- Table structure for table `tokens`
--

CREATE TABLE `tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tokens`
--

INSERT INTO `tokens` (`id`, `user_id`, `token`, `type`, `expires_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 26, 'H8Wy45WgcGaqj9AOHwYWCxWlmHJiUG37Pmm6CpojAeSqDk9x2wp5EEdSxlef', 'forgot_password', '2024-09-03 17:35:35', '2024-09-03 15:35:35', '2024-09-03 15:35:35', NULL),
(2, 35, 'tqzp8pWJLWlqgvhN95urPwaN2upC8dotclm9dAnXLhQFy5qJWaScBexVGswv', 'forgot_password', '2025-01-20 13:32:22', '2025-01-20 13:31:17', '2025-01-20 13:32:22', '2025-01-20 13:32:22'),
(3, 35, 'edOyFB9ZpBl9geIzhmxaa58OyXCyol5agOxRzghqsPjHFjJwNbemubcnSmOd', 'forgot_password', '2025-01-20 15:35:09', '2025-01-20 13:35:09', '2025-01-20 13:35:09', NULL),
(4, 35, 'RmOLI3MVtn1d0yhIr3Pn1OdSSMvxjRkDMqUd7vopWyHtAfZOjdDFhkGIWQeY', 'forgot_password', '2025-01-20 15:35:40', '2025-01-20 13:35:40', '2025-01-20 13:35:40', NULL),
(5, 50, 'D5TSIqKfHy0mwR8a5sVU7zuSqeh1Ko85D5rHYXhlRjFQuKhrGX5ODMrTgleJ', 'forgot_password', '2025-01-22 07:54:27', '2025-01-22 05:54:27', '2025-01-22 05:54:27', NULL),
(6, 26, 'VwjNO5TSX7le6klDLglPsDkFMaXgSlWlEoOWSi5jSbfJDMictUSImN8CF4s1', 'forgot_password', '2025-01-22 06:18:57', '2025-01-22 06:12:39', '2025-01-22 06:18:57', '2025-01-22 06:18:57'),
(7, 3, 'u4xgABf3I6asNzEc66ZDM2lobjFnnewREqOUDISG2HuZaOBeF2WlGQuGznUk', 'forgot_password', '2025-02-25 20:31:59', '2025-02-25 18:31:59', '2025-02-25 18:31:59', NULL),
(8, 3, 'OBga8bMAXzisyJ6xgxvxLbtNHkehJlz1tqusjpYgvyBdzzpy2irTkVwEBcoS', 'forgot_password', '2025-02-26 12:44:14', '2025-02-26 10:44:14', '2025-02-26 10:44:14', NULL),
(9, 3, 'DKeAXoqdCLHcCKuG7cNr9JAxT8l7up0avm06PYcRPuvNDVoWEfe35t4AAfk6', 'forgot_password', '2025-02-26 12:44:53', '2025-02-26 10:44:53', '2025-02-26 10:44:53', NULL),
(10, 26, 'bYiS3wTzpQ4ZYJOPbaAGA01FsgbFc3PdI9sfdm4noDZdycNbtZC2fq2bcJEk', 'forgot_password', '2025-02-26 05:19:16', '2025-02-26 10:47:43', '2025-02-26 10:49:16', '2025-02-26 10:49:16'),
(11, 26, '0QbeU11pqSaF0FjN5FhM92aviau01biElu1AkkUTO5YDnvpevVi8brO9PzEM', 'forgot_password', '2025-02-26 12:51:17', '2025-02-26 10:51:17', '2025-02-26 10:51:17', NULL),
(12, 26, 'vC2LysBa53XD3gCHUtlesmSckLnQCRcpu4mIJyz27RPPom8ni7gh4EgqqIJg', 'forgot_password', '2025-02-26 05:26:54', '2025-02-26 10:51:47', '2025-02-26 10:56:54', '2025-02-26 10:56:54'),
(13, 26, '7QEY9n6CH2bwOCo0qQz0hvbNRgONXay8O0VAyLqvjhMvDicIkQKEQRmrJGhQ', 'forgot_password', '2025-02-26 12:52:32', '2025-02-26 10:52:32', '2025-02-26 10:52:32', NULL),
(14, 26, 'SLf7AuGxqJIvi3XzO4YuYKNOsw9imPJepEIlYTOF2venxnzGSaTFR0AQZK2B', 'forgot_password', '2025-02-26 12:53:33', '2025-02-26 10:53:33', '2025-02-26 10:53:33', NULL),
(15, 26, 'hvH5yHANahiGFv4F7EwVvJn1BIdeAiDAtDr0Yzq6JnUWbwiS5zYSzHD7QZlO', 'forgot_password', '2025-02-26 05:26:25', '2025-02-26 10:55:47', '2025-02-26 10:56:25', '2025-02-26 10:56:25'),
(16, 26, 'XZrTX5efho3l74L2I5DB39IZq1LESUv9EgkhVG308br9mRLQ9QziOZfTxjq2', 'forgot_password', '2025-02-26 12:57:17', '2025-02-26 10:57:17', '2025-02-26 10:57:17', NULL),
(17, 26, 'U1QVkuWa23rosnruXgQMvZAzf2uiKixQEwSzz71cAhj24Ejs237m5iV1ogFu', 'forgot_password', '2025-02-26 12:58:23', '2025-02-26 10:58:23', '2025-02-26 10:58:23', NULL),
(18, 26, 'ujuuR4eox2z6DreOh7ggOeyXKPY9ifiyI08aiSArIzDgDWRj5EsAvw25ak5A', 'forgot_password', '2025-02-26 13:00:08', '2025-02-26 11:00:08', '2025-02-26 11:00:08', NULL),
(19, 26, 'utST5QK4T03EnJzgdIo72bqLBEgyYZXR88dEO8blXFP8ZbA2pFYhq8JGqhpr', 'forgot_password', '2025-02-26 05:30:52', '2025-02-26 11:00:35', '2025-02-26 11:00:52', '2025-02-26 11:00:52'),
(20, 26, '9BK20GzSOTovTAYpSbys7ceOS1OFZStlp3knRb8k8LZ1wiIul9tRhZohJSVv', 'forgot_password', '2025-02-26 07:04:37', '2025-02-26 11:47:20', '2025-02-26 12:34:37', '2025-02-26 12:34:37'),
(21, 3, 'NXYoGD015XzXtzyRMt7FeGXB67VOP4LJDVhNm5mIiVPvXokWa00frGcZ3mQS', 'forgot_password', '2025-02-26 14:33:11', '2025-02-26 12:33:11', '2025-02-26 12:33:11', NULL),
(22, 26, 'eIExL1a3DvoLO9xDZZzMRAGV2CSKFBnqKqC38YStWNaZF6EtMId08cZ7E0lQ', 'forgot_password', '2025-02-26 07:05:22', '2025-02-26 12:35:08', '2025-02-26 12:35:22', '2025-02-26 12:35:22'),
(23, 3, 'nMXpqYWLaXb02bXiq0rLdVPiljT3bR7RusJCVzzzXKusWSw0X5xWKteAfsR4', 'forgot_password', '2025-02-27 12:51:12', '2025-02-27 10:51:12', '2025-02-27 10:51:12', NULL),
(24, 26, 'X2Kil1Ai35fmNZEcLzB0C6E4yCpoKlbPTv9AwS9xAHVu94kqdn8CYos4H5ut', 'forgot_password', '2025-02-27 19:45:59', '2025-02-27 17:45:59', '2025-02-27 17:45:59', NULL),
(25, 17, 'hb5yIWIyQwKx89UaExeRfy0UxCzG5pR9IxYMhPrvANBCUtltUPdNXpwaKeIa', 'forgot_password', '2025-03-17 12:31:49', '2025-03-17 10:31:49', '2025-03-17 10:31:49', NULL);

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

--
-- Table structure for table `trainers`
--

CREATE TABLE `trainers` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(50) NOT NULL,
  `specialty` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `user_type` bigint NOT NULL DEFAULT '0',
  `franchise_id` bigint NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` 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 NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `discount_hotel` bigint DEFAULT NULL,
  `discount_package` bigint DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` bigint NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `user_type`, `franchise_id`, `name`, `mobile`, `email`, `email_verified_at`, `password`, `address`, `description`, `discount_hotel`, `discount_package`, `remember_token`, `image_path`, `created_at`, `updated_at`, `status`, `deleted_at`) VALUES
(1, 2, 0, 'Administrator', '9876543210', 'admin@admin.com', NULL, '$2y$12$cC9bVr2nLhfoNwU6ZygBwukZeeU.sDLlq5h9UHI9DJugC0CsDWpFO', 'testing', 'testing', 1, 1, NULL, '', NULL, '2024-08-06 18:52:43', 1, NULL),
(2, 2, 0, 'John Doe', '0123456789', 'john@example.com', NULL, '$2y$12$cC9bVr2nLhfoNwU6ZygBwukZeeU.sDLlq5h9UHI9DJugC0CsDWpFO', 'sddggsfdg', 'fdgdfgdf', 3, 2, '0AElX7NE82zBwW1pvPnZfFkJDONfnnmSDidF2Ici2KwITxPBOa0DNRZiAybh', '', '2024-05-14 11:29:58', '2024-08-06 18:09:25', 1, NULL),
(3, 1, 0, 'SuperAdmin', '9876543210', 'superadmin@tripifyme.com', NULL, '$2y$12$g1k17p236AOslv57igN2uebcDc4rXZBcoWmROXByzZaqLq.pXCrVG', 'testing', 'testing', NULL, NULL, 'LmqsJ6oOGvujrVCBKuYW15x8axR2scWe1fBePGrZX2uXHSxDfAYtciSfURUL', 'profile_pictures/3.jpg', NULL, '2024-08-09 17:32:44', 1, NULL),
(5, 2, 0, 'test', '1234567890', 'test@gmail.com', NULL, '$2y$12$wYkrpxVUjR2KhxWWMWdQvedvxa4sE1xIctmc9c39o1P5oEcSoZfzi', 'test', 'test', 3, 5, NULL, '', '2024-08-06 18:14:51', '2024-08-06 18:45:47', -1, NULL),
(6, 1, 0, 'test one', '12334345', 'testone@gmail.com', NULL, '$2y$12$zlWQoNKyZ8eP69ZlbRx.E.mlL1ASN4rjjRqbOlThqn328fCA.mQrC', 'test', 'test', 5, 3, NULL, '', '2024-08-06 18:17:07', '2024-08-06 18:59:36', 1, NULL),
(9, 1, 0, 'test', '1234567890', 'testtwo@gmail.com', NULL, '$2y$12$hObXibYH/TB9zTMElDJ3POuiWz4IeeV0uRevocvKUGyad6LRDP3JO', 'hhh', 'hhh', 3, 5, NULL, '', '2024-08-06 18:54:01', '2024-08-06 18:59:50', 0, NULL),
(13, 4, 0, 'test three', '1234567890', 'testthree@gmail.com', NULL, '$2y$12$zfFo5F5jXSJrBZbhdsay6uBI/eYjZPqvu.LmdKaN5UNPmiTm/z3Pa', 'testing', 'testing', 4, 6, NULL, '', '2024-08-07 10:12:42', '2025-01-30 12:21:40', 1, '2025-01-30 12:21:40'),
(16, 3, 5, 'test four', '1242344555', 'testfour@gmail.com', NULL, '$2y$12$EF2N.aLiebjbrJYQA0aZ3uB8pKFXPa6yjCKqRbbsiy0Ye2HmZy8Ym', 'testing', 'testing', 4, 3, NULL, '', '2024-08-08 10:23:17', '2025-01-30 13:42:00', 1, NULL),
(17, 6, 5, 'abin', '1354556676', 'qwe@gmail.com', NULL, '$2y$12$g1k17p236AOslv57igN2uebcDc4rXZBcoWmROXByzZaqLq.pXCrVG', 'bn', 'ghgh', NULL, NULL, NULL, NULL, '2024-08-09 17:31:37', '2025-01-31 18:28:26', 1, NULL),
(18, 4, 5, 'test six', '22323434545665', 'testsix@gmail.com', NULL, '$2y$12$g1k17p236AOslv57igN2uebcDc4rXZBcoWmROXByzZaqLq.pXCrVG', 'ghh', 'ttyuy', 0, 0, NULL, NULL, '2024-08-13 09:58:16', '2025-01-30 13:41:27', 1, NULL),
(19, 5, 0, 'joy', '434656577', 'testseven@gmail.com', NULL, '$2y$12$C0cChvH1yjS6aG/q.uaIeOUC2bvYLzcJbSL5h5a4Ig4hi177j.LhW', 'tftyy', 'fgfhg', 23, 34, NULL, NULL, '2024-08-13 10:03:07', '2024-08-13 10:03:07', 1, NULL),
(20, 4, 0, 'rtgtg', '233456', 'qw@example.com', NULL, '$2y$12$xnNElY3rInKxvHC8Jhgc6O9Bg9s2.w6WnZCvrrDdmF0vhKOqYRAby', 'uyjui', 'ooioi', 12, 3, NULL, NULL, '2024-08-19 13:22:54', '2024-08-26 17:33:41', 1, '2024-08-26 17:33:41'),
(23, 4, 34, 'ajay', '3546789999', 'ajay@gmail.com', NULL, '$2y$12$HGIR0olIHUcIDJUlaMegKu2GVokSv9n7ftSzaCjPkta82DyDHDaie', 'gggh', 'jjk', 0, 0, NULL, NULL, '2024-08-26 17:33:28', '2024-11-14 09:25:07', 1, NULL),
(24, 4, 0, 'amal', '43444666', 'ggyeu@gmail.com', NULL, '$2y$12$4JBGn8mYQtznBQ.m.VOkAOcliYc4jsYCLXO1B4nD/h/8RSTOat9wi', 'fddgfg', 'bhgh', 33, 44, NULL, NULL, '2024-08-29 19:39:23', '2024-08-29 19:39:23', 0, NULL),
(25, 2, 0, 'abin', '22323455656', 'xcv@gmail.com', NULL, '$2y$12$E9CuvHJ6jgeagXZ6Kl.lsuCgj/ak3A.waVnWu7a8IkgXSMk7YPKFy', 'vbfgghjh', 'rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrfddfgffggffgggggggggggggggggggggggeethghgjhhkhkkkhjghghfgfgffffffhtyygjgghggggg', NULL, NULL, NULL, NULL, '2024-08-30 10:59:08', '2024-11-20 09:07:45', 1, NULL),
(26, 6, 3, 'abi', '98077555533', 'waheficrage-5861@yopmail.com', NULL, '$2y$12$e2B0aH4al1OBV5FRXxj4e.9icnmEOQ0Wtj2uY0hrm.LsyFzOaH4dK', 'gyyyyr', 'yyyfy', NULL, NULL, 'r5KfnhBIsnb7O8DcmkY2vwDEr1ADMuB2rnaIyefOUxdtiQmnVaxI5ufIa0hk', NULL, '2024-08-30 17:12:47', '2025-03-24 15:43:53', 1, NULL),
(27, 4, 0, 'sona', '43545666778', 'rihabroibroda-4886@yopmail.com', NULL, '$2y$12$pVfhl9h/W/FeRW4foO5aqe1F0YhjndyJfV2F7WwJ/cyMquTFRnKF2', 'hhhhj', 'ghggggy', 20, 10, NULL, NULL, '2024-09-02 17:03:35', '2024-09-02 17:03:35', 0, NULL),
(28, 4, 0, 'Testb2bone', '9876543210', 'testb2bone@mail.com', NULL, '$2y$12$7RqHU1FdkLO98m9itmLJluQvZ7gwHYJy12YD85pFY95wg7b2.lxUS', 'testing', 'testing', 0, 10, NULL, NULL, '2024-09-19 12:03:48', '2024-09-19 12:03:48', 1, NULL),
(29, 3, 0, 'amal', '123455666', 'rty@gmail.com', NULL, '$2y$12$Oh.TENEH5ZuVf5KheaZ4QuYwtonzLOxzOT4wOLRmkbgMlVtCZG1Ne', NULL, NULL, 8, 10, NULL, NULL, '2024-09-20 16:02:13', '2024-09-20 16:02:13', 1, NULL),
(30, 3, 0, 'akash', '3444555666', 'vbn@gmail.com', NULL, '$2y$12$IuGqzhpW2N7HihBEciwEC.SngX7IfT8LoSTEmjOW4wtiURVaW3pxG', NULL, NULL, 10, 10, NULL, NULL, '2024-09-20 16:04:07', '2024-09-20 16:04:07', 1, NULL),
(31, 5, 0, 'anju', '2334455', 'jow@gmail.com', NULL, '$2y$12$HOSG7YahS0yyQeR3QyGNGeg2H1u7/unPZ1Hnh06iISiYkD9g8fNAi', 'ghhg', NULL, 10, 10, NULL, NULL, '2024-09-20 16:11:35', '2024-09-20 16:11:35', 1, NULL),
(32, 5, 0, 'dev', '4457777', 'bnm@gmail.com', NULL, '$2y$12$KmP7f73911svIx0DfuCIBOEWbdMb/9ry5hSzJKz238Cn0/ytFfdvC', NULL, NULL, 10, 10, NULL, NULL, '2024-09-20 16:12:42', '2024-09-20 16:12:42', 1, NULL),
(33, 7, 0, 'abin', '656788', 'ggtgy@gmail.com', NULL, '$2y$12$qojoP7tVUqAlhDv0p1W8Pu4YKt2RV1WX8/DqJ44Th8QQuT393sOLG', 'vvvc', 'vcv', 0, 0, NULL, NULL, '2024-11-06 04:40:11', '2024-11-19 08:35:17', 1, NULL),
(34, 7, 0, 'Five Star', '9947117411', 'fivestar@example.com', NULL, '$2y$12$KQVXr1yLt0hlsNyyQIshp.cLvisN85kSLR1tKbh84YQCEHdIODSO6', 'test address', 'test', 0, 0, NULL, NULL, '2024-11-14 09:24:24', '2024-11-14 09:24:24', 1, NULL),
(35, 2, 0, 'shaju', '1223345', 'vaddafittuxeu-9263@yopmail.com', NULL, '$2y$12$e9rZTgbbeNA547T1HMh6veeFvznyfqnfhLcrpIOgN.KPC33/312a.', 'test addresss', 'ffff', NULL, NULL, NULL, NULL, '2024-11-19 08:39:37', '2025-01-20 13:32:22', 1, NULL),
(36, 7, 0, 'arav', '334545', 'cricroiffevilleu-5790@yopmail.com', NULL, '$2y$12$K0Nf.ZNkgODu8SkR/SR7RegpFrCgShshCICjJ1kAfGXzZcY1V4L5y', 'fgfg', 'fgg', NULL, NULL, NULL, NULL, '2024-11-19 08:41:24', '2024-11-20 09:24:56', 1, NULL),
(37, 4, 5, 'remyaks', '4555555555556', 'xuttaubrofruve-4963@yopmail.com', NULL, '$2y$12$nMjBr0u9lnS9zCqe7gEwHewklbbsm1vDQ89kHZN59Q3xUfEIqJ6wq', 'abced\r\ntest one\r\nbranch no\r\n67899', 'fgfg', 0, 0, NULL, 'profile_pictures/37.jpg', '2024-11-19 08:45:04', '2025-04-10 11:26:45', 1, NULL),
(38, 4, 0, 'remya', '22354545', 'anurajevsubhosting@gmail.com', NULL, '$2y$12$NmHawFGPF7gwqqpj5H38Ruy4CPKpBLGuTlszrEOKUXtRh7tyMadr.', 'hgh', 'ggg', 0, 0, NULL, 'profile_pictures/38.jpeg', '2024-11-19 08:54:24', '2025-03-27 18:05:24', 1, NULL),
(39, 4, 36, 'jebin', '4545666', 'grautriqueummeussu-4134@yopmail.com', NULL, '$2y$12$uOn98YlOcIN1RDoiPQRybO7vPdVTAXMtfA8tseyqrdE9Dalz2x2Gi', 'gftrt', 'rtrt', 0, 0, NULL, NULL, '2024-11-20 08:32:23', '2024-11-20 08:39:19', 1, NULL),
(40, 7, 0, 'appu', '345555', 'pruffecracrugi-6906@yopmail.com', NULL, '$2y$12$FC26tqGcO5PfQIQTKziGCO8mdEAxNiH98kfSZFj.FiDqBiDA797dy', 'gfg', 'gg', 0, 0, NULL, NULL, '2024-11-20 10:23:45', '2024-11-20 10:23:45', 1, NULL),
(41, 8, 0, 'shebin', '567899', 'jerecotacra-7594@yopmail.com', NULL, '$2y$12$GQOAR9cdhYmFYimiG7c4eOWr98OEe1LFaHrZQOJlBVTQCgBULl1tC', 'vghn', 'fg', NULL, NULL, NULL, NULL, '2024-11-21 11:31:14', '2024-11-21 11:55:18', 0, NULL),
(42, 7, 0, 'COCO', '9072121217', 'mail@tripifyme.com', NULL, '$2y$12$U/MDdtbd6.TYDDKDXSvyQ.xJkAB9rNvvEzIIkr1AK2pXp3L1jgRu2', 'Second Floor Valamkottil Towers Thrikakkara Kakkanad 682021', 'Company Owned Company run Franchisee COCO', 0, 0, NULL, NULL, '2024-11-24 17:50:20', '2024-12-07 18:01:30', 1, NULL),
(43, 3, 0, 'rmya', '547777', 'rtuu@gmail.com', NULL, '$2y$12$JaTMdz8VDHFpajdYCcAtgeWadKgydMIeJ4MH3ebjjNRi9Ps2i.Ksm', 'ggg', 'hgh', 24, 44, NULL, NULL, '2024-11-26 11:16:50', '2024-11-26 11:16:50', 1, NULL),
(44, 4, 42, 'BestEscapes', '8261098033', 'bestescape.info@gmail.com', NULL, '$2y$12$3pamIacD5SOBewJbR858/eiYVow.fnUS5apo70JvqkXh/QFCvIpDS', 'Manali Mall road, HP', NULL, 0, 0, NULL, NULL, '2024-12-11 07:55:49', '2024-12-11 07:56:17', 1, NULL),
(45, 4, 42, 'Explosure Journey', '9149882007', 'explosurejourney@gmail.com', NULL, '$2y$12$jrs/F9PkY68okqsGZsUfZ.6nTgDuivhJTT.TYub0018j5MCVo1H4u', 'Srinagar, J&K', NULL, 0, 0, NULL, NULL, '2024-12-11 08:12:27', '2024-12-11 08:12:27', 1, NULL),
(46, 4, 42, 'Saji Alleppey', '8921177087', 'sajialpytripify@gmail.com', NULL, '$2y$12$YyE6KrNpSP2r7kll/jkrSuP8ES3SEBZ7GKAHkzgNWLeCSEanrmc/y', 'Alleppey, Kerala', NULL, 0, 0, NULL, NULL, '2024-12-13 06:30:37', '2024-12-13 06:30:37', 1, NULL),
(47, 4, 33, 'akhil', '990877274', 'akhil@gmail.com', NULL, '$2y$12$mwqWfzd6dVnZYSGLIxyn4epjoDNsDIfsvMqhc6laFxh16Dl4zg7tS', 'vgv', 'ffg', 0, 0, NULL, NULL, '2024-12-13 08:41:28', '2024-12-13 08:41:28', 1, NULL),
(48, 7, 3, 'Test edit', '9947117411', 'test@tripifyme.com', NULL, '$2y$12$7TjYNDvP2oNDWjZJbCGX0ekvyVyM5c4owFFgc91UqU8hMb3CAQFry', 'test address', 'test description', 12, 10, NULL, NULL, '2025-01-17 03:16:08', '2025-01-17 03:16:40', 1, NULL),
(49, 7, 3, 'test free', '557778', 'test900@gmail.com', NULL, '$2y$12$tudR9KAeZnki8ycvg4NlgOl.zxGa42OSlkQV0iHIIowozIj9GcWDe', NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-17 07:45:16', '2025-01-17 07:45:16', 1, NULL),
(50, 4, 0, 'Asha', '9887867876', 'ashalekshmi.radhamani@subhosting.net', NULL, '$2y$12$sy0ozSv83.aRyl.dxjRPc.SqmDP.uGLvqH1Rg0XIhZSR5Hn8.FqMS', NULL, NULL, 0, 0, NULL, 'profile_pictures/50.jpg', '2025-01-17 10:02:32', '2025-01-17 10:02:32', 1, NULL),
(51, 7, 3, 'lekshmi', '4556778', 'lekshmi@gmail.com', NULL, '$2y$12$mO66PV0pAzBAgdql7vpdcOc3Z5uAlum6mH/DoaxO4XpjoCv4IjT.O', NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-17 10:23:39', '2025-01-17 10:23:39', 1, NULL),
(52, 7, 3, 'lekshmi', '4556778', 'lekshmi12@gmail.com', NULL, '$2y$12$UguYoEImmCwRMyd6NHFEXOOkKUd.2eAnlH2iuo9iroxtYEcSRuBTW', NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-17 10:26:55', '2025-01-17 10:26:55', 1, NULL),
(53, 7, 3, 'Terms', '9947117411', 'terms@tripifyme.com', NULL, '$2y$12$CaWAgUlfqMZzO1sbl9HKmOAK9xstVjdrroeKwh6GMUM6CM95t0oly', 'test', 'test', NULL, NULL, NULL, NULL, '2025-01-17 10:45:01', '2025-01-17 13:33:48', 1, NULL),
(54, 3, 0, 'testi', '3456789', 'testi@gmail.com', NULL, '$2y$12$MeB.RQlI7zIX.zagLmcefO/EACbDBvtHsvGy4FaPZoWhoYtyyN4Ky', NULL, NULL, 56, 67, NULL, NULL, '2025-01-17 10:51:27', '2025-01-17 10:51:27', 1, NULL),
(55, 6, 3, 'ab', '5676787887', 'freyuquagubo-3454@yopmail.com', NULL, '$2y$12$Zc57ZOV3qtD3ulowxEveI.xV/QnuKZbbzP.0RzewrbDQUSgvv0Qmy', NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-17 11:17:29', '2025-02-26 17:21:29', 1, NULL),
(56, 4, 3, 'akku', '445455665', 'anurajeevsubhosting@gmail.com', NULL, '$2y$12$Ur72TsN5Fmz2RpsVQtxvhuQDlOptBYFq6Jzo2k2m55RYt2Or/9.nO', 'tyttftfyt', NULL, 0, 0, NULL, 'profile_pictures/56.jpeg', '2025-01-17 11:23:55', '2025-03-27 18:12:34', 1, NULL),
(57, 3, 0, 'kashi', '897658499', 'kashi@gmail.com', NULL, '$2y$12$qq1k.2RiRrH0uXOe6b1T0.GCkP1KEMhYDAKtvsLUj5bP2Hmmt1KQ2', NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-20 08:35:17', '2025-01-20 08:35:17', 1, NULL),
(58, 8, 0, 'kashi', '354677', 'kashi123@gmail.com', NULL, '$2y$12$k8O8oUTZvoIEa4poM0HY8u0FT9G9J7GEHePLKV9LTV7I5JnU6QhFK', NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-22 05:55:14', '2025-01-22 05:55:14', 1, NULL),
(59, 6, 5, 'reshmi', '78903099', 'reshmi@gmail.com', NULL, '$2y$12$vdpWp2cox6oTwEDKYw6.vuONTF/gSqUOitq8ei3zJdffTwtp8yPWm', NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-31 09:49:32', '2025-02-06 09:51:05', 1, NULL),
(60, 3, 3, 'rudra', '3234466', 'bolejekuke-5234@yopmail.com', NULL, '$2y$12$uLAzpp1MKaMG7pnNR4tazeGb30lJNPH/EMOyJvI27Npo46yq.GFda', 'ghbhghjhjh', NULL, 45, 32, NULL, NULL, '2025-01-31 10:44:58', '2025-03-26 10:12:53', 1, NULL),
(61, 6, 4, 'arun', '8907656655', 'creixeupannanno-4089@yopmail.com', NULL, '$2y$12$KHj7GWCAbP2I12orqg3foeR5/0ohReefvzNx8eLI2tvEvVgvWTpH2', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-06 09:52:24', '2025-02-26 17:18:57', 1, NULL),
(62, 6, 3, 'Testcseuser', '9947117411', 'pramod@gmail.com', NULL, '$2y$12$J2dpRqJKcOqAPT/9ES6P6.nAYo8Y4QjhAYvaXL.9yT7kUtqySM6qS', 'cxsxcxc', 'sfcsdfsdfds', NULL, NULL, NULL, NULL, '2025-02-07 14:38:08', '2025-02-07 14:38:08', 1, NULL),
(63, 2, 0, 'Aneeh 2', '9887670987', 'aneesh3@email.com', NULL, '$2a$10$LgJtPG/RXiHidD4O33.TROF17ZAiw6GtMH1nrUEy19N7AmXzvkqj6', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-15 07:10:47', '2025-02-15 07:10:47', 0, NULL),
(64, 2, 0, 'Aneeh 4', '9887670987', 'aneesh4@email.com', NULL, '$2a$10$nq87HScVeiTJ/fl9smXhLerYNpvAqU6qaBKqIXRmWkr9lGef/qYou', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-15 07:25:01', '2025-02-15 07:25:01', 0, NULL),
(65, 2, 0, 'Aneeh 7', '9887670987', 'aneesh7@email.com', NULL, '$2a$10$sAn.ZiHIPTtSmjf1aHleoub8i4HAwpq0Bo455B4Wr.DTJ5Qg0W1Gi', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-15 08:57:00', '2025-02-15 08:57:00', 0, NULL),
(67, 8, 0, 'account manager', '3465756465', 'creuquelluttudda-3226@yopmail.com', NULL, '$2y$12$f68cXCPqk6DpMQKm3ckRb.o6UuPWVfxZ/l/YZK3CBHwbAXNWjnEOK', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-17 13:25:24', '2025-02-17 13:29:03', 1, NULL),
(68, 2, 0, 'Aneeh 1', '9887670987', 'aneesh@email.com', NULL, '$2a$10$qPPESYpQ3J3/ShlSqPwg1.W7ppffyOmLCO/OQACVNFIgoarTFjng.', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-18 12:16:08', '2025-02-18 12:16:08', 0, NULL),
(69, 2, 0, 'Aneeh 1', '9887670987', 'aneesh_group_test@email.com', NULL, '$2a$10$aXVW1Kp2xUFispJNXsLFpOWZanS9YFkOf7MEd3mQV0vaOIlbuCwfO', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-19 09:45:57', '2025-02-19 09:45:57', 0, NULL),
(70, 2, 0, 'Aneeh 123', '9887670987', 'aneesh123@email.com', NULL, '$2a$10$ey3VUXYWozdDXWN7BdzkxuC/l/H8U6znR3Iml7ZnE5qyUggVROHPK', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-21 11:53:08', '2025-02-21 11:53:08', 0, NULL),
(71, 6, 3, 'krishna', '36553767979', 'anutest3051@gmail.com', NULL, '$2y$12$U1BqNawbSe15VEE6LfOMLe6Lv2lX/5.TFIyZ9gIebHj103WThzqAa', 'gdg', 'gdge', NULL, NULL, NULL, NULL, '2025-02-27 09:45:53', '2025-02-27 09:45:53', 1, NULL),
(72, 6, 4, 'chinnu', '3676545774757', 'anutest2824@gmail.com', NULL, '$2y$12$QL3Rjgn.ygdVntrhMBG9fOZD429Ve0GDTLLG8cm7Alvtf2mg0OBJm', 'fdgz', 'dhd', NULL, NULL, NULL, NULL, '2025-02-27 10:06:31', '2025-02-27 10:06:31', 1, NULL),
(73, 6, 7, 'test three', '464588865', 'testthree3@gmail.com', NULL, '$2y$12$.G8Rcq54gXqzK5Id6Yq42.iyPa1qHmFgjPtqMNXtVZ4nRQvocf22G', 'ff', 'ffffg', NULL, NULL, NULL, NULL, '2025-02-27 11:13:33', '2025-02-27 11:17:24', 1, '2025-02-27 11:17:24'),
(74, 4, 3, 'goutham', '545667', 'caricojafru-4553@yopmail.com', NULL, '$2y$12$Ejfy.kAwg0tvDOlLRoyOKeE9JkX4cdujOC64ciW7xVYsgHeMhHH8a', NULL, NULL, 0, 0, NULL, NULL, '2025-03-25 14:37:40', '2025-03-25 14:38:03', 1, NULL);

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

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` bigint UNSIGNED NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` (`id`, `code`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '1', 'SuperAdmin', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(2, '2', 'Admin', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(3, '3', 'Corporate Users', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(4, '4', 'B2B Users', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(5, '5', 'Hotel Users', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(6, '6', 'CSE', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(7, '7', 'Franchise Admin', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(8, '8', 'Account Manager', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57'),
(9, '9', 'POC', NULL, '2025-01-27 13:13:57', '2025-01-27 13:13:57');

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

--
-- Table structure for table `workout_plans`
--

CREATE TABLE `workout_plans` (
  `id` bigint NOT NULL,
  `member_id` int DEFAULT NULL,
  `plan_details` text,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  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 `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attendances`
--
ALTER TABLE `attendances`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `diet_plans`
--
ALTER TABLE `diet_plans`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `trainers`
--
ALTER TABLE `trainers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `workout_plans`
--
ALTER TABLE `workout_plans`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;
COMMIT;

