{"table_name":"dci_products","full_table_name":"wp_dci_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_dci_products` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) DEFAULT NULL, `menu_slug` VARCHAR(255) NULL DEFAULT NULL, `public_key` VARCHAR(255) NULL DEFAULT NULL, `status` VARCHAR(1) NULL DEFAULT NULL COMMENT 'A = active, I = inactive', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) $charset_collate\"; $schema2 = \"CREATE TABLE IF NOT EXISTS `wp_dci_data` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `product_name` VARCHAR(255) NULL DEFAULT NULL, `first_name` VARCHAR(255) NULL DEFAULT NULL, `last_name` VARCHAR(255) NULL DEFAULT NULL, `email` VARCHAR(255) NULL DEFAULT NULL, `email_status` VARCHAR(1) NULL DEFAULT NULL COMMENT 'V = verified, U = unverified, C = catchall, I = invalid, R = risky', `user_role` VARCHAR(255) NULL DEFAULT NULL, `website_url` VARCHAR(255) NULL DEFAULT NULL, `website_data` LONGTEXT NULL DEFAULT NULL COMMENT 'JSON encoded data', `marketing` VARCHAR(1) NULL DEFAULT NULL COMMENT 'N = no, Y = yes', `custom_data` LONGTEXT NULL DEFAULT NULL COMMENT 'JSON encoded data', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT NULL, `operation` VARCHAR(2) NULL DEFAULT NULL COMMENT 'I = insert, U = update, D = delete', PRIMARY KEY (`id`) ) $charset_collate\"; /** * If email_status column not exist then add it * * @since 1.2.0 */ //phpcs:ignore $column = $wpdb->get_results( \"SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '\" . DB_NAME . \"' AND TABLE_NAME = 'wp_dci_data' AND COLUMN_NAME = 'email_status'\" );","columns":[{"name":"id","type":"INT(11)","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"menu_slug","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"public_key","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"first_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"email_status","type":"VARCHAR(1)","nullable":true,"primary_key":false},{"name":"user_role","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"website_url","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"website_data","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"marketing","type":"VARCHAR(1)","nullable":true,"primary_key":false},{"name":"custom_data","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"operation","type":"VARCHAR(2)","nullable":true,"primary_key":false}],"plugin":{"slug":"data-collector-insights","name":"Data Insights – Analytics SDK for WordPress Plugin Developers","active_installs":0,"version":"1.6.0","wp_org_url":"https://wordpress.org/plugins/data-collector-insights/"}}