{"slug":"everest-forms","name":"Everest Forms – Contact Form, Payment Form, Quiz, Survey & Custom Form Builder","description":"The best WordPress form builder. Create contact forms, payment forms, conversational forms, custom forms, surveys, & quizzes using drag and drop.","author":"wpeverest","active_installs":100000,"version":"3.4.5","wp_org_url":"https://wordpress.org/plugins/everest-forms/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"evf_entries","full_table_name":"wp_evf_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[{"name":"entry_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"form_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_device","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"user_ip_address","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"referer","type":"text","nullable":false,"primary_key":false},{"name":"fields","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"viewed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"starred","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"entry_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"session_key","type":"char(32)","nullable":false,"primary_key":false},{"name":"session_value","type":"longtext","nullable":false,"primary_key":false},{"name":"session_expiry","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_evf_entries ( entry_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, user_device varchar(100) NOT NULL, user_ip_address VARCHAR(100) NULL DEFAULT '', referer text NOT NULL, fields longtext NULL, status varchar(20) NOT NULL, viewed tinyint(1) NOT NULL DEFAULT '0', starred tinyint(1) NOT NULL DEFAULT '0', date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (entry_id), KEY form_id (form_id) ) $charset_collate; CREATE TABLE wp_evf_entrymeta ( meta_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, entry_id BIGINT UNSIGNED NOT NULL, meta_key varchar(255) default NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY entry_id (entry_id), KEY meta_key (meta_key(32)) ) $charset_collate; CREATE TABLE wp_evf_sessions ( session_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value longtext NOT NULL, session_expiry BIGINT UNSIGNED NOT NULL, PRIMARY KEY (session_id), UNIQUE KEY session_key (session_key) ) $charset_collate; \"; return $tables; } /** * Return a list of EverestForms tables. Used to make sure all UM tables are dropped when uninstalling the plugin * in a single site or multi site environment. * * @return array UM tables. */ public static function get_tables() { global $wpdb; $tables = array( \"wp_evf_entries\", \"wp_evf_entrymeta\", \"wp_evf_sessions\", );"},{"table_name":"evf_entrymeta","full_table_name":"wp_evf_entrymeta","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"evf_sessions","full_table_name":"wp_evf_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":3}