{"slug":"data-collector-insights","name":"Data Insights – Analytics SDK for WordPress Plugin Developers","description":"Analytics SDK for WordPress plugin developers. Track user behavior, analyze competitors, boost conversions. 2-line integration.","author":"wowDevs","active_installs":0,"version":"1.6.0","wp_org_url":"https://wordpress.org/plugins/data-collector-insights/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dci_apikeys","full_table_name":"wp_dci_apikeys","description":"Stores dci apikeys data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(11)","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"product_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"api_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"product_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"feedback","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"user_action","type":"VARCHAR(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"updated_at","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"product_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"sent_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"response","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"plugin_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"usage_count","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"plugin_info","type":"longtext","nullable":false,"primary_key":false},{"name":"last_processed_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"theme_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"theme_version","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"theme_author","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"usage_count","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"theme_info","type":"longtext","nullable":false,"primary_key":false},{"name":"last_processed_id","type":"bigint(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dci_apikeys` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `product_id` bigint(11) NOT NULL, `product_name` VARCHAR(255) NULL DEFAULT NULL, `title` VARCHAR(255) NULL DEFAULT NULL, `api_key` VARCHAR(255) NOT 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\"; $schema4 = \"CREATE TABLE IF NOT EXISTS `wp_dci_feedbacks` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `email` VARCHAR(255) NULL DEFAULT NULL, `product_id` bigint(11) NOT NULL, `feedback` LONGTEXT NULL DEFAULT NULL COMMENT 'JSON encoded data', `user_action` VARCHAR(1) NULL DEFAULT NULL COMMENT 'D = Deactivation, O = Other', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` VARCHAR(255) NULL DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate\"; $schema_logs = \"CREATE TABLE IF NOT EXISTS `wp_dci_crm_logs` ( `log_id` bigint(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL COMMENT 'Client Name', `email` VARCHAR(255) NOT NULL COMMENT 'Client email', `product_id` bigint(11) NOT NULL, `product_name` VARCHAR(255) NOT NULL, `sent_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `response` LONGTEXT NULL DEFAULT NULL, PRIMARY KEY (`log_id`), UNIQUE KEY `email` (`email`) ) $charset_collate\"; $pusage_log = \"CREATE TABLE IF NOT EXISTS `wp_dci_pusage_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `plugin_name` varchar(255) NOT NULL, `usage_count` bigint(20) NOT NULL, `plugin_info` longtext NOT NULL, `last_processed_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;\"; $tusage_log = \"CREATE TABLE IF NOT EXISTS `wp_dci_tusage_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `theme_name` varchar(255) NOT NULL, `theme_version` varchar(255) NOT NULL, `theme_author` varchar(255) NOT NULL, `usage_count` bigint(20) NOT NULL, `theme_info` longtext NOT NULL, `last_processed_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) $charset_collate\"; if ( ! function_exists( 'dbDelta' ) ) { require_once ABSPATH . 'wp-admin/includes/upgrade.php'; } dbDelta( $schema );"},{"table_name":"dci_crm_logs","full_table_name":"wp_dci_crm_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dci_data","full_table_name":"wp_dci_data","description":"Stores dci data data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dci_feedbacks","full_table_name":"wp_dci_feedbacks","description":"Stores dci feedbacks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dci_products","full_table_name":"wp_dci_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","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}],"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'\" );"},{"table_name":"dci_pusage_log","full_table_name":"wp_dci_pusage_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"dci_tusage_log","full_table_name":"wp_dci_tusage_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":7}