-- =============================================================================
-- Entitlement Platform — MCLIENT additive column extension (PostgreSQL variant)
-- Migration: 20260713 — Entitlement Phase 1 MCLIENT Extension
--
-- ⚠ EXPLICIT REVIEW REQUIRED BEFORE APPLYING ANYWHERE ⚠
-- MCLIENT is shared by every module. Additive-only (three new nullable/defaulted
-- columns, fully backward compatible) — apply separately, scratch-DB first.
--
-- DEPLOYMENTTYPE:      0=OnPrem 1=Cloud 2=Hybrid
-- SUBSCRIPTIONSTATUS:  denormalised fast tenant-status filter
-- TRIALMODE:           0=No 1=Yes
-- =============================================================================

ALTER TABLE MCLIENT ADD COLUMN IF NOT EXISTS DEPLOYMENTTYPE     SMALLINT NULL DEFAULT 0;
ALTER TABLE MCLIENT ADD COLUMN IF NOT EXISTS SUBSCRIPTIONSTATUS SMALLINT NULL DEFAULT 0;
ALTER TABLE MCLIENT ADD COLUMN IF NOT EXISTS TRIALMODE          SMALLINT NULL DEFAULT 0;

-- =============================================================================
-- END OF MIGRATION 20260713_Entitlement_Phase1_MCLIENT_Extension (PostgreSQL)
-- =============================================================================