{"table_name":"booking_dates_props","full_table_name":"wp_booking_dates_props","description":"Stores booking dates props data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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' );","columns":[{"name":"booking_dates_prop_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"resource_id","type":"bigint(10)","nullable":false,"primary_key":false},{"name":"calendar_date","type":"datetime","nullable":false,"primary_key":false},{"name":"prop_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"prop_value","type":"text","nullable":true,"primary_key":false}],"plugin":{"slug":"booking","name":"Booking Calendar","active_installs":50000,"version":"11.3","wp_org_url":"https://wordpress.org/plugins/booking/"}}