wp_faan_sessions
StaticStores session data for tracking user or visitor state.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| id | varchar(32) | NO |
| form_id | bigint(20) unsigned | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
| device | varchar(8) | NO |
| started | tinyint(1) | NO |
| attempted | tinyint(1) | NO |
| submitted | tinyint(1) | NO |
| last_field | varchar(40) | NO |
| steps | smallint(5) unsigned | NO |
| duration | int(10) unsigned | NO |
| sequence | int(10) unsigned | NO |
CREATE TABLE Statement
CREATE TABLE wp_faan_sessions ( id varchar(32) NOT NULL, form_id bigint(20) unsigned NOT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, device varchar(8) NOT NULL, started tinyint(1) NOT NULL DEFAULT 0, attempted tinyint(1) NOT NULL DEFAULT 0, submitted tinyint(1) NOT NULL DEFAULT 0, last_field varchar(40) NOT NULL DEFAULT '', steps smallint(5) unsigned NOT NULL DEFAULT 0, duration int(10) unsigned NOT NULL DEFAULT 0, sequence int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY form_date (form_id,created_at), KEY created_at (created_at), KEY updated_at (updated_at) ) $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_sessions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from FormVela – Form Abandonment Analytics