Alireza HassaniandCursor
92601ae729
Auto-count storefront page views with 6-month event retention and lifetime counters, track product visit/cart/sale stats, persist SSL cert expiry with daily probes, and support owner titles plus annual contract renewal. Co-authored-by: Cursor <cursoragent@cursor.com>
6 lines
292 B
SQL
6 lines
292 B
SQL
-- Lifetime product analysis counters (visits, cart adds, units sold).
|
|
ALTER TABLE products
|
|
ADD COLUMN IF NOT EXISTS visit_count BIGINT NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS cart_add_count BIGINT NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS sale_count BIGINT NOT NULL DEFAULT 0;
|