wp_base_bookings
StaticStores base bookings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | bigint(20) unsigned | NO |
| parent_id | bigint(20) unsigned | NO |
| created | datetime | YES |
| user | bigint(20) | NO |
| location | bigint(20) | NO |
| service | bigint(20) | NO |
| worker | bigint(20) | NO |
| status | varchar(35) | YES |
| start | datetime | YES |
| end | datetime | YES |
| seats | bigint(20) | NO |
| gcal_ID | varchar(250) | YES |
| gcal_updated | datetime | YES |
| price | varchar(50) | YES |
| deposit | varchar(50) | YES |
| payment_method | varchar(35) | YES |
| transaction_app_ID | bigint(20) | NO |
| transaction_paypal_ID | varchar(30) | YES |
| transaction_stamp | bigint(35) | NO |
| transaction_total_amount | varchar(255) | YES |
| transaction_currency | varchar(35) | YES |
| transaction_status | varchar(35) | YES |
| transaction_note | text | YES |
| transaction_gateway | varchar(200) | YES |
| sort_order | bigint(20) | NO |
| name | varchar(255) | YES |
| locations | text | YES |
| capacity | bigint(20) | NO |
| duration | bigint(20) | NO |
| padding | bigint(20) | NO |
| break_time | bigint(20) | NO |
| internal | tinyint(1) | NO |
| price | varchar(255) | YES |
| deposit | varchar(255) | YES |
| page | bigint(20) | NO |
| categories | text | YES |
| sort_order | bigint(20) | NO |
| name | varchar(255) | YES |
| dummy | varchar(255) | YES |
| price | varchar(255) | YES |
| services_provided | text | YES |
| page | bigint(20) | NO |
| sort_order | bigint(20) | NO |
| name | varchar(255) | YES |
| capacity | bigint(20) | NO |
| price | varchar(255) | YES |
| page | bigint(20) | NO |
| object_id | bigint(20) unsigned | NO |
| meta_type | varchar(50) | YES |
| meta_key | varchar(50) | YES |
| meta_value | longtext | YES |
| avail_data | text | YES |
| avail_data | text | YES |
| avail_data | text | YES |
CREATE TABLE Statement
CREATE TABLE wp_base_bookings ( ID bigint(20) unsigned NOT null auto_increment, parent_id bigint(20) unsigned NOT null default '0', created datetime, user bigint(20) NOT null default '0', location bigint(20) NOT null default '0', service bigint(20) NOT null default '0', worker bigint(20) NOT null default '0', status varchar(35) default null, start datetime default null, end datetime default null, seats bigint(20) NOT null default '1', gcal_ID varchar(250) default null, gcal_updated datetime, price varchar(50) default null, deposit varchar(50) default null, payment_method varchar(35) default null, PRIMARY KEY (ID), UNIQUE KEY gcal_ID (gcal_ID) ) $collate; CREATE TABLE wp_base_transactions ( transaction_ID bigint(20) unsigned NOT null auto_increment, transaction_app_ID bigint(20) NOT null default '0', transaction_paypal_ID varchar(30) default null, transaction_stamp bigint(35) NOT null default '0', transaction_total_amount varchar(255) default null, transaction_currency varchar(35) default null, transaction_status varchar(35) default null, transaction_note text, transaction_gateway varchar(200) default null, PRIMARY KEY (transaction_ID), KEY transaction_app_ID (transaction_app_ID) ) $collate; CREATE TABLE wp_base_services ( ID bigint(20) unsigned NOT null auto_increment, sort_order bigint(20) NOT null default '0', name varchar(255) default null, locations text, capacity bigint(20) NOT null default '0', duration bigint(20) NOT null default '0', padding bigint(20) NOT null default '0', break_time bigint(20) NOT null default '0', internal tinyint(1) NOT null default '0', price varchar(255) default null, deposit varchar(255) default null, page bigint(20) NOT null default '0', categories text, PRIMARY KEY (ID) ) $collate; CREATE TABLE wp_base_workers ( ID bigint(20) unsigned, sort_order bigint(20) NOT null default '0', name varchar(255) default null, dummy varchar(255) default null, price varchar(255) default null, services_provided text, page bigint(20) NOT null default '0', PRIMARY KEY (ID) ) $collate; CREATE TABLE wp_base_locations ( ID bigint(20) unsigned NOT null auto_increment, sort_order bigint(20) NOT null default '0', name varchar(255) default null, capacity bigint(20) NOT null default '0', price varchar(255) default null, page bigint(20) NOT null default '0', PRIMARY KEY (ID) ) $collate; CREATE TABLE wp_base_meta ( meta_id bigint(20) unsigned NOT null AUTO_INCREMENT, object_id bigint(20) unsigned NOT null DEFAULT '0', meta_type varchar(50) DEFAULT null, meta_key varchar(50) DEFAULT null, meta_value longtext , PRIMARY KEY (meta_id), KEY object_id (object_id), KEY meta_type (meta_type), KEY meta_key (meta_key) ) $collate; "; if ( defined( 'WPB_USE_INNODB' ) && WPB_USE_INNODB ) { $SQL2 =" CREATE TABLE wp_base_wh_w ( ID bigint(20) unsigned NOT null, avail_data text, PRIMARY KEY (ID) ) $collate; CREATE TABLE wp_base_wh_s ( ID bigint(20) unsigned NOT null, avail_data text, PRIMARY KEY (ID) ) $collate; CREATE TABLE wp_base_wh_a ( ID bigint(20) unsigned NOT null, avail_data text, PRIMARY KEY (ID) ) $collate; "; } else { $columns = ''; foreach ( range(0,287) as $no ) { $columns .= "`c".$no."` text,". "\n"; } $columns = rtrim( $columns, "\n" );Safe to delete?
If you have uninstalled WP BASE Booking of Appointments, Services and Events, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_base_bookings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP BASE Booking of Appointments, Services and Events