wp_babe_rates

Column Definitions

CREATE TABLE Statement

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' );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_babe_rates`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from BA Book Everything