wp_ecout_products
StaticStores product records and related data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| name | VARCHAR(255) | NO |
| type | VARCHAR(20) | NO |
| status | VARCHAR(20) | NO |
| description | LONGTEXT | YES |
| image_id | BIGINT(20) UNSIGNED | NO |
| price | BIGINT(20) | NO |
| download_limit | INT(11) | NO |
| download_expiry_days | INT(11) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | YES |
| product_id | BIGINT(20) UNSIGNED | NO |
| name | VARCHAR(255) | NO |
| file_path | VARCHAR(2000) | NO |
| file_name | VARCHAR(255) | NO |
| file_size | BIGINT(20) UNSIGNED | NO |
| mime_type | VARCHAR(100) | NO |
| enabled | TINYINT(1) | NO |
| position | INT(11) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | YES |
| user_id | BIGINT(20) UNSIGNED | NO |
| VARCHAR(100) | NO | |
| name | VARCHAR(255) | NO |
| country | CHAR(2) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | YES |
| order_key | CHAR(32) | NO |
| parent_id | BIGINT(20) UNSIGNED | NO |
| type | VARCHAR(20) | NO |
| status | VARCHAR(20) | NO |
| customer_id | BIGINT(20) UNSIGNED | NO |
| VARCHAR(100) | NO | |
| name | VARCHAR(255) | NO |
| currency | CHAR(3) | NO |
| mode | VARCHAR(10) | NO |
| subtotal | BIGINT(20) | NO |
| discount | BIGINT(20) | NO |
| total | BIGINT(20) | NO |
| discount_code | VARCHAR(50) | NO |
| ip_address | VARCHAR(45) | NO |
| gateway | VARCHAR(50) | NO |
| transaction_id | VARCHAR(255) | NO |
| payment_method | VARCHAR(100) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | YES |
| paid_at | DATETIME | YES |
| completed_at | DATETIME | YES |
| order_id | BIGINT(20) UNSIGNED | NO |
| product_id | BIGINT(20) UNSIGNED | NO |
| product_name | VARCHAR(255) | NO |
| price | BIGINT(20) | NO |
| quantity | INT(11) | NO |
| subtotal | BIGINT(20) | NO |
| total | BIGINT(20) | NO |
| position | INT(11) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | YES |
| order_id | BIGINT(20) UNSIGNED | NO |
| product_id | BIGINT(20) UNSIGNED | NO |
| download_id | BIGINT(20) UNSIGNED | NO |
| customer_id | BIGINT(20) UNSIGNED | NO |
| ip_address | VARCHAR(45) | NO |
| user_agent | VARCHAR(255) | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_ecout_products ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL DEFAULT '', type VARCHAR(20) NOT NULL DEFAULT 'simple', status VARCHAR(20) NOT NULL DEFAULT 'active', description LONGTEXT NULL, image_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, price BIGINT(20) NOT NULL DEFAULT 0, download_limit INT(11) NOT NULL DEFAULT 0, download_expiry_days INT(11) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), KEY status (status) ) $collate; CREATE TABLE wp_ecout_downloads ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, product_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', file_path VARCHAR(2000) NOT NULL DEFAULT '', file_name VARCHAR(255) NOT NULL DEFAULT '', file_size BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, mime_type VARCHAR(100) NOT NULL DEFAULT '', enabled TINYINT(1) NOT NULL DEFAULT 1, position INT(11) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), KEY product_id (product_id), KEY enabled (enabled) ) $collate; CREATE TABLE wp_ecout_customers ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, email VARCHAR(100) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', country CHAR(2) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY email (email), KEY user_id (user_id) ) $collate; CREATE TABLE wp_ecout_orders ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_key CHAR(32) NOT NULL DEFAULT '', parent_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, type VARCHAR(20) NOT NULL DEFAULT 'sale', status VARCHAR(20) NOT NULL DEFAULT 'pending', customer_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, email VARCHAR(100) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', currency CHAR(3) NOT NULL DEFAULT '', mode VARCHAR(10) NOT NULL DEFAULT 'live', subtotal BIGINT(20) NOT NULL DEFAULT 0, discount BIGINT(20) NOT NULL DEFAULT 0, total BIGINT(20) NOT NULL DEFAULT 0, discount_code VARCHAR(50) NOT NULL DEFAULT '', ip_address VARCHAR(45) NOT NULL DEFAULT '', gateway VARCHAR(50) NOT NULL DEFAULT '', transaction_id VARCHAR(255) NOT NULL DEFAULT '', payment_method VARCHAR(100) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, paid_at DATETIME NULL DEFAULT NULL, completed_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY order_key (order_key), KEY parent_id (parent_id), KEY customer_id (customer_id), KEY type_status_created (type, status, created_at), KEY created_at (created_at), KEY transaction_id (transaction_id(191)) ) $collate; CREATE TABLE wp_ecout_order_items ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, product_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, product_name VARCHAR(255) NOT NULL DEFAULT '', price BIGINT(20) NOT NULL DEFAULT 0, quantity INT(11) NOT NULL DEFAULT 1, subtotal BIGINT(20) NOT NULL DEFAULT 0, total BIGINT(20) NOT NULL DEFAULT 0, position INT(11) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), KEY order_id (order_id), KEY product_id (product_id) ) $collate; CREATE TABLE wp_ecout_download_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, product_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, download_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, customer_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, ip_address VARCHAR(45) NOT NULL DEFAULT '', user_agent VARCHAR(255) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_download (order_id, download_id), KEY download_id (download_id), KEY customer_id (customer_id), KEY created_at (created_at) ) $collate; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $tables );
Safe to delete?
If you have uninstalled Ever Checkout – Sell Digital Products & Downloads, 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_ecout_products`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Ever Checkout – Sell Digital Products & Downloads