wp_contactum_entries
StaticStores form submissions and user-entered data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| form_id | bigint(20) unsigned | YES |
| user_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| user_device | varchar(50) | YES |
| referer | varchar(255) | YES |
| status | varchar(10) | YES |
| created_at | datetime | YES |
| contactum_entry_id | bigint(20) unsigned | YES |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
| form_id | bigint(20) unsigned | YES |
| view_date | date | YES |
| count | int(11) unsigned | NO |
| form_id | bigint(20) unsigned | NO |
| session_hash | varchar(64) | NO |
| filled_fields | text | YES |
| varchar(255) | YES | |
| page_url | varchar(2048) | YES |
| user_ip | varchar(45) | YES |
| user_device | varchar(20) | YES |
| converted | tinyint(1) | NO |
| follow_up_sent | tinyint(1) | NO |
| abandoned_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_contactum_entries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `user_device` varchar(50) DEFAULT NULL, `referer` varchar(255) DEFAULT NULL, `status` varchar(10) DEFAULT 'publish', `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `form_id` (`form_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_contactum_entrymeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `contactum_entry_id` bigint(20) unsigned DEFAULT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `meta_key` (`meta_key`), KEY `entry_id` (`contactum_entry_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_contactum_form_views` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_id` bigint(20) unsigned DEFAULT NULL, `view_date` date DEFAULT NULL, `count` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `form_date` (`form_id`, `view_date`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_contactum_form_abandonments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_id` bigint(20) unsigned NOT NULL, `session_hash` varchar(64) NOT NULL, `filled_fields` text DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `page_url` varchar(2048) DEFAULT NULL, `user_ip` varchar(45) DEFAULT NULL, `user_device` varchar(20) DEFAULT NULL, `converted` tinyint(1) NOT NULL DEFAULT 0, `follow_up_sent` tinyint(1) NOT NULL DEFAULT 0, `abandoned_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `form_session` (`form_id`, `session_hash`), KEY `converted` (`converted`) ) $collate;", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );Safe to delete?
If you have uninstalled Contactum Drag & Drop Contact Form Builder For WordPress, 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_contactum_entries`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Contactum Drag & Drop Contact Form Builder For WordPress