{ "{{TABLE_PREFIX}}latepoint_services": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_services` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `name` varchar(255) NOT NULL,\n `short_description` text DEFAULT NULL,\n `is_price_variable` tinyint(1) DEFAULT NULL,\n `price_min` decimal(20,4) DEFAULT NULL,\n `price_max` decimal(20,4) DEFAULT NULL,\n `charge_amount` decimal(20,4) DEFAULT NULL,\n `deposit_amount` decimal(20,4) DEFAULT NULL,\n `is_deposit_required` tinyint(1) DEFAULT NULL,\n `duration_name` varchar(255) DEFAULT NULL,\n `override_default_booking_status` varchar(255) DEFAULT NULL,\n `duration` int(11) NOT NULL,\n `buffer_before` int(11) DEFAULT NULL,\n `buffer_after` int(11) DEFAULT NULL,\n `category_id` int(11) DEFAULT NULL,\n `order_number` int(11) DEFAULT NULL,\n `selection_image_id` int(11) DEFAULT NULL,\n `description_image_id` int(11) DEFAULT NULL,\n `bg_color` varchar(20) DEFAULT NULL,\n `timeblock_interval` int(11) DEFAULT NULL,\n `capacity_min` int(4) DEFAULT NULL,\n `capacity_max` int(4) DEFAULT NULL,\n `status` varchar(20) NOT NULL,\n `visibility` varchar(20) NOT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n `earliest_possible_booking` varchar(50) DEFAULT NULL,\n `latest_possible_booking` varchar(50) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `category_id_index` (`category_id`),\n KEY `order_number_index` (`order_number`),\n KEY `status_index` (`status`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "name": "Personalized nutrition plans", "short_description": "", "is_price_variable": null, "price_min": "500.0000", "price_max": "500.0000", "charge_amount": "500.0000", "deposit_amount": "0.0000", "is_deposit_required": null, "duration_name": "", "override_default_booking_status": "", "duration": "60", "buffer_before": "5", "buffer_after": "10", "category_id": "0", "order_number": null, "selection_image_id": "91", "description_image_id": "0", "bg_color": "#bbeb5b", "timeblock_interval": "0", "capacity_min": "1", "capacity_max": "1", "status": "active", "visibility": "visible", "created_at": "2025-02-05 08:54:57", "updated_at": "2025-02-05 12:54:07", "earliest_possible_booking": null, "latest_possible_booking": null }, { "id": "2", "name": "Weight management counseling\u200b", "short_description": "", "is_price_variable": null, "price_min": "1000.0000", "price_max": "1000.0000", "charge_amount": "1000.0000", "deposit_amount": "0.0000", "is_deposit_required": null, "duration_name": "", "override_default_booking_status": "", "duration": "60", "buffer_before": "5", "buffer_after": "10", "category_id": "0", "order_number": null, "selection_image_id": "116", "description_image_id": "0", "bg_color": "#2752E4", "timeblock_interval": "0", "capacity_min": "1", "capacity_max": "1", "status": "active", "visibility": "visible", "created_at": "2025-02-05 12:44:19", "updated_at": "2025-02-05 12:54:21", "earliest_possible_booking": null, "latest_possible_booking": null }, { "id": "3", "name": "Health and wellness coaching", "short_description": "", "is_price_variable": null, "price_min": "800.0000", "price_max": "800.0000", "charge_amount": "800.0000", "deposit_amount": "0.0000", "is_deposit_required": null, "duration_name": "", "override_default_booking_status": "", "duration": "60", "buffer_before": "5", "buffer_after": "10", "category_id": "0", "order_number": null, "selection_image_id": "117", "description_image_id": "0", "bg_color": "#C066F1", "timeblock_interval": "0", "capacity_min": "1", "capacity_max": "1", "status": "active", "visibility": "visible", "created_at": "2025-02-05 12:45:44", "updated_at": "2025-02-05 12:54:39", "earliest_possible_booking": null, "latest_possible_booking": null }, { "id": "4", "name": "Expand your spiritual knowledge", "short_description": "", "is_price_variable": null, "price_min": "1500.0000", "price_max": "1500.0000", "charge_amount": "1500.0000", "deposit_amount": "0.0000", "is_deposit_required": null, "duration_name": "", "override_default_booking_status": "", "duration": "60", "buffer_before": "5", "buffer_after": "10", "category_id": "0", "order_number": null, "selection_image_id": "163", "description_image_id": "0", "bg_color": "#26B7DD", "timeblock_interval": "0", "capacity_min": "1", "capacity_max": "1", "status": "active", "visibility": "visible", "created_at": "2025-02-05 12:46:22", "updated_at": "2025-02-05 12:55:06", "earliest_possible_booking": null, "latest_possible_booking": null } ] }, "{{TABLE_PREFIX}}latepoint_settings": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_settings` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `name` varchar(110) NOT NULL,\n `value` longtext DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `name_index` (`name`)\n) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "name": "default_booking_status", "value": "approved", "created_at": "2025-02-05 04:54:53", "updated_at": "2025-03-06 12:48:34" }, { "id": "2", "name": "timeslot_blocking_statuses", "value": "approved", "created_at": "2025-02-05 04:54:53", "updated_at": "2025-03-06 12:48:34" }, { "id": "3", "name": "calendar_hidden_statuses", "value": "cancelled", "created_at": "2025-02-05 04:54:53", "updated_at": "2025-03-06 12:48:34" }, { "id": "4", "name": "need_action_statuses", "value": "pending,payment_pending", "created_at": "2025-02-05 04:54:53", "updated_at": "2025-03-06 12:48:34" }, { "id": "5", "name": "is_database_seeded", "value": "1", "created_at": "2025-02-05 04:54:53", "updated_at": "2025-02-05 04:54:53" }, { "id": "6", "name": "step_codes_in_order", "value": "booking__services,booking__agents,booking__datepicker,customer,verify,payment__times,payment__portions,payment__methods,payment__processors,payment__pay,confirmation", "created_at": "2025-02-05 09:22:59", "updated_at": "2025-02-05 09:22:59" }, { "id": "7", "name": "steps_settings", "value": "a:12:{s:6:\"shared\";a:1:{s:18:\"steps_support_text\";s:54:\"<h5>Questions?<\/h5><p>Call (858) 939-3746 for help<\/p>\";}s:17:\"booking__services\";a:6:{s:18:\"side_panel_heading\";s:17:\"Service Selection\";s:22:\"side_panel_description\";s:69:\"Please select a service for which you want to schedule an appointment\";s:18:\"main_panel_heading\";s:18:\"Available Services\";s:25:\"main_panel_content_before\";s:0:\"\";s:24:\"main_panel_content_after\";s:0:\"\";s:26:\"side_panel_custom_image_id\";s:0:\"\";}s:15:\"booking__agents\";a:3:{s:18:\"side_panel_heading\";s:15:\"Agent Selection\";s:22:\"side_panel_description\";s:59:\"Please select an agent that will be providing you a service\";s:18:\"main_panel_heading\";s:16:\"Available Agents\";}s:19:\"booking__datepicker\";a:3:{s:18:\"side_panel_heading\";s:18:\"Select Date & Time\";s:22:\"side_panel_description\";s:48:\"Please select date and time for your appointment\";s:18:\"main_panel_heading\";s:21:\"Date & Time Selection\";}s:8:\"customer\";a:3:{s:18:\"side_panel_heading\";s:22:\"Enter Your Information\";s:22:\"side_panel_description\";s:37:\"Please enter your contact information\";s:18:\"main_panel_heading\";s:20:\"Customer Information\";}s:6:\"verify\";a:3:{s:18:\"side_panel_heading\";s:20:\"Verify Order Details\";s:22:\"side_panel_description\";s:86:\"Double check your reservation details and click submit button if everything is correct\";s:18:\"main_panel_heading\";s:20:\"Verify Order Details\";}s:14:\"payment__times\";a:3:{s:18:\"side_panel_heading\";s:22:\"Payment Time Selection\";s:22:\"side_panel_description\";s:61:\"Please choose when you would like to pay for your appointment\";s:18:\"main_panel_heading\";s:27:\"When would you like to pay?\";}s:17:\"payment__portions\";a:3:{s:18:\"side_panel_heading\";s:25:\"Payment Portion Selection\";s:22:\"side_panel_description\";s:48:\"Please select how much you would like to pay now\";s:18:\"main_panel_heading\";s:35:\"How much would you like to pay now?\";}s:16:\"payment__methods\";a:3:{s:18:\"side_panel_heading\";s:24:\"Payment Method Selection\";s:22:\"side_panel_description\";s:68:\"Please select a payment method you would like to make a payment with\";s:18:\"main_panel_heading\";s:21:\"Select payment method\";}s:19:\"payment__processors\";a:3:{s:18:\"side_panel_heading\";s:27:\"Payment Processor Selection\";s:22:\"side_panel_description\";s:70:\"Please select a payment processor you want to process the payment with\";s:18:\"main_panel_heading\";s:24:\"Select payment processor\";}s:12:\"payment__pay\";a:3:{s:18:\"side_panel_heading\";s:14:\"Make a Payment\";s:22:\"side_panel_description\";s:67:\"Please enter your payment information so we can process the payment\";s:18:\"main_panel_heading\";s:30:\"Enter your payment information\";}s:12:\"confirmation\";a:3:{s:18:\"side_panel_heading\";s:12:\"Confirmation\";s:22:\"side_panel_description\";s:76:\"Your order has been placed. Please retain this confirmation for your record.\";s:18:\"main_panel_heading\";s:18:\"Order Confirmation\";}}", "created_at": "2025-02-05 09:22:59", "updated_at": "2025-02-24 06:35:21" }, { "id": "8", "name": "steps_support_text", "value": "<h5>Questions?<\/h5><p>Call (858) 939-3746 for help<\/p>", "created_at": "2025-02-24 06:35:21", "updated_at": "2025-02-24 06:35:21" }, { "id": "9", "name": "color_scheme_for_booking_form", "value": "black", "created_at": "2025-02-24 06:35:21", "updated_at": "2025-02-24 06:35:21" }, { "id": "10", "name": "custom_brand_primary_color", "value": "#000000", "created_at": "2025-02-24 06:35:21", "updated_at": "2025-02-24 06:35:21" }, { "id": "11", "name": "border_radius", "value": "flat", "created_at": "2025-02-24 06:35:21", "updated_at": "2025-02-24 06:35:21" }, { "id": "12", "name": "steps_show_service_categories", "value": "on", "created_at": "2025-02-24 06:35:21", "updated_at": "2025-02-24 06:35:21" }, { "id": "13", "name": "additional_booking_statuses", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "14", "name": "time_system", "value": "12", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "15", "name": "date_format", "value": "m\/d\/Y", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "16", "name": "timeblock_interval", "value": "30", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "17", "name": "show_booking_end_time", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "18", "name": "disable_verbose_date_output", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "19", "name": "earliest_possible_booking", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "20", "name": "latest_possible_booking", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "21", "name": "max_future_bookings_per_customer", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "22", "name": "currency_symbol_before", "value": "$", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "23", "name": "currency_symbol_after", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "24", "name": "thousand_separator", "value": ",", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "25", "name": "decimal_separator", "value": ".", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "26", "name": "number_of_decimals", "value": "2", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "27", "name": "hide_breakdown_if_subtotal_zero", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "28", "name": "list_of_phone_countries", "value": "all", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "29", "name": "default_phone_country", "value": "us", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "30", "name": "included_phone_countries", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "31", "name": "validate_phone_number", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "32", "name": "mask_phone_number_fields", "value": "on", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "33", "name": "show_dial_code_with_flag", "value": "on", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "34", "name": "one_agent_at_location", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "35", "name": "one_location_at_time", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "36", "name": "multiple_services_at_time", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "37", "name": "allow_customer_booking_reschedule", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "38", "name": "limit_when_customer_can_reschedule", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "39", "name": "reschedule_limit_value", "value": "5", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "40", "name": "reschedule_limit_unit", "value": "hour", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "41", "name": "change_status_on_customer_reschedule", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "42", "name": "status_to_set_after_customer_reschedule", "value": "pending", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "43", "name": "allow_customer_booking_cancellation", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "44", "name": "limit_when_customer_can_cancel", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "45", "name": "cancellation_limit_value", "value": "5", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "46", "name": "cancellation_limit_unit", "value": "hour", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "47", "name": "customer_dashboard_book_shortcode", "value": "[latepoint_book_form]", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "48", "name": "customer_dashboard_book_button_attributes", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "49", "name": "wp_users_as_customers", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "50", "name": "steps_require_setting_password", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "51", "name": "steps_hide_login_register_tabs", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "52", "name": "steps_hide_registration_prompt", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "53", "name": "page_url_customer_dashboard", "value": "\/customer-cabinet", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "54", "name": "page_url_customer_login", "value": "\/customer-cabinet", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "55", "name": "business_logo", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "56", "name": "business_name", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "57", "name": "business_phone", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "58", "name": "business_address", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "59", "name": "day_calendar_min_height", "value": "700", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "60", "name": "booking_template_for_calendar", "value": "{{service_name}}", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "61", "name": "confirmation_step_tracking_code", "value": "", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "62", "name": "allow_non_admins_download_csv", "value": "off", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "63", "name": "number_of_records_per_page", "value": "20", "created_at": "2025-03-06 12:48:34", "updated_at": "2025-03-06 12:48:34" }, { "id": "64", "name": "selected_customer_authentication_field_type", "value": "email", "created_at": "2025-09-24 07:16:30", "updated_at": "2025-09-24 07:16:30" } ] }, "{{TABLE_PREFIX}}latepoint_work_periods": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_work_periods` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `agent_id` int(11) NOT NULL,\n `service_id` int(11) NOT NULL,\n `location_id` int(11) NOT NULL,\n `start_time` smallint(6) NOT NULL,\n `end_time` smallint(6) NOT NULL,\n `week_day` tinyint(3) NOT NULL,\n `custom_date` date DEFAULT NULL,\n `chain_id` varchar(20) DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `agent_id_index` (`agent_id`),\n KEY `service_id_index` (`service_id`),\n KEY `location_id_index` (`location_id`),\n KEY `week_day_index` (`week_day`),\n KEY `custom_date_index` (`custom_date`)\n) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "agent_id": "0", "service_id": "0", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "1", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 08:34:52", "updated_at": "2025-02-05 08:34:52" }, { "id": "2", "agent_id": "0", "service_id": "0", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "2", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 08:34:52", "updated_at": "2025-02-05 08:34:52" }, { "id": "3", "agent_id": "0", "service_id": "0", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "3", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 08:34:52", "updated_at": "2025-02-05 08:34:52" }, { "id": "4", "agent_id": "0", "service_id": "0", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "4", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 08:34:52", "updated_at": "2025-02-05 08:34:52" }, { "id": "5", "agent_id": "0", "service_id": "0", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "5", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 08:34:52", "updated_at": "2025-02-05 08:34:52" }, { "id": "6", "agent_id": "0", "service_id": "0", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "6", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 08:34:52", "updated_at": "2025-02-05 08:34:52" }, { "id": "7", "agent_id": "0", "service_id": "0", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "7", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 08:34:52", "updated_at": "2025-02-05 08:34:52" }, { "id": "8", "agent_id": "0", "service_id": "1", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "1", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:07", "updated_at": "2025-02-05 12:54:07" }, { "id": "9", "agent_id": "0", "service_id": "1", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "2", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:07", "updated_at": "2025-02-05 12:54:07" }, { "id": "10", "agent_id": "0", "service_id": "1", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "3", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:07", "updated_at": "2025-02-05 12:54:07" }, { "id": "11", "agent_id": "0", "service_id": "1", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "4", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:07", "updated_at": "2025-02-05 12:54:07" }, { "id": "12", "agent_id": "0", "service_id": "1", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "5", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:07", "updated_at": "2025-02-05 12:54:07" }, { "id": "13", "agent_id": "0", "service_id": "1", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "6", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:07", "updated_at": "2025-02-05 12:54:07" }, { "id": "14", "agent_id": "0", "service_id": "1", "location_id": "0", "start_time": "0", "end_time": "0", "week_day": "7", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:07", "updated_at": "2025-02-05 12:54:07" }, { "id": "15", "agent_id": "0", "service_id": "2", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "1", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:21", "updated_at": "2025-02-05 12:54:21" }, { "id": "16", "agent_id": "0", "service_id": "2", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "2", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:21", "updated_at": "2025-02-05 12:54:21" }, { "id": "17", "agent_id": "0", "service_id": "2", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "3", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:21", "updated_at": "2025-02-05 12:54:21" }, { "id": "18", "agent_id": "0", "service_id": "2", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "4", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:21", "updated_at": "2025-02-05 12:54:21" }, { "id": "19", "agent_id": "0", "service_id": "2", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "5", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:21", "updated_at": "2025-02-05 12:54:21" }, { "id": "20", "agent_id": "0", "service_id": "2", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "6", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:21", "updated_at": "2025-02-05 12:54:21" }, { "id": "21", "agent_id": "0", "service_id": "2", "location_id": "0", "start_time": "0", "end_time": "0", "week_day": "7", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:21", "updated_at": "2025-02-05 12:54:21" }, { "id": "22", "agent_id": "0", "service_id": "3", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "1", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:39", "updated_at": "2025-02-05 12:54:39" }, { "id": "23", "agent_id": "0", "service_id": "3", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "2", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:39", "updated_at": "2025-02-05 12:54:39" }, { "id": "24", "agent_id": "0", "service_id": "3", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "3", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:39", "updated_at": "2025-02-05 12:54:39" }, { "id": "25", "agent_id": "0", "service_id": "3", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "4", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:39", "updated_at": "2025-02-05 12:54:39" }, { "id": "26", "agent_id": "0", "service_id": "3", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "5", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:39", "updated_at": "2025-02-05 12:54:39" }, { "id": "27", "agent_id": "0", "service_id": "3", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "6", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:39", "updated_at": "2025-02-05 12:54:39" }, { "id": "28", "agent_id": "0", "service_id": "3", "location_id": "0", "start_time": "0", "end_time": "0", "week_day": "7", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:54:39", "updated_at": "2025-02-05 12:54:39" }, { "id": "29", "agent_id": "0", "service_id": "4", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "1", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:55:06", "updated_at": "2025-02-05 12:55:06" }, { "id": "30", "agent_id": "0", "service_id": "4", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "2", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:55:06", "updated_at": "2025-02-05 12:55:06" }, { "id": "31", "agent_id": "0", "service_id": "4", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "3", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:55:06", "updated_at": "2025-02-05 12:55:06" }, { "id": "32", "agent_id": "0", "service_id": "4", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "4", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:55:06", "updated_at": "2025-02-05 12:55:06" }, { "id": "33", "agent_id": "0", "service_id": "4", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "5", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:55:06", "updated_at": "2025-02-05 12:55:06" }, { "id": "34", "agent_id": "0", "service_id": "4", "location_id": "0", "start_time": "480", "end_time": "1020", "week_day": "6", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:55:06", "updated_at": "2025-02-05 12:55:06" }, { "id": "35", "agent_id": "0", "service_id": "4", "location_id": "0", "start_time": "0", "end_time": "0", "week_day": "7", "custom_date": null, "chain_id": null, "created_at": "2025-02-05 12:55:06", "updated_at": "2025-02-05 12:55:06" } ] }, "{{TABLE_PREFIX}}latepoint_agents_services": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_agents_services` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `agent_id` int(11) NOT NULL,\n `service_id` int(11) NOT NULL,\n `location_id` int(11) DEFAULT NULL,\n `is_custom_hours` tinyint(1) DEFAULT NULL,\n `is_custom_price` tinyint(1) DEFAULT NULL,\n `is_custom_duration` tinyint(1) DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `agent_id_index` (`agent_id`),\n KEY `service_id_index` (`service_id`),\n KEY `location_id_index` (`location_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "agent_id": "1", "service_id": "1", "location_id": "1", "is_custom_hours": "0", "is_custom_price": "0", "is_custom_duration": "0", "created_at": "2025-02-05 08:54:57", "updated_at": "2025-02-05 08:54:57" }, { "id": "2", "agent_id": "1", "service_id": "2", "location_id": "1", "is_custom_hours": "0", "is_custom_price": "0", "is_custom_duration": "0", "created_at": "2025-02-05 12:44:19", "updated_at": "2025-02-05 12:44:19" }, { "id": "3", "agent_id": "1", "service_id": "3", "location_id": "1", "is_custom_hours": "0", "is_custom_price": "0", "is_custom_duration": "0", "created_at": "2025-02-05 12:45:44", "updated_at": "2025-02-05 12:45:44" }, { "id": "4", "agent_id": "1", "service_id": "4", "location_id": "1", "is_custom_hours": "0", "is_custom_price": "0", "is_custom_duration": "0", "created_at": "2025-02-05 12:46:22", "updated_at": "2025-02-05 12:46:22" } ] }, "{{TABLE_PREFIX}}latepoint_agents": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_agents` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `avatar_image_id` int(11) DEFAULT NULL,\n `bio_image_id` int(11) DEFAULT NULL,\n `first_name` varchar(255) NOT NULL,\n `last_name` varchar(255) DEFAULT NULL,\n `display_name` varchar(255) DEFAULT NULL,\n `title` varchar(255) DEFAULT NULL,\n `bio` text DEFAULT NULL,\n `features` text DEFAULT NULL,\n `email` varchar(110) NOT NULL,\n `phone` varchar(255) DEFAULT NULL,\n `password` varchar(255) DEFAULT NULL,\n `custom_hours` tinyint(1) DEFAULT NULL,\n `wp_user_id` int(11) DEFAULT NULL,\n `status` varchar(20) NOT NULL,\n `extra_emails` text DEFAULT NULL,\n `extra_phones` text DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `email_index` (`email`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "avatar_image_id": "0", "bio_image_id": "0", "first_name": "Lumora", "last_name": "Grace", "display_name": "", "title": "", "bio": "", "features": "null", "email": "lumoragrace@gmail.com", "phone": "+11234567891", "password": "$P$BOVtx59Lhy8vzARgyWQs.v8yU.ygrX1", "custom_hours": null, "wp_user_id": "0", "status": "active", "extra_emails": "", "extra_phones": "", "created_at": "2025-02-05 08:52:50", "updated_at": "2025-02-25 06:23:14" } ] }, "{{TABLE_PREFIX}}latepoint_service_meta": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_service_meta` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `object_id` mediumint(9) NOT NULL,\n `meta_key` varchar(110) NOT NULL,\n `meta_value` text DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `meta_key_index` (`meta_key`),\n KEY `object_id_index` (`object_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "object_id": "1", "meta_key": "durations", "meta_value": "[]", "created_at": "2025-02-05 08:54:57", "updated_at": "2025-02-05 12:54:07" }, { "id": "2", "object_id": "2", "meta_key": "durations", "meta_value": "[]", "created_at": "2025-02-05 12:44:19", "updated_at": "2025-02-05 12:54:21" }, { "id": "3", "object_id": "3", "meta_key": "durations", "meta_value": "[]", "created_at": "2025-02-05 12:45:44", "updated_at": "2025-02-05 12:54:39" }, { "id": "4", "object_id": "4", "meta_key": "durations", "meta_value": "[]", "created_at": "2025-02-05 12:46:22", "updated_at": "2025-02-05 12:55:06" } ] }, "{{TABLE_PREFIX}}latepoint_locations": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_locations` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `name` varchar(255) NOT NULL,\n `full_address` text DEFAULT NULL,\n `status` varchar(20) NOT NULL,\n `category_id` int(11) DEFAULT NULL,\n `order_number` int(11) DEFAULT NULL,\n `selection_image_id` int(11) DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `status_index` (`status`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "name": "Main Location", "full_address": null, "status": "active", "category_id": "0", "order_number": null, "selection_image_id": null, "created_at": "2025-02-05 04:54:53", "updated_at": "2025-02-05 04:54:53" } ] }, "{{TABLE_PREFIX}}latepoint_processes": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_processes` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `name` varchar(110) NOT NULL,\n `event_type` varchar(110) NOT NULL,\n `actions_json` text DEFAULT NULL,\n `status` varchar(30) DEFAULT 'active',\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "name": "New Booking Notification", "event_type": "booking_created", "actions_json": "[{\"type\":\"group\",\"trigger_condition\":false,\"items\":[{\"type\":\"action\",\"id\":\"pa_HXR2tA\",\"settings\":{\"status\":\"active\",\"type\":\"send_email\",\"settings\":{\"to_email\":\"{{agent_full_name}} <{{agent_email}}>\",\"subject\":\"New Appointment Received\",\"content\":\"<div style=\\\"padding: 20px; background-color: #f0f0f0; font-family: -apple-system, system-ui, BlinkMacSystemFont, \\\"Segoe UI\\\", Roboto, \\\"Helvetica Neue\\\", Arial, sans-serif;\\\">\\n\\t<div style=\\\"background-color: #fff; padding: 30px; margin: 0px auto; max-width: 450px; box-shadow: 0px 2px 6px -1px rgba(0,0,0,0.2); border-radius: 6px;\\\">\\n\\t\\t<div style=\\\"margin: 0px auto 30px auto; border-bottom: 1px solid #eee; padding-bottom: 20px;\\\">\\n\\t\\t\\t<table style=\\\"width: 100%;\\\">\\n\\t\\t\\t\\t<tr>\\n\\t\\t\\t\\t\\t<td>{{business_logo_image}}<\\\/td>\\n\\t\\t\\t\\t\\t<td style=\\\"text-align: right;\\\"><span style=\\\"color: #7b7b7b;\\\">Questions?<\\\/span><br\\\/><strong>{{business_phone}}<\\\/strong><\\\/td>\\n\\t\\t\\t\\t<\\\/tr>\\n\\t\\t\\t<\\\/table>\\n\\t\\t<\\\/div>\\n\\t\\t<div style=\\\"font-size: 16px; line-height: 1.5;\\\">\\n\\t\\t\\t<div style=\\\"font-size: 16px; margin-bottom: 20px; line-height: 1.6;\\\">\\n\\tHi {{agent_full_name}},\\n\\t<br\\\/><br\\\/>\\n\\tYou have received a new appointment request from {{customer_full_name}}\\n<\\\/div>\\n<h4 style=\\\"margin-bottom: 10px; margin-top: 0px; font-size: 16px; font-weight: bold;\\\">Customer Information<\\\/h4>\\n<ul>\\n\\t<li>\\n\\t\\t<span>Full Name:<\\\/span> <strong>{{customer_full_name}}<\\\/strong>\\n\\t<\\\/li>\\n\\t<li>\\n\\t\\t<span>Email Address:<\\\/span> <strong>{{customer_email}}<\\\/strong>\\n\\t<\\\/li>\\n\\t<li>\\n\\t\\t<span>Phone:<\\\/span> <strong>{{customer_phone}}<\\\/strong>\\n\\t<\\\/li>\\n\\t<li>\\n\\t\\t<span>Comments:<\\\/span> <strong>{{customer_notes}}<\\\/strong>\\n\\t<\\\/li>\\n<\\\/ul>\\n<h4 style=\\\"margin-bottom: 10px; margin-top: 0px; font-size: 16px; font-weight: bold;\\\">Appointment Information<\\\/h4>\\n<ul>\\n\\t<li>\\n\\t\\t<span>Service:<\\\/span> <strong>{{service_name}}<\\\/strong>\\n\\t<\\\/li>\\n\\t<li>\\n\\t\\t<span>Date, Time:<\\\/span> <strong>{{start_date}}, {{start_time}} - {{end_time}}<\\\/strong>\\n\\t<\\\/li>\\n<\\\/ul>\\n<div style=\\\"margin-top: 25px;\\\">\\n\\t<a href=\\\"{{manage_booking_url_agent}}\\\" style=\\\"display: block; text-decoration: none; padding: 10px; border-radius: 6px; text-align: center; font-size: 18px; color: #fff; background-color: #2652E4; font-weight: 700;\\\">Manage This Appointment<\\\/a>\\n<\\\/div>\\n\\t\\t<\\\/div>\\n\\t<\\\/div>\\n\\t<div style=\\\"max-width: 450px; margin: 10px auto; text-align: center;\\\">{{business_address}}<\\\/div>\\n<\\\/div>\"}}},{\"type\":\"action\",\"id\":\"pa_DBuHmA\",\"settings\":{\"status\":\"active\",\"type\":\"send_email\",\"settings\":{\"to_email\":\"{{customer_full_name}} <{{customer_email}}>\",\"subject\":\"Appointment Confirmation\",\"content\":\"<div style=\\\"padding: 20px; background-color: #f0f0f0; font-family: -apple-system, system-ui, BlinkMacSystemFont, \\\"Segoe UI\\\", Roboto, \\\"Helvetica Neue\\\", Arial, sans-serif;\\\">\\n\\t<div style=\\\"background-color: #fff; padding: 30px; margin: 0px auto; max-width: 450px; box-shadow: 0px 2px 6px -1px rgba(0,0,0,0.2); border-radius: 6px;\\\">\\n\\t\\t<div style=\\\"margin: 0px auto 30px auto; border-bottom: 1px solid #eee; padding-bottom: 20px;\\\">\\n\\t\\t\\t<table style=\\\"width: 100%;\\\">\\n\\t\\t\\t\\t<tr>\\n\\t\\t\\t\\t\\t<td>{{business_logo_image}}<\\\/td>\\n\\t\\t\\t\\t\\t<td style=\\\"text-align: right;\\\"><span style=\\\"color: #7b7b7b;\\\">Questions?<\\\/span><br\\\/><strong>{{business_phone}}<\\\/strong><\\\/td>\\n\\t\\t\\t\\t<\\\/tr>\\n\\t\\t\\t<\\\/table>\\n\\t\\t<\\\/div>\\n\\t\\t<div style=\\\"font-size: 16px; line-height: 1.5;\\\">\\n\\t\\t\\t<div style=\\\"font-size: 16px; margin-bottom: 20px; line-height: 1.6;\\\">\\n\\tHi {{customer_full_name}},\\n\\t<br>\\n\\t<br>\\n\\tYour {{service_name}} appointment with <strong>{{agent_full_name}}<\\\/strong> is <strong>{{booking_status}}<\\\/strong>.\\n<\\\/div>\\n<h4 style=\\\"margin-bottom: 10px; margin-top: 0px; font-size: 16px; font-weight: bold;\\\">Appointment Details:<\\\/h4>\\n<ul>\\n\\t<li>\\n\\t\\t<span>Agent:<\\\/span> <strong>{{agent_full_name}}<\\\/strong>\\n\\t<\\\/li>\\n\\t<li>\\n\\t\\t<span>Service:<\\\/span> <strong>{{service_name}}<\\\/strong>\\n\\t<\\\/li>\\n\\t<li>\\n\\t\\t<span>Date, Time:<\\\/span> <strong>{{start_date}}, {{start_time}} - {{end_time}}<\\\/strong>\\n\\t<\\\/li>\\n<\\\/ul>\\n<div style=\\\"margin-top: 25px;\\\">\\n\\t<a href=\\\"{{manage_booking_url_customer}}\\\" style=\\\"display: block; text-decoration: none; padding: 10px; border-radius: 6px; text-align: center; font-size: 18px; color: #fff; background-color: #2652E4; font-weight: 700;\\\">Manage This Appointment<\\\/a>\\n<\\\/div>\\n\\t\\t<\\\/div>\\n\\t<\\\/div>\\n\\t<div style=\\\"max-width: 450px; margin: 10px auto; text-align: center;\\\">{{business_address}}<\\\/div>\\n<\\\/div>\"}}}],\"time_offset\":[]}]", "status": "active", "created_at": "2025-02-05 04:54:53", "updated_at": "2025-02-05 04:54:53" } ] }, "{{TABLE_PREFIX}}latepoint_customer_otp_codes": { "create": "CREATE TABLE `{{TABLE_PREFIX}}latepoint_customer_otp_codes` (\n `id` mediumint(9) NOT NULL AUTO_INCREMENT,\n `contact_value` varchar(255) NOT NULL,\n `contact_type` varchar(30) NOT NULL,\n `delivery_method` varchar(30) NOT NULL,\n `otp_hash` varchar(255) NOT NULL,\n `expires_at` datetime NOT NULL,\n `status` varchar(30) NOT NULL DEFAULT 'active',\n `attempts` int(11) DEFAULT 0,\n `used_at` datetime DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_contact_status` (`contact_value`,`status`),\n KEY `idx_expires_status` (`expires_at`,`status`)\n) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci", "prefix": "shark_1514_", "data": [ { "id": "1", "contact_value": "test@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$V9O1aa2xUED86hxhAyEx6Ov\/.9AozI.iCiLn8IHqRrXkiHDY4xC9u", "expires_at": "2025-10-01 06:53:12", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-01 06:43:12", "updated_at": "2025-11-03 06:00:57" }, { "id": "2", "contact_value": "az7ahra@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$2XNuqOepNxrCVA1d514WMeFI9fPHkDtCDJM3658vg5YBbUgSxhNX6", "expires_at": "2025-10-07 09:51:04", "status": "cancelled", "attempts": "0", "used_at": null, "created_at": "2025-10-07 09:41:04", "updated_at": "2025-10-07 09:41:12" }, { "id": "3", "contact_value": "az7ahra@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$y68HuZ0lEuMmaE1tgOBGaO3QCQgtFsYblOrUDCRUsVWIyjXmdQ0m.", "expires_at": "2025-10-07 09:51:12", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-07 09:41:12", "updated_at": "2025-11-03 06:00:57" }, { "id": "4", "contact_value": "panteva85@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$GSKV5YZvUSPeZ6\/YYsbpdeWVJ2qBK.MiLn1hcmFwVwyO4gHrLp7Kq", "expires_at": "2025-10-08 17:55:12", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-08 17:45:12", "updated_at": "2025-11-03 06:00:57" }, { "id": "5", "contact_value": "cjjjjjjjjjjjj@chj.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$2RXBE0QchYFZlzFmKaPZMud595I2d3J18oDqOo.YAeyl0Kx8ANyaa", "expires_at": "2025-10-09 15:02:51", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-09 14:52:51", "updated_at": "2025-11-03 06:00:57" }, { "id": "6", "contact_value": "a@a.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$X0BZpeuBkEWjyqTdtUDLIeGgl4Z9zHHC3BmMYIUTSzN0g83Yw\/etu", "expires_at": "2025-10-11 14:29:31", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-11 14:19:31", "updated_at": "2025-11-03 06:00:57" }, { "id": "7", "contact_value": "berlineonyango2000@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$vmX\/aOUSRDzlblDJ3xWg6OiFVi8lzFmLX45EyF\/mQsiC.Q2LTiV3q", "expires_at": "2025-10-11 17:42:44", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-11 17:32:44", "updated_at": "2025-11-03 06:00:57" }, { "id": "8", "contact_value": "nshutip4@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$sw004zkkaNXqzKz8jK9nAOarxp1P\/O9TfqPYcSo06\/psSwYG1WCXe", "expires_at": "2025-10-21 10:52:28", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-21 10:42:28", "updated_at": "2025-11-03 06:00:57" }, { "id": "9", "contact_value": "lepatrodesigns@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$y3cw26TdhRD5gPJd1AvN3.ueGcK7pbhXDuwtsiAiMfiZJfBlKn4mO", "expires_at": "2025-10-24 11:06:28", "status": "cancelled", "attempts": "0", "used_at": null, "created_at": "2025-10-24 10:56:28", "updated_at": "2025-10-24 10:58:06" }, { "id": "10", "contact_value": "lepatrodesigns@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$R9QjjYt8QqvAWcbTjx8\/i.u9N8QjC16cdZ3Gi5rwWJpbjcQODoaxC", "expires_at": "2025-10-24 11:08:06", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-24 10:58:06", "updated_at": "2025-11-03 06:00:57" }, { "id": "11", "contact_value": "giubijn@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$td0fW.SeNvwWlAoYE0Yxv.\/GfOoDARV2a9nbeKsCwyTO3FaAH\/0Qy", "expires_at": "2025-10-27 23:30:49", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-27 23:20:49", "updated_at": "2025-11-03 06:00:57" }, { "id": "12", "contact_value": "gazelselman@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$oKcOooXZypRG0hmgb8vWBe9qipIjj2Flduh4OAWlAMB3crLnqVGXq", "expires_at": "2025-10-30 21:08:14", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-10-30 20:58:14", "updated_at": "2025-11-03 06:00:57" }, { "id": "13", "contact_value": "proslaw21@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$vgzNH.mE6NK4KheM.zMv2eCCOLwRj11aKWwjtDal.Lsl43q.\/rJ3m", "expires_at": "2025-11-02 23:14:36", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-11-02 23:04:36", "updated_at": "2025-11-03 06:00:57" }, { "id": "14", "contact_value": "smjafor65@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$QjNffY9Iu3s5Pe9EQpsrx.4NgXxT4zi89nn9M.eigZnc6eKLoLfLC", "expires_at": "2025-11-03 06:10:25", "status": "expired", "attempts": "1", "used_at": null, "created_at": "2025-11-03 06:00:25", "updated_at": "2025-11-09 04:17:12" }, { "id": "15", "contact_value": "mayowayusuf3@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$ab0hHTUvoXC2ea7ph1VMKOxzElqxtCrD28e4sxTe8z9rAazGmHN.C", "expires_at": "2025-11-04 01:40:32", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-11-04 01:30:32", "updated_at": "2025-11-09 04:17:12" }, { "id": "16", "contact_value": "info@msomismart.co.ke", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$Q38hLbB2nG49jT23uy5JEuqKazkYs02uZb1n43XZa2uAiFmWS.dKy", "expires_at": "2025-11-05 17:04:55", "status": "expired", "attempts": "0", "used_at": null, "created_at": "2025-11-05 16:54:55", "updated_at": "2025-11-09 04:17:12" }, { "id": "17", "contact_value": "asdf@asf.net", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$v.chGhjcBAbRVrUxtagM\/OIxaH60zEfYPGiOfYwrObFNFmP9AqNsi", "expires_at": "2025-11-09 04:27:04", "status": "active", "attempts": "1", "used_at": null, "created_at": "2025-11-09 04:17:04", "updated_at": "2025-11-09 04:17:12" }, { "id": "18", "contact_value": "fdgg@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$hA\/OIctwiLIPjR6NmK3hhO27KPC4\/cNwX7meJqE7gRcZLArZwvNYq", "expires_at": "2025-11-10 14:07:47", "status": "active", "attempts": "0", "used_at": null, "created_at": "2025-11-10 13:57:47", "updated_at": "2025-11-10 13:57:47" }, { "id": "19", "contact_value": "contact.amsads09@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$\/VallJI\/70JIhcFz.4C.oelFaVj8lgJ\/.D55b\/bnpcWNWo9RGdt4y", "expires_at": "2025-11-14 15:24:35", "status": "active", "attempts": "0", "used_at": null, "created_at": "2025-11-14 15:14:35", "updated_at": "2025-11-14 15:14:35" }, { "id": "20", "contact_value": "yhb3@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$PUjV7JJ29MGzr6bFx3lV5.NvjzVWzZbMTNLwRwjGFj0mLRlHYpCl.", "expires_at": "2025-11-15 16:30:12", "status": "cancelled", "attempts": "0", "used_at": null, "created_at": "2025-11-15 16:20:12", "updated_at": "2025-11-15 16:20:23" }, { "id": "21", "contact_value": "yhb3@gmail.com", "contact_type": "email", "delivery_method": "email", "otp_hash": "$wp$2y$10$Tw30AfcuTzEg5Q.6xKJ35.GB88A9tBOX1zIhmWMR3B1Ym8p1GEYFa", "expires_at": "2025-11-15 16:30:23", "status": "active", "attempts": "0", "used_at": null, "created_at": "2025-11-15 16:20:23", "updated_at": "2025-11-15 16:20:23" } ] } }