wp_dci_products
StaticStores product records and related data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT(11) | NO |
| title | VARCHAR(255) | YES |
| menu_slug | VARCHAR(255) | YES |
| public_key | VARCHAR(255) | YES |
| status | VARCHAR(1) | YES |
| created_at | TIMESTAMP | NO |
| product_id | int(11) | NO |
| product_name | VARCHAR(255) | YES |
| first_name | VARCHAR(255) | YES |
| last_name | VARCHAR(255) | YES |
| VARCHAR(255) | YES | |
| email_status | VARCHAR(1) | YES |
| user_role | VARCHAR(255) | YES |
| website_url | VARCHAR(255) | YES |
| website_data | LONGTEXT | YES |
| marketing | VARCHAR(1) | YES |
| custom_data | LONGTEXT | YES |
| created_at | TIMESTAMP | NO |
| updated_at | TIMESTAMP | YES |
| operation | VARCHAR(2) | YES |
CREATE TABLE Statement
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'" );
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_products`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Data Insights – Analytics SDK for WordPress Plugin Developers