wp_booking_dates_props
StaticStores booking dates props data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑booking_dates_prop_id | bigint(20) unsigned | NO |
| resource_id | bigint(10) | NO |
| calendar_date | datetime | NO |
| prop_name | varchar(200) | NO |
| prop_value | text | YES |
CREATE TABLE Statement
CREATE TABLE wp_booking_dates_props ( booking_dates_prop_id bigint(20) unsigned NOT NULL auto_increment, resource_id bigint(10) NOT NULL default 1, calendar_date datetime NOT NULL default '0000-00-00 00:00:00', prop_name varchar(200) NOT NULL default '', prop_value text, PRIMARY KEY (booking_dates_prop_id) )"; */ } /** * Update dates status * * @param $params array( 'resource_id' => 1, // int 'prop_name' => 'date_status', // 'rate', 'allow_start_day_selection', 'allow_days_number_to_select', 'availability_count', ... 'prop_value' => 'unavailable', // 'available', 'unavailable' , 'pending', 'approved' 'dates_selection' => '' // '2023-04-04 | 2023-04-07' ) * * @return bool|int - return how many DB rows affected -how many dates processed */ function wpbc_availability__update_dates_status__sql( $params ){ $defaults = array( 'resource_id' => 1, // int 'prop_name' => 'date_status', // 'rate', 'allow_start_day_selection', 'allow_days_number_to_select', 'availability_count', ... 'prop_value' => 'unavailable', // 'available', 'unavailable' , 'pending', 'approved' 'dates_selection' => '' // '2023-04-04 | 2023-04-07' );Safe to delete?
If you have uninstalled Booking Calendar, 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_booking_dates_props`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Booking Calendar