wp_booking_form_structures

Static

Stores form definitions and related configuration.

Column Definitions

ColumnTypeNullable
🔑booking_form_idbigint(20) unsignedNO
form_slugVARCHAR(191)NO
statusVARCHAR(32)NO
owner_user_idBIGINT(20) UNSIGNEDNO
scopevarchar(64)NO
versionint(11)NO
booking_resource_idBIGINT UNSIGNEDYES
enginevarchar(32)NO
engine_versionvarchar(16)NO
structure_jsonLONGTEXTNO
settings_jsonLONGTEXTYES
advanced_formLONGTEXTYES
content_formLONGTEXTYES
is_defaultTINYINT(1)NO
titleVARCHAR(255)NO
descriptionTEXTYES
picture_urltextYES
created_atDATETIMENO
updated_atDATETIMENO
created_bybigint(20) unsignedYES
updated_bybigint(20) unsignedYES

CREATE TABLE Statement

CREATE TABLE wp_booking_form_structures ( booking_form_id bigint(20) unsigned NOT NULL auto_increment, form_slug VARCHAR(191) NOT NULL, status VARCHAR(32) NOT NULL, owner_user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, scope varchar(64) NOT NULL default 'global', version int(11) NOT NULL default 1, booking_resource_id BIGINT UNSIGNED NULL, engine varchar(32) NOT NULL default 'bfb', engine_version varchar(16) NOT NULL default '1.0', structure_json LONGTEXT NOT NULL, settings_json LONGTEXT NULL, advanced_form LONGTEXT NULL, content_form LONGTEXT NULL, is_default TINYINT(1) NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL, description TEXT NULL, picture_url text NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, created_by bigint(20) unsigned DEFAULT NULL, updated_by bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (booking_form_id), UNIQUE KEY form_slug_status (form_slug, status, owner_user_id) ) {$charset_collate}"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter $wpdb->query( $simple_sql );

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_form_structures`;

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

Other tables from Booking Calendar