wp_fluentform_submissions

Static

Stores 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