-- =============================================================================
-- MAUTONUMBER seed for EIPACTIONREGISTRY / EIPCAPABILITYACTIONMAP / EIPRESTACTIONCFG (SQL Server)
-- Migration: 20260825 — Action Registry + Capability-Action-Map + REST Action Config admin CRUD
--
-- MEIPACTIONREGISTRY.ACTIONID, MEIPCAPABILITYACTIONMAP.CAPABILITYACTIONMAPID, and
-- MEIPRESTACTIONCFG.RESTACTIONCFGID are all plain INT (not IDENTITY) — confirmed live via
-- sys.columns.is_identity 2026-08-25, same pattern as every other EIP master table. New admin
-- Save endpoints for these three tables call AutoNumber.GetNumberAsync(1,
-- AUTONUMBERCONSTANT.<X>, ...), which throws "AutoNumber entry not found" without a seed row.
--
-- Block numbering continues the existing EIP sequence (-1210010000 .. -1210110000 already used
-- by EIPINTERACTIONSESSION/.../EIPMESSAGETEMPLATE/DIRECTACTION/DIRECTACTIONDETAIL/
-- EIPCHANNELENDPOINT, confirmed live via MAUTONUMBER) — next three free blocks are
-- -1210120000/-1210130000/-1210140000.
-- =============================================================================

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

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

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

-- =============================================================================
-- END OF MIGRATION 20260825_EIP_ActionRegistry_CapabilityActionMap_RestActionCfg_AutoNumber_Seed (SQL Server)
-- =============================================================================