{"slug":"mis-webform","name":"MIS Webform","description":"Easy contact form and form builder. Multi-step forms, file uploads, conditional logic, form analytics and Google Sheets sync.","author":"mistechnolabs","active_installs":0,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/mis-webform/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"fw_form_views","full_table_name":"wp_fw_form_views","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"fw_forms","full_table_name":"wp_fw_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"fields","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"settings","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"form_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"data","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"user_agent","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"view_date","type":"DATE","nullable":false,"primary_key":false},{"name":"views","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_fw_forms ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NULL, fields LONGTEXT NULL, settings LONGTEXT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id) ) $charset_collate;\"; $sql_submissions = \"CREATE TABLE wp_fw_submissions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT UNSIGNED NOT NULL, data LONGTEXT NULL, status VARCHAR(32) NOT NULL DEFAULT 'new', ip VARCHAR(64) NULL, user_agent VARCHAR(512) NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY form_id (form_id) ) $charset_collate;\"; // 1.0.2: daily view counts per form, for the Dashboard. One row per // form per day (site timezone) - counts only, no visitor data. $sql_views = \"CREATE TABLE wp_fw_form_views ( form_id BIGINT UNSIGNED NOT NULL, view_date DATE NOT NULL, views BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (form_id,view_date), KEY view_date (view_date) ) $charset_collate;\"; dbDelta($sql_forms);"},{"table_name":"fw_submissions","full_table_name":"wp_fw_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":3}