wp_wprdm_submissions
StaticStores form submissions and user-entered data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| form_id | bigint(20) UNSIGNED | NO |
| template_id | bigint(20) UNSIGNED | NO |
| submitter_email | varchar(200) | NO |
| form_data | longtext | NO |
| doc_path_docx | varchar(500) | NO |
| doc_path_pdf | varchar(500) | NO |
| status | varchar(30) | NO |
| error_log | text | NO |
| retry_count | tinyint(3) | NO |
| delivery_status | varchar(30) | NO |
| admin_notes | text | NO |
| ip_address | varchar(45) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_wprdm_submissions ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, template_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, submitter_email varchar(200) NOT NULL DEFAULT '', form_data longtext NOT NULL, doc_path_docx varchar(500) NOT NULL DEFAULT '', doc_path_pdf varchar(500) NOT NULL DEFAULT '', status varchar(30) NOT NULL DEFAULT 'processing', error_log text NOT NULL, retry_count tinyint(3) NOT NULL DEFAULT 0, delivery_status varchar(30) NOT NULL DEFAULT 'pending', admin_notes text NOT NULL, ip_address varchar(45) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY form_id (form_id), KEY status (status), KEY created_at (created_at) ) {$charset_collate};"; dbDelta( $sql );Safe to delete?
If you have uninstalled WPRobo DocuMerge Lite, 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_wprdm_submissions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WPRobo DocuMerge Lite