{"slug":"acquisitionsuite","name":"AcquisitionSuite","description":"WordPress lead generation plugin: gate PDF & file downloads behind a lead capture form, build custom forms, and automate follow-up emails.","author":"UfirstDEV Technologies","active_installs":20,"version":"3.6.4","wp_org_url":"https://wordpress.org/plugins/acquisitionsuite/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"acquis_analytics","full_table_name":"wp_acquis_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"event_type","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"form_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"file_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"lead_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"source_post","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"source_url","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"utm_source","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"utm_medium","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"utm_campaign","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_analytics ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, event_type VARCHAR(30) NOT NULL, form_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, file_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, lead_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, source_post BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, source_url VARCHAR(1000) NOT NULL DEFAULT '', utm_source varchar(191) NOT NULL DEFAULT '', utm_medium varchar(191) NOT NULL DEFAULT '', utm_campaign varchar(191) NOT NULL DEFAULT '', ip_address VARCHAR(45) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY event_type (event_type), KEY file_id (file_id), KEY lead_id (lead_id), KEY created_at (created_at) ) $c;\" );"},{"table_name":"acquis_email_logs","full_table_name":"wp_acquis_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":"lead_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"email","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"subject","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"provider","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"error_msg","type":"TEXT","nullable":true,"primary_key":false},{"name":"opened_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"click_count","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"last_clicked_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"sequence_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"sequence_step","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_email_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, lead_id BIGINT(20) UNSIGNED NOT NULL, email varchar(191) NOT NULL, subject VARCHAR(500) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'queued', provider VARCHAR(50) NOT NULL DEFAULT 'wp_mail', error_msg TEXT, opened_at DATETIME DEFAULT NULL, click_count INT(11) UNSIGNED NOT NULL DEFAULT 0, last_clicked_at DATETIME DEFAULT NULL, sequence_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, sequence_step BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY lead_id (lead_id), KEY status (status), KEY created_at (created_at) ) $c;\" );"},{"table_name":"acquis_form_fields","full_table_name":"wp_acquis_form_fields","description":"Stores form definitions and related configuration.","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":"field_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"field_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(300)","nullable":false,"primary_key":false},{"name":"placeholder","type":"VARCHAR(300)","nullable":false,"primary_key":false},{"name":"help_text","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"options","type":"TEXT","nullable":true,"primary_key":false},{"name":"step","type":"TINYINT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"sort_order","type":"SMALLINT(5) UNSIGNED","nullable":false,"primary_key":false},{"name":"required","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"validation","type":"TEXT","nullable":true,"primary_key":false},{"name":"conditions","type":"TEXT","nullable":true,"primary_key":false},{"name":"settings","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_form_fields ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT(20) UNSIGNED NOT NULL, field_key VARCHAR(100) NOT NULL, field_type VARCHAR(50) NOT NULL, label VARCHAR(300) NOT NULL, placeholder VARCHAR(300) NOT NULL DEFAULT '', help_text VARCHAR(500) NOT NULL DEFAULT '', options TEXT, step TINYINT(3) UNSIGNED NOT NULL DEFAULT 1, sort_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, required TINYINT(1) NOT NULL DEFAULT 0, validation TEXT, conditions TEXT, settings TEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY form_id (form_id), KEY sort_order (sort_order) ) $c;\" );"},{"table_name":"acquis_forms","full_table_name":"wp_acquis_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"steps","type":"TINYINT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"settings","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_forms ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(191) NOT NULL, description TEXT, steps TINYINT(3) UNSIGNED NOT NULL DEFAULT 1, settings LONGTEXT, status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status) ) $c;\" );"},{"table_name":"acquis_funnel_objects","full_table_name":"wp_acquis_funnel_objects","description":"Stores acquis funnel objects data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"funnel_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"owned","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"role","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_acquis_funnel_objects ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, funnel_id BIGINT(20) UNSIGNED NOT NULL, object_type VARCHAR(30) NOT NULL, object_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, owned TINYINT(1) NOT NULL DEFAULT 0, role VARCHAR(40) NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY funnel_role (funnel_id, role), KEY object (object_type, object_id) ) $c;\" );"},{"table_name":"acquis_funnels","full_table_name":"wp_acquis_funnels","description":"Stores acquis funnels data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"template","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"config","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"form_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"file_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"synced_at","type":"DATETIME","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}],"create_sql":"CREATE TABLE wp_acquis_funnels ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(191) NOT NULL, template VARCHAR(40) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'draft', config LONGTEXT, form_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, file_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, synced_at DATETIME NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY status (status), KEY form_id (form_id) ) $c;\" );"},{"table_name":"acquis_integration_logs","full_table_name":"wp_acquis_integration_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":"lead_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"integration","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"response","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_integration_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, lead_id BIGINT(20) UNSIGNED NOT NULL, integration VARCHAR(50) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'skipped', response TEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY lead_id (lead_id) ) $c;\" );"},{"table_name":"acquis_leads","full_table_name":"wp_acquis_leads","description":"Stores acquis leads data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"full_name","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"file_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"user_agent","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"browser","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"os","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"region","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"city","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"visit_count","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"last_seen_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"deal_value","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_leads ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, full_name varchar(191) NOT NULL, email varchar(191) NOT NULL, file_id BIGINT(20) UNSIGNED NOT NULL, ip_address VARCHAR(45) NOT NULL DEFAULT '', user_agent VARCHAR(500) NOT NULL DEFAULT '', device VARCHAR(20) NOT NULL DEFAULT '', browser VARCHAR(50) NOT NULL DEFAULT '', os VARCHAR(50) NOT NULL DEFAULT '', country VARCHAR(100) NOT NULL DEFAULT '', region VARCHAR(100) NOT NULL DEFAULT '', city VARCHAR(100) NOT NULL DEFAULT '', visit_count INT(11) UNSIGNED NOT NULL DEFAULT 1, last_seen_at DATETIME DEFAULT NULL, deal_value DECIMAL(12,2) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY email (email), KEY file_id (file_id), KEY created_at (created_at), KEY country (country) ) $c;\" );"},{"table_name":"acquis_submission_values","full_table_name":"wp_acquis_submission_values","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":"submission_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"field_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"field_label","type":"VARCHAR(300)","nullable":false,"primary_key":false},{"name":"value","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_submission_values ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, submission_id BIGINT(20) UNSIGNED NOT NULL, field_key VARCHAR(100) NOT NULL, field_label VARCHAR(300) NOT NULL DEFAULT '', value TEXT, PRIMARY KEY (id), KEY submission_id (submission_id), KEY field_key (field_key) ) $c;\" );"},{"table_name":"acquis_submissions","full_table_name":"wp_acquis_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","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":"lead_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"file_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"source_url","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"source_post","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"referrer","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"utm_source","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"utm_medium","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"utm_campaign","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_submissions ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, form_id BIGINT(20) UNSIGNED NOT NULL, lead_id BIGINT(20) UNSIGNED NOT NULL, file_id BIGINT(20) UNSIGNED NOT NULL, source_url VARCHAR(1000) NOT NULL DEFAULT '', source_post BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, referrer VARCHAR(1000) NOT NULL DEFAULT '', utm_source varchar(191) NOT NULL DEFAULT '', utm_medium varchar(191) NOT NULL DEFAULT '', utm_campaign varchar(191) NOT NULL DEFAULT '', ip_address VARCHAR(45) NOT NULL DEFAULT '', source VARCHAR(40) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY form_id (form_id), KEY source (source), KEY lead_id (lead_id), KEY file_id (file_id), KEY created_at (created_at) ) $c;\" );"},{"table_name":"acquis_tokens","full_table_name":"wp_acquis_tokens","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"token","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"lead_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"file_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"used","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_acquis_tokens ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, token VARCHAR(64) NOT NULL, lead_id BIGINT(20) UNSIGNED NOT NULL, file_id BIGINT(20) UNSIGNED NOT NULL, expires_at DATETIME NOT NULL, used TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY token (token), KEY expires_at (expires_at) ) $c;\" );"}],"table_count":11}