-- =============================================================================
-- MIGRATION: Per-merchant image compression default + per-image / per-product limits
-- Convention: Prisma maps createdAt→createdOn, updatedAt→updatedOn in DB
-- Run: idempotent — safe to re-execute
-- =============================================================================

BEGIN;

ALTER TABLE platform.organizations
  ADD COLUMN IF NOT EXISTS "imageCompressionDefault" INTEGER NOT NULL DEFAULT 0,
  ADD COLUMN IF NOT EXISTS "maxImageSizeBytes" INTEGER,
  ADD COLUMN IF NOT EXISTS "maxImagesPerProduct" INTEGER;

COMMIT;