\\n\\t\\t
\\n\\t\\t\\t
To make an offline donation toward this cause, follow these steps:
Your tax-deductible donation is greatly appreciated!
"},"innerBlocks":[]}]}]'), (3, 2182, '_give_price_option', 'multi'), (4, 2182, '_give_donation_levels', 'a:3:{i:0;a:3:{s:8:"_give_id";a:1:{s:8:"level_id";i:0;}s:12:"_give_amount";d:20000;s:10:"_give_text";s:0:"";}i:1;a:3:{s:8:"_give_id";a:1:{s:8:"level_id";i:1;}s:12:"_give_amount";d:50000;s:10:"_give_text";s:0:"";}i:2;a:3:{s:8:"_give_id";a:1:{s:8:"level_id";i:2;}s:12:"_give_amount";d:100000;s:10:"_give_text";s:0:"";}}'), (12, 2182, '_give_form_grid_option', 'global'), (13, 2182, '_give_form_grid_redirect_url', ''), (14, 2182, '_give_form_grid_donate_button_text', ''), (15, 2182, '_give_email_options', 'global'), (5, 2182, '_give_goal_option', 'disabled'), (6, 2182, '_give_goal_format', 'amount'), (7, 2182, '_give_set_goal', '1000.000000'), (8, 2182, '_give_recurring', 'no'), (9, 2182, '_eb_reusable_block_ids', 'a:0:{}'), (10, 2182, '_eael_post_view_count', '185'), (11, 2182, '_elementor_page_assets', 'a:0:{}'), (16, 2182, '_give_email_template', 'default'), (17, 2182, '_give_email_logo', ''), (18, 2182, '_give_from_name', ''), (19, 2182, '_give_from_email', ''), (20, 2182, 'give_stripe_per_form_accounts', 'disabled'), (21, 2182, '_give_customize_offline_donations', 'global'), (22, 2182, '_give_offline_checkout_notes', 'To make an offline donation toward this cause, follow these steps:
Your tax-deductible donation is greatly appreciated!
'); -- -------------------------------------------------------- -- -- Table structure for table `wpdz_give_log` -- CREATE TABLE `wpdz_give_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `log_type` varchar(16) NOT NULL, `data` text NOT NULL, `category` varchar(64) NOT NULL, `source` varchar(64) NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`), KEY `log_type` (`log_type`), KEY `category` (`category`), KEY `source` (`source`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wpdz_give_log` -- INSERT INTO `wpdz_give_log` VALUES (1, 'error', '{"message":"Invalid Secure Route","context":{"routeSignature":"61b839e08dc097f3f5a46149e91f1fd0","signature":{"Object Class":"Give\\\\DonationForms\\\\Routes\\\\DonateRouteSignature","\\u0000Give\\\\DonationForms\\\\Routes\\\\DonateRouteSignature\\u0000signature":"givewp-donation-form-validation|1760671370","expiration":"1760671370"},"signatureString":"givewp-donation-form-validation|1760671370","signatureHash":"61b839e08dc097f3f5a46149e91f1fd0","signatureExpiration":"1760671370"}}', 'Payment Gateway', 'Payment Gateway', '2025-10-17 04:18:20'), (2, 'error', '{"message":"Invalid Secure Route","context":{"routeSignature":"a13999561374b8f4a57268721ef6bb1f","signature":{"Object Class":"Give\\\\DonationForms\\\\Routes\\\\DonateRouteSignature","\\u0000Give\\\\DonationForms\\\\Routes\\\\DonateRouteSignature\\u0000signature":"givewp-donation-form-authentication|1760671370","expiration":"1760671370"},"signatureString":"givewp-donation-form-authentication|1760671370","signatureHash":"a13999561374b8f4a57268721ef6bb1f","signatureExpiration":"1760671370"}}', 'Payment Gateway', 'Payment Gateway', '2025-10-17 04:18:29'), (3, 'error', '{"message":"Invalid Secure Route","context":{"routeSignature":"212ea5f9dc1e78352e5d50b6ac78b62b","signature":{"Object Class":"Give\\\\DonationForms\\\\Routes\\\\DonateRouteSignature","\\u0000Give\\\\DonationForms\\\\Routes\\\\DonateRouteSignature\\u0000signature":"givewp-donate|1760671370","expiration":"1760671370"},"signatureString":"givewp-donate|1760671370","signatureHash":"212ea5f9dc1e78352e5d50b6ac78b62b","signatureExpiration":"1760671370"}}', 'Payment Gateway', 'Payment Gateway', '2025-10-17 04:18:33'); -- -------------------------------------------------------- -- -- Table structure for table `wpdz_give_migrations` -- CREATE TABLE `wpdz_give_migrations` ( `id` varchar(180) NOT NULL, `status` varchar(16) NOT NULL, `error` text DEFAULT NULL, `last_run` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wpdz_give_migrations` -- INSERT INTO `wpdz_give_migrations` VALUES ('create_migrations_table', 'success', '', '2025-10-15 09:49:26'), ('migrate_completed_migrations', 'success', '', '2025-10-15 09:49:26'), ('create_revenue_table', 'success', '', '2025-10-15 09:49:26'), ('remove_revenue_foreign_keys', 'success', '', '2025-10-15 09:49:27'), ('set-form-donation-levels-to-strings', 'success', '', '2025-10-15 09:49:27'), ('set_paypal_standard_id_to_paypal_from_paypal_standard', 'success', '', '2025-10-15 09:49:27'), ('create_new_log_table', 'success', '', '2025-10-15 09:49:27'), ('delete_old_log_tables', 'success', '', '2025-10-15 09:49:27'), ('remove-paypal-ipn-verification-setting', 'success', '', '2025-10-15 09:49:28'), ('set_automatic_formatting_option', 'success', '', '2025-10-15 09:49:28'), ('add-statement-descriptor-to-stripe-accounts', 'success', '', '2025-10-15 09:49:28'), ('remove-log-with-card-info', 'success', '', '2025-10-15 09:49:28'), ('add-missing-transaction-id-for-uncompleted-stripe-donations', 'success', '', '2025-10-15 09:49:28'), ('create_subscription_tables', 'success', '', '2025-10-15 09:49:28'), ('remove_sensitive_logs', 'success', '', '2025-10-15 09:49:28'), ('complete-removed-legacy-log-migration', 'success', '', '2025-10-15 09:49:28'), ('add_paymentmode_to_subscription_table', 'success', '', '2025-10-15 09:49:28'), ('add-missing-donor-id-in-donation-comments', 'success', '', '2025-10-15 09:49:28'), ('move-donation-comment-to-donation-meta-table', 'success', '', '2025-10-15 09:49:28'), ('donation-forms-remove-duplicate-meta', 'success', '', '2025-10-15 09:49:28'), ('register-paypal-donations-refresh-token-cron-job-by-mode', 'success', '', '2025-10-15 09:49:28'), ('remove_payment_intent_secret_meta', 'success', '', '2025-10-15 09:49:28'), ('copy-v2-gateways-settings-to-v3', 'success', '', '2025-10-15 09:49:28'), ('donation-forms-clean-multiple-slashes-on-db', 'success', '', '2025-10-15 09:49:28'), ('donors-add-phone-column', 'success', '', '2025-10-15 09:49:28'), ('donation-forms-donation-levels-schema', 'success', '', '2025-10-15 09:49:28'), ('give-campaigns-create-give-campaigns-table', 'success', '', '2025-10-15 09:49:28'), ('give-campaigns-create-give-campaign-forms-table', 'success', '', '2025-10-15 09:49:28'), ('give-campaigns-set-campaign-type', 'success', '', '2025-10-15 09:49:28'), ('migrate_forms_to_campaign_forms', 'success', '', '2025-10-15 09:49:28'), ('add_campaign_id_to_revenue_table', 'success', '', '2025-10-15 09:49:28'), ('associate_donations_to_campaign', 'success', '', '2025-10-15 09:49:28'), ('add_indexes_to_revenue_table', 'success', '', '2025-10-15 09:49:28'), ('donation-meta-unserialize-title-prefix', 'success', '', '2025-10-15 09:49:28'), ('add_campaign_id_to_donations', 'success', '', '2025-10-15 09:49:28'), ('recalculate_exchange_rate', 'success', '', '2025-10-15 09:49:28'), ('refresh-licenses-for-platform-fee', 'success', '', '2025-10-15 09:49:28'), ('subscriptions_backfill_missing_campaign_id_for_donations', 'success', '', '2025-10-15 09:49:28'), ('cache_campaign_data', 'success', '', '2025-10-15 09:49:28'), ('refresh-licenses-for-last-active-date', 'success', '', '2025-10-15 09:49:28'); -- -------------------------------------------------------- -- -- Table structure for table `wpdz_give_revenue` -- CREATE TABLE `wpdz_give_revenue` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `donation_id` bigint(20) unsigned NOT NULL, `form_id` bigint(20) unsigned NOT NULL, `amount` int(10) unsigned NOT NULL, `campaign_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`), KEY `campaign_id` (`campaign_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_give_sequential_ordering` -- CREATE TABLE `wpdz_give_sequential_ordering` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `payment_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_give_sessions` -- CREATE TABLE `wpdz_give_sessions` ( `session_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `session_key` char(32) NOT NULL, `session_value` longtext NOT NULL, `session_expiry` bigint(20) unsigned NOT NULL, PRIMARY KEY (`session_key`), UNIQUE KEY `session_id` (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_give_subscriptionmeta` -- CREATE TABLE `wpdz_give_subscriptionmeta` ( `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, `subscription_id` bigint(20) NOT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext DEFAULT NULL, PRIMARY KEY (`meta_id`), KEY `subscription_id` (`subscription_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_give_subscriptions` -- CREATE TABLE `wpdz_give_subscriptions` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) NOT NULL, `period` varchar(20) NOT NULL, `frequency` bigint(20) NOT NULL DEFAULT 1, `initial_amount` decimal(18,10) NOT NULL, `recurring_amount` decimal(18,10) NOT NULL, `recurring_fee_amount` decimal(18,10) NOT NULL, `bill_times` bigint(20) NOT NULL, `transaction_id` varchar(60) NOT NULL, `parent_payment_id` bigint(20) NOT NULL, `payment_mode` varchar(20) NOT NULL DEFAULT '', `product_id` bigint(20) NOT NULL, `created` datetime NOT NULL, `expiration` datetime NOT NULL, `status` varchar(20) NOT NULL, `profile_id` varchar(60) NOT NULL, `notes` longtext NOT NULL, PRIMARY KEY (`id`), KEY `profile_id` (`profile_id`), KEY `customer` (`customer_id`), KEY `transaction` (`transaction_id`), KEY `customer_and_status` (`customer_id`,`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_activities` -- CREATE TABLE `wpdz_latepoint_activities` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `agent_id` int(11) DEFAULT NULL, `booking_id` int(11) DEFAULT NULL, `service_id` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `location_id` int(11) DEFAULT NULL, `order_id` int(11) DEFAULT NULL, `order_item_id` int(11) DEFAULT NULL, `code` varchar(255) NOT NULL, `description` text DEFAULT NULL, `initiated_by` varchar(100) DEFAULT NULL, `initiated_by_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_agents` -- CREATE TABLE `wpdz_latepoint_agents` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `avatar_image_id` int(11) DEFAULT NULL, `bio_image_id` int(11) DEFAULT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) DEFAULT NULL, `display_name` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `bio` text DEFAULT NULL, `features` text DEFAULT NULL, `email` varchar(110) NOT NULL, `phone` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `custom_hours` tinyint(1) DEFAULT NULL, `wp_user_id` int(11) DEFAULT NULL, `status` varchar(20) NOT NULL, `extra_emails` text DEFAULT NULL, `extra_phones` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `email_index` (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_agents_services` -- CREATE TABLE `wpdz_latepoint_agents_services` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `agent_id` int(11) NOT NULL, `service_id` int(11) NOT NULL, `location_id` int(11) DEFAULT NULL, `is_custom_hours` tinyint(1) DEFAULT NULL, `is_custom_price` tinyint(1) DEFAULT NULL, `is_custom_duration` tinyint(1) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `agent_id_index` (`agent_id`), KEY `service_id_index` (`service_id`), KEY `location_id_index` (`location_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_agent_meta` -- CREATE TABLE `wpdz_latepoint_agent_meta` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `object_id` mediumint(9) NOT NULL, `meta_key` varchar(110) NOT NULL, `meta_value` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `meta_key_index` (`meta_key`), KEY `object_id_index` (`object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_blocked_periods` -- CREATE TABLE `wpdz_latepoint_blocked_periods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `summary` text DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `start_time` mediumint(9) DEFAULT NULL, `end_time` mediumint(9) DEFAULT NULL, `start_datetime_utc` datetime DEFAULT NULL, `end_datetime_utc` datetime DEFAULT NULL, `service_id` mediumint(9) DEFAULT NULL, `agent_id` mediumint(9) DEFAULT NULL, `location_id` mediumint(9) DEFAULT NULL, `server_timezone` varchar(100) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `start_date_index` (`start_date`), KEY `end_date_index` (`end_date`), KEY `service_id_index` (`service_id`), KEY `agent_id_index` (`agent_id`), KEY `location_id_index` (`location_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_bookings` -- CREATE TABLE `wpdz_latepoint_bookings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `booking_code` varchar(10) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `start_time` mediumint(9) DEFAULT NULL, `end_time` mediumint(9) DEFAULT NULL, `start_datetime_utc` datetime DEFAULT NULL, `end_datetime_utc` datetime DEFAULT NULL, `buffer_before` mediumint(9) NOT NULL, `buffer_after` mediumint(9) NOT NULL, `duration` mediumint(9) DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'pending', `customer_id` mediumint(9) NOT NULL, `service_id` mediumint(9) NOT NULL, `agent_id` mediumint(9) NOT NULL, `location_id` mediumint(9) DEFAULT NULL, `order_item_id` mediumint(9) DEFAULT NULL, `recurrence_id` mediumint(9) DEFAULT NULL, `total_attendees` mediumint(4) DEFAULT NULL, `customer_timezone` varchar(100) DEFAULT NULL, `server_timezone` varchar(100) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `start_date_index` (`start_date`), KEY `end_date_index` (`end_date`), KEY `status_index` (`status`), KEY `customer_id_index` (`customer_id`), KEY `service_id_index` (`service_id`), KEY `agent_id_index` (`agent_id`), KEY `location_id_index` (`location_id`), KEY `recurrence_id_index` (`recurrence_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_booking_meta` -- CREATE TABLE `wpdz_latepoint_booking_meta` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `object_id` mediumint(9) NOT NULL, `meta_key` varchar(110) NOT NULL, `meta_value` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `meta_key_index` (`meta_key`), KEY `object_id_index` (`object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_bundles` -- CREATE TABLE `wpdz_latepoint_bundles` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `short_description` text DEFAULT NULL, `charge_amount` decimal(20,4) DEFAULT NULL, `deposit_amount` decimal(20,4) DEFAULT NULL, `status` varchar(20) NOT NULL, `visibility` varchar(20) NOT NULL, `order_number` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_number_index` (`order_number`), KEY `status_index` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_bundles_services` -- CREATE TABLE `wpdz_latepoint_bundles_services` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `bundle_id` mediumint(9) DEFAULT NULL, `service_id` mediumint(9) DEFAULT NULL, `total_attendees` mediumint(4) DEFAULT NULL, `duration` int(11) DEFAULT NULL, `quantity` mediumint(4) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `bundle_id_index` (`bundle_id`), KEY `service_id_index` (`service_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_carts` -- CREATE TABLE `wpdz_latepoint_carts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(36) DEFAULT NULL, `order_intent_id` int(11) DEFAULT NULL, `order_id` int(11) DEFAULT NULL, `coupon_code` varchar(100) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `uuid_index` (`uuid`), KEY `order_id_index` (`order_id`), KEY `order_intent_id_index` (`order_intent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_cart_items` -- CREATE TABLE `wpdz_latepoint_cart_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `cart_id` int(11) NOT NULL, `variant` varchar(55) DEFAULT NULL, `item_data` text DEFAULT NULL, `connected_cart_item_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `connected_cart_item_id_index` (`connected_cart_item_id`), KEY `cart_id_index` (`cart_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_cart_meta` -- CREATE TABLE `wpdz_latepoint_cart_meta` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `object_id` mediumint(9) NOT NULL, `meta_key` varchar(110) NOT NULL, `meta_value` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `meta_key_index` (`meta_key`), KEY `object_id_index` (`object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_customers` -- CREATE TABLE `wpdz_latepoint_customers` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `email` varchar(110) NOT NULL, `phone` varchar(255) DEFAULT NULL, `avatar_image_id` int(11) DEFAULT NULL, `status` varchar(50) NOT NULL, `password` varchar(255) DEFAULT NULL, `activation_key` varchar(255) DEFAULT NULL, `account_nonse` varchar(255) DEFAULT NULL, `google_user_id` varchar(255) DEFAULT NULL, `facebook_user_id` varchar(255) DEFAULT NULL, `wordpress_user_id` int(11) DEFAULT NULL, `is_guest` tinyint(1) DEFAULT NULL, `notes` text DEFAULT NULL, `admin_notes` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `email_index` (`email`), KEY `status_index` (`status`), KEY `wordpress_user_id_index` (`wordpress_user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_customer_meta` -- CREATE TABLE `wpdz_latepoint_customer_meta` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `object_id` mediumint(9) NOT NULL, `meta_key` varchar(110) NOT NULL, `meta_value` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `meta_key_index` (`meta_key`), KEY `object_id_index` (`object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_custom_prices` -- CREATE TABLE `wpdz_latepoint_custom_prices` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `agent_id` int(11) NOT NULL, `service_id` int(11) NOT NULL, `location_id` int(11) NOT NULL, `is_price_variable` tinyint(1) DEFAULT NULL, `price_min` decimal(20,4) DEFAULT NULL, `price_max` decimal(20,4) DEFAULT NULL, `charge_amount` decimal(20,4) DEFAULT NULL, `is_deposit_required` tinyint(1) DEFAULT NULL, `deposit_amount` decimal(20,4) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `agent_id_index` (`agent_id`), KEY `service_id_index` (`service_id`), KEY `location_id_index` (`location_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_locations` -- CREATE TABLE `wpdz_latepoint_locations` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `full_address` text DEFAULT NULL, `status` varchar(20) NOT NULL, `category_id` int(11) DEFAULT NULL, `order_number` int(11) DEFAULT NULL, `selection_image_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `status_index` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wpdz_latepoint_locations` -- INSERT INTO `wpdz_latepoint_locations` VALUES (1, 'Main Location', NULL, 'active', 0, NULL, NULL, '2025-05-20 08:16:39', '2025-05-20 08:16:39'); -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_location_categories` -- CREATE TABLE `wpdz_latepoint_location_categories` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `short_description` text DEFAULT NULL, `parent_id` mediumint(9) DEFAULT NULL, `selection_image_id` int(11) DEFAULT NULL, `order_number` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_number_index` (`order_number`), KEY `parent_id_index` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_orders` -- CREATE TABLE `wpdz_latepoint_orders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subtotal` decimal(20,4) DEFAULT NULL, `total` decimal(20,4) DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'open', `fulfillment_status` varchar(30) NOT NULL DEFAULT 'not_fulfilled', `payment_status` varchar(30) NOT NULL DEFAULT 'not_paid', `source_id` varchar(100) DEFAULT NULL, `source_url` text DEFAULT NULL, `ip_address` varchar(55) DEFAULT NULL, `customer_id` int(11) NOT NULL, `customer_comment` text DEFAULT NULL, `confirmation_code` varchar(10) DEFAULT NULL, `price_breakdown` text DEFAULT NULL, `coupon_code` varchar(100) DEFAULT NULL, `coupon_discount` decimal(20,4) DEFAULT NULL, `tax_total` decimal(20,4) DEFAULT NULL, `initial_payment_data` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `customer_id_index` (`customer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_order_intents` -- CREATE TABLE `wpdz_latepoint_order_intents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `intent_key` varchar(55) NOT NULL, `customer_id` int(11) NOT NULL, `cart_items_data` text DEFAULT NULL, `restrictions_data` text DEFAULT NULL, `presets_data` text DEFAULT NULL, `payment_data` text DEFAULT NULL, `other_data` text DEFAULT NULL, `order_id` int(11) DEFAULT NULL, `booking_form_page_url` text DEFAULT NULL, `total` decimal(20,4) DEFAULT NULL, `subtotal` decimal(20,4) DEFAULT NULL, `coupon_code` varchar(100) DEFAULT NULL, `coupon_discount` decimal(20,4) DEFAULT NULL, `tax_total` decimal(20,4) DEFAULT NULL, `charge_amount` decimal(20,4) DEFAULT NULL, `specs_charge_amount` varchar(55) DEFAULT NULL, `price_breakdown` text DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'new', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `intent_key_index` (`intent_key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_order_invoices` -- CREATE TABLE `wpdz_latepoint_order_invoices` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `invoice_number` varchar(10) DEFAULT NULL, `data` text DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'open', `charge_amount` decimal(20,4) DEFAULT NULL, `due_at` datetime DEFAULT NULL, `payment_portion` varchar(55) DEFAULT NULL, `access_key` varchar(36) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `invoice_number_index` (`invoice_number`), KEY `order_id_index` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_order_items` -- CREATE TABLE `wpdz_latepoint_order_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `variant` varchar(55) DEFAULT NULL, `item_data` text DEFAULT NULL, `subtotal` decimal(20,4) DEFAULT NULL, `total` decimal(20,4) DEFAULT NULL, `coupon_code` varchar(100) DEFAULT NULL, `coupon_discount` decimal(20,4) DEFAULT NULL, `tax_total` decimal(20,4) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_id_index` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_order_meta` -- CREATE TABLE `wpdz_latepoint_order_meta` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `object_id` mediumint(9) NOT NULL, `meta_key` varchar(110) NOT NULL, `meta_value` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `meta_key_index` (`meta_key`), KEY `object_id_index` (`object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_payment_requests` -- CREATE TABLE `wpdz_latepoint_payment_requests` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `invoice_id` int(11) NOT NULL, `charge_amount` decimal(20,4) DEFAULT NULL, `due_at` datetime DEFAULT NULL, `portion` varchar(55) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `invoice_id_index` (`invoice_id`), KEY `order_id_index` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -------------------------------------------------------- -- -- Table structure for table `wpdz_latepoint_processes` -- CREATE TABLE `wpdz_latepoint_processes` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(110) NOT NULL, `event_type` varchar(110) NOT NULL, `actions_json` text DEFAULT NULL, `status` varchar(30) DEFAULT 'active', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; -- -- Dumping data for table `wpdz_latepoint_processes` -- INSERT INTO `wpdz_latepoint_processes` VALUES (1, 'New Booking Notification', 'booking_created', '[{"type":"group","trigger_condition":false,"items":[{"type":"action","id":"pa_mN6phi","settings":{"status":"active","type":"send_email","settings":{"to_email":"{{agent_full_name}} <{{agent_email}}>","subject":"New Appointment Received","content":"
MJ Rathbun hasn’t tried contributing to WordPress yet.
The latest episode is 
\n 
