wp_bfmsf_analytics
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint(9) | NO |
| title | varchar(255) | NO |
| description | longtext | YES |
| status | varchar(20) | YES |
| created_date | datetime | YES |
| modified_date | datetime | YES |
| created_by | bigint(20) | YES |
| form_id | mediumint(9) | NO |
| step_number | mediumint(9) | NO |
| field_order | mediumint(9) | NO |
| field_type | varchar(50) | NO |
| field_label | varchar(255) | NO |
| field_name | varchar(255) | NO |
| field_placeholder | varchar(255) | YES |
| field_required | tinyint(1) | YES |
| field_options | longtext | YES |
| form_id | mediumint(9) | NO |
| submission_data | longtext | NO |
| submitted_date | datetime | YES |
| user_ip | varchar(45) | YES |
| form_id | mediumint(9) | NO |
| date | date | NO |
| views | int(11) | YES |
| submissions | int(11) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS $forms_table ( id mediumint(9) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, description longtext, status varchar(20) DEFAULT 'publish', created_date datetime DEFAULT CURRENT_TIMESTAMP, modified_date datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, created_by bigint(20), PRIMARY KEY (id) ) $charset_collate;"; // Form Fields table $fields_table = wp_'bfmsf_form_fields'; $fields_sql = "CREATE TABLE $fields_table ( id mediumint(9) NOT NULL AUTO_INCREMENT, form_id mediumint(9) NOT NULL, step_number mediumint(9) NOT NULL, field_order mediumint(9) NOT NULL, field_type varchar(50) NOT NULL, field_label varchar(255) NOT NULL, field_name varchar(255) NOT NULL, field_placeholder varchar(255), field_required tinyint(1) DEFAULT 0, field_options longtext, PRIMARY KEY (id) ) $charset_collate;"; // Form Submissions table $submissions_table = wp_'bfmsf_submissions'; $submissions_sql = "CREATE TABLE $submissions_table ( id mediumint(9) NOT NULL AUTO_INCREMENT, form_id mediumint(9) NOT NULL, submission_data longtext NOT NULL, submitted_date datetime DEFAULT CURRENT_TIMESTAMP, user_ip varchar(45), PRIMARY KEY (id) ) $charset_collate;"; $analytics_sql = "CREATE TABLE IF NOT EXISTS wp_bfmsf_analytics ( id mediumint(9) NOT NULL AUTO_INCREMENT, form_id mediumint(9) NOT NULL, date date NOT NULL, views int(11) DEFAULT 0, submissions int(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY form_date (form_id, date) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
Safe to delete?
If you have uninstalled Bullet Forms, 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_bfmsf_analytics`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Bullet Forms