wp_bookings

Static

Stores bookings data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	BIGINT UNSIGNED	NO
room_id	BIGINT UNSIGNED	NO
purchase_plan_id	INT	NO
date_start	date	NO
date_end	date	NO
booking_date	date	NO
no_rooms	INT	NO
adult	INT	NO
kid	INT	NO
total_charge	DECIMAL(10,2)	NO
total_taxes	DECIMAL(10,2)	YES
user_id	BIGINT UNSIGNED	YES
order_id	BIGINT UNSIGNED	YES
first_name	varchar(100)	YES
last_name	varchar(100)	YES
email	varchar(100)	YES
phone	varchar(50)	YES
status	varchar(50)	YES
created_at	DATETIME	YES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_bookings ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `room_id` BIGINT UNSIGNED NOT NULL, `purchase_plan_id` INT NOT NULL, `date_start` date NOT NULL, `date_end` date NOT NULL, `booking_date` date NOT NULL, `no_rooms` INT NOT NULL DEFAULT 1, `adult` INT NOT NULL DEFAULT 1, `kid` INT NOT NULL DEFAULT 0, `total_charge` DECIMAL(10,2) NOT NULL DEFAULT 0, `total_taxes` DECIMAL(10,2) DEFAULT 0, `user_id` BIGINT UNSIGNED DEFAULT NULL, `order_id` BIGINT UNSIGNED DEFAULT NULL, `first_name` varchar(100) DEFAULT NULL, `last_name` varchar(100) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `phone` varchar(50) DEFAULT NULL, `status` varchar(50) DEFAULT 'pending', `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_room_date (room_id, booking_date), KEY idx_order (order_id), KEY idx_user (user_id), KEY idx_status (status), KEY idx_dates (date_start, date_end) ) $charset_collate"; require_once (ABSPATH . 'wp-admin/includes/upgrade.php');

Safe to delete?

If you have uninstalled Saksh WP Hotel Booking Lite, 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_bookings`;

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