wp_frm_subscriptions
StaticStores frm subscriptions data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| sub_id | varchar(100) | YES |
| meta_value | longtext | YES |
| item_id | bigint(20) | NO |
| action_id | bigint(20) | NO |
| amount | decimal(12,2) | NO |
| first_amount | decimal(12,2) | NO |
| interval_count | bigint(20) | YES |
| time_interval | varchar(100) | YES |
| fail_count | bigint(20) | YES |
| end_count | bigint(20) | YES |
| next_bill_date | date | YES |
| status | varchar(100) | YES |
| paysys | varchar(100) | YES |
| created_at | datetime | NO |
| test | TINYINT(1) | YES |
CREATE TABLE Statement
CREATE TABLE wp_frm_subscriptions ( id bigint(20) NOT NULL auto_increment, sub_id varchar(100) default NULL, meta_value longtext default NULL, item_id bigint(20) NOT NULL, action_id bigint(20) NOT NULL, amount decimal(12,2) NOT NULL default '0.00', first_amount decimal(12,2) NOT NULL default '0.00', interval_count bigint(20) default 1, time_interval varchar(100) default NULL, fail_count bigint(20) default 0, end_count bigint(20) default NULL, next_bill_date date default NULL, status varchar(100) 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_subscriptions`;
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