wp_faan_fields
StaticStores faan fields data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| session_id | varchar(32) | NO |
| field_key | varchar(40) | NO |
| label | varchar(100) | NO |
| field_type | varchar(24) | NO |
| position | smallint(5) unsigned | NO |
| step | smallint(5) unsigned | NO |
| reached | tinyint(1) | NO |
| completed | tinyint(1) | NO |
| errors | smallint(5) unsigned | NO |
| focus_count | smallint(5) unsigned | NO |
| time_ms | int(10) unsigned | NO |
CREATE TABLE Statement
CREATE TABLE wp_faan_fields ( session_id varchar(32) NOT NULL, field_key varchar(40) NOT NULL, label varchar(100) NOT NULL, field_type varchar(24) NOT NULL, position smallint(5) unsigned NOT NULL DEFAULT 0, step smallint(5) unsigned NOT NULL DEFAULT 1, reached tinyint(1) NOT NULL DEFAULT 0, completed tinyint(1) NOT NULL DEFAULT 0, errors smallint(5) unsigned NOT NULL DEFAULT 0, focus_count smallint(5) unsigned NOT NULL DEFAULT 0, time_ms int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (session_id,field_key) ) $charset;" );
Safe to delete?
If you have uninstalled FormVela – Form Abandonment Analytics, 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_faan_fields`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from FormVela – Form Abandonment Analytics