{"slug":"wp-hotelier","name":"WP Hotelier","description":"WP Hotelier is a powerful WordPress hotel booking plugin allows you to manage hotel, hostel, b&b reservations with ease.","author":"benitolopez","active_installs":2000,"version":"2.19.0","wp_org_url":"https://wordpress.org/plugins/wp-hotelier/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"hotelier_bookings","full_table_name":"wp_hotelier_bookings","description":"Stores hotelier bookings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"hotelier_reservation_itemmeta","full_table_name":"wp_hotelier_reservation_itemmeta","description":"Stores hotelier reservation itemmeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"hotelier_reservation_items","full_table_name":"wp_hotelier_reservation_items","description":"Stores hotelier reservation items data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"reservation_item_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"reservation_item_name","type":"longtext","nullable":false,"primary_key":false},{"name":"reservation_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"reservation_item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"reservation_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"reservation_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"room_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"session_key","type":"char(32)","nullable":false,"primary_key":false},{"name":"session_value","type":"longtext","nullable":false,"primary_key":false},{"name":"session_expiry","type":"bigint(20)","nullable":false,"primary_key":false}],"create_sql":"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' ) . ']' ) );"},{"table_name":"hotelier_rooms_bookings","full_table_name":"wp_hotelier_rooms_bookings","description":"Stores hotelier rooms bookings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"hotelier_sessions","full_table_name":"wp_hotelier_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":5}