{"slug":"ayyes-forms","name":"AYYES Forms – AI Contact Form Builder, Lead Forms, Survey, Quiz & SMTP Email Delivery","description":"Build AI-assisted contact forms with drag & drop, multi-step layouts, conditional logic, SMTP, lead storage, health checks and safe migration.","author":"AYYES","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/ayyes-forms/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ayyesfo_email_logs","full_table_name":"wp_ayyesfo_email_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","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":"entry_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"notification","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"to_email","type":"TEXT","nullable":true,"primary_key":false},{"name":"subject","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"error_message","type":"TEXT","nullable":true,"primary_key":false},{"name":"headers","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ayyesfo_email_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, entry_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, notification VARCHAR(190) NOT NULL DEFAULT '', to_email TEXT NULL, subject VARCHAR(255) NOT NULL DEFAULT '', status VARCHAR(32) NOT NULL DEFAULT 'unknown', error_message TEXT NULL, headers LONGTEXT NULL, date_created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY form_id (form_id), KEY entry_id (entry_id), KEY status (status), KEY date_created (date_created) ) $charset;\"; dbDelta( $email_logs );"},{"table_name":"ayyesfo_entries","full_table_name":"wp_ayyesfo_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","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}],"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 );"},{"table_name":"ayyesfo_entry_notes","full_table_name":"wp_ayyesfo_entry_notes","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"entry_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"note","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ayyesfo_entry_notes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, entry_id BIGINT(20) UNSIGNED NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, note LONGTEXT NOT NULL, date_created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY entry_id (entry_id) ) $charset;\"; dbDelta( $notes );"},{"table_name":"ayyesfo_files","full_table_name":"wp_ayyesfo_files","description":"Stores ayyesfo files data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"entry_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"field_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"file_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"file_path","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"file_url","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"file_size","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"mime","type":"VARCHAR(128)","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ayyesfo_files ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, entry_id BIGINT(20) UNSIGNED NOT NULL, field_id VARCHAR(64) NOT NULL, file_name VARCHAR(255) NOT NULL, file_path VARCHAR(500) NOT NULL, file_url VARCHAR(500) NOT NULL, file_size BIGINT(20) NOT NULL DEFAULT 0, mime VARCHAR(128) NULL, date_created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY entry_id (entry_id) ) $charset;\"; dbDelta( $files );"}],"table_count":4}