{"slug":"wp-hotel-booking","name":"WP Hotel Booking","description":"WordPress Hotel Booking Plugin - A complete hotel booking reservation plugin for WordPress.","author":"ThimPress","active_installs":7000,"version":"2.3.2","wp_org_url":"https://wordpress.org/plugins/wp-hotel-booking/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"hotel_booking_order_itemmeta","full_table_name":"wp_hotel_booking_order_itemmeta","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"meta_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"hotel_booking_order_item_id","type":"bigint(20) unsigned","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}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_hotel_booking_order_itemmeta ( meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, hotel_booking_order_item_id bigint(20) unsigned NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, UNIQUE KEY meta_id (meta_id), PRIMARY KEY (meta_id), KEY hotel_booking_order_item_id(hotel_booking_order_item_id) ) $charset_collate; \"; dbDelta( $sql );"},{"table_name":"hotel_booking_order_items","full_table_name":"wp_hotel_booking_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"order_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"order_item_name","type":"longtext","nullable":false,"primary_key":false},{"name":"order_item_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"order_item_parent","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false}],"create_sql":"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 );"},{"table_name":"hotel_booking_plans","full_table_name":"wp_hotel_booking_plans","description":"Stores hotel booking plans data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"plan_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"room_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"start_time","type":"timestamp","nullable":true,"primary_key":false},{"name":"end_time","type":"timestamp","nullable":true,"primary_key":false},{"name":"pricing","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_hotel_booking_plans ( plan_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, room_id bigint(20) unsigned NOT NULL, start_time timestamp NULL, end_time timestamp NULL, pricing longtext NULL, UNIQUE KEY plan_id (plan_id), PRIMARY KEY (plan_id) ) $charset_collate; \"; dbDelta( $sql );"}],"table_count":3}