wp_acquis_form_fields
StaticStores form definitions and related configuration.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| form_id | BIGINT(20) UNSIGNED | NO |
| field_key | VARCHAR(100) | NO |
| field_type | VARCHAR(50) | NO |
| label | VARCHAR(300) | NO |
| placeholder | VARCHAR(300) | NO |
| help_text | VARCHAR(500) | NO |
| options | TEXT | YES |
| step | TINYINT(3) UNSIGNED | NO |
| sort_order | SMALLINT(5) UNSIGNED | NO |
| required | TINYINT(1) | NO |
| validation | TEXT | YES |
| conditions | TEXT | YES |
| settings | TEXT | YES |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_acquis_form_fields ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT(20) UNSIGNED NOT NULL, field_key VARCHAR(100) NOT NULL, field_type VARCHAR(50) NOT NULL, label VARCHAR(300) NOT NULL, placeholder VARCHAR(300) NOT NULL DEFAULT '', help_text VARCHAR(500) NOT NULL DEFAULT '', options TEXT, step TINYINT(3) UNSIGNED NOT NULL DEFAULT 1, sort_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, required TINYINT(1) NOT NULL DEFAULT 0, validation TEXT, conditions TEXT, settings TEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY form_id (form_id), KEY sort_order (sort_order) ) $c;" );
Safe to delete?
If you have uninstalled AcquisitionSuite, 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_acquis_form_fields`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AcquisitionSuite