{"table_name":"ezhance_promotions","full_table_name":"wp_ezhance_promotions","description":"Stores ezhance promotions data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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;\", );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"priority","type":"int(11)","nullable":false,"primary_key":false},{"name":"conditions","type":"longtext","nullable":false,"primary_key":false},{"name":"targets","type":"longtext","nullable":false,"primary_key":false},{"name":"display","type":"longtext","nullable":false,"primary_key":false},{"name":"end_date","type":"datetime","nullable":true,"primary_key":false},{"name":"max_usage_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"used_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"total_revenue","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"updated_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"promotion_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"customer_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"promo_details","type":"longtext","nullable":true,"primary_key":false},{"name":"discount_amount","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"discount_amount_base_currency","type":"decimal(19,4)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"ezhance","name":"Ezhance – Product Discounts, Bulk Pricing and Safety Score for WooCommerce","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/ezhance/"}}