wp_fw_forms
StaticStores form definitions and related configuration.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| name | VARCHAR(255) | NO |
| description | TEXT | YES |
| fields | LONGTEXT | YES |
| settings | LONGTEXT | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| form_id | BIGINT UNSIGNED | NO |
| data | LONGTEXT | YES |
| status | VARCHAR(32) | NO |
| ip | VARCHAR(64) | YES |
| user_agent | VARCHAR(512) | YES |
| created_at | DATETIME | NO |
| view_date | DATE | NO |
| views | BIGINT UNSIGNED | NO |
CREATE TABLE Statement
CREATE TABLE wp_fw_forms ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NULL, fields LONGTEXT NULL, settings LONGTEXT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id) ) $charset_collate;"; $sql_submissions = "CREATE TABLE wp_fw_submissions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT UNSIGNED NOT NULL, data LONGTEXT NULL, status VARCHAR(32) NOT NULL DEFAULT 'new', ip VARCHAR(64) NULL, user_agent VARCHAR(512) NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY form_id (form_id) ) $charset_collate;"; // 1.0.2: daily view counts per form, for the Dashboard. One row per // form per day (site timezone) - counts only, no visitor data. $sql_views = "CREATE TABLE wp_fw_form_views ( form_id BIGINT UNSIGNED NOT NULL, view_date DATE NOT NULL, views BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (form_id,view_date), KEY view_date (view_date) ) $charset_collate;"; dbDelta($sql_forms);
Safe to delete?
If you have uninstalled MIS Webform, 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_fw_forms`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from MIS Webform