wp_ayyesfo_entries
StaticStores form submissions and user-entered data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| form_id | BIGINT(20) UNSIGNED | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| status | VARCHAR(32) | NO |
| lead_status | VARCHAR(32) | NO |
| lead_owner | VARCHAR(190) | NO |
| source_plugin | VARCHAR(64) | NO |
| lead_value | DECIMAL(12,2) | NO |
| tags | TEXT | YES |
| fields | LONGTEXT | NO |
| meta | LONGTEXT | YES |
| ip | VARCHAR(64) | YES |
| user_agent | VARCHAR(255) | YES |
| referer | VARCHAR(255) | YES |
| date_created | DATETIME | NO |
| date_modified | DATETIME | NO |
| viewed | TINYINT(1) | NO |
| starred | TINYINT(1) | NO |
CREATE TABLE Statement
CREATE TABLE wp_ayyesfo_entries ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT(20) UNSIGNED NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, status VARCHAR(32) NOT NULL DEFAULT 'completed', lead_status VARCHAR(32) NOT NULL DEFAULT 'new', lead_owner VARCHAR(190) NOT NULL DEFAULT '', source_plugin VARCHAR(64) NOT NULL DEFAULT 'ayyesfo', lead_value DECIMAL(12,2) NOT NULL DEFAULT 0.00, tags TEXT NULL, fields LONGTEXT NOT NULL, meta LONGTEXT NULL, ip VARCHAR(64) NULL, user_agent VARCHAR(255) NULL, referer VARCHAR(255) NULL, date_created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', date_modified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', viewed TINYINT(1) NOT NULL DEFAULT 0, starred TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY form_id (form_id), KEY status (status), KEY lead_status (lead_status), KEY source_plugin (source_plugin), KEY date_created (date_created) ) $charset;"; dbDelta( $entries );
Safe to delete?
If you have uninstalled AYYES Forms – AI Contact Form Builder, Lead Forms, Survey, Quiz & SMTP Email Delivery, 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_ayyesfo_entries`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AYYES Forms – AI Contact Form Builder, Lead Forms, Survey, Quiz & SMTP Email Delivery