wp_dynamic_surveys
StaticStores dynamic surveys data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint(9) | NO |
| title | varchar(255) | NO |
| question | text | NO |
| options | longtext | NO |
| status | varchar(20) | YES |
| created_at | datetime | YES |
| survey_id | mediumint(9) | NO |
| user_id | bigint(20) | NO |
| option_id | varchar(32) | NO |
| ip_address | varchar(45) | YES |
| created_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_dynamic_surveys ( id mediumint(9) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, question text NOT NULL, options longtext NOT NULL, status varchar(20) DEFAULT 'open', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; // Define votes table $sql_votes = "CREATE TABLE IF NOT EXISTS wp_dynamic_surveys_votes ( id mediumint(9) NOT NULL AUTO_INCREMENT, survey_id mediumint(9) NOT NULL, user_id bigint(20) NOT NULL, option_id varchar(32) NOT NULL, ip_address varchar(45), created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY survey_user (survey_id, user_id), KEY survey_ip (survey_id, ip_address) ) $charset_collate;"; // Include WordPress upgrade functions if (!function_exists('dbDelta')) { require_once(ABSPATH . 'wp-admin/includes/upgrade.php');Safe to delete?
If you have uninstalled Dynamic Surveys, 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_dynamic_surveys`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Dynamic Surveys