{"table_name":"dci_apikeys","full_table_name":"wp_dci_apikeys","description":"Stores dci apikeys data created by this plugin.","detection_method":"static","confidence":"medium","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 );","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}],"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/"}}