{"slug":"booking-system","name":"Pinpoint Booking System – Version 2","description":"Book anything, anytime, anywhere.","author":"DOTonPAPER","active_installs":3000,"version":"2.9.9.6.9","wp_org_url":"https://wordpress.org/plugins/booking-system/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"dopbsp_api_keys","full_table_name":"wp_dopbsp_api_keys","description":"Stores dopbsp api keys data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_api_keys` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `api_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_availability","full_table_name":"wp_dopbsp_availability","description":"Stores dopbsp availability data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_availability` (\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `date_end` datetime NOT NULL DEFAULT '9999-01-01 00:00:00',\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `date_start` (`date_start`),\\n  KEY `date_end` (`date_end`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_availability_no","full_table_name":"wp_dopbsp_availability_no","description":"Stores dopbsp availability no data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_availability_no` (\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `no_available` int unsigned NOT NULL DEFAULT '2',\\n  `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `date_end` datetime NOT NULL DEFAULT '9999-01-01 00:00:00',\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `no_available` (`no_available`),\\n  KEY `date_start` (`date_start`),\\n  KEY `date_end` (`date_end`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_availability_price","full_table_name":"wp_dopbsp_availability_price","description":"Stores dopbsp availability price data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_availability_price` (\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `price` float unsigned NOT NULL DEFAULT '0',\\n  `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `date_end` datetime NOT NULL DEFAULT '9999-01-01 00:00:00',\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `price` (`price`),\\n  KEY `date_start` (`date_start`),\\n  KEY `date_end` (`date_end`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_calendars","full_table_name":"wp_dopbsp_calendars","description":"Stores dopbsp calendars data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_calendars` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `post_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `max_year` int unsigned NOT NULL DEFAULT '0',\\n  `hours_enabled` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `hours_interval_enabled` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `min_available` float NOT NULL DEFAULT '0',\\n  `price_min` float NOT NULL DEFAULT '0',\\n  `price_max` float NOT NULL DEFAULT '0',\\n  `rating` float NOT NULL DEFAULT '0',\\n  `address` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `address_en` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `address_alt` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `address_alt_en` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `default_availability` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `last_update_google` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `last_update_airbnb` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `coordinates` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`),\\n  KEY `post_id` (`post_id`),\\n  KEY `min_available` (`min_available`),\\n  KEY `price_min` (`price_min`),\\n  KEY `price_max` (`price_max`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_coupons","full_table_name":"wp_dopbsp_coupons","description":"Stores dopbsp coupons data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_coupons` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `start_date` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `end_date` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `start_hour` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `end_hour` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `no_coupons` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `operation` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '+',\\n  `price` float NOT NULL DEFAULT '0',\\n  `price_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'fixed',\\n  `price_by` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'once',\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_days","full_table_name":"wp_dopbsp_days","description":"Stores dopbsp days data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_days` (\\n  `unique_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `day` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `year` smallint unsigned NOT NULL DEFAULT '2026',\\n  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `min_available` float NOT NULL DEFAULT '0',\\n  `price_min` float NOT NULL DEFAULT '0',\\n  `price_max` float NOT NULL DEFAULT '0',\\n  UNIQUE KEY `id` (`unique_key`),\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `day` (`day`),\\n  KEY `year` (`year`),\\n  KEY `min_available` (`min_available`),\\n  KEY `price_min` (`price_min`),\\n  KEY `price_max` (`price_max`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_discounts","full_table_name":"wp_dopbsp_discounts","description":"Stores dopbsp discounts data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_discounts` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `extras` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_discounts_items","full_table_name":"wp_dopbsp_discounts_items","description":"Stores dopbsp discounts items data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_discounts_items` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `discount_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `position` int unsigned NOT NULL DEFAULT '0',\\n  `start_time_lapse` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `end_time_lapse` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `operation` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '-',\\n  `price` float NOT NULL DEFAULT '0',\\n  `price_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'percent',\\n  `price_by` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'once',\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `discount_id` (`discount_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_discounts_items_rules","full_table_name":"wp_dopbsp_discounts_items_rules","description":"Stores dopbsp discounts items rules data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_discounts_items_rules` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `discount_item_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `position` int unsigned NOT NULL DEFAULT '0',\\n  `start_date` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `end_date` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `start_hour` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `end_hour` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `operation` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '-',\\n  `price` float NOT NULL DEFAULT '0',\\n  `price_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'percent',\\n  `price_by` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'once',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `discount_item_id` (`discount_item_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_emails","full_table_name":"wp_dopbsp_emails","description":"Stores dopbsp emails data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_emails` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_emails_translation","full_table_name":"wp_dopbsp_emails_translation","description":"Stores dopbsp emails translation data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_emails_translation` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `email_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `template` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `subject` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `email_id` (`email_id`),\\n  KEY `template` (`template`)\\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_extras","full_table_name":"wp_dopbsp_extras","description":"Stores dopbsp extras data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_extras` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_extras_groups","full_table_name":"wp_dopbsp_extras_groups","description":"Stores dopbsp extras groups data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_extras_groups` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `extra_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `position` int unsigned NOT NULL DEFAULT '0',\\n  `multiple_select` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `required` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `no_items_multiply` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'true',\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `extra_id` (`extra_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_extras_groups_items","full_table_name":"wp_dopbsp_extras_groups_items","description":"Stores dopbsp extras groups items data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_extras_groups_items` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `group_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `position` int unsigned NOT NULL DEFAULT '0',\\n  `operation` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '+',\\n  `price` float NOT NULL DEFAULT '0',\\n  `price_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'fixed',\\n  `price_by` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'once',\\n  `default_value` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'no',\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `group_id` (`group_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_fees","full_table_name":"wp_dopbsp_fees","description":"Stores dopbsp fees data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_fees` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `operation` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '+',\\n  `price` float NOT NULL DEFAULT '0',\\n  `price_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'fixed',\\n  `price_by` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'once',\\n  `included` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'true',\\n  `extras` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'true',\\n  `cart` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'true',\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_forms","full_table_name":"wp_dopbsp_forms","description":"Stores form definitions and related configuration.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_forms` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_forms_fields","full_table_name":"wp_dopbsp_forms_fields","description":"Stores form definitions and related configuration.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_forms_fields` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `form_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `position` int unsigned NOT NULL DEFAULT '0',\\n  `multiple_select` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `allowed_characters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `size` int unsigned NOT NULL DEFAULT '0',\\n  `is_email` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `is_phone` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `default_country` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'US',\\n  `required` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `add_to_day_hour_info` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `add_to_day_hour_body` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `form_id` (`form_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_forms_select_options","full_table_name":"wp_dopbsp_forms_select_options","description":"Stores form definitions and related configuration.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_forms_select_options` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `field_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `position` int unsigned NOT NULL DEFAULT '0',\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `field_id` (`field_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_languages","full_table_name":"wp_dopbsp_languages","description":"Stores dopbsp languages data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_languages` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `code` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `enabled` varchar(6) NOT NULL DEFAULT '0',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `code` (`code`),\\n  KEY `enabled` (`enabled`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_locations","full_table_name":"wp_dopbsp_locations","description":"Stores dopbsp locations data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_locations` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `address` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `address_en` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `address_alt` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `address_alt_en` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `coordinates` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `calendars` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `link` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `image` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `businesses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `businesses_other` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `languages` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `email` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_reservations","full_table_name":"wp_dopbsp_reservations","description":"Stores dopbsp reservations data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_reservations` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `language` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'en',\\n  `currency` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '$',\\n  `currency_code` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'USD',\\n  `check_in` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `check_out` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `start_hour` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `end_hour` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `no_items` int unsigned NOT NULL DEFAULT '1',\\n  `price` float NOT NULL DEFAULT '0',\\n  `price_total` float NOT NULL DEFAULT '0',\\n  `refund` float NOT NULL DEFAULT '0',\\n  `extras` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `extras_price` float NOT NULL DEFAULT '0',\\n  `discount` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `discount_price` float NOT NULL DEFAULT '0',\\n  `coupon` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `coupon_price` float NOT NULL DEFAULT '0',\\n  `fees` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `fees_price` float NOT NULL DEFAULT '0',\\n  `deposit` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `deposit_price` float NOT NULL DEFAULT '0',\\n  `days_hours_history` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `form` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `address_billing` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `address_shipping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `stripe_user` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'pending',\\n  `payment_method` varchar(32) NOT NULL DEFAULT 'default',\\n  `payment_status` varchar(32) NOT NULL DEFAULT 'pending',\\n  `transaction_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `reservation_from` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'pinpoint',\\n  `uid` varchar(75) NOT NULL,\\n  `token` varchar(128) NOT NULL DEFAULT '',\\n  `ip` varchar(32) NOT NULL DEFAULT '',\\n  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `check_in` (`check_in`),\\n  KEY `check_out` (`check_out`),\\n  KEY `start_hour` (`end_hour`),\\n  KEY `status` (`status`),\\n  KEY `payment_method` (`payment_method`),\\n  KEY `transaction_id` (`transaction_id`),\\n  KEY `uid` (`uid`),\\n  KEY `token` (`token`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_rules","full_table_name":"wp_dopbsp_rules","description":"Stores dopbsp rules data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_rules` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `time_lapse_min` float NOT NULL DEFAULT '0',\\n  `time_lapse_max` float NOT NULL DEFAULT '0',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_searches","full_table_name":"wp_dopbsp_searches","description":"Stores dopbsp searches data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_searches` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `calendars_excluded` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `currency` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'USD',\\n  `currency_position` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'before',\\n  `hours_enabled` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_settings","full_table_name":"wp_dopbsp_settings","description":"Stores dopbsp settings data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_settings` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  KEY `id` (`id`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_settings_calendar","full_table_name":"wp_dopbsp_settings_calendar","description":"Stores dopbsp settings calendar data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_settings_calendar` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  KEY `id` (`id`),\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_settings_notifications","full_table_name":"wp_dopbsp_settings_notifications","description":"Stores dopbsp settings notifications data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_settings_notifications` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  KEY `id` (`id`),\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_settings_payment","full_table_name":"wp_dopbsp_settings_payment","description":"Stores dopbsp settings payment data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_settings_payment` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `calendar_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  KEY `id` (`id`),\\n  KEY `calendar_id` (`calendar_id`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_settings_search","full_table_name":"wp_dopbsp_settings_search","description":"Stores dopbsp settings search data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_settings_search` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `search_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  KEY `id` (`id`),\\n  KEY `search_id` (`search_id`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_smses","full_table_name":"wp_dopbsp_smses","description":"Stores dopbsp smses data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_smses` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `user_id` (`user_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_smses_translation","full_table_name":"wp_dopbsp_smses_translation","description":"Stores dopbsp smses translation data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_smses_translation` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `sms_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `template` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  UNIQUE KEY `id` (`id`),\\n  KEY `sms_id` (`sms_id`),\\n  KEY `template` (`template`)\\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"},{"table_name":"dopbsp_translation_en","full_table_name":"wp_dopbsp_translation_en","description":"Stores dopbsp translation en data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_dopbsp_translation_en` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `key_data` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `parent_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `text_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `translation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `location` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'backend',\\n  UNIQUE KEY `id` (`id`),\\n  KEY `key_data` (`key_data`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"}],"table_count":32}