{"table_name":"acquis_leads","full_table_name":"wp_acquis_leads","description":"Stores acquis leads data created by this plugin.","detection_method":"static","confidence":"medium","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;\" );","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}],"plugin":{"slug":"acquisitionsuite","name":"AcquisitionSuite","active_installs":20,"version":"3.6.4","wp_org_url":"https://wordpress.org/plugins/acquisitionsuite/"}}