{"slug":"frankel-bullet-form","name":"Bullet Forms","description":"\"Multi-step form builder for WordPress. Lightweight, collects submissions, and allows reviewing/exporting responses from the admin.\"","author":"mdtanvirahmed","active_installs":0,"version":"1.1.3","wp_org_url":"https://wordpress.org/plugins/frankel-bullet-form/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bfmsf_analytics","full_table_name":"wp_bfmsf_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"created_date","type":"datetime","nullable":true,"primary_key":false},{"name":"modified_date","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"form_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"step_number","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"field_order","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"field_label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"field_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"field_placeholder","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"field_required","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"field_options","type":"longtext","nullable":true,"primary_key":false},{"name":"form_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"submission_data","type":"longtext","nullable":false,"primary_key":false},{"name":"submitted_date","type":"datetime","nullable":true,"primary_key":false},{"name":"user_ip","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"form_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"views","type":"int(11)","nullable":true,"primary_key":false},{"name":"submissions","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS $forms_table ( id mediumint(9) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, description longtext, status varchar(20) DEFAULT 'publish', created_date datetime DEFAULT CURRENT_TIMESTAMP, modified_date datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, created_by bigint(20), PRIMARY KEY (id) ) $charset_collate;\"; // Form Fields table $fields_table = wp_'bfmsf_form_fields'; $fields_sql = \"CREATE TABLE $fields_table ( id mediumint(9) NOT NULL AUTO_INCREMENT, form_id mediumint(9) NOT NULL, step_number mediumint(9) NOT NULL, field_order mediumint(9) NOT NULL, field_type varchar(50) NOT NULL, field_label varchar(255) NOT NULL, field_name varchar(255) NOT NULL, field_placeholder varchar(255), field_required tinyint(1) DEFAULT 0, field_options longtext, PRIMARY KEY (id) ) $charset_collate;\"; // Form Submissions table $submissions_table = wp_'bfmsf_submissions'; $submissions_sql = \"CREATE TABLE $submissions_table ( id mediumint(9) NOT NULL AUTO_INCREMENT, form_id mediumint(9) NOT NULL, submission_data longtext NOT NULL, submitted_date datetime DEFAULT CURRENT_TIMESTAMP, user_ip varchar(45), PRIMARY KEY (id) ) $charset_collate;\"; $analytics_sql = \"CREATE TABLE IF NOT EXISTS wp_bfmsf_analytics ( id mediumint(9) NOT NULL AUTO_INCREMENT, form_id mediumint(9) NOT NULL, date date NOT NULL, views int(11) DEFAULT 0, submissions int(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY form_date (form_id, date) ) $charset_collate;\"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');"},{"table_name":"bfmsf_form_fields","full_table_name":"wp_bfmsf_form_fields","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bfmsf_forms","full_table_name":"wp_bfmsf_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bfmsf_submissions","full_table_name":"wp_bfmsf_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":4}