wp_dci_apikeys
StaticStores dci apikeys data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(11) | NO |
| product_id | bigint(11) | NO |
| product_name | VARCHAR(255) | YES |
| title | VARCHAR(255) | YES |
| api_key | VARCHAR(255) | NO |
| status | VARCHAR(1) | YES |
| created_at | TIMESTAMP | NO |
| VARCHAR(255) | YES | |
| product_id | bigint(11) | NO |
| feedback | LONGTEXT | YES |
| user_action | VARCHAR(1) | YES |
| created_at | TIMESTAMP | NO |
| updated_at | VARCHAR(255) | YES |
| name | VARCHAR(255) | NO |
| VARCHAR(255) | NO | |
| product_id | bigint(11) | NO |
| product_name | VARCHAR(255) | NO |
| sent_at | TIMESTAMP | NO |
| response | LONGTEXT | YES |
| plugin_name | varchar(255) | NO |
| usage_count | bigint(20) | NO |
| plugin_info | longtext | NO |
| last_processed_id | bigint(20) | NO |
| theme_name | varchar(255) | NO |
| theme_version | varchar(255) | NO |
| theme_author | varchar(255) | NO |
| usage_count | bigint(20) | NO |
| theme_info | longtext | NO |
| last_processed_id | bigint(20) | NO |
CREATE TABLE Statement
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 );Safe to delete?
If you have uninstalled Data Insights – Analytics SDK for WordPress Plugin Developers, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_dci_apikeys`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Data Insights – Analytics SDK for WordPress Plugin Developers