-- =============================================================================
-- Entitlement Platform — PLACEHOLDER SUBSCRIPTIONTERMS agreement content seed (SQL Server variant)
-- Migration: 20260904 — tracker §51.10, the "buying"/commercial-transaction consent gate on
-- SubscriptionService.InitiatePaymentAsync.
--
-- NOT REAL LEGAL CONTENT. Seeds 1 MAGREEMENTTYPE row (SUBSCRIPTIONTERMS) and one universal
-- (JurisdictionCode = NULL) MAGREEMENTVERSION, pointing at the lorem-ipsum file under
-- Docs/legal-placeholders/ (see that folder's own README.md). Published directly via this seed
-- rather than the real Draft->Published authoring flow (AgreementAuthoringBLL) — a reasonable
-- shortcut for seed/demo data, matching the identical convention already used for TOS/
-- PRIVACYPOLICY in 20260904_Entitlement_Agreement_PlaceholderContent_Seed_*.
--
-- Before going live: retire this row (VERSIONSTATUS=3) once real, counsel-reviewed subscription/
-- billing terms are published through the real authoring flow — never edit it in place.
--
-- IDs continue the same -1370000100/-1370000200 sub-numbering already used by the TOS/
-- PRIVACYPOLICY placeholder seed (…101/102 types, …201/202 versions) — NOT live-collision-checked,
-- same honest-disclosure convention as every other blind-then-verify migration in this engagement.
-- =============================================================================

IF NOT EXISTS (SELECT 1 FROM MAGREEMENTTYPE WHERE TYPECODE = 'SUBSCRIPTIONTERMS')
BEGIN
    INSERT INTO MAGREEMENTTYPE (AGREEMENTTYPEID, TYPECODE, TYPENAME, REQUIRESINDIVIDUALACCEPTANCE, CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON)
    VALUES (-1370000103, 'SUBSCRIPTIONTERMS', 'Subscription & Billing Terms (PLACEHOLDER)', 0, -1, GETUTCDATE(), -1, GETUTCDATE());
END
GO

IF NOT EXISTS (SELECT 1 FROM MAGREEMENTVERSION WHERE AGREEMENTVERSIONID = -1370000203)
BEGIN
    INSERT INTO MAGREEMENTVERSION
        (AGREEMENTVERSIONID, AGREEMENTTYPEID, VERSIONLABEL, JURISDICTIONCODE, CONTENTREF, CONTENTHASH,
         EFFECTIVEFROM, VERSIONSTATUS, CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON)
    VALUES
        (-1370000203, -1370000103, 'v1.0-PLACEHOLDER', NULL, 'Docs/legal-placeholders/SUBSCRIPTIONTERMS-PLACEHOLDER-v1.txt', NULL,
         GETUTCDATE(), 1, -1, GETUTCDATE(), -1, GETUTCDATE());
END
GO

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