{"table_name":"crmlytics_contacts","full_table_name":"wp_crmlytics_contacts","description":"Stores crmlytics contacts data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_crmlytics_contacts ( id BIGINT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY, wc_customer_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, email VARCHAR(100) NOT NULL, first_name VARCHAR(100), last_name VARCHAR(100), phone VARCHAR(20), billing_company VARCHAR(100), billing_address_1 TEXT, billing_address_2 TEXT, billing_city VARCHAR(100), billing_state VARCHAR(100), billing_postcode VARCHAR(20), billing_country VARCHAR(10), shipping_address_1 TEXT, shipping_address_2 TEXT, shipping_city VARCHAR(100), shipping_state VARCHAR(100), shipping_postcode VARCHAR(20), shipping_country VARCHAR(10), created_at DATETIME, updated_at DATETIME, INDEX idx_email (email), INDEX idx_wc_customer_id (wc_customer_id) ) $charset_collate;\"; dbDelta($sql);","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":true},{"name":"wc_customer_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"billing_company","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"billing_address_1","type":"TEXT","nullable":true,"primary_key":false},{"name":"billing_address_2","type":"TEXT","nullable":true,"primary_key":false},{"name":"billing_city","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"billing_state","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"billing_postcode","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"billing_country","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"shipping_address_1","type":"TEXT","nullable":true,"primary_key":false},{"name":"shipping_address_2","type":"TEXT","nullable":true,"primary_key":false},{"name":"shipping_city","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"shipping_state","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"shipping_postcode","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"shipping_country","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"crmlytics","name":"CRMlytics – WooCommerce CRM & Customer Analytics","active_installs":0,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/crmlytics/"}}