{"slug":"rackforms-express","name":"RackForms Express Web Form Builder","description":"RackForms Express For WordPress is a FREE and UNLIMITED web form builder.","author":"rackforms","active_installs":10,"version":"1.5","wp_org_url":"https://wordpress.org/plugins/rackforms-express/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"fb_admin","full_table_name":"wp_fb_admin","description":"Stores fb admin data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"user_id","type":"INT(11)","nullable":false,"primary_key":true},{"name":"user_name","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"user_pass","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"pwd","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"user_email","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"user_privilege","type":"INT(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `fb_admin` ( `user_id` INT(11) NOT NULL AUTO_INCREMENT, `user_name` VARCHAR(20) DEFAULT NULL, `user_pass` VARCHAR(50) DEFAULT NULL, `pwd` VARCHAR(100) DEFAULT NULL, `user_email` VARCHAR(50) DEFAULT NULL, `user_privilege` INT(11) DEFAULT '0', PRIMARY KEY (`user_id`) ) ENGINE"},{"table_name":"fb_auth","full_table_name":"wp_fb_auth","description":"Stores fb auth data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"auth","type":"VARCHAR","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `fb_auth`( id INT (11) NOT NULL AUTO_INCREMENT, auth VARCHAR (255) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"fb_comments","full_table_name":"wp_fb_comments","description":"Stores fb comments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"ts","type":"DATETIME","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"website","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"comment","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE fb_comments( id INT (11) NOT NULL AUTO_INCREMENT, ts DATETIME DEFAULT NULL, name VARCHAR (50) DEFAULT NULL, email VARCHAR (100) DEFAULT NULL, website VARCHAR (100) DEFAULT NULL, `comment` LONGTEXT DEFAULT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"fb_demo","full_table_name":"wp_fb_demo","description":"Stores fb demo data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"age","type":"INT","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"pwd","type":"BLOB","nullable":true,"primary_key":false},{"name":"image","type":"LONGBLOB","nullable":true,"primary_key":false},{"name":"ts","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE fb_demo( id INT (11) NOT NULL AUTO_INCREMENT, name VARCHAR (50) DEFAULT NULL, age INT (11) DEFAULT NULL, email VARCHAR (50) DEFAULT NULL, pwd BLOB DEFAULT NULL, image LONGBLOB DEFAULT NULL, ts DATETIME DEFAULT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"fb_files","full_table_name":"wp_fb_files","description":"Stores fb files data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"file_id","type":"INT","nullable":false,"primary_key":true},{"name":"entry_id","type":"INT","nullable":true,"primary_key":false},{"name":"file_caption","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"file_name","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"file_mime","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"file_size","type":"INT","nullable":true,"primary_key":false},{"name":"file_data","type":"LONGBLOB","nullable":true,"primary_key":false},{"name":"file_thumb","type":"LONGBLOB","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE fb_files( file_id INT (11) NOT NULL AUTO_INCREMENT, entry_id INT (11) DEFAULT NULL, file_caption LONGTEXT DEFAULT NULL, file_name VARCHAR (100) DEFAULT NULL, file_mime VARCHAR (40) DEFAULT NULL, file_size INT (11) DEFAULT NULL, file_data LONGBLOB DEFAULT NULL, file_thumb LONGBLOB DEFAULT NULL, PRIMARY KEY (file_id) ) ENGINE"},{"table_name":"fb_images","full_table_name":"wp_fb_images","description":"Stores fb images data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"image_id","type":"INT","nullable":false,"primary_key":true},{"name":"entry_id","type":"INT","nullable":true,"primary_key":false},{"name":"image_caption","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"image_name","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"image_mime","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"image_size","type":"INT","nullable":true,"primary_key":false},{"name":"image_data","type":"LONGBLOB","nullable":true,"primary_key":false},{"name":"image_thumb","type":"LONGBLOB","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE fb_images( image_id INT (11) NOT NULL AUTO_INCREMENT, entry_id INT (11) DEFAULT NULL, image_caption LONGTEXT DEFAULT NULL, image_name VARCHAR (100) DEFAULT NULL, image_mime VARCHAR (40) DEFAULT NULL, image_size INT (11) DEFAULT NULL, image_data LONGBLOB DEFAULT NULL, image_thumb LONGBLOB DEFAULT NULL, PRIMARY KEY (image_id) ) ENGINE"},{"table_name":"fb_job_entries","full_table_name":"wp_fb_job_entries","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11)","nullable":false,"primary_key":true},{"name":"job_id","type":"INT(11)","nullable":false,"primary_key":false},{"name":"ts","type":"INT(11)","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"label","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"entry_value","type":"TEXT","nullable":true,"primary_key":false},{"name":"file_data","type":"LONGBLOB","nullable":true,"primary_key":false},{"name":"file_mime","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"file_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"entry_key","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"entry_type","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"remote_ip","type":"VARCHAR(50)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `fb_job_entries` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `job_id` INT(11) NOT NULL, `ts` INT(11) DEFAULT NULL, `name` VARCHAR(255) DEFAULT NULL, `label` VARCHAR (255) DEFAULT NULL, `entry_value` TEXT, `file_data` LONGBLOB, `file_mime` VARCHAR(50) DEFAULT NULL, `file_name` VARCHAR(255) DEFAULT NULL, `entry_key` VARCHAR(50) DEFAULT NULL, `entry_type` VARCHAR(20) DEFAULT NULL, `remote_ip` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`), INDEX index1 USING BTREE (`job_id`), INDEX IDX_ts USING BTREE (`ts`), INDEX IDX_entry_key USING BTREE (`entry_key`), CONSTRAINT `fb_job_entries_FK1` FOREIGN KEY (`job_id`) REFERENCES `fb_jobs` (`id`) ON DELETE CASCADE ) ENGINE"},{"table_name":"fb_jobs","full_table_name":"wp_fb_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11)","nullable":false,"primary_key":true},{"name":"job_name","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"created","type":"VARCHAR(12)","nullable":true,"primary_key":false},{"name":"created_ts","type":"DATETIME","nullable":true,"primary_key":false},{"name":"last_edit","type":"VARCHAR(12)","nullable":true,"primary_key":false},{"name":"last_edit_ts","type":"DATETIME","nullable":true,"primary_key":false},{"name":"user_id","type":"INT(11)","nullable":true,"primary_key":false},{"name":"job_xml","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `fb_jobs` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `job_name` VARCHAR(50) DEFAULT NULL, `created` VARCHAR(12) DEFAULT NULL, `created_ts` DATETIME DEFAULT NULL, `last_edit` VARCHAR(12) DEFAULT NULL, `last_edit_ts` DATETIME DEFAULT NULL, `user_id` INT(11) DEFAULT NULL, `job_xml` LONGTEXT, PRIMARY KEY (`id`), INDEX IDX_job_name (`job_name`), INDEX IDX_user_id (`user_id`) ) ENGINE"}],"table_count":8}