🗄️What WP Table Is This?
Home / Pinpoint Booking System – Version 2 / wp_dopbsp_reservations

wp_dopbsp_reservations

Live

Stores dopbsp reservations data created by this plugin.

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled Pinpoint Booking System – Version 2, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_dopbsp_reservations`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Pinpoint Booking System – Version 2