wp_ezhance_promotions

Static

Stores ezhance promotions data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	bigint(20) unsigned	NO
title	varchar(255)	NO
status	varchar(20)	NO
priority	int(11)	NO
conditions	longtext	NO
targets	longtext	NO
display	longtext	NO
end_date	datetime	YES
max_usage_count	int(11)	NO
used_count	int(11)	NO
currency	varchar(10)	YES
total_revenue	decimal(19,4)	NO
updated_at	datetime	YES
created_by	bigint(20) unsigned	NO
updated_by	bigint(20) unsigned	NO
promotion_id	bigint(20) unsigned	NO
order_id	bigint(20) unsigned	NO
product_id	bigint(20) unsigned	YES
customer_id	bigint(20) unsigned	YES
promo_details	longtext	YES
discount_amount	decimal(19,4)	NO
currency	varchar(10)	YES
discount_amount_base_currency	decimal(19,4)	YES
created_at	datetime	YES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_ezhance_promotions ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, status varchar(20) NOT NULL DEFAULT 'draft', priority int(11) NOT NULL DEFAULT 10, /* The JSON Payloads (Mirrors the React UI State perfectly) */ action longtext NOT NULL, conditions longtext NOT NULL, targets longtext NOT NULL, display longtext NOT NULL, /* Filtering & Scheduling Columns */ start_date datetime DEFAULT NULL, end_date datetime DEFAULT NULL, max_usage_count int(11) NOT NULL DEFAULT 0, used_count int(11) NOT NULL DEFAULT 0, /* Additional Attributes */ language varchar(20) DEFAULT NULL, currency varchar(10) DEFAULT NULL, total_revenue decimal(19,4) NOT NULL DEFAULT 0.0000, /* Timestamps */ created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, created_by bigint(20) unsigned NOT NULL DEFAULT 0, updated_by bigint(20) unsigned NOT NULL DEFAULT 0, /* JSON metadata column — safety score and future multi-purpose data */ score_data longtext NULL DEFAULT NULL, /* Indexes for blazing-fast cart retrieval */ PRIMARY KEY (id), KEY status_priority (status, priority), KEY active_dates (start_date, end_date) ) $charset_collate;", // Analytics table to track promotion usage. "CREATE TABLE IF NOT EXISTS wp_ezhance_promotion_analytics ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, promotion_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL, product_id bigint(20) unsigned DEFAULT 0, customer_id bigint(20) unsigned DEFAULT 0, promo_details longtext DEFAULT NULL, discount_amount decimal(19,4) NOT NULL DEFAULT 0.0000, currency varchar(10) DEFAULT NULL, discount_amount_base_currency decimal(19,4) DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY promotion_id (promotion_id), KEY order_id (order_id), KEY product_id (product_id), KEY customer_id (customer_id), KEY currency (currency) ) $charset_collate;", );

Safe to delete?

If you have uninstalled Ezhance – Product Discounts, Bulk Pricing and Safety Score for WooCommerce, 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_ezhance_promotions`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Ezhance – Product Discounts, Bulk Pricing and Safety Score for WooCommerce

wp_ezhance_promotion_analytics