{"table_name":"dopbsp_reservations","full_table_name":"wp_dopbsp_reservations","description":"Stores dopbsp reservations data created by this plugin.","detection_method":"live","confidence":"high","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","columns":[],"plugin":{"slug":"booking-system","name":"Pinpoint Booking System – Version 2","active_installs":3000,"version":"2.9.9.6.9","wp_org_url":"https://wordpress.org/plugins/booking-system/"}}