wp_hotel_booking_order_items

Static

Stores order records and related transaction data.

Column Definitions

Column	Type	Nullable
🔑order_item_id	bigint(20) unsigned	NO
order_item_name	longtext	NO
order_item_type	varchar(255)	NO
order_item_parent	bigint(20)	YES
order_id	bigint(20) unsigned	NO

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_hotel_booking_order_items ( order_item_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_item_name longtext NOT NULL, order_item_type varchar(255) NOT NULL, order_item_parent bigint(20) NULL, order_id bigint(20) unsigned NOT NULL, UNIQUE KEY order_item_id (order_item_id), PRIMARY KEY (order_item_id) ) $charset_collate; "; dbDelta( $sql );

Safe to delete?

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

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

Other tables from WP Hotel Booking

wp_hotel_booking_order_itemmeta wp_hotel_booking_plans