-- =============================================================================
-- GB5 BI platform — Phase 2: MAUTONUMBER seed for BIFIELDMAPPING (SQL Server)
-- Plan: /Users/venkatv/.claude/plans/gb5-in-product-analytics-dapper-bear.md
--
-- BIFieldMappingBLL.SaveMapping calls AutoNumber.GetAutoNumber(1, "BIFIELDMAPPING", login) —
-- the pilot's own three MBIFIELDMAPPING rows were all seeded manually via raw SQL; this is
-- the first time the app itself ever saves one (the SuggestMappings review/save flow).
--
-- *** ENTITYID BELOW IS NOT YET LIVE-COLLISION-CHECKED *** — same caveat as the BIVIEW/
-- BICATALOG AutoNumber seeds in this same batch.
-- =============================================================================

-- SELECT * FROM MAUTONUMBER WHERE ENTITYID = -1399687719;  -- run this first, live, before trusting the INSERT below

IF NOT EXISTS (SELECT 1 FROM MAUTONUMBER WHERE ENTITYCODE = 'BIFIELDMAPPING')
BEGIN
    INSERT INTO MAUTONUMBER (ENTITYID, ENTITYCODE, AUTOID)
    VALUES (-1399687719, 'BIFIELDMAPPING', -1399687719);
END
GO

-- =============================================================================
-- END OF MIGRATION 20260806_BIFieldMapping_AutoNumber_Seed (SQL Server)
-- =============================================================================