{"table_name":"bookings","full_table_name":"wp_bookings","description":"Stores bookings data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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');","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"room_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"purchase_plan_id","type":"INT","nullable":false,"primary_key":false},{"name":"date_start","type":"date","nullable":false,"primary_key":false},{"name":"date_end","type":"date","nullable":false,"primary_key":false},{"name":"booking_date","type":"date","nullable":false,"primary_key":false},{"name":"no_rooms","type":"INT","nullable":false,"primary_key":false},{"name":"adult","type":"INT","nullable":false,"primary_key":false},{"name":"kid","type":"INT","nullable":false,"primary_key":false},{"name":"total_charge","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"total_taxes","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"first_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"saksh-wp-hotel-booking-lite","name":"Saksh WP Hotel Booking Lite","active_installs":0,"version":"2.1","wp_org_url":"https://wordpress.org/plugins/saksh-wp-hotel-booking-lite/"}}