-- =============================================================================
-- Phase 0.1 of the Portlet/Page/Dashboard admin-UI build (FE plan): CRUD
-- endpoints for MENTITLEMENTFEATUREPORTLETTYPEMAP / MENTITLEMENTFEATUREDASHBOARDMAP
-- (Phase 5's migration only wired the read-side JOIN into GetSelectListPortletType/
-- GetDashboardListForUser — nothing let anyone create/delete a mapping row except
-- raw SQL). This migration adds the MAUTONUMBER seeds
-- AutoNumber.GetAutoNumber("FEATUREPORTLETTYPEMAP"/"FEATUREDASHBOARDMAP", ...)
-- requires — a bare UPDATE against a missing EntityCode row throws
-- NotFoundException, same gap documented in prior Dashboard-family migrations.
-- =============================================================================

IF NOT EXISTS (SELECT 1 FROM MAUTONUMBER WHERE ENTITYCODE = 'FEATUREPORTLETTYPEMAP')
    INSERT INTO MAUTONUMBER (ENTITYID, ENTITYCODE, AUTOID) VALUES (-1384000005, 'FEATUREPORTLETTYPEMAP', -1499999999);
GO

IF NOT EXISTS (SELECT 1 FROM MAUTONUMBER WHERE ENTITYCODE = 'FEATUREDASHBOARDMAP')
    INSERT INTO MAUTONUMBER (ENTITYID, ENTITYCODE, AUTOID) VALUES (-1384000006, 'FEATUREDASHBOARDMAP', -1499999999);
GO

-- =============================================================================
-- END OF MIGRATION 20260802_EntitlementMapping_AutoNumberSeed (SQL Server)
-- =============================================================================