{"slug":"formidable","name":"Formidable Forms – Contact Form Plugin, Survey, Quiz, Payment, Calculator Form & Custom Form Builder","description":"The most advanced WordPress forms plugin. Go beyond contact forms with our drag and drop form builder for surveys, quizzes, and more.","author":"Strategy11 Team","active_installs":300000,"version":"6.30","wp_org_url":"https://wordpress.org/plugins/formidable/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"frm_fields","full_table_name":"wp_frm_fields","description":"Stores frm fields data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"frm_forms","full_table_name":"wp_frm_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"frm_item_metas","full_table_name":"wp_frm_item_metas","description":"Stores additional metadata (key-value pairs) for frm item metas records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"frm_items","full_table_name":"wp_frm_items","description":"Stores frm items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"frm_payments","full_table_name":"wp_frm_payments","description":"Stores frm payments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"receipt_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"invoice_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sub_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"action_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"begin_date","type":"date","nullable":false,"primary_key":false},{"name":"expire_date","type":"date","nullable":true,"primary_key":false},{"name":"paysys","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"test","type":"TINYINT(1)","nullable":true,"primary_key":false}],"create_sql":"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 );"},{"table_name":"frm_subscriptions","full_table_name":"wp_frm_subscriptions","description":"Stores frm subscriptions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"sub_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"action_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"first_amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"interval_count","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"time_interval","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"fail_count","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"end_count","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"next_bill_date","type":"date","nullable":true,"primary_key":false},{"name":"status","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"paysys","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"test","type":"TINYINT(1)","nullable":true,"primary_key":false}],"create_sql":"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 );"}],"table_count":6}