{"table_name":"frm_payments","full_table_name":"wp_frm_payments","description":"Stores frm payments data created by this plugin.","detection_method":"static","confidence":"high","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 );","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}],"plugin":{"slug":"formidable","name":"Formidable Forms – Contact Form Plugin, Survey, Quiz, Payment, Calculator Form & Custom Form Builder","active_installs":300000,"version":"6.30","wp_org_url":"https://wordpress.org/plugins/formidable/"}}