wp_frm_payments
StaticStores frm payments data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| meta_value | longtext | YES |
| receipt_id | varchar(100) | YES |
| invoice_id | varchar(100) | YES |
| sub_id | varchar(100) | YES |
| item_id | bigint(20) | NO |
| action_id | bigint(20) | NO |
| amount | decimal(12,2) | NO |
| status | varchar(100) | YES |
| begin_date | date | NO |
| expire_date | date | YES |
| paysys | varchar(100) | YES |
| created_at | datetime | NO |
| test | TINYINT(1) | YES |
CREATE TABLE Statement
CREATE TABLE wp_frm_payments ( id bigint(20) NOT NULL auto_increment, meta_value longtext default NULL, receipt_id varchar(100) default NULL, invoice_id varchar(100) default NULL, sub_id varchar(100) default NULL, item_id bigint(20) NOT NULL, action_id bigint(20) NOT NULL, amount decimal(12,2) NOT NULL default '0.00', status varchar(100) default NULL, begin_date date NOT NULL, expire_date date default NULL, paysys varchar(100) default NULL, created_at datetime NOT NULL, test TINYINT(1) NULL DEFAULT NULL, PRIMARY KEY (id), KEY item_id (item_id) ) {$charset_collate};"; dbDelta( $sql );Safe to delete?
If you have uninstalled Formidable Forms – Contact Form Plugin, Survey, Quiz, Payment, Calculator Form & Custom 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_frm_payments`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Formidable Forms – Contact Form Plugin, Survey, Quiz, Payment, Calculator Form & Custom Form Builder