-- =============================================================================
-- Entitlement Platform — MCLIENT.JURISDICTIONCODE (SQL Server variant)
-- Migration: 20260904 — tracker §51.12, Legal/Contract Agreement Consent jurisdiction resolution
--
-- Additive-only, nullable — MCLIENT is shared by every module, same caution as
-- 20260713_Entitlement_Phase1_MCLIENT_Extension. NULL = jurisdiction unknown/not yet captured;
-- IAgreementConsentProvider treats NULL/empty the same as an explicit universal request (falls
-- back to the type's own JurisdictionCode IS NULL default version).
--
-- Captured at client-creation time (SelfProvisionTrial / RegisterProspect / OnboardClient, all
-- optional — no existing caller is required to start supplying it) and read back at the two
-- points where a real ClientId already exists and needs its OWN jurisdiction resolved: the
-- individual-user EULA gate at login (ClientAuthBLL.LoginAsync) and the "buying" gate
-- (SubscriptionService.InitiatePaymentAsync).
-- =============================================================================

IF COL_LENGTH('MCLIENT', 'JURISDICTIONCODE') IS NULL
    ALTER TABLE MCLIENT ADD JURISDICTIONCODE NVARCHAR(10) NULL;
GO

-- =============================================================================
-- END OF MIGRATION 20260904_Entitlement_MCLIENT_JurisdictionCode (SQL Server variant)
-- =============================================================================