{"table_name":"ayyesfo_entries","full_table_name":"wp_ayyesfo_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_ayyesfo_entries ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT(20) UNSIGNED NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, status VARCHAR(32) NOT NULL DEFAULT 'completed', lead_status VARCHAR(32) NOT NULL DEFAULT 'new', lead_owner VARCHAR(190) NOT NULL DEFAULT '', source_plugin VARCHAR(64) NOT NULL DEFAULT 'ayyesfo', lead_value DECIMAL(12,2) NOT NULL DEFAULT 0.00, tags TEXT NULL, fields LONGTEXT NOT NULL, meta LONGTEXT NULL, ip VARCHAR(64) NULL, user_agent VARCHAR(255) NULL, referer VARCHAR(255) NULL, date_created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', date_modified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', viewed TINYINT(1) NOT NULL DEFAULT 0, starred TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY form_id (form_id), KEY status (status), KEY lead_status (lead_status), KEY source_plugin (source_plugin), KEY date_created (date_created) ) $charset;\"; dbDelta( $entries );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"form_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"lead_status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"lead_owner","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"source_plugin","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"lead_value","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"tags","type":"TEXT","nullable":true,"primary_key":false},{"name":"fields","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"meta","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"ip","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"user_agent","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"referer","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"date_modified","type":"DATETIME","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}],"plugin":{"slug":"ayyes-forms","name":"AYYES Forms – AI Contact Form Builder, Lead Forms, Survey, Quiz & SMTP Email Delivery","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/ayyes-forms/"}}