{"slug":"ba-book-everything","name":"BA Book Everything","description":"The really fast and powerful Booking engine for theme/site developers to create any booking or rental sites (tours, cars, events, apartments, yachts)","author":"bookingalgorithms","active_installs":10000,"version":"1.8.25","wp_org_url":"https://wordpress.org/plugins/ba-book-everything/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"babe_av_cal","full_table_name":"wp_babe_av_cal","description":"Stores babe av cal data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"babe_booking_rules","full_table_name":"wp_babe_booking_rules","description":"Stores babe booking rules data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"babe_category_deactivate_schedule","full_table_name":"wp_babe_category_deactivate_schedule","description":"Stores babe category deactivate schedule data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"category_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"deactivate_date_from","type":"datetime","nullable":true,"primary_key":false},{"name":"deactivate_date_to","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_babe_category_deactivate_schedule ( id int NOT NULL AUTO_INCREMENT, category_id bigint(20) DEFAULT NULL, deactivate_date_from datetime DEFAULT NULL, deactivate_date_to datetime DEFAULT NULL, PRIMARY KEY (id), KEY category_id (category_id), KEY deactivate_date_from (deactivate_date_from), KEY deactivate_date_to (deactivate_date_to), KEY category_deactivate_date_from_to (category_id, deactivate_date_from, deactivate_date_to) ) $collate;\" );"},{"table_name":"babe_discount","full_table_name":"wp_babe_discount","description":"Stores babe discount data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"babe_order_itemmeta","full_table_name":"wp_babe_order_itemmeta","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"babe_order_items","full_table_name":"wp_babe_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"babe_payment_tokenmeta","full_table_name":"wp_babe_payment_tokenmeta","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"babe_payment_tokens","full_table_name":"wp_babe_payment_tokens","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"babe_rates","full_table_name":"wp_babe_rates","description":"Stores babe rates data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"rate_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"booking_obj_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"rate_title","type":"text","nullable":true,"primary_key":false},{"name":"date_from","type":"datetime","nullable":true,"primary_key":false},{"name":"date_to","type":"datetime","nullable":true,"primary_key":false},{"name":"apply_days","type":"longtext","nullable":true,"primary_key":false},{"name":"start_days","type":"longtext","nullable":true,"primary_key":false},{"name":"min_booking_period","type":"int(4)","nullable":true,"primary_key":false},{"name":"max_booking_period","type":"int(4)","nullable":true,"primary_key":false},{"name":"price_from","type":"float","nullable":true,"primary_key":false},{"name":"price_general","type":"longtext","nullable":true,"primary_key":false},{"name":"prices_conditional","type":"longtext","nullable":true,"primary_key":false},{"name":"color","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"rate_order","type":"int(11)","nullable":true,"primary_key":false},{"name":"booking_obj_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"date_from","type":"datetime","nullable":true,"primary_key":false},{"name":"guests","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"in_schedule","type":"int(1)","nullable":true,"primary_key":false},{"name":"av_guests","type":"INT","nullable":true,"primary_key":false},{"name":"rule_title","type":"text","nullable":true,"primary_key":false},{"name":"basic_booking_period","type":"varchar(24)","nullable":true,"primary_key":false},{"name":"hold","type":"int","nullable":true,"primary_key":false},{"name":"stop_booking_before","type":"int","nullable":true,"primary_key":false},{"name":"ages","type":"int(1)","nullable":true,"primary_key":false},{"name":"payment_model","type":"varchar(24)","nullable":true,"primary_key":false},{"name":"deposit","type":"float","nullable":true,"primary_key":false},{"name":"recurrent_payments","type":"int(1)","nullable":true,"primary_key":false},{"name":"booking_mode","type":"varchar(24)","nullable":true,"primary_key":false},{"name":"booking_obj_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"date_from","type":"datetime","nullable":true,"primary_key":false},{"name":"date_to","type":"datetime","nullable":true,"primary_key":false},{"name":"discount","type":"float","nullable":true,"primary_key":false},{"name":"booking_obj_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"order_item_name","type":"longtext","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_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":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"gateway_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"token","type":"text","nullable":false,"primary_key":false},{"name":"amount","type":"float","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_default","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"payment_token_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":"category_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"deactivate_date_from","type":"datetime","nullable":true,"primary_key":false},{"name":"deactivate_date_to","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_babe_rates ( rate_id bigint(20) NOT NULL AUTO_INCREMENT, booking_obj_id bigint(20) DEFAULT NULL, rate_title text DEFAULT NULL, date_from datetime DEFAULT NULL, date_to datetime DEFAULT NULL, apply_days longtext DEFAULT NULL, start_days longtext DEFAULT NULL, min_booking_period int(4) DEFAULT '0', max_booking_period int(4) DEFAULT '0', price_from float DEFAULT '0', price_general longtext DEFAULT NULL, prices_conditional longtext DEFAULT NULL, color varchar(16) DEFAULT NULL, rate_order int(11) DEFAULT '0', PRIMARY KEY (rate_id), KEY booking_obj_id (booking_obj_id), KEY date_from (date_from), KEY date_to (date_to), KEY price_from (price_from), KEY rate_order (rate_order), KEY apply_days (apply_days(191)), KEY start_days (start_days(191)), KEY min_booking_period (min_booking_period), KEY max_booking_period (max_booking_period), KEY booking_obj_date_from_to (booking_obj_id, date_from, date_to), KEY booking_obj_date_from_to_apply_days (booking_obj_id, date_from, date_to, apply_days(64)) ) $collate; CREATE TABLE wp_babe_av_cal ( id bigint(20) NOT NULL AUTO_INCREMENT, booking_obj_id bigint(20) DEFAULT NULL, date_from datetime DEFAULT NULL, guests bigint(20) DEFAULT '0', in_schedule int(1) DEFAULT '0', av_guests INT DEFAULT 0, PRIMARY KEY (id), KEY booking_obj_id (booking_obj_id), KEY date_from (date_from), KEY guests (guests), KEY in_schedule (in_schedule), KEY av_guests (av_guests), KEY booking_obj_date_from_guests_in_schedule (booking_obj_id,date_from,guests,in_schedule), KEY booking_obj_date_from_av_guests_in_schedule (booking_obj_id,date_from,av_guests,in_schedule) ) $collate; CREATE TABLE wp_babe_booking_rules ( rule_id bigint(20) NOT NULL AUTO_INCREMENT, rule_title text DEFAULT NULL, basic_booking_period varchar(24) DEFAULT NULL, hold int DEFAULT '0', stop_booking_before int DEFAULT '0', ages int(1) DEFAULT '0', payment_model varchar(24) DEFAULT NULL, deposit float DEFAULT '0', recurrent_payments int(1) DEFAULT '0', booking_mode varchar(24) DEFAULT NULL, PRIMARY KEY (rule_id), KEY basic_booking_period (basic_booking_period), KEY hold (hold), KEY stop_booking_before (stop_booking_before), KEY ages (ages), KEY payment_model (payment_model), KEY deposit (deposit), KEY recurrent_payments (recurrent_payments), KEY booking_mode (booking_mode) ) $collate; CREATE TABLE wp_babe_discount ( id bigint(20) NOT NULL AUTO_INCREMENT, booking_obj_id bigint(20) DEFAULT NULL, date_from datetime DEFAULT NULL, date_to datetime DEFAULT NULL, discount float DEFAULT '0', PRIMARY KEY (id), KEY booking_obj_id (booking_obj_id), KEY date_from (date_from), KEY date_to (date_to) ) $collate; CREATE TABLE wp_babe_order_items ( order_item_id bigint(20) NOT NULL AUTO_INCREMENT, booking_obj_id bigint(20) DEFAULT NULL, order_item_name longtext NOT NULL, order_id bigint(20) NOT NULL, PRIMARY KEY (order_item_id), KEY booking_obj_id (booking_obj_id), KEY order_id (order_id) ) $collate; CREATE TABLE wp_babe_order_itemmeta ( meta_id bigint(20) NOT NULL AUTO_INCREMENT, order_item_id bigint(20) NOT NULL, meta_key varchar(255) default NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY order_item_id (order_item_id), KEY meta_key (meta_key($max_index_length)) ) $collate; CREATE TABLE wp_babe_payment_tokens ( token_id bigint(20) NOT NULL AUTO_INCREMENT, order_id bigint(20) NOT NULL, gateway_id varchar(255) NOT NULL, token text NOT NULL, amount float DEFAULT '0', user_id bigint(20) NOT NULL DEFAULT '0', type varchar(255) NOT NULL, is_default tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (token_id), KEY user_id (user_id), KEY order_id (order_id), KEY gateway_id (gateway_id(191)), KEY amount (amount), KEY is_default (is_default) ) $collate; CREATE TABLE wp_babe_payment_tokenmeta ( meta_id bigint(20) NOT NULL AUTO_INCREMENT, payment_token_id bigint(20) NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY payment_token_id (payment_token_id), KEY meta_key (meta_key($max_index_length)) ) $collate; CREATE TABLE wp_babe_category_deactivate_schedule ( id int NOT NULL AUTO_INCREMENT, category_id bigint(20) DEFAULT NULL, deactivate_date_from datetime DEFAULT NULL, deactivate_date_to datetime DEFAULT NULL, PRIMARY KEY (id), KEY category_id (category_id), KEY deactivate_date_from (deactivate_date_from), KEY deactivate_date_to (deactivate_date_to), KEY category_deactivate_date_from_to (category_id, deactivate_date_from, deactivate_date_to) ) $collate; \"; return $tables; } ////////////////////////////// /** * Setup thumbnails * * @return void */ public static function setup_thumbnails() { if ( ! current_theme_supports( 'post-thumbnails' ) ) { add_theme_support( 'post-thumbnails' );"},{"table_name":"babe_rates_meta","full_table_name":"wp_babe_rates_meta","description":"Stores additional metadata (key-value pairs) for babe rates records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":10}