wp_bitforms_reports
StaticStores bitforms reports data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| category | varchar(50) | NO |
| type | varchar(20) | NO |
| context | varchar(20) | NO |
| details | longtext | YES |
| isDefault | tinyint(1) | YES |
| 1 | default | YES |
| user_ip | int(11) unsigned | YES |
| user_device | varchar(50) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| form_name | varchar(255) | YES |
| form_content | longtext | YES |
| builder_helper_state | longtext | YES |
| atomic_class_map | longtext | YES |
| generated_script_page_ids | longtext | YES |
| user_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| views | int(11) unsigned | YES |
| entries | int(11) unsigned | YES |
| user_device | varchar(50) | YES |
| status | tinyint(1) | YES |
| 1 | published | YES |
| 2 | trashed | YES |
| updated_at | datetime | YES |
| workflow_name | varchar(255) | NO |
| workflow_type | varchar(50) | NO |
| workflow_run | varchar(50) | NO |
| workflow_behaviour | varchar(25) | NO |
| workflow_condition | longtext | YES |
| workflow_info | longtext | YES |
| workflow_order | int(11) unsigned | YES |
| workflow_status | tinyint(1) | YES |
| 1 | enable | YES |
| 2 | enable | YES |
| user_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| user_location | text | YES |
| user_device | varchar(50) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| message_title | varchar(255) | YES |
| message_content | longtext | YES |
| message_config | longtext | YES |
| form_id | bigint(20) unsigned | YES |
| user_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| title | text | YES |
| sub | text | YES |
| body | longtext | YES |
| form_id | bigint(20) unsigned | YES |
| user_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| category | varchar(50) | NO |
| integration_name | varchar(255) | YES |
| integration_type | varchar(50) | NO |
| integration_details | longtext | YES |
| form_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| status | tinyint(1) | YES |
| 1 | published | YES |
| 2 | trashed | YES |
| updated_at | datetime | YES |
| form_id | bigint(20) unsigned | YES |
| user_id | bigint(20) unsigned | YES |
| user_ip | varchar(255) | YES |
| user_location | text | YES |
| user_device | varchar(50) | YES |
| referer | TEXT | YES |
| status | tinyint(1) | YES |
| 1 | viewed | YES |
| 2 | trashed | YES |
| updated_at | datetime | YES |
| bitforms_form_entry_id | bigint(20) unsigned | YES |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
| user_id | int(11) | NO |
| log_type | varchar(50) | YES |
| ip | int(11) | YES |
| action_type | varchar(50) | YES |
| form_entry_id | bigint(20) | YES |
| form_id | bigint(20) | YES |
| content | longtext | YES |
| created_at | DATETIME | NO |
| log_id | bigint(20) | NO |
| integration_id | bigint(20) | YES |
| api_type | varchar(255) | YES |
| response_type | varchar(50) | YES |
| response_obj | LONGTEXT | YES |
| created_at | DATETIME | NO |
| info_type | VARCHAR(50) | NO |
| info_details | LONGTEXT | YES |
| form_id | BIGINT(20) UNSIGNED | NO |
| entry_id | BIGINT(20) UNSIGNED | NO |
| user_id | BIGINT(20) UNSIGNED | YES |
| user_ip | INT(11) UNSIGNED | YES |
| status | INT(1) UNSIGNED | NO |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_bitforms_reports` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(50) NOT NULL, `type` varchar(20) NOT NULL, `context` varchar(20) NOT NULL, `details` longtext DEFAULT NULL, `isDefault` tinyint(1) DEFAULT 0,/* 0 not default, 1 default */ `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `user_device` varchar(50) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_form` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_name` varchar(255) DEFAULT NULL, `form_content` longtext DEFAULT NULL, `builder_helper_state` longtext DEFAULT NULL, `atomic_class_map` longtext DEFAULT NULL, `generated_script_page_ids` longtext DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `views` int(11) unsigned DEFAULT 0, `entries` int(11) unsigned DEFAULT 0, `user_device` varchar(50) DEFAULT NULL, `status` tinyint(1) DEFAULT 1,/* 0 not published, 1 published, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_workflows` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `workflow_name` varchar(255) NOT NULL, `workflow_type` varchar(50) NOT NULL, `workflow_run` varchar(50) NOT NULL, `workflow_behaviour` varchar(25) NOT NULL, `workflow_condition` longtext DEFAULT NULL, `workflow_info` longtext DEFAULT NULL, `workflow_order` int(11) unsigned DEFAULT NULL, `workflow_status` tinyint(1) DEFAULT 1,/* 0 disable, 1 enable, 2 enable in field settings */ `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `user_location` text DEFAULT NULL, `user_device` varchar(50) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_success_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `message_title` varchar(255) DEFAULT NULL, `message_content` longtext DEFAULT NULL, `message_config` longtext DEFAULT NULL, `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_email_template` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` text DEFAULT NULL, `sub` text DEFAULT NULL, `body` longtext DEFAULT NULL, `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_integration` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(50) NOT NULL, `integration_name` varchar(255) DEFAULT NULL, `integration_type` varchar(50) NOT NULL, `integration_details` longtext DEFAULT NULL, `form_id` bigint(20) unsigned DEFAULT NULL, /* form_id = 0 means all/app */ `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `status` tinyint(1) DEFAULT 1,/* 0 disabled, 1 published, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `user_location` text DEFAULT NULL, `user_device` varchar(50) DEFAULT NULL, `referer` TEXT DEFAULT NULL, `status` tinyint(1) DEFAULT 0,/* 0 not viewed, 1 viewed, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entrymeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `bitforms_form_entry_id` bigint(20) unsigned DEFAULT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `meta_key` (`meta_key`({$max_index_length})), KEY `entry_id` (`bitforms_form_entry_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entry_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `log_type` varchar(50) DEFAULT NULL, `ip` int(11) DEFAULT NULL, `action_type` varchar(50) DEFAULT NULL, `form_entry_id` bigint(20) DEFAULT NULL, `form_id` bigint(20) DEFAULT NULL, `content` longtext, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`), KEY `form_entry_id` (`form_entry_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_form_log_details` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `log_id` bigint(20) NOT NULL, `integration_id` bigint(20) DEFAULT NULL, `api_type` varchar(255) DEFAULT NULL, `response_type` varchar(50) DEFAULT NULL, `response_obj` LONGTEXT DEFAULT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `log_id` (`log_id`), KEY `integration_id` (`integration_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitforms_form_entry_relatedinfo` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `info_type` VARCHAR(50) NOT NULL, `info_details` LONGTEXT NULL, `form_id` BIGINT(20) UNSIGNED NOT NULL, `entry_id` BIGINT(20) UNSIGNED NOT NULL, `user_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, `user_ip` INT(11) UNSIGNED NULL DEFAULT NULL, `status` INT(1) UNSIGNED NOT NULL DEFAULT '1', `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `form_id` (`form_id`), KEY `entry_id` (`entry_id`) ) $collate;" ]; try { include_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($table_schema as $table) { dbDelta($table);Safe to delete?
If you have uninstalled Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder, 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_bitforms_reports`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Bit Form – Contact Form, Payment Forms, Multi Step Forms, Calculator & Custom Form Builder