-- =============================================================================
-- MIGRATION: Discount code min/max amount, customer eligibility, stacking, usage tracking
-- Convention: Prisma maps createdAt→createdOn, updatedAt→updatedOn in DB
-- Run: idempotent — safe to re-execute
-- =============================================================================

BEGIN;

ALTER TABLE marketing.discount_codes
  ADD COLUMN IF NOT EXISTS "minOrderAmount" INTEGER,
  ADD COLUMN IF NOT EXISTS "maxDiscountAmount" INTEGER,
  ADD COLUMN IF NOT EXISTS "customerEligibility" TEXT NOT NULL DEFAULT 'all',
  ADD COLUMN IF NOT EXISTS "stackable" BOOLEAN NOT NULL DEFAULT false,
  ADD COLUMN IF NOT EXISTS "usedCount" INTEGER NOT NULL DEFAULT 0;

COMMIT;