wp_fluentform_submissions
StaticStores form submissions and user-entered data.
CREATE TABLE Statement
CREATE TABLE `wp_fluentform_submissions` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `form_id` int unsigned DEFAULT NULL,\n `serial_number` int unsigned DEFAULT NULL,\n `response` longtext COLLATE utf8mb4_unicode_520_ci,\n `source_url` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `user_id` int unsigned DEFAULT NULL,\n `status` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT 'unread' COMMENT 'possible values: read, unread, trashed',\n `is_favourite` tinyint(1) NOT NULL DEFAULT '0',\n `browser` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `device` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `ip` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `city` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `country` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `payment_status` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `payment_method` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `payment_type` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `currency` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `payment_total` float DEFAULT NULL,\n `total_paid` float DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `form_id_status` (`form_id`,`status`),\n KEY `form_id_created_at` (`form_id`,`created_at`),\n KEY `user_id` (`user_id`),\n KEY `serial_number` (`serial_number`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
Safe to delete?
If you have uninstalled Fluent Forms – Customizable Contact Forms, Survey, Quiz, & Conversational Form Builder, 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_fluentform_submissions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Fluent Forms – Customizable Contact Forms, Survey, Quiz, & Conversational Form Builder