wp_hotelier_reservation_items
StaticStores hotelier reservation items data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑reservation_item_id | bigint(20) | NO |
| reservation_item_name | longtext | NO |
| reservation_id | bigint(20) | NO |
| reservation_item_id | bigint(20) | NO |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
| reservation_id | bigint(20) | NO |
| status | varchar(255) | NO |
| reservation_id | bigint(20) | NO |
| room_id | bigint(20) | NO |
| session_key | char(32) | NO |
| session_value | longtext | NO |
| session_expiry | bigint(20) | NO |
CREATE TABLE Statement
CREATE TABLE wp_hotelier_reservation_items ( reservation_item_id bigint(20) NOT NULL auto_increment, reservation_item_name longtext NOT NULL, reservation_id bigint(20) NOT NULL, PRIMARY KEY (reservation_item_id), KEY reservation_id (reservation_id) ) $charset_collate; CREATE TABLE wp_hotelier_reservation_itemmeta ( meta_id bigint(20) NOT NULL auto_increment, reservation_item_id bigint(20) NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY reservation_item_id (reservation_item_id), KEY meta_key (meta_key) ) $charset_collate; CREATE TABLE wp_hotelier_bookings ( id bigint(20) NOT NULL auto_increment, reservation_id bigint(20) NOT NULL, checkin date NOT NULL, checkout date NOT NULL, status varchar(255) NOT NULL, PRIMARY KEY (id), KEY reservation_id (reservation_id) ) $charset_collate; CREATE TABLE wp_hotelier_rooms_bookings ( id bigint(20) NOT NULL auto_increment, reservation_id bigint(20) NOT NULL, room_id bigint(20) NOT NULL, PRIMARY KEY (id), KEY reservation_id (reservation_id), KEY room_id (room_id) ) $charset_collate; CREATE TABLE wp_hotelier_sessions ( session_id bigint(20) NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value longtext NOT NULL, session_expiry bigint(20) NOT NULL, UNIQUE KEY session_id (session_id), PRIMARY KEY (session_key) ) $charset_collate; "; return $sql; } /** * Create Hotelier pages, storing page id's in variables. */ public static function create_pages() { $pages = array( 'listing' => array( 'name' => esc_html_x( 'available-rooms', 'Page slug', 'wp-hotelier' ), 'title' => esc_html_x( 'Available rooms', 'Page title', 'wp-hotelier' ), 'content' => '[' . apply_filters( 'hotelier_listing_shortcode_tag', 'hotelier_listing' ) . ']' ), 'booking' => array( 'name' => esc_html_x( 'booking', 'Page slug', 'wp-hotelier' ), 'title' => esc_html_x( 'Booking', 'Page title', 'wp-hotelier' ), 'content' => '[' . apply_filters( 'hotelier_booking_shortcode_tag', 'hotelier_booking' ) . ']' ) );Safe to delete?
If you have uninstalled WP Hotelier, 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_hotelier_reservation_items`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP Hotelier